qt遍历mysql数据库信息

#include <QtSql>

int main() {
    // 连接到MySQL数据库
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    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()) {
        QString name = query.value(0).toString();
        int age = query.value(1).toInt();
        qDebug() << "Name:" << name << "Age:" << age;
    }

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

    return 0;
}