QT配置链接mysql

1.由于QT没有mysql动态库，使用时需要配置

2.根据自己编译器安装对应动态mysql库  

 

 3.安装目录

 

 4.上述步骤完成，就能操作mysql

 

#include <QApplication>
#include <QtSql>


#int main(int argc, char* argv[])
{
     QApplication a(argc, argv);
     QSqlDatabase db =  QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("公网ip");  // 这里换成你自己的云服务器ip
    db.setPort(3306);
    db.setDatabaseName("数据库名");    
    db.setUserName("root");
    db.setPassword("登录密码");           
  
    if(!db.open())
        qDebug() << "Failed!";
    else
        qDebug() << "open";  

    QSqlQuery query(db);

     query.exec("create table User(id int primary key,name varchar(20))");

    query.exec("insert into User values(1,'aaa')");
    query.exec("insert into User values(2,'bbb')");
    query.exec("insert into User values(3,'cccc')");
    query.exec("insert into User values(4,'ddd')");

 
    return a.exec();   
     
}