數(shù)據(jù)庫(kù)圖書管理系統(tǒng)課程設(shè)計(jì)-資料下載頁(yè)
2025-04-07 23:10本頁(yè)面
【正文】 rsset borrowednum = borrowednum 1where readerid in (select readerid from deleted建立刪除圖書觸發(fā)器create trigger [tr_dellendbook] on system_booksfor deleteasdelete reader_feewhere bookid in (select bookid from deleteddelete return _recordwhere bookid in (select bookid from deleted信息地錄入insert into system_books(bookid ,bookname,bookstyle,bookauthor,bookpub,bookpubdate, bookindate, isborrowed 7EqZcWLZNXvalues(39。0012541515239。,39。計(jì)算機(jī)組成原理39。,39。王愛英39。, 39。工科類39。,39。清華大學(xué)出版社39。,39。2001010339。,39。2003111539。,39。139。lzq7IGf02Einsert into system_readers(readerid,readername,readersex,readertype,regdate,booktotal,borrowednum,overduenoreturnnumzvpgeqJ1hkvalues(39。20182018010539。,39。張三39。,39。男39。,39。學(xué)生39。,39。20181639。,39。839。,39。239。,39。039。NrpoJac3v1insert into borrow_record(bookid,readerid,borrowdate1nowfTG4KIvalues (39。0012541515239。,39。20182023010539。,39。2018121839。insert into return_record (bookid,readerid,returndatefjnFLDa5Zovalues (39。0012541515239。,39。20182023010539。,39。201811839。信息地修改update system_booksset bookname=39。王英39。where bookid=39。0012541515239。update system_readers set readersex=39。女39。where readerid=39。20182023010539。update borrow_record set bookid=’00125415153’where bookid=’00125415152’update return_recordset bookid=’00125415153’where bookid=’00125415152’信息地刪除delete from system_bookswhere bookid=’001215415152’delete from system_readerswhere readerid=’201820230105’delete from borrow_recordwhere bookid=’001215415152’七．實(shí)驗(yàn)總結(jié)本次實(shí)驗(yàn)通過對(duì)圖書借閱功能地分析,我分別創(chuàng)建了圖書信息表,讀者信息表,借閱信息表,八．心得體會(huì)這次實(shí)訓(xùn)最大地體會(huì)就是明白到自己之前有多么地懶惰,還好在老師地幫助下,但是我也發(fā)現(xiàn),只要用心地去學(xué),去鉆,
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1