qt连接数据库实现增删查改mysql

#include <QtSql>
#include <QDebug>

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost"); // 设置MySQL服务器主机名
db.setDatabaseName("databaseName"); // 设置要连接的数据库名称
db.setUserName("username"); // 设置MySQL登录用户名
db.setPassword("password"); // 设置MySQL登录密码

if (db.open()) {
    qDebug() << "Database connected!";
} else {
    qDebug() << "Failed to connect database!";
}

QSqlQuery query;
query.prepare("INSERT INTO tableName (column1, column2) VALUES (:value1, :value2)");
query.bindValue(":value1", value1); // 设置插入的值
query.bindValue(":value2", value2);

if (query.exec()) {
    qDebug() << "Insertion success!";
} else {
    qDebug() << "Insertion failed!";
}

QSqlQuery query;
query.prepare("SELECT * FROM tableName");
if (query.exec()) {
    while (query.next()) {
        QString column1 = query.value(0).toString(); // 获取第一个列的值
        QString column2 = query.value(1).toString(); // 获取第二个列的值
        qDebug() << "Column1:" << column1 << "Column2:" << column2;
    }
} else {
    qDebug() << "Query failed!";
}

QSqlQuery query;
query.prepare("UPDATE tableName SET column1 = :value WHERE id = :id");
query.bindValue(":value", newValue);
query.bindValue(":id", id);

if (query.exec()) {
    qDebug() << "Update success!";
} else {
    qDebug() << "Update failed!";
}

QSqlQuery query;
query.prepare("DELETE FROM tableName WHERE id = :id");
query.bindValue(":id", id);

if (query.exec()) {
    qDebug() << "Deletion success!";
} else {
    qDebug() << "Deletion failed!";
}