setTable("scooter");model->setSo" />
首页 > 软件教程

tr5white插件安装 请教高手如何使用QT建立SQLite数据库

更新时间:2024-03-18 16:32:49 来源:嗨二软件园

请教高手如何使用QT建立SQLite数据库

代码如下

#include<QtGui>#include<QtSql>#include"scooterwindow.h"ScooterWindow::ScooterWindow(){model=newQSqlTableModel(this);model->setTable("scooter");model->setSort(Scooter_Name,Qt::AscendingOrder);model->setHeaderData(Scooter_Name,Qt::Horizontal,tr("Name"));model->setHeaderData(Scooter_MaxSpeed,Qt::Horizontal,tr("MPH"));model->setHeaderData(Scooter_MaxRange,Qt::Horizontal,tr("Miles"));model->setHeaderData(Scooter_Weight,Qt::Horizontal,tr("Lbs"));model->setHeaderData(Scooter_Description,Qt::Horizontal,tr("Description"));model->select();view=newQTableView;view->setModel(model);view->setSelectionMode(QAbstractItemView::SingleSelection);view->setSelectionBehavior(QAbstractItemView::SelectRows);view->setColumnHidden(Scooter_Id,true);view->resizeColumnsToContents();view->setEditTriggers(QAbstractItemView::NoEditTriggers);QHeaderView*header=view->horizontalHeader();header->setStretchLastSection(true);QHBoxLayout*mainLayout=newQHBoxLayout;mainLayout->addWidget(view);setLayout(mainLayout);setWindowTitle(tr("Scooters"));}#ifndefSCOOTERWINDOW_H#defineSCOOTERWINDOW_H#include<QWidget>classQSqlTableModel;classQTableView;enum{Scooter_Id=0,Scooter_Name=

1,Scooter_MaxSpeed=

2,Scooter_MaxRange=

3,Scooter_Weight=

4,Scooter_Description=5};classScooterWindow:publicQWidget{Q_OBJECTpublic:ScooterWindow();private:QSqlTableModel*model;QTableView*view;};#endif#include<QtGui>#include<QtSql>#include"scooterwindow.h"boolcreateConnection(){QSqlDatabasedb=QSqlDatabase::addDatabase("QSQLITE");db.setDatabaseName("scooters.dat");if(!db.open()){QMessageBox::warning(0,QObject::tr("DatabaseError"),db.lastError().text());returnfalse;}returntrue;}voidcreateFakeData(){QSqlQueryquery;query.exec("DROPTABLEscooter");query.exec("CREATETABLEscooter(""idINTEGERPRIMARYKEYAUTOINCREMENT,""nameVARCHAR(40)NOTNULL,""maxspeedINTEGERNOTNULL,""maxrangeINTEGERNOTNULL,""weightINTEGERNOTNULL,""descriptionVARCHAR(80)NOTNULL)");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('Mod-Rad1500',40,35,298,""'Speedometer,odometer,batterymeter,turnsignal""indicator,lockingsteeringcolumn')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('Rad2GoGreatWhiteE36',22,12,93,""'10\"airlesstires')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('X-TremeX360',21,14,59,""'Cargorack,foldable')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('VegoSX600',20,,76,""'Twointerchangeablebatteries,foldable')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('SunbirdEBike',18,30,118,'')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('LeopardShark',16,12,63,""'Batteryindicator,removableseat,foldable')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('VegoiQ450',15,0,60,""'OUTOFSTOCK')");query.exec("INSERTINTOscooter(name,maxspeed,""maxrange,weight,description)""VALUES('X-TremeX-11',15,11

traditional culture有复数形式吗

当tradition的意思是“传统,传说”时,是不可数的。

当tradition的意思是“惯例”时,是可数的。复数形式为traditions。

tradition

英文发音:[tr?'d??(?)n]

中文释义:

n.惯例,传统;传说

例句:

Inmanycountriesyoungpeoplestillkeepupthetraditionthatwomenwillgetmarriedinalongwhitedress.

许多国家里,年轻人仍保持着妇女结婚时穿白色长礼服的传统。

短语:

1、culturaltradition文化传统

2、bytradition照传统;根据口传

3、oraltradition口头传统;口传;口传

扩展资料

tradition的同根词:

1、traditional

英文发音:[tr?'d??(?)n(?)l]

中文释义:

adj.传统的;惯例的

例句:

Traditionalteachingmethodssometimesonlysucceededinputtingstudentsofflearning.

传统的教学方法有时只会使学生们厌学。

2、traditionally

英文发音:[tr?'d???n?li]

中文释义:

adv.传统上;习惯上;传说上

例句:

Well,traditionally,yes.Butforpracticalreasons.

传统上是的,但是实际的原因

rt什么颜色的简写

RT的颜色简写是红色。RT是英文单词“retweet”的缩写,意为转发。在社交媒体上,用户可以通过点击“转发”按钮将其他用户的信息转载到自己的账号中,形成一种信息传播的链式反应。

而转发的原始信息在被其他用户转载的同时,会用红色字体显示“RT”,以突出与原始信息的区别。因此,RT的颜色简写就是红色。这种标志在社交媒体中被广泛使用,有助于用户更好地区分原始信息与转载信息。