Qt - 如何获取编译Mysql驱动程序

获取和编译 MySQL 驱动程序的 Qt 指南

plaintext
QT += sql

plaintext
INCLUDEPATH += /path/to/mysql/connector/c/include
LIBS += -L/path/to/mysql/connector/c/lib -lmysqlclient

cpp
#include 
#include 
#include 
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    // 创建数据库连接
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("your_database_name");
    db.setUserName("your_username");
    db.setPassword("your_password");
    // 打开数据库
    if (db.open()) {
        qDebug() << "Connected to database";
        // 执行查询
        QSqlQuery query;
        query.exec("SELECT * FROM your_table_name");
        // 处理查询结果
        while (query.next()) {
            QString name = query.value(0).toString();
            int age = query.value(1).toInt();
            qDebug() << "Name:" << name << ", Age:" << age;
        }
        // 关闭数据库连接
        db.close();
    } else {
        qDebug() << "Failed to connect to database:" << db.lastError().text();
    }
    return a.exec();
}