sql課程設(shè)計(jì)報(bào)告圖書館管理系統(tǒng)(參考版)
2025-04-17 04:41本頁面
【正文】 21。在完成該數(shù)據(jù)庫設(shè)計(jì)的過程中，本人碰到過一些問題，但感激同學(xué)們的熱心幫助。本系統(tǒng)基本上完成了信息的錄入 、信息保存?zhèn)鬏?、信息查詢?yōu)g覽修改打印等基本功能。執(zhí)行可得： 系統(tǒng)運(yùn)行和維護(hù)使用系統(tǒng)過程中系統(tǒng)管理人員根據(jù)需要逐步的完善和改進(jìn)系統(tǒng)的功能，對(duì)系統(tǒng)出現(xiàn)的漏洞進(jìn)行修補(bǔ)，發(fā)現(xiàn)問題解決問題。+wherefetch from library_cursor1 into name,jnum,pnum,where endclose library_cursor1deallocate library_cursor1執(zhí)行結(jié)果為存儲(chǔ)過程的創(chuàng)建和使用通過利用存儲(chǔ)過程，從表中返回所有書號(hào)為2006給罰款的人的信息 (借書人姓名，罰款單號(hào)，金額 )create procedure asselect 借書人姓名,罰款單號(hào),金額from on = where 書號(hào)=39。+pnum+39。+jnum+39。print name+39。下面以余坤龍為例來創(chuàng)建一個(gè)游標(biāo)實(shí)現(xiàn)查詢打印功能使用命令語句：declare name char(10),jnum char(20),pnum char(20),where char (40)declare library_cursor1 cursor for select 借書人姓名,借書證號(hào),借書人電話,借書人地址from open library_cursor1fetch from library_cursor1 into name, jnum, pnum,where while fetch_status=0begin print 39。經(jīng)管類39。結(jié)果如下視圖功能及創(chuàng)建建立視圖命令：create view [schemaname.] viewname [(column [,…,n])] as selectstatement [。 where 借書人姓名=39。當(dāng)我們要把余坤龍的電話改為456789時(shí)update 借書人電話= 39。 where 屬性=39。執(zhí)行后結(jié)果為數(shù)據(jù)修改功能及操作使用命令語句：update 表格名稱 set 屬性=39。當(dāng)我們想知道出版人格心理學(xué)的出版社名稱時(shí)select * from on = 書名=39。執(zhí)行后結(jié)果為2， 連接查詢，當(dāng)我們只對(duì)一個(gè)數(shù)據(jù)表進(jìn)行查詢時(shí)，我們或許只能知道我們部分想要的信息，即信息的不完整性。3）操作舉例1，當(dāng)我們想知道借書證為3108004641的同學(xué)借了什么書，可以select * from 借書證號(hào)= 39。）2）連接查詢使用命令語句：select * from 表格名稱1 join 表格名稱2 on = where 屬性xx=39。)執(zhí)行可得：數(shù)據(jù)查詢功能及操作1）簡(jiǎn)單查詢select * from 表格名稱（ where 屬性like 39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)insert into values (39。,39。,39。,39。)執(zhí)行可得：5，借還書登記表數(shù)據(jù)輸入insert into (書號(hào),借書證號(hào),借閱日期, 還書日期)values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)insert into values (39。,39。,39。,39。,39。)執(zhí)行可得：4，罰款單表數(shù)據(jù)插入insert into (罰款單號(hào),借書證號(hào),書號(hào),罰款日期,金額)values (39。, 39。,39。,39。,39。,39。)insert into values (39。, 39。,39。,39。,39。,39。)insert into values (39。, 39。,39。,39。,39。,39。)insert into values (39。, 39。,39。,39。,39。,39。)
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號(hào)-1