sql課程設(shè)計(圖書信息管理系統(tǒng))(已改無錯字)
2023-02-16 05:22:30 本頁面
【正文】 n)if @flag0 begin insert into jy(借書證號,ISBN,索書號,借書時間) values(@jszh ,@isbn ,@ssh,@jssj)endelse set @flag=0use xsbook/*對 JY 表中刪除一條記錄 */create procedure jy_delete @ssh char(10),@flag int output as declare @jszh char(8),@isbn char(16) declare @jssj datetime,@hssj datetime if exists(select * from jy where 索書號=@ssh) begin set @flag=1 select @jszh=借書證號,@isbn=ISBN,@jssj=借書時間 from jy where 索書號=@ssh set @hssj=getdate() insert into JYLS values(@jszh,@isbn,@ssh,@jssj,@hssj) delete from jy where 索書號=@ssh end else set @flag=0use xsbook/*對JY表進(jìn)行查詢的存儲過程*/gocreate procedure jy_serch6 @ssh char(10) as select ,from XS,BOOK,JY WHERE = and = and 索書號=@ssh對JY表的觸發(fā)器如下：use xsbook /*對JY表定義的INSERT的觸發(fā)器*/gocreate trigger tjy_insert on jy for insert asbegin update xs set 借書量= 借書量+1 where in(select from inserted)update book set 庫存量=庫存量1where in (select from inserted )enduse xsbook/*對JY表進(jìn)行刪除的觸發(fā)器*/go create trigger tjy_delete on jy for delete as begin update xs set 借書量=借書量1 where (select from deleted) update book set 庫存量=庫存量+1 where in(select from deleted)end74系統(tǒng)調(diào)試存儲過程調(diào)試：調(diào)用 borrow_insert 之前： 調(diào)用 borrow_insert 之后：8調(diào)用 borrow_delete 之后：調(diào)用 borrow_serch 之后：9總結(jié) 當(dāng)今社會計算機(jī)技術(shù)在的迅猛發(fā)
試題試卷相關(guān)推薦
鄂ICP備17016276號-1