图书馆管理系统代码+SQL脚本

create table managerInfo( mangNO int(10) not null, mangName char(20) not null, mangPassword char(20) not null, primary key(mangNO)); create table bookInfo( callNO int not null, bookName char(50) not null, bookAuther char(20) not null, time char(50) not null, bookPrice double not null, bookObject char(20) not null, number int not null, primary key(callNO)); create table readerInfo( readerNO int not null, readerName char(20) not null, readerMajor char(20) not null, primary key(readerNO)); create table borrow ( id mediumint not null auto_increment, outTime date not null, inTime date not null, callNO int not null, readerNO int not null, foreign key(callNO) references bookInfo(callNO), foreign key(readerNO) references readerInfo(readerNO) ); insert into bookInfo(callNO,bookName,bookAuther,time,bookPrice,bookObject,number) values(1247,"JSP应用开发","马建红","2010.2",58.0,"计算机",10); insert into readerInfo(readerNO,readerName,readerMajor) values(1014010112,"刘新卉","软件工程"), (1014010111,"刘晓男","软件工程"), (1014010114,"邢宇","软件工程"), (1014010113,"孙德伟","软件工程"), (1014010115,"何俊良","软件工程");