#include<qapplication.h>
#include<qsqldatabase.h>
#include "../lib/connection.h"
int main(int argc,char *argv[])
{
QApplication app(argc,argv);
if(!createConnections())
return 1;
QSqlQuery query;
//query.exec("CREATE DATABASE library;");
query.exec("DROP TABLE book;");
query.exec("DROP TABLE loanbook;");
query.exec("DROP TABLE reader;");
query.exec("DROP TABLE subject;");
query.exec("DROP TABLE sysmange;");
query.exec("CREATE TABLE book("
"bISBN VARCHAR(10) NOT NULL,"
"sorted VARCHAR(30) NOT NULL,"
"code VARCHAR(10) NOT NULL)");
query.exec("CREATE TABLE loanbook("
"lbnum VARCHAR(10) NOT NULL,"
"lbnam VARCHAR(40) NOT NULL,"
"loandat VARCHAR(50) NOT NULL,"
"lrtndate VARCHAR(50) NOT NULL,"
"lcount INTEGER,"
"lbrwcount INTEGER)");
query.exec("CREATE TABLE sysmange("
"snum VARCHAR(10) NOT NULL,"
"snam VARCHAR(40) NOT NULL,"
"popedom VARCHAR(2) NOT NULL,"
"pwd VARCHAR(10) NOT NULL)");
query.exec("CREATE TABLE subject("
"sISBN INTEGER NOT NULL,"
"sbnum VARCHAR(10) NOT NULL,"
"sbnam VARCHAR(40) NOT NULL,"
"pbl VARCHAR(50),"
"scount INTEGER,"
"author VARCHAR(40),"
"pbler VARCHAR(40))");
query.exec("CREATE TABLE reader("
"rnum VARCHAR(10) NOT NULL,"
"rbnum VARCHAR(10) NOT NULL,"
"rnam VARCHAR(40),"
"sex VARCHAR(8),"
"age INTEGER,"
"bckcount INTEGER,"
"rbrwcount INTEGER)");
#if 1
query.exec("INSERT INTO reader "
"VALUES('11111','11111','aa','m','12','5','132')");
query.exec("INSERT INTO reader "
"VALUES('11112','11112','bb','m',22','5','122')");
query.exec("INSERT INTO reader "
"VALUES('11113','11113','cc','f','32','5','12222')");
query.exec("INSERT INTO reader "
"VALUES('11114','11114','dd','f','32','2','1332')");
query.exec("INSERT INTO reader "
"VALUES('11115','11115','ee','f','22','2','12')");
query.exec("INSERT INTO reader "
"VALUES('11116','11116','ff','m','12','5','132')");
query.exec("INSERT INTO subject "
"VALUES('1111','11111','a','2000-12-6','12','aqws','aa')");
query.exec("INSERT INTO subject "
"VALUES('1112','11112','b','2001-08-6','22','aes','awa')");
query.exec("INSERT INTO subject "
"VALUES('1113','11113','c','2002-09-6','32','eas','waa')");
query.exec("INSERT INTO subject "
"VALUES('1114','11114','d','2003-10-6','34','aas','aas')");
query.exec("INSERT INTO subject"
"VALUES('1115','11115','e','2004-11-6','32','ass','asa')");
query.exec("INSERT INTO subject "
"VALUES('1116','11116','f','2005-02-12','22','sss','sas')");
query.exec("INSERT INTO book "
"VALUES('1111','ass','11111')");
query.exec("INSERT INTO book "
"VALUES('1112','dsa','11112')");
query.exec("INSERT INTO book "
"VALUES('1113','sdfsd','11123')");
query.exec("INSERT INTO book"
"VALUES('1114','sdfsd','111234')");
query.exec("INSERT INTO book "
"VALUES('1115','sdfs','111234')");
query.exec("INSERT INTO book "
"VALUES('1116','fghf','111334')");
query.exec("INSERT INTO loanbook "
"VALUES('11111','a','2001-01-01','2001-02-01','5','0')");
query.exec("INSERT INTO loanbook "
"VALUES('11112','b','2001-01-01','2001-02-01','2','2')");
query.exec("INSERT INTO loanbook "
"VALUES('11113','c','2001-01-01','2001-02-01','1','3')");
query.exec("INSERT INTO loanbook "
"VALUES('11114','d','2001-01-01','2001-02-01','0','1')");
query.exec("INSERT INTO loanbook"
"VALUES('11115','e','2001-01-01','2001-02-01','3','0')");
query.exec("INSERT INTO loanbook "
"VALUES('11116','f','2001-01-01','2001-02-01','1','2')");
query.exec("INSERT INTO sysmange "
"VALUES('11111','aa','r','1111')");
query.exec("INSERT INTO sysmange "
"VALUES('11112','bb','u','2222')");
query.exec("INSERT INTO sysmange "
"VALUES('11113','cc','u','3333')");
query.exec("INSERT INTO sysmange "
"VALUES('11114','dd','u','4444')");
query.exec("INSERT INTO sysmange"
"VALUES('11115','ee','u','5555')");
query.exec("INSERT INTO sysmange "
"VALUES('11116','ff','u','6666')");
#endif
return 0;
}
我是在MYSQL数据库的,数据库的简单建立