Qt连接MySQL

Qt可以连接MySQL使用

1. 编译好MySQL连接驱动与库文件:

2. 工程文件pro添加 QT += sql

3. 头文件添加

/** 数据库连接对象 */
QSqlDatabase* dbc = nullptr;
QSqlQuery* qyb = nullptr;
QString _sqlc = "";
 
/** 连接数据库 */
void connectDB();
 

4. 函数

#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 {
        // ---> 连接成功
 
  }
 
}