Qt连接数据库:
void ConnectDb::onConnectDb()
{
QMessageBox msgBox;
dbconn=QSqlDatabase::addDatabase("QSQLITE");
dbconn.setDatabaseName("E:\\MyJob\\ConnectDb\\testDatabase.db");
if(!dbconn.open())
{
dbconn.close();
QMessageBox::warning(NULL,tr("提示"),tr("打开数据库失败!"),tr("确定"));
}
else
{
msgBox.setText(tr("打开数据库成功"));
msgBox.exec();
}
}
使用QTableWidget显示数据:
void ConnectDb::onShowDb()
{
QSqlQuery query;
int i = 0, j = 0, nColumn, nRow;
query.prepare("select * from testTable");
query.exec();
query.last();
nRow = query.at() + 1;
ui.tableWidget->setRowCount(nRow);
nColumn = ui.tableWidget->columnCount();
query.first();
while(j<nRow)
{
for (i = 0; i<nColumn; i++)
ui.tableWidget->setItem(j, i, new QTableWidgetItem(query.value(i).toString()));
j++;
query.next();
}
dbconn.close();
}