數(shù)據(jù)庫(kù)圖書(shū)管理系統(tǒng)含代碼(編輯修改稿)
2025-05-04 23:10 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 NT BorrowPK1 FOREIGN KEY(adminNo) REFERENCES Admin(adminNo), CONSTRAINT BorrowPK2 FOREIGN KEY(readerNo)REFERENCES Reader(readerNo), CONSTRAINT BorrowPK3 FOREIGN KEY(bookNo) REFERENCES Book(bookNo), ) （6）創(chuàng)建管理員_圖書(shū)表Admin_BookCREATE TABLE Admin_Book( adminNo varchar(12) not null, bookNo varchar(20) not null, shopTime datetime, inLibrary char(4) CONSTRAINT Admin_BookPK PRIMARY KEY(adminNo,bookNo), CONSTRAINT Admin_BookPK1 FOREIGN KEY(adminNo) REFERENCES Admin(adminNo),) （7）創(chuàng)建管理員_讀者 Admin_Reader CREATE TABLE Admin_Reader( adminNo varchar(12) not null, readerNo varchar(12) not null, bookNo varchar(20) not null, brCheck char(4) not null, CONSTRAINT Admin_readerPK PRIMARY KEY(adminNo,readerNo,bookNo), CONSTRAINT Admin_readerPK1 FOREIGN KEY(adminNo) REFERENCES Admin(adminNo), CONSTRAINT Admin_readerPK2 FOREIGN KEY(readerNo) REFERENCES Reader(readerNo), CONSTRAINT Admin_readerPK3 FOREIGN KEY(bookNo) REFERENCES Book(bookNo)) Create Trigger RENEW On Borrowfor Update As If Update(renewal) begin Update Borrow Set shouldDate=shouldDate+30 Where adminNo=1001 end （1）注冊(cè)INSERT INTO Admin (adminNo, adminName, aSex, aPhoneNumber, address) VALUES(adminNo, adminName, aSex, aPhoneNumber, address) （2）注銷DELETE FROMAdmin WHERE(adminNo =adminNo)。(3)修改個(gè)人信息UPDATE AdminSET(adminNo=adminNo, adminName= adminName, aSex=aSex, aPhoneNumber aPhoneNumber, addressaddress)。(4)增加圖書(shū)INSERT INTO Book (bookNo, classNo,bookName, author, publishName, publishDate, introduction) VALUES(bookNo, classNo,bookName, author, publishName, publishDate, introduction) (5)刪除圖書(shū)DELETE FROM BookWHERE(bookNo=bookNo)（6）修改圖書(shū)信息UPDATE Book (bookNo=bookNo, classNo=classNo,bookName=bookName, author=author, publishName=publishName, publishDate=publishDate, introduction=introduction) （7）增加圖書(shū)分類INSERT INTO BookClass（classNo,className）VALUES(classNo,className)（8）刪除圖書(shū)分類DELETE FROM BookClassWHERE(classNo=classNo)（9）更新圖書(shū)分類UPDATE BookClass(classNo=classNo,className=className)（1）注冊(cè)INSERT INTO Reader (readerNo, readerName, rSex, rPhoneNumber , institute, effectDate, lostEffectDate, breakRules,borrowAdd) VALUES（readerNo, readerName, rSex, rPhoneNumber , institute, effectDate, lostEffectDate, breakRules,borrowAdd）（2）注銷DELETE ReaderWHERE（readerNo=readerNo）（3）修改個(gè)人信息UPDATE ReaderSET （readerNo =readerNo, readerName =readerName, rSex= rSex, r
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1