query.exec("CREATE TABLE students (" "id INTEGER PRIMARY KEY AUTOINCREMENT, " "name VARCHAR(40) NOT NULL, " " score INTEGER NOT NULL, " "class VARCHAR(40) NOT NULL)"); //创建一个students表,标题分别为id、name、score、class 1. 2. 3. 4. 5. 6. "PRIMARY KEY AUTOINCREMENT,":表示...
"id INTEGER PRIMARY KEY AUTOINCREMENT," "name VARCHAR," "age INT)")) { QMessageBox::critical(0, QObject::tr("Database Error"), query.lastError().text()); return 1; } } else { return 1; } return a.exec(); } main()函数中,我们调用这个connect()函数打开数据库。如果打开成功,我们...
if(!query.exec("create table if not exists user(id integer primary key autoincrement,username ntext unique not NULL,password ntext not NULL)")) { qDebug()<<"创建表格失败!"; } } Widget::~Widget() { delete ui; } 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. ...
程序运行后我们将在mainwindow::mainwindow(qwidget *parent)构造函数内完成数据库表记录与tableview组件字段的对应关系绑定,将数据库绑定到qdatawidgetmapper对象上,绑定代码如下。 mainwindow::mainwindow(qwidget *parent) :qmainwindow(parent),ui(new ui::mainwindow) { ui->setupui(this); // 打开数据库 db=q...
FOREIGNKEY(class_id) REFERENCESpc_class(id)) Qt sqlite 外键写入例子(开启事务写入) QStringList sqlList <<QString("create table users (id INTEGER primary key AUTOINCREMENT,") +QString("name varchar(16), passwordvarchar(30), power int, FOREIGNKEY(power) REFERENCESuser_roles(id));")// 创建...
( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name CHAR (50) UNIQUE NOT NULL, age INTEGER );)"; //QSqlQuery构造前,需要db已打开并连接 //未指定db或者db无效时使用默认连接进行操作 QSqlQuery query; if(query.exec(sql)){ qDebug()<<"init table success"; }else{ //打印sql语句错误信息 q...
db.open()) {qDebug() < <"Failedto connect database.";returnfalse; }// 创建 petfeeder 表QSqlQuery query;boolret = query.exec("CREATE TABLE IF NOT EXISTS petfeeder ""(id INTEGER PRIMARY KEY AUTOINCREMENT, ""interval INTEGER, temperature REAL, weight REAL)");if(!ret) {qDebug() < <...
db.open()){std::cout<<db.lastError().text().toStdString()<<std::endl;return;}// 执行SQL创建表db.exec("DROP TABLE Student");db.exec("CREATE TABLE Student (""id INTEGER PRIMARY KEY AUTOINCREMENT, ""name VARCHAR(40) NOT NULL, ""age INTEGER NOT NULL)");// 批量创建数据QString...
query.exec("CREATE TABLE students (""id INTEGER PRIMARY KEY AUTOINCREMENT, ""name VARCHAR(40) NOT NULL, "" score INTEGER NOT NULL, ""class VARCHAR(40) NOT NULL)");//创建一个students表,标题分别为id、name、score、class " PRIMARY KEY AUTOINCREMENT,":表示该列为整数递增,如果为空时则自动填...
"id INTEGER PRIMARY KEY AUTOINCREMENT, " "name VARCHAR(40) NOT NULL, " "departID INTEGER NOT NULL)" ); // 逐条插入数据 db.exec("INSERT INTO Student(name,departID) VALUES('zhangsan',10)"); db.exec("INSERT INTO Student(name,departID) VALUES('lisi',20)"); ...