數(shù)據(jù)庫圖書管理系統(tǒng)課程設(shè)計(更新版)
【正文】 where readerid in (select readerid from inserted建立還書記錄刪除觸發(fā)器create trigger [tr_dellend] on return_recordfor deleteasupdate system_booksset isborrowed =0where bookid in (select bookid from deletedupdate system_readersset 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。d:\39。計算機(jī)組成原理39。2001010339。張三39。839。20182023010539。201811839。20182023010539。0012541515239。0012541515239。039。學(xué)生39。139。工科類39。d:\39。, size = 10, maxsize = 50, filegrowth = 5 log on指明事務(wù)日志文件( name = 39。,39。,39。,39。,39。,39。信息地修改update system_booksset bookname=39。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)通過對圖書借閱功能地分析,我分別創(chuàng)建了圖書信息表,讀者信息表,借閱信息表,八．心得體會這次實(shí)訓(xùn)最大地體會就是明白到自己之前有多么地懶惰,還好在老師地幫助下,但是我也發(fā)現(xiàn),只要用心地去學(xué),去鉆,。where bookid=39。insert into return_record (bookid,readerid,returndatefjnFLDa5Zovalues (39。,39。,39。,39。, 39。, filename = 39。library39。王愛英39。2003111539。男39。239。2018121839。王英39
公司管理相關(guān)推薦
鄂ICP備17016276號-1