请教高手如何使用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的颜色简写就是红色。这种标志在社交媒体中被广泛使用,有助于用户更好地区分原始信息与转载信息。