圖書(shū)管理系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)-mysql實(shí)現(xiàn)-資料下載頁(yè)
2025-08-05 04:25本頁(yè)面
【正文】 ble values(stu_id, book_id, borrowdate, return_date)。 delete from borrow where = stu_id and = book_id。 end if。 end實(shí)驗(yàn)操作與結(jié)果顯示：學(xué)生1借了圖書(shū)2：超期產(chǎn)生了罰單，沒(méi)有交罰單，payoff=1：此時(shí)調(diào)用還書(shū)過(guò)程：call proc_return(1, 2, now())。提示交罰單：交罰單，調(diào)用proc_payoff:call proc_payoff(1, 2)。交罰單成功，payoff = 0；此時(shí)再次調(diào)用還書(shū)過(guò)程：call proc_return(1, 2, now())。還書(shū)成功，在return_table生成了還書(shū)紀(jì)錄：6. 交罰單存儲(chǔ)過(guò)程：修改罰單中payoff段為0，表明罰單已交：create procedure proc_payoff(in stuid int, in bookid int)begin update ticket set payoff = 0 where = stuid and = bookid。 select ‘succeed’。end交罰單，調(diào)用proc_payoff:call proc_payoff(1, 2)。交罰單成功，payoff = 0；功能實(shí)現(xiàn) 按各功能模塊進(jìn)行描述。要求：畫(huà)出流程圖并給出實(shí)現(xiàn)代碼。l 創(chuàng)建學(xué)生統(tǒng)一賬戶(hù),賬戶(hù)名：student_account，并且授予權(quán)限：sql：create user 39。student_account39。@39。localhost39。grant insert,select on student to 39。student_account39。@39。localhost39。grant select on book to 39。student_account39。@39。localhost39。grant insert,select on borrow to 39。student_account39。@39。localhost39。grant insert,select on return_table to 39。student_account39。@39。localhost39。grant select on ticket to 39。student_account39。@39。localhost39。l 創(chuàng)建管理員統(tǒng)一賬戶(hù)，賬戶(hù)名：manager_account, 并且授予全部權(quán)限：sql：create user 39。manager_account39。@39。localhost39。 identified by 39。12339。grant all on library_management to 39。manager_account39。@39。localhost39。l 查詢(xún)圖書(shū)信息按書(shū)名查找： select * from book where book_name = ‘sql’。按作者查找： select * from book where book_author = ‘a(chǎn)uthor’。l 借書(shū)功能: proc_borrow(in stu_id int, in book_id int, in borrow_date datetime)如果要接的書(shū)還在架上，并且學(xué)生的誠(chéng)信級(jí)為1，那么可以借書(shū)call proc_borrow(1, 1, now())。命令行操作：表borrow：視圖stu_borrow:表book：l 還書(shū)功能: proc_return(in stu_id int, in book_id int, in return_date datetime)call proc_return(1, 1, now())。命令行操作：表return_table:表borrow：表book：l 交罰單功能:proc_payoff(in stuid int, in bookid int)call proc_payoff(1,1)。實(shí)驗(yàn)操作和結(jié)果見(jiàn)上節(jié)：“6. 交罰單存儲(chǔ)過(guò)程“l(fā) 管理員添加圖書(shū)：insert into bookvalues(…)。操作與結(jié)果：l 管理員刪除圖書(shū)：delete from bookwhere (condition)。l 管理員注銷(xiāo)學(xué)生信息：delete from studentwhere (condition)。l 管理員恢復(fù)學(xué)生的誠(chéng)信級(jí)：update studentset stu_integrity=1where (condition)。學(xué)生借書(shū)歸還流程圖：管理員管理流程圖：數(shù)據(jù)庫(kù)設(shè)計(jì)結(jié)果：五、實(shí)習(xí)體會(huì)自己寫(xiě) 專(zhuān)業(yè)整理
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1