利用
QTableView与QSqlTableModel显示
数据库中的浮点数据时,为什么科学计数法?能不能实现普通的
显示?
代码如下:
db_sqlite = QSqlDatabase::addDatabase("QSQLITE");
db_sqlite.setDatabaseName("testDB.db3");
if (!db_sqlite.open())
{
QMessageBox::critical(0, tr("Cannot open database"),
tr("Unable to establish a database connection.\n"
"This example needs
SQLite support. Please read "
"the Qt
SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."),
QMessageBox::Cancel);
return false;
}
db_TableModel = new QSqlTableModel;
db_TableModel->setTable("test_table");
db_TableModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
db_TableModel->select();
db_TableView = new QTableView;
db_TableView->setModel(db_TableModel);
db_TableView->setWindowTitle("SQLite view");
数据库表格显示如下: