Home>Article>Database> How to connect to mysql in qt5.8

How to connect to mysql in qt5.8

藏色散人
藏色散人 Original
2020-11-06 10:31:42 2463browse

Qt5.8 How to connect to mysql: first compile and generate the mysql driver; then download the "libmysql.dll" library and place it in the Qt bin folder; finally create the connection code file for testing. Can.

How to connect to mysql in qt5.8

Recommended: "mysql video tutorial"

qt5.8 connects to mysql database

Solution to connect mysql under Qt Creator. The following takes qt5.8.0 and mysql5.7.18 as examples.

Preparation work

1.qt5.2 and above versions have mysql driver by default. We can (such as: D:\Qt\Qt5.8.0\5.8\mingw53_32\plugins\ sqldrivers) below to find the mysql driver. If there is no driver, then you have to compile and generate it yourself.

2. Download mysql (qt cannot find the mysql library file). The library file name is "libmysql.dll". This library file should be placed in the bin folder of Qt (for example: D:\Qt \Qt5.8.0\5.8\mingw53_32\bin) This file is generally in the lib directory of mysql.

Test code

#include "mainwindow.h" #include  #include  #include  #include  #include  #include  int main(int argc, char *argv[]) { QApplication a(argc, argv); MainWindow w; w.show(); QStringList drivers = QSqlDatabase::drivers(); qDebug() << drivers; QSqlDatabase dbconn; QSqlQuery query; dbconn = QSqlDatabase::addDatabase("QMYSQL"); dbconn.setHostName("192.168.80.221");//主机名字 dbconn.setDatabaseName("iacrms");//数据库名字 dbconn.open("gdzt", "039.com");//用户名、密码,成功返回1 query = (QSqlQuery)dbconn; query.exec("select * from tb_UserQQInfo"); while(query.next()) { int id = query.value(0).toInt(); QString name = query.value(1).toString(); qDebug() << QString::number(id) + " : "+ name; } return a.exec(); }

Notes

1.qt version must be the same as mysql. If it is 64-bit, it must be 64-bit, or both must be 32-bit.

The above is the detailed content of How to connect to mysql in qt5.8. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn