school.rar
把这样的数据去去除重复的，并计算出重复个数，手工计算太麻烦了，所以写个小程序
主要代码
#include "school.h"
school::school(QWidget *parent)
: QWidget(parent)
{
ui.setupUi(this);
QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setUserName("root");
db.setPassword("admin");
db.setDatabaseName("test");
if (!db.open()) {
QMessageBox::warning(this,tr("出错"),tr("打开错误"));
}
connect(ui.pushButton,SIGNAL(clicked()),this,SLOT(appendData()));
}
void school::appendData()
{
QSqlQuery query;
QString s = QString("SELECT data FROM `mdl_user_info_data` WHERE fieldid =4 ORDER BY `mdl_user_info_data`.`data`");
if(query.exec(s)){
int i = 0;
while(query.next()){
i++;
QString school_temp = query.value(0).toString();
if(school_data != school_temp){
ui.textEdit->append(
QString::fromUtf8("所在学校(单位):%1 [%2人]")
.arg(school_data)
.arg(i));
school_data = school_temp;
i = 0;
}
}
}else{
QMessageBox::warning(this,tr("er"),s);
}
}
school::~school()
{
}
效果图
我的博客
http://school.2embed.com/mod/forum/discuss.php?d=3051
