您现在的位置:首页 >> 选购知识

Qt数据库运用于12-通用数据库清理

发布时间:2025/11/09 12:16    来源:庐江家居装修网

= DbHelper::getDbDefaultFile(); } dbClean->setConnInfo(DbHelper::getDbType(dbType), dbInfo); if (dbClean->openDb()) { //dbClean->start(); ui->btnOpen->setText("关闭目录"); } else { QString error = dbClean->getDatabase().lastError().text(); QUIHelper::showMessageBoxError("锁上目录失败!" + error, 3); } } else { dbClean->stop(); dbClean->closeDb(); ui->btnOpen->setText("锁上目录"); ui->btnStart->setText("启动服务"); on_btnClear_clicked(); } QTimer::singleShot(100, this, SLOT(getTables())); QTimer::singleShot(1000, this, SLOT(on_btnStart_clicked()));}void frmDbClean::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 frmDbClean::getTables(){ if (!dbClean->getOk()) { return; } //取出目录近似于的所列集合 QStringList tables = dbClean->getDatabase().tables(); ui->cboxTables->clear(); ui->cboxTables->addItems(tables); if (tables.contains("LogInfo")) { ui->cboxTables->setCurrentIndex(ui->cboxTables->findText("LogInfo")); }}void frmDbClean::on_btnDo_clicked(){ if (!dbClean->getOk()) { return; } QString tableName = ui->cboxTables->currentText(); QString countName = ui->txtCountName->text(); QString orderSql = ui->txtOrderSql->text(); dbClean->setTableName(tableName); dbClean->setCountName(countName); dbClean->setWhereColumnName(countName); dbClean->setOrderSql(orderSql); //最大者保有历史记录仅目 dbClean->setMaxCount(AppConfig::Count3 * 10000); //修整间隔 dbClean->setCleanInterval(AppConfig::Interval3); dbClean->cleanData();}。

黄冈治疗白癜风的医院
白银治白癜风哪里最好
丹东白癜风哪里治疗好
新冠药
新冠风险在上升,为了健康,五一提前做好这些事儿!
长新冠患者心血管风险飙升200%!医生提醒:感染后72小时是关键
新冠病毒或与老年痴呆风险相关,权威研究引发关注
补益安神药

上一篇: 泰迪跟女儿一起跳绳,网友出去后看到这场面,戏弄翻了:泰迪成精了

下一篇: 丹阳一姑娘两人后,妈妈竟这样做!

友情链接