Qt连接MySQL
Qt可以连接MySQL使用
-
编译好MySQL连接驱动与库文件:
-
工程文件pro添加
QT += sql
-
头文件添加
/** 数据库连接对象 */
QSqlDatabase* dbc = nullptr;
QSqlQuery* qyb = nullptr;
QString _sqlc = "";
/** 连接数据库 */
void connectDB();
- 函数
#define cfgpath "E:/Projects/Qt/TestCode/config.ini"
void Widget::connectDB(){
QSettings * cfg = new QSettings(cfgpath,QSettings::IniFormat);
QString ipaddr = cfg->value("NET/ServerName").toString();
int dbport = cfg->value("NET/ServerName").toInt();
QString dbusr = cfg->value("SSNC2/LogId").toString();
QString dbpass = cfg->value("SSNC2/LogPass").toString();
#ifdef DEBUG
cout << "ip地址: " << ipaddr;
cout << "db端口: " << dbport;
cout << "用户名: " << dbusr;
cout << "密码: " << dbpass;
#endif
cfg->disconnect();
delete cfg;
dbc = new QSqlDatabase(QSqlDatabase::addDatabase("QMYSQL","nlp"));
dbc->setHostName(ipaddr);
dbc->setPort(dbport);
dbc->setDatabaseName("nlp_data");
dbc->setUserName(dbusr);
dbc->setPassword(dbpass);
if(!dbc->open()){
#ifdef DEBUG
cout << "无法连接数据库!";
cout << dbc->lastError();
#endif
} else {
// ---> 连接成功
}
}