qt mysql 封装_Qt数据库集成应用封装

#include "dblocalthread.h"

DbLocalThread *DbLocalThread::self = 0;

DbLocalThread::DbLocalThread(QObject *parent) : QThread(parent)

{

stopped = false;

dbOkLocal = false;

lastCheckTimeLocal = QDateTime::currentDateTime();

checkInterval = 30;

dbTypeLocal = DbType_MySql;

connNameLocal = "qt_sql_default_connection";

hostNameLocal = "127.0.0.1";

portLocal = 3306;

dbNameLocal = "tcms_liu_mysql";

userNameLocal = "root";

userPwdLocal = "root";

}

void DbLocalThread::run()

{

while (!stopped) {

//定时执行一次校验数据库连接是否正常

QDateTime now = QDateTime::currentDateTime();

if (lastCheckTimeLocal.secsTo(now) >= checkInterval) {

checkDb();