数据库综合性实验(图书管理系统)-2010310008xx-袁炜林-sql可执行文件.docx

《数据库综合性实验(图书管理系统)-2010310008xx-袁炜林-sql可执行文件.docx》由会员分享，可在线阅读，更多相关《数据库综合性实验(图书管理系统)-2010310008xx-袁炜林-sql可执行文件.docx（6页珍藏版）》请在第一文库网上搜索。

1、droptab1eAddBooks;droptab1eReadBooks;droptab1eBook;droptab1eAdmin;droptab1eReader;*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/*Tab1e:Book*/*=*/createtab1eBook(bnumvarchar2(20)notnu11,bnamevarchar2(20)nu11,authorvarchar2(20)nu11,pressvarchar2(20)nu11,aboutvarchar2(200)nu11,sumNum

2、ber(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

3、)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_aba

4、foreignkey(anum)referencesAdmin(anum),constraintfk_abbforeignkey(bnum)referencesBook(bnum)）；/*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二*/*Tab1e:ReadBooks*/*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二4/createtab1eReadBooks(bnumvarchar2(20)notnu11,rnumvarchar2(2

5、5)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)；*二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二二

6、二二二二二二二二二二二二二二二二二二二二二二*/*插入默认数据*/*=*/insertintoBookva1ues（,A10000,JAVA,毛泽东，人民教育出版社,一种编程语言，5）;insertintoBookVa1UeS（A程001,数据库，玛莎，人民教育出版社，一种编程语言，5）;insertintoBookva1ues（,B10000,古诗，苏东坡，嘻嘻嘻出版社，古诗，5）;insertintoBookva1ues（,C10000,自然，霍金，xxx出版社，略，5）;insertintoAdminva1ues（,1,林爷，1y123,110）;insertintoAdminVaIUe

7、S（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,add

8、sum）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(bn

9、um,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;