【導(dǎo)讀】知識(shí)的主要途徑，而各類(lèi)書(shū)店在人們的學(xué)習(xí)生活中也逐漸占據(jù)了重要的位置。脫傳統(tǒng)的人工管理方式，實(shí)現(xiàn)科學(xué)、有效地管理書(shū)店不僅能提高書(shū)店自身的發(fā)展，也能極大的方便各類(lèi)讀者的需求。因此，開(kāi)發(fā)一個(gè)完善的圖書(shū)租賃管理系統(tǒng)是十。理系統(tǒng)的星系過(guò)程。本系統(tǒng)采用自頂向下地分析與設(shè)計(jì)，自下而上地應(yīng)用開(kāi)發(fā)的。形成了一個(gè)比較全面系統(tǒng)的管理模式。

　　

【正文】 e FROM Book,VBorrowBook where = 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 26 create view TBBinfo as select ,Tphno from Book,TBorrowBook where = 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 27 create view InmanagerInfo as select Mname,Mphno,DIneSum,Ddate from SystemManager,Ine where = 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 28 數(shù)據(jù)表視圖的建立（ Oracle） create view VBBinfo as select ,Vno,Bwriter,Bname FROM Book,VBorrowBook where = 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 29 create view TBBinfo as select ,Tphno from Book,TBorrowBook where = 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 30 create view InmanagerInfo as select Mname,Mphno,DIneSum,Ddate from SystemManager,Ine where = 附錄 4 觸發(fā)器及存儲(chǔ)過(guò)程 存儲(chǔ)過(guò)程的定義 （ SQL Server2021） create procedure P1_Book_Insert @Bsno char(15) , @Bname char (30), @Bprice numeric (10), @Bwriter char (20), @Bsort char (10), @BScount smallint, @BNowcount smallint , @BNewcount smallint as insert into Book 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 31 values(@Bsno,@Bname,@Bprice,@Bwriter, @Bsort,@Bscount,@Bnowcount,@Bnewcount)。 create procedure P2_Vip_Insert @Vno char (10) , @Vname varchar (20), @Vsex char (5), @Vphno varchar(11), @Vwexpired char (2), @Vfee smallint, @VAcount smallint, @VBcount smallint, @Waexit char (10), @VMdate datetime as insert into Vip values(@Vno,@Vname,@Vsex,@Vphno,@Vwexpired,@vfee, @Vacount,@Vbcount,@Waexit,@Vmdate)。 create procedure P3_SystemManager_Insert @Mno char(4), @Mname varchar(20), @Mphno char(15) as insert into SystemManager values(@Mno,@Mname,@Mphno) create procedure P4_Ine_Insert @Mno char(4), @Ddate datetime, @Trent smallint, @Efine smallint, @Bdfine smallint, @Lfine smallint, @Vfee smallint, @DIneSum smallint as insert into Ine values(@Mno,@Ddate,@Trent,@Efine,@Bdfine,@Lfine,@Vfee,@DIneSum) 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 32 create procedure P5_VBorrowBook_Insert @Bsno char(15), @Vno char(10), @Ldate datetime, @Rdeadline datetime as insert into VBorrowBook values(@Bsno,@Vno,@Ldate,@Rdeadline) create procedure P6_VReturnBook_Insert @Vno char(10), @Bsno char(15), @Rdeadline datetime, @Rdate datetime, @Wrexpired char(2), @Bdfine smallmoney, @Lfine smallmoney, @Efine smallmoney as insert into VReturnBook values(@Vno,@Bsno,@Rdeadline,@Rdate,@Wrexpired,@Efine,@Bdfine,@Lfine) create procedure P7_TBorrowBook_Insert @Bsno char(15), @Tphno char(15), @Ldate datetime, @ReadLine datetime, @Tdeposit smallint as insert into TBorrowBook values(@Bsno,@Tphno,@Ldate,@Readline,@Tdeposit) create procedure P8_TReturnBook_Insert @Bsno char(15), @Tphno char(15), @Readline datetime, @Rdate datetime, @Wrexpired char(2), 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 33 @Trent smallint, @Efine smallint, @Bdfine smallint, @Lfine smallint as insert into TReturnBook values(@Bsno,@Tphno,@Readline,@Rdate,@Wrexpired, @Trent,@Efine,@Bdfine,@Lfine) create procedure P9_Book_Delete @Bname char(30) as delete from Book where Bname=RTRIM(LTRIM(@Bname))。 create procedure P10_SystemManager_Delete @Mno char(4) as delete from SystemManager where Mno=RTRIM(LTRIM(@Mno))。 create procedure P11_Vip_Delete @Vno char(10) as delete from Vip where Vno=RTRIM(LTRIM(@Vno))。 ，其對(duì)應(yīng)的借閱信息也刪除 create procedure P1_del_borrow @Bname char(15) as delete from Book where Bname=@Bname 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 34 ,如果書(shū)庫(kù)中還有該書(shū)可借，進(jìn)行借閱，否則，出提示信息。 create procedure book_canborrow @Bname varchar(30) as declare @Bscount smallint, @Bnowcount smallint, @Bprice numeric(10,0), @Bsno char(15), @Vno char(10), @Ldate datetime, @Readline datetime, @Tdeposit smallint, @Tphno char(15) /*從 Book 表中選出書(shū)的總量 */ select @Bscount=Bscount from Book where Bname=@Bname /*從 Book 表中選出書(shū)的現(xiàn)存量 */ select @Bnowcount=Bnowcount from Book where Bname=@Bname /*從 Book 表中選出書(shū)的價(jià)格 */ select @Bprice=Bprice from Book where Bname=@Bname /*從 Book 表中選出書(shū)的店內(nèi)編號(hào) */ select @Bsno=Bsno from Book where Bname=@Bname /*非會(huì)員的押金 */ select @Bprice=Bprice from Book where Bname=@Bname set @Tdeposit=@Bprice* if(@Bname in(select Bname from Book)) begin if(@Bnowcount=0) 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 35 begin print39。對(duì)不起，您所查詢(xún)的 39。+@Bname+39。已全部借出 ,請(qǐng)您選擇其他相關(guān)書(shū)籍借閱 39。 end else if(@Bnowcount0) begin print39。您所查詢(xún)的 39。+@Bname+39。有庫(kù)存，您可以借閱 ,請(qǐng)輸入您的會(huì)員卡號(hào)39。+@Vno if(@Vno=null) begin insert into TBorrowBook values(@Bsno,@Tphno,@Ldate,@Tdeposit,@Readline) end else if(@Vno0) begin insert into VBorrowBook values(@Bsno,@Vno,@Ldate,@Readline) end end end else print39。您所查詢(xún)的書(shū)籍不存在，請(qǐng)核對(duì)后再查 39。 create procedure day_ine_search @Mno char(4) as declare @Ddate datetime, @DIneSum smallint, @Trent smallint, @Efine smallint, @Bdfine smallint, @Lfine smallint, @Vfee smallint, @Mname varchar(20) /*從 Ine 表中選出當(dāng)天的系統(tǒng)管理員 */ select @Mno=Mno from Ine 2021 級(jí)信管專(zhuān)業(yè) 3 班數(shù)據(jù)庫(kù)應(yīng)用系統(tǒng)課程設(shè)計(jì)課程論文 36 where Mno=@Mno /*從 Ine 表中選出當(dāng)天非會(huì)員的租金 */ select @Trent=Trent from Ine where Mno=@Mno /*從 Ine 表中選出當(dāng)天過(guò)期還書(shū)的罰款 */ select @Efine=Efine from Ine where Mno=@Mno /*從 Ine 表中選出當(dāng)天還書(shū)中因書(shū)被損壞所收的罰金 */ select @Bdfine=Bdfine from Ine where Mno=@Mno /*從 Ine 表中選出當(dāng)天因書(shū)丟失所收到的賠償金 */ select @Lfine=Lfine from Ine where Mno=@Mno /*從 Ine 表中選出當(dāng)天因?yàn)樾略鰰?huì)員所收的會(huì)員費(fèi) */ select @Vfee=Vfee from Ine where Mno=@Mno /*從 SystemManager 表中選出管理員姓名 */ select @Mname=Mname from SystemManager where @Mno=Mno set @DIneSum=0 begin set @DIneSum=@Trent+@Efine+@Bdfine+@Lfine+@Vfee print39。當(dāng)天的