qt mysql发布程序

#include <QSqlDatabase>
#include <QSqlError>
#include <QDebug>

void connectToDatabase() {
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setPort(3306);
    db.setDatabaseName("mydatabase");
    db.setUserName("myuser");
    db.setPassword("mypassword");

    if (!db.open()) {
        qDebug() << "Error: connection with database failed";
        qDebug() << db.lastError().text();
    } else {
        qDebug() << "Database: connection ok";
    }
}

#include <QSqlQuery>
#include <QDebug>

void executeQuery() {
    QSqlQuery query;
    query.prepare("SELECT * FROM users WHERE id = :id");
    query.bindValue(":id", 1);

    if (!query.exec()) {
        qDebug() << "Error: executing query failed";
        qDebug() << query.lastError().text();
    } else {
        while (query.next()) {
            qDebug() << "User ID:" << query.value(0).toInt();
            qDebug() << "User Name:" << query.value(1).toString();
        }
    }
}