ããå¨QTçwidgetä¸ç¨tableviewæ¾ç¤ºsqliteæ°æ®åºè¡¨ä¸çå
容ã
ããå设ææ°æ®åºæ件test.db,æ表table(id integer, name nvarchar(20),age integer)ï¼ä¸ææ°æ¡æ°æ®ã
ããé¦å
ç¨QTcreatorå建ä¸ä¸ªåºäºWidgetç±»ççªå£ï¼åæä¸ä¸ªtableviewå°widgetä¸ï¼ä¿åï¼ç¶åæç
§å¦ä¸æ¹æ³è¿è¡ï¼
ãã1.å¨widget.hä¸å¢æ·»
头æ件ï¼QtSql/qsql.hãQtSql/QsqlDatabaseãQtSql/QsqlQueryãQtSql/QsqlQueryModel
ãã2.å¨.proå·¥ç¨æ件ä¸æ·»å ï¼QT+=sql
ãã3.å¨widget.cppä¸widgetç
æé å½æ°ä¸æ·»å å¦ä¸ä»£ç ï¼
ããQsqDatabase db = QsqlDatabase::addDatabase("QSQLITE");
ããdb.setDatabaseName("test.db");
ããif(!db.open())
ãã{
ãã//é误å¤ç
ãã}
ããstatic QSqlQueryModel *model = new QSqlQueryModel(ui->tableview);
ããmodel->setQuery(QString("select * from table"));
ããmodel->setHeaderData(0,Qt::Horizontal,QObject::tr("ç¼å·"));
ããmodel->setHeaderData(1,Qt::Horizontal,QObject::tr("å§å"));
ããmodel->setHeaderData(2,Qt::Horizontal,QObject::tr("å¹´é¾"));
ããui->tableview->setModel(model);
ããdb->close();
ããè¿æ ·ä¹åï¼table表éçå
容就ä¼æ¾ç¤ºå°tableviewä¸äºã