數(shù)據(jù)庫圖書管理系統(tǒng)課程設(shè)計(參考版)
2025-04-10 23:10本頁面
【正文】 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’七．實驗總結(jié)本次實驗通過對圖書借閱功能地分析,我分別創(chuàng)建了圖書信息表,讀者信息表,借閱信息表,八．心得體會這次實訓最大地體會就是明白到自己之前有多么地懶惰,還好在老師地幫助下,但是我也發(fā)現(xiàn),只要用心地去學,去鉆,。where readerid=39。update system_readers set readersex=39。where bookid=39。信息地修改update system_booksset bookname=39。,39。,39。insert into return_record (bookid,readerid,returndatefjnFLDa5Zovalues (39。,39。,39。NrpoJac3v1insert into borrow_record(bookid,readerid,borrowdate1nowfTG4KIvalues (39。,39。,39。,39。,39。,39。,39。,39。lzq7IGf02Einsert into system_readers(readerid,readername,readersex,readertype,regdate,booktotal,borrowednum,overduenoreturnnumzvpgeqJ1hkvalues(39。,39。,39。,39。,39。, 39。,39。,39。,指定存儲地路徑名和文件名LDAYtRyKfE size = 5mb, maxsize = 25mb, filegrowth = 5mb 建立圖書信息表create table system_books (bookid varchar(20primary key , 書籍編號為主鍵bookname varchar(30 Not null, 圖書名稱bookstyle varchar(30 Not null,圖書類型bookauthor varchar(30, 圖書作者bookpub varchar(30 , 出版社bookpubdate datetime, 出版時間bookindate datetime , 收錄時間isborrowed bit, 是否被借建立讀者信息表create table system_readers (readerid varchar(9primary key,借書證號為主鍵readername varchar(10 not null,讀者姓名readersex char(2not null,性別readertype varchar(20not null,讀者類型regdate datetime,登記時間booktotal int,可借書數(shù)borrowednum int,
公司管理相關(guān)推薦
鄂ICP備17016276號-1