先是打开数据库QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); //
db.connectOptions();
db.setDatabaseName("lc");
if (!db.open())
{
QMessageBox::warning(0, QObject::tr("Database Error"),
db.lastError().text()); return false;
}
以下是查询和显示的处理
model = new QSqlTableModel(this);
model->setTable("UserTable");
model->setSort(UserTable_UserName, Qt::AscendingOrder);
model->setHeaderData(UserTable_UserName, Qt::Horizontal, tr("姓名"));
model->setHeaderData(UserTable_UserUnits, Qt::Horizontal, tr("单位"));
model->setHeaderData(UserTable_PWD, Qt::Horizontal, tr("MPH"));
model->setHeaderData(UserTable_Popedom, Qt::Horizontal, tr("权限"));
model->setHeaderData(UserTable_SpecialTopic, Qt::Horizontal, tr("专业代码")); //
model-> model->select(); //model-> //
view = new QTableView;
ui->usertableView->setModel(model);
ui->usertableView->setSelectionMode(QAbstractItemView::SingleSelection);
ui->usertableView->setSelectionBehavior(QAbstractItemView::SelectRows);
ui->usertableView->setColumnHidden(UserTable_UserName, true);
ui->usertableView->resizeColumnsToContents();
ui->usertableView->setEditTriggers(QAbstractItemView::NoEditTriggers);
main.cpp中已经做以下处理QTextCodec::setCodecForTr(QTextCodec::codecForLocale());
中文就是显示不正常不知道怎么回事