Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to connect qt5.8 to mysql, the article is very detailed, has a certain reference value, interested friends must read it!

How to connect qt5.8 to mysql: first, compile the driver that generates mysql; then download the "libmysql.dll" library and place it in the bin folder of Qt; finally, create a connection code file for testing.

Qt5.8 connects to mysql database

The solution of connecting mysql under Qt Creator. Let's take qt5.8.0 and mysql5.7.18 as examples.

Preparatory work

All 1.qt5.2 versions and above have mysql drivers by default. We can find mysql drivers under (for example: d:\ Qt\ Qt5.8.0\ 5.8\ mingw53_32\ plugins\ sqldrivers). If you don't have a driver, you'll have to compile and generate it yourself.

two。 The file that downloads the mysql (qt cannot find the library file for mysql) is called "libmysql.dll". The 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 usually in the lib directory of mysql.

Test code

# include "mainwindow.h" # include # include int main (int argc, char * argv []) {QApplication a (argc, argv); MainWindow w; w.show (); QStringList drivers = QSqlDatabase::drivers (); qDebug ()

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.