~~~
CREATE DATABASE test
CREATE TABLE book (
BookNO int PRIMARY KEY,
BookName varchar(50) NOT NULL,
Author varchar(50) ,
Publishment varchar(50),
ButTime varchar(50) ,
Borrowed varchar(50),
Ordered varchar(50) )
INSERT INTO book VALUES (10001,'oracle快速入门','王海亮','水利出版社','2003.1.12','否','否');
INSERT INTO book VALUES (10002,'数据库项目案例','周兴华','清华出版社','2003.3.16','否','否');
INSERT INTO book VALUES (10003,'大学英语','王海','外文出版社','2007.1.12','否','否');
INSERT INTO book VALUES (10004,'体育','张亮','体育出版社','2003.1.12','否','否');
INSERT INTO book VALUES (10005,'英语大全','jeans','外文出版社','2003.1.12','否','否');
INSERT INTO book VALUES (10006,'计算机网络','谢希任','高教出版社','2003.11.04','否','否');
INSERT INTO book VALUES (10007,'考验英语','李阳','文化出版社','2003.3.12','否','否');
INSERT INTO book VALUES (10008,'数值分析','王文超','实践出版社','2008.1.15','否','否');
INSERT INTO book VALUES (10009,'java me','秦一杰','人民邮电出版社','2004.1.12','否','否');
INSERT INTO book VALUES (10010,'思想理论','吴俊','同济大学出版社','2003.1.12','否','否');
select * from book
CREATE TABLE exceedtime (
StuNO int NOT NULL DEFAULT '0' ,
BookNO int DEFAULT NULL,
BookName varchar(50) DEFAULT '',
DelayTime int,
PRIMARY KEY (StuNO,BookName))
INSERT INTO exceedtime VALUES (10001,10001,'oracle快速入门',50);
INSERT INTO exceedtime VALUES (10002,10002,'数据库项目案例',50);
INSERT INTO exceedtime VALUES (10003,10001,'oracle快速入门',50);
INSERT INTO exceedtime VALUES (10004,10002,'数据库项目案例',50);
select * from exceedtime
CREATE TABLE losebook (
LBNO int NOT NULL,
StuNO int DEFAULT NULL,
BookNO int DEFAULT NULL,
BookName varchar(50) DEFAULT NULL,
PRIMARY KEY (LBNO) )
CREATE TABLE manager (
mgNo int NOT NULL,
permitted varchar(50) DEFAULT NULL,
password varchar(50) DEFAULT NULL,
PRIMARY KEY (mgNo))
INSERT INTO manager VALUES (1001,'1','1001');
select * from manager
CREATE TABLE orderreport (
BookNO int NOT NULL,
StuName varchar(50) DEFAULT NULL,
Class varchar(50) DEFAULT NULL,
BookName varchar(50) DEFAULT NULL,
StuNO int DEFAULT NULL,
Author varchar(50) DEFAULT NULL,
PRIMARY KEY (BookNO) )
CREATE TABLE record (
BookNO int NOT NULL,
StuNO int DEFAULT NULL,
BorrowTime varchar(50) DEFAULT NULL,
ReturnTime varchar(50) DEFAULT NULL,
Borrowed varchar(50) DEFAULT NULL,
Ordered varchar(50) DEFAULT NULL,
PRIMARY KEY (BookNO))
CREATE TABLE student (
StuNO int NOT NULL,
StuName varchar(50) DEFAULT NULL,
StuAge int DEFAULT NULL,
StuSex varchar(50) DEFAULT NULL,
Class varchar(50) DEFAULT NULL,
Department varchar(50) DEFAULT NULL,
Tel char(11) DEFAULT NULL,
Permitted varchar(50) DEFAULT NULL,
Password varchar(20) DEFAULT NULL,
PRIMARY KEY (StuNO) )
INSERT INTO student VALUES (10001,'陈小诗',20,'女','计算机1班','计算机系','2592921','是','number1');
INSERT INTO student VALUES (10002,'李飞',21,'女','计算机1班','计算机系','13730120123','是','number2');
INSERT INTO student VALUES (10003,'孙亚',20,'男','计算机1班','计算机系','13633654578','是','number3');
INSERT INTO student VALUES (10004,'何二',22,'男','计算机1班','计算机系','2568975','是','number4');
INSERT INTO student VALUES (10005,'唐雨',21,'女','计算机1班','计算机系','13936968956','是','number5');
INSERT INTO student VALUES (10006,'宋江',20,'男','计算机2班','计算机系','1234667','是','number6');
select * from student
~~~
