正在尝试从QT表的数据库中删除

#include <QtSql>

int main() {
    // 连接到数据库
    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;
    QString deleteQuery = "DELETE FROM mytable WHERE id = :id";
    query.prepare(deleteQuery);
    query.bindValue(":id", 1); // 设置删除条件
    if (!query.exec()) {
        qDebug() << "Failed to delete data:" << query.lastError().text();
        return -1;
    }
    
    // 处理结果
    while (query.next()) {
        // 处理每一行数据
        int id = query.value(0).toInt();
        QString name = query.value(1).toString();
        qDebug() << "Deleted data: id =" << id << ", name =" << name;
    }
    
    // 关闭数据库连接
    db.close();
    
    return 0;
}