QT操作mysql数据库的DDL、DML

雨点打透心脏的1/2处 2022-12-27 07:39 322阅读 0赞

# 1、查看QT查看支持的数据库驱动 #

QStringList drivers = QSqlDatabase::drivers();
    
    qDebug() << drivers;

![20201208203123941.png][]

# 2、连接mysql数据库 #

# 3、插入数据库数据 #

QStringList drivers = QSqlDatabase::drivers();
        qDebug() << drivers;
    
        QSqlDatabase sqlDatabase = QSqlDatabase::addDatabase("QMYSQL");
        sqlDatabase.setHostName("47.104.9.61");
        sqlDatabase.setUserName("root");
        sqlDatabase.setPassword("wtl199201180271");
    
        //选择数据库名
        sqlDatabase.setDatabaseName("test");
    
        if (!sqlDatabase.open()){
            QMessageBox::warning(this,QString("数据库打开信息"),sqlDatabase.lastError().text());
        }
        else{
            QSqlQuery sqlQuery;
    
            sqlQuery.prepare("INSERT INTO student(`name`,`age`) VALUES(:name,:age);");
    
            QVariantList nameList;
            nameList << "王五" << "赵六" << "田七";
    
            QVariantList ageList;
            ageList << 28 << 30 << 26;
    
            sqlQuery.bindValue(":name",nameList);
            sqlQuery.bindValue(":age",ageList);
    
            sqlQuery.execBatch();
        }

# ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70][] #

# 4、查询数据 #

QStringList drivers = QSqlDatabase::drivers();
        qDebug() << drivers;
    
        QSqlDatabase sqlDatabase = QSqlDatabase::addDatabase("QMYSQL");
        sqlDatabase.setHostName("47.104.9.61");
        sqlDatabase.setUserName("root");
        sqlDatabase.setPassword("wtl199201180271");
    
        //选择数据库名
        sqlDatabase.setDatabaseName("test");
    
        if (!sqlDatabase.open()){
            QMessageBox::warning(this,QString("数据库打开信息"),sqlDatabase.lastError().text());
        }
        else{
            QSqlQuery sqlQuery;
    
            sqlQuery.prepare("select * from student;");
            sqlQuery.exec();
            while (sqlQuery.next()) {
                qDebug() << sqlQuery.value("id")
                         << sqlQuery.value("name")
                         << sqlQuery.value("age");
            }
    
        }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 1][]

[20201208203123941.png]: /images/20221120/6914187096e54cfabf1929366b13f67a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70]: /images/20221120/15da4e9aea7a4f6c8262910bea513b0d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d0bDE5OTI_size_16_color_FFFFFF_t_70 1]: /images/20221120/e7e979c8df6b44d2adc9195a86f57772.png