數(shù)據(jù)庫課程設(shè)計(jì)(圖書借閱管理系統(tǒng)數(shù)據(jù)庫的設(shè)計(jì)與實(shí)現(xiàn))(編輯修改稿)
2025-03-09 01:49 本頁面
【文章內(nèi)容簡(jiǎn)介】 (2) create procedure tea_select (@tea_id varchar(20)) as select * from teacher_infor where tea_id=@tea_id 創(chuàng)建對(duì)讀者信息修改的存儲(chǔ)過程 (1) create procedure stu_update (@stu_id varchar(20), @stu_name char(6), @stu_age int , @stu_sex char(2), @stu_dept varchar(20), @stu_major varchar(20), @stu_class varchar(20)) as update student_infor set stu_name=@stu_name,stu_age=@stu_age,stu_sex=@stu_sex,stu_dept=@stu_dept, stu_major=@stu_major,stu_class=@stu_class where stu_id=@stu_id exec stu_update 39。11218101739。,39。熊峰 39。,19,39。男 39。,39。軟件學(xué)院 39。,39。軟件工程 39。,39。112181039。 select * from student_infor (2) create procedure tea_update (@tea_id varchar(20), @tea_name char(6), @tea_sex char(2), @tea_age int , @tea_dept varchar(20), @tea_major varchar(20), @tea_class varchar(20)) as update teacher_infor set tea_name=@tea_name,tea_sex=@tea_sex,tea_age=@tea_age,tea_dept=@tea_dept, tea_major=@tea_major where tea_id=@tea_id exec procedure tea_update 創(chuàng)建對(duì)圖書信息插入、刪除、查找、修改的存儲(chǔ)過程 (1) create procedure book_insert (@book_id varchar(20) , @book_name varchar(20), @book_auother varchar(4), @publisher varchar(20), @publish_date datetime, @price int, @book_sum int, @book_rem int) as insert into book_infor values(@book_id,@book_name,@book_auother,@publisher,@publish_date,@price,@book_sum,@book_rem) exec book_insert 39。12339。,39。數(shù)據(jù)庫 39。,39。熊峰 39。,39。清華大學(xué)出版社39。,39。2021/12/539。,50,100,50 exec book_insert 39。1234539。,39。數(shù)據(jù)庫 39。,39。熊峰 39。,39。清華大學(xué)出版社39。,39。2021/12/539。,50,100,50 select * from book_infor delete from book_infor (2) create procedure book_delete (@book_id varchar(20)) as delete from book_infor where book_id=@book_id exec book_delete 39。12339。 (3) create procedure book_select (@book_id varchar(20)) as select * from book_infor where book_id=@book_id exec book_select 39。12339。 (4) create procedure book_update (@book_id varchar(20), @book_name varchar(20), @book_auother varchar(4), @publisher varchar(20), @publish_date datetime, @price int, @book_sum int, @book_rem int) as update book_infor set book_name=@book_name,book_auother=@book_auother,publisher=@publisher, publish_date=@publish_date,price=@price,book_sum=@book_sum,book_rem=@book_rem where book_id=@book_id exec book_update39。123439。,39。計(jì)算機(jī)組成原理 39。,39。陶德發(fā) 39。,39。工業(yè)出版社39。,39。2021/1/139。,40,100,20 創(chuàng)建對(duì)借閱信息插入、刪除、查找、修改的存儲(chǔ)過程 (1)插入 create procedure stu_bor_insert (@stu_id varchar(20) , @book_id varchar(20) , @borrow_date datetime, @return_date datetime, @borrow_times int, @stu_fine int) as if exists(select * from student_borrow_infor where stu_id=@stu_id and book_id=@book_id
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1