update Book
set BookState='不可借' where BookID=@BookID
附录1 存储过程定义
1.Book_Insert的定义:
CREATE PROCEDURE Book_Insert
@BookID char(9) , @BookNo char(20), @BookName char(50), @BookWriter char(30), @BookPublish char(20), @BookPrice char(7), @BookDate datetime, @BookClass char(20), @BookMain char(200), @BookPrim char(30), @BookCopy char(5), @BookState char(10), @BookRNo char(5) as
insert into Book
values(@BookID ,@BookNo,@BookName,@BookWriter ,@BookPublish ,@BookPrice,
@BookDate,@BookClass ,@BookMain ,@BookPrim ,@BookCopy ,@BookState , @BookRNo);
2.Reader_Insert的定义:
CREATE PROCEDURE Reader_Insert
@ReaID char(9), @ReaName char(10), @ReaSex char(2), @ReaNo char(9), @ReaLBID char(5), @ReaType char(20), @ReaDep char(20), @ReaGrade char(5),
@ReaPref char(20), @ReaDate Datetime as
insert into Reader
values( @ReaID , @ReaName, @ReaSex,@ReaNo ,@ReaLBID,@ReaType,@ReaDep , @ReaGrade ,@ReaPref ,@ReaDate);
3.Maneger_Insert的定义:
CREATE PROCEDURE Maneger_Insert
@MID char(10) , @MName char(10), @MSex char(2), @Mpwd char(8), @MAuth char(40), @MTeleph char(15), @MAddre char(30) as
insert into Maneger
alues(@MID , @MName ,@MSex ,@Mpwd ,@MAuth ,@MTeleph ,@MAddre);
4.Borrow_Insert的定义:
CREATE PROCEDURE Borrow_Insert
@BookID char(9), @ReaID char(9), @Outdate Datetime , @YHdate Datetime , @Indate Datetime, @Fine char(5), @CLState char(8), @MID char(10) as
insert into Borrow
values(@BookID ,@ReaID ,@Outdate ,@YHdate ,@Indate ,@Fine ,@CLState ,@MID );
5.Query_Reader_R的定义：
create procedure Query_Reader_R
@ReaID char(9) as select *
from Readerview
where 编号 = ltrim(@ReaID);
6. Query_Reader_M的定义：
create procedure Query_Reader_M
as
select *
from Readerview
7. Query_Book_Writer的定义：
create procedure Query_Book_Writer
@BookWriter char(50)
as select * from Bookview
where 作者 like '%'+ltrim(@BookWriter)+'%';
8. Query_Book_Name_Publish的定义：
create procedure Query_Book_Name_Publish
@BookName char(50),
@BookPublish char(20) as
select *
from Bookview
where 书名=ltrim(@BookName) and 出版社=ltrim(@BookPublish);
9. Delete_Reader的定义：
create procedure Delete_Reader
@ReaNo char(9) as delete from Reader
where ReaNo = ltrim(@ReaNo);
10. Delete_Book的定义：
create procedure Delete_Book
@BookID char(9) as delete from Book
where BookID= ltrim(@BookID);