qt读取mysql数据库表的数据

#include <QCoreApplication>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QDebug>

int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);

    // 创建数据库连接
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setPort(3306);
    db.setDatabaseName("mydatabase");
    db.setUserName("username");
    db.setPassword("password");

    // 打开数据库连接
    if (!db.open()) {
        qDebug() << "Failed to connect to database!";
        return -1;
    }

    // 查询数据库表数据
    QSqlQuery query;
    if (!query.exec("SELECT * FROM mytable")) {
        qDebug() << "Failed to execute query!";
        return -1;
    }

    // 处理查询结果
    while (query.next()) {
        int id = query.value(0).toInt();
        QString name = query.value(1).toString();
        qDebug() << "ID:" << id << "Name:" << name;
    }

    // 关闭数据库连接
    db.close();

    return a.exec();
}