Qt数据库应用之实现通用数据生成器

void frmDbCreat::on_btnOpen_clicked()
{
    if (ui->btnOpen->text() == "打开数据库") {
        DbInfo dbInfo;
        dbInfo.connName = this->objectName();
        dbInfo.dbName = AppConfig::DbName2;
        dbInfo.hostName = AppConfig::HostName2;
        dbInfo.hostPort = AppConfig::HostPort2;
        dbInfo.userName = AppConfig::UserName2;
        dbInfo.userPwd = AppConfig::UserPwd2;

        QString dbType = AppConfig::DbType2.toUpper();
        if (dbType == "SQLITE") {
            dbInfo.dbName = DbHelper::getDbDefaultFile();
        }

        dbConn->setConnInfo(DbHelper::getDbType(dbType), dbInfo);
        if (dbConn->openDb()) {
            dbConn->start();
            ui->btnOpen->setText("关闭数据库");
        } else {
            QString error = dbConn->getDatabase().lastError().text();
            QUIHelper::showMessageBoxError("打开数据库失败!\n" + error, 3);
        }
    } else {
        dbConn->stop();
        dbConn->closeDb();
        ui->btnOpen->setText("打开数据库");
        on_btnClear_clicked();
    }

    QTimer::singleShot(100, this, SLOT(getMaxID()));
    QTimer::singleShot(1000, this, SLOT(on_btnStart_clicked()));
}

void frmDbCreat::on_btnCopy_clicked()
{
    //将数据库设置参数一键粘贴过来
    ui->cboxDbType->setCurrentIndex(ui->cboxDbType->findText(AppConfig::LocalDbType));
    ui->txtDbName->setText(AppConfig::LocalDbName);
    ui->txtHostName->setText(AppConfig::LocalHostName);
    ui->txtHostPort->setText(QString::number(AppConfig::LocalHostPort));
    ui->txtUserName->setText(AppConfig::LocalUserName);
    ui->txtUserPwd->setText(AppConfig::LocalUserPwd);
}

void frmDbCreat::getMaxID()
{
    if (!dbConn->getOk()) {
        return;
    }

    //根据插入sql语句取出对应的表名和自增字段
    QString sqlColumn = AppConfig::SqlColumn2;
    QString sqlValue = AppConfig::SqlValue2;
    if (sqlValue.contains("AUTO_INCREMENT")) {
        sqlColumn.replace("insert into ", "");
        sqlValue.replace("values", "");
        QString tableName = sqlColumn.split("(").first();
        sqlColumn.replace(tableName, "");
        sqlColumn.replace("(", "");
        sqlColumn.replace(")", "");
        sqlValue.replace("(", "");
        sqlValue.replace(")", "");

        QStringList listColumn = sqlColumn.split(",");
        QStringList listValue = sqlValue.split(",");
        int index = listValue.indexOf("'AUTO_INCREMENT'");
        QString columnName = listColumn.at(index);
        //取出最大记录数
        maxID = DbHelper::getMaxID(tableName, columnName, dbConn->getDatabase());
    }
}

void frmDbCreat::on_btnDo_clicked()
{
    if (!dbConn->getOk()) {
        return;
    }

    QString sql = AppConfig::SqlColumn2 + " " + AppConfig::SqlValue2;
    //qDebug() << TIMEMS << sql;

    QStringList sqls;
    for (int i = 0; i < AppConfig::Count2; ++i) {
        QString temp = sql;
        //替换自增ID
        maxID++;
        temp.replace("AUTO_INCREMENT", QString::number(maxID));
        //替换时间
        temp.replace("DATETIME", DATETIME);
        sqls << temp;
    }

    dbConn->append(sqls);
}

void frmDbCreat::on_btnCount_clicked()
{
    dbConn->selectCount("LogInfo", "LogID", "where 1=1");
}

void frmDbCreat::on_btnStart_clicked()
{
    if (ui->btnStart->text() == "启动服务") {
        on_btnDo_clicked();
        timer->start();
        ui->btnStart->setText("停止服务");
    } else {
        timer->stop();
        ui->btnStart->setText("启动服务");
    }
}