|
Joey_Chan 发表于 2015-6-16 21:10
为什么你前面写的是borrowL, 后面写borrow
在db文件里并没有找到borrow这个表,是我创建表格时错误了吗,还是列数太多了,把代码贴给你看- static bool connect ()
- {
- //连接数据库,如果不存在则新建一个
- bool ok=QFile::exists("library.db");
- QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
- db.setDatabaseName("library.db");
- if(!db.open())
- {
- QMessageBox::warning(0,"title","打开数据库失败");
- return false;
- }
- QSqlQuery query;
- query.exec("create table student(id varchar(40) PRIMARY KEY,password varchar(40));");
- query.exec("create table borrow(id varchar(40) PRIMARY KEY,code varchar(40),name varchar(40),author varchar(40),bor varchar,re varchar");
- query.exec("create table manager(id varchar(40) PRIMARY KEY,password varchar(40));");
- query.exec("create table allbook(code varchar(40) PRIMARY KEY,name varchar(40),author varchar(30),amount varchar(5));");
- query.exec("insert into borrow(id,code,name,author,bor,re)values('liuxin','201','wings','Jane','2015-06-16','2015-07-16')");
- query.exec("select * from borrow");
- while(query.next())
- {
- QString a=query.value(0).toString();
- QString b=query.value(1).toString();
- QString c=query.value(2).toString();
- QString d=query.value(4).toString();
- qDebug()<<a<<b<<c<<d;
- }
- return true;
- }
复制代码 |
|