圖書(shū)管理系統(tǒng)詳細(xì)設(shè)計(jì)方案(編輯修改稿)
2025-06-06 00:03 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 e(bookstyle)create index borrow_record_index_readerid on borrow_record(readerid)create index reader_fee_index_readerid on reader_fee (readerid)create index return_record_index_readerid on return_record(readerid)create index system_books_index_bookname on system_books(bookname)create index system_books_index_styleno on system_books(bookstyleno)create index system_books_index_bookauthor on system_books(bookauthor)2 數(shù)據(jù)初始化（1）將書(shū)籍類(lèi)別加入表book_style中insert into book_style(bookstyleno,bookstyle)values(39。139。,39。人文藝術(shù)類(lèi)39。) insert into book_style(bookstyleno,bookstyle)values(39。239。,39。自然科學(xué)類(lèi)39。)insert into book_style(bookstyleno,bookstyle)values(39。339。,39。社會(huì)科學(xué)類(lèi)39。)insert into book_style(bookstyleno,bookstyle)values(39。439。,39。圖片藝術(shù)類(lèi)39。)insert into book_style(bookstyleno,bookstyle)values(39。539。,39。政治經(jīng)濟(jì)類(lèi)39。)insert into book_style(bookstyleno,bookstyle)values(39。639。,39。工程技術(shù)類(lèi)39。)insert into book_style(bookstyleno,bookstyle)values(39。739。,39。語(yǔ)言技能類(lèi)39。)（2）將已有的圖書(shū)加入system_books表中(定義相同的作者出版社的書(shū)本編號(hào)不一樣)insert into system_books(bookid,bookname,bookstyleno,bookauthor,bookpub,bookpubdate,bookindate,isborrowed )values(39。0012541515239。,39。計(jì)算機(jī)組成原理39。,39。639。,39。王愛(ài)英39。,39。清華大學(xué)出版社39。,39。2001010339。,39。2003111539。,39。139。)。insert into system_books(bookid ,bookname,bookstyleno,bookauthor,bookpub,bookpubdate,bookindate, isborrowed )values(39。0012541515339。,39。計(jì)算機(jī)組成原理39。,39。639。,39。王愛(ài)英39。,39。清華大學(xué)出版社39。,39。2001010339。,39。2003111539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。0045645639。,39。數(shù)據(jù)庫(kù)原理39。,39。639。,39。薩師煊39。,39。高等教育出版社39。,39。2007070239。,39。2007091539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub,bookpubdate, bookindate, isborrowed )values(39。1221512139。,39。C程序設(shè)計(jì)39。,39。639。,39。譚浩強(qiáng)39。,39。清華大學(xué)出版社39。,39。2002040239。,39。2004031439。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。978730802055839。,39。計(jì)算機(jī)體系結(jié)構(gòu)39。,39。639。,39。石教英39。,39。浙江大學(xué)出版社39。,39。2004100339。,39。2006111539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。4545614141439。,39。數(shù)據(jù)結(jié)構(gòu)（C語(yǔ)言版）39。,39。639。,39。吳偉民，嚴(yán)蔚敏39。,39。清華大學(xué)出版社39。,39。2002062839。,39。2004012139。,39。139。)。該系統(tǒng)設(shè)置四種類(lèi)型的用戶(hù)超級(jí)管理員(superadministrator) 即系統(tǒng)管理員擁有所有的權(quán)限。管理員(administrator) 可以進(jìn)行借還書(shū)處理；教師(teacher) :只能瀏覽圖書(shū)信息，可借書(shū)數(shù)為10本，借書(shū)時(shí)間長(zhǎng)為2個(gè)月。學(xué)生(student)：只能瀏覽圖書(shū)信息，可借書(shū)5本，借書(shū)時(shí)間長(zhǎng)為1個(gè)月。，存儲(chǔ)過(guò)程建立借書(shū)記錄存貯過(guò)程CREATE PROCEDURE SP_BORROWBOOK @BOOKID CHAR(20), @READERID CHAR(9) ASINSERT INTO BORROW_RECORD (BOOKID,READERID,BORROWDATE)VALUES(@BOOKID,@READERID,GETDATE())GO建立還書(shū)記錄存貯過(guò)程CREATE PROCEDURE SP_RETURNBOOK @BOOKID CHAR(20),@READERID CHAR(9)ASDELETE FROM RETUN_RECORDWHERE BOOKID=@BOOKID AND READERID=@READERIDGO建立罰款單存貯過(guò)程CREATE PROCEDURE SP_ READERFEE @READERID, @borrowdate ASUPDATE reader_feeSET bookfee=*(day(getdate())day(@borrowdate))Where @reader=@readeridAnd borrowdate=@borrowdate建立借書(shū)記錄表增加觸發(fā)器CREATE TRIGGER [TR_ADDLEND] ON [dbo].[ BORROW_RECORD] FOR INSERTASupdate system_booksset isborrowed =1WHERE BOOKID IN (SELECT BOOKID FROM inserted)UPDATE READERSET borrowednum = borrowednum +1WHERE READERID IN (SELECT READERID FROM inserted)建立還書(shū)記錄刪除觸發(fā)器CREATE TRIGGER [TR_DELLEND] ON [dbo]
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1