数据库综合性实验(图书管理系统)-2010310008xx-袁炜林-sql可执行文件.docx
droptab1eAddBooks;droptab1eReadBooks;droptab1eBook;droptab1eAdmin;droptab1eReader;*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/*Tab1e:Book*/*=*/createtab1eBook(bnumvarchar2(20)notnu11,bnamevarchar2(20)nu11,authorvarchar2(20)nu11,pressvarchar2(20)nu11,aboutvarchar2(200)nu11,sumNumber(5)defau1t0check(sum>=0),constraintpk_bprimarykey(bnm)）；/*=*/*Tab1e:Reader*/*=*/createtab1eReader(rnumvarchar2(25)notnu11,rnamevarchar2(20)nu11,addrvarchar2(100)nu11,rte1varchar2(20)nu11,constraintpk_rprimarykey(rnum)；/*=*/*Tab1e:Admin*/*=*/createtab1eAdmin(anumvarchar2(25)notnu11,anamevarchar2(20)nu11,mimavarchar2(25)defau1t,123456,ate1varchar2(20)nu11,constraintpk_aprimarykey(anum)；*Tab1e:AddBooks*/*=*/createtab1eAddBooks(anumvarchar2(25)notnu11,bnumvarchar2(20)notnu11,adatedatedefau1tsysdate,addsumNumber(5)defau1t0check(addsum>=0),constraintpk_abprimarykey(anum,bnum,adate),constraintfk_abaforeignkey(anum)referencesAdmin(anum),constraintfk_abbforeignkey(bnum)referencesBook(bnum)）；/*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/*Tab1e:ReadBooks*/*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二4/createtab1eReadBooks(bnumvarchar2(20)notnu11,rnumvarchar2(25)notnu11,brrDatedatedefau1tsysdate,reDatedatenu11,remainNumber(5)check(remain>=0),vio1atevarchar2(200)nu11,constraintpk_rbprimarykey(bnum,rnum,brrdate),constraintfk_rbrforeignkey(rnum)referencesReader(rnum),constraintfk_rbbforeignkey(bnum)referencesBook(bnum)；*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/*插入默认数据*/*=*/insertintoBookva1ues（,A10000,JAVA','毛泽东，人民教育出版社','一种编程语言'，5）;insertintoBookVa1UeS（'A程001','数据库，玛莎，'人民教育出版社，'一种编程语言'，5）;insertintoBookva1ues（,B10000,古诗'，'苏东坡'，'嘻嘻嘻出版社，'古诗'，5）;insertintoBookva1ues（,C10000,自然，霍金'，'xxx出版社，'略'，5）;insertintoAdminva1ues（,1,林爷'，'1y123','110'）;insertintoAdminVaIUeS（'22','炜sama,w123,120,）;insertintoAdminva1ues（,33',八神，'bs123,12210,）;insertintoAdminva1ues（'44','大蛇'，'ds123',T12310'）;insertintoReaderva1ues（,1,林爷，'火星'，T10'）；insertintoReaderva1ues（,22','炜sama,地球'，'120'）;insertintoReaderva1ues（,33',八神'，'银河系'，'12210'）;insertintoReaderva1ues（,44,大蛇'，'xx星'，T12310'）;insertintoAddBooks（anum,bnum,addsum）va1ues（,11,A10000,5）;insertintoAddBooks（anum,bnum,addsum）va1ues（,22,A1000,5）;insertintoAddBooks（anum,bnum,addsum）va1ues（'33','B10000,5）;insertintoAddBooks（anum,bnum,addsum）va1ues（'44','C10000,5）;insertintoReadBooks(bnum,rnum,reDate,remain,vio1ate)va1ues(,A10000,1,sysdate,O,nu11);insertintoReadBooks(bnum,rnum,reDate,remain,vio1ate)va1ues(,A1000,22,sysdate,O,nu11);insertintoReadBooks(bnum,rnum,reDate,remain,vio1ate)va1ues(,B10000,33,sysdate,O,nu11);insertintoReadBooks(bnum,rnum,reDate,remain,vio1ate)va1uesCC10000,44,sysdate,O,nu11);*检索数据*/一二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/se1ect*fromBook;se1ect*fromReader;se1ect*fromAdmin;se1ect*fromAddBooks;se1ect*fromReadBooks;
