QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("D:/SqliteDatabase/syspara");
if (!db.open()) {
QMessageBox::critical(0, qApp->tr("Cannot open database"),
qApp->tr("Unable to establish a database connection.\n"
"This example needs QSQLITE support. Please read "
"the Qt SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."), QMessageBox::Cancel);
return false;
}
return true;
}
上段代码可在程序初始化的时候调用,主要是连接数据库,当然要先建立对应的sqlite数据库文件。
下段代码是查询:(比如点击了一个按钮)
void MainWindow::on_pBtnShowTable_clicked()
{
// QDate date = ui->dateEdit->date();
int intyear = ui->dateEdit->date().year();
int intmonth = ui->dateEdit->date().month();
int intday = ui->dateEdit->date().day();
// QString dateStr = ui->dateEdit->date().toString("yyyy-MM-dd");
QSqlTableModel *model = new QSqlTableModel(this);
model->setTable("failtb");
model->setHeaderData(0,Qt::Horizontal,tr("年"));
model->setHeaderData(1,Qt::Horizontal,tr("月"));
model->setHeaderData(2,Qt::Horizontal,tr("日"));
model->setHeaderData(3,Qt::Horizontal,tr("时间"));
model->setHeaderData(4,Qt::Horizontal,tr("描述"));