Qt5+mysqlwindows

pro文件中添加 QT += sql 添加动态库 window下直接将libmysql.dll拷到exe文件目录下 cpp文件 #include <QCoreApplication>#include <QSqlDatabase>#include <QSqlRecord>#include <QSqlQuery>#include <QVariant>#include <qdebug.h>int main(int argc, char *argv[]){ QCoreApplication a(argc, argv); QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("127.0.0.1"); db.setPort(3306); db.setDatabaseName("iot_wind"); db.setUserName("root"); db.setPassword("密码"); if(db.open()) { const char* pcRes = "success!"; }else{ const char* pcRes = "failure"; } QSqlQuery q("", db); QSqlRecord Mysql_Res; q.exec("select DISTINCT STATUS_CODE,STATUS_TIME from tb_wind_status where '2016-03-29 08:35:52' < STATUS_TIME order by STATUS_TIME asc "); // 查询的结果可能不止一条记录，所以我们称之为结果集 while (q.next()) { QString name = q.value(1).toString(); int age = q.value(0).toInt(); qDebug()<<name; } return a.exec();}