賓館客房管理系統(tǒng)--數(shù)據(jù)庫課程設(shè)計-預(yù)覽頁
【正文】 據(jù)表bill*/(bno varchar(36) not null, rid char(6) not null, ame varchar(10), cust money, btime datetime, etime datetime, remarks varchar(40)) gocreate table roomsp /*創(chuàng)建數(shù)據(jù)表roomsp*/(rstyle varchar(10) not null, rprice money)gocreate table hordform /*創(chuàng)建數(shù)據(jù)表hordform*/(ono varchar(36) not null, ame varchar(10) not null, csex char(2), cid char(18), rid char(6) not null, rstyle varchar(10), arrivetime datetime, o char(10) not null, dingname varchar(10), livetime char(10), dingph char(15) not null, ozt char(4))gocreate table hliveorder /*創(chuàng)建數(shù)據(jù)表hliveorder*/(lno varchar(36) not null, rid char(6) not null, rstyle varchar(10), btime datetime not null, o char(10), ame varchar(10) not null, etime datetime, ono varchar(36), lzt char(4) )goinsert into cusinfo values(39。,39。)insert into cusinfo values(39。,39。)goinsert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。) insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)goinsert into roomsp values(39。,300)go insert into ordform values(39。,39。,39。,39。,39。,39。)goinsert into liveorder values(39。,39。,39。,39。,39。,39。,39。,39。,39。)insert into liveorder(lno,rid,rstyle,btime,o,ame,ono,lzt) values(39。,39。,39。,39。)insert into liveorder(lno,rid,rstyle,btime,o,ame,ono,lzt)values(39。,39。,39。,null,39。,39。,0,39。,39。,0,39。 from roominfo,liveorder where = and =lno /*修改客房信息*/update ordform set ozt=39。 /*將已入住的預(yù)訂單放入歷史*/delete from ordform where ozt=39。exec ordformproc 39。 where lno=lno update roominfo set kfzt=39。goselect * from liveorderselect * from hliveorder select *from roominfo where rid=39。goselect * from liveorderselect * from bill 數(shù)據(jù)庫的完整性和安全性 數(shù)據(jù)庫的完整性是指數(shù)據(jù)的正確性和相容性。在數(shù)據(jù)庫系統(tǒng)中，大量的數(shù)據(jù)集中存放，而且為許多用戶直接共享，是寶貴的信息資源，系統(tǒng)的安全保護措施就顯得更為重要，它保護數(shù)據(jù)庫防止惡意的破壞和非法的存取。服務(wù)器的安全也是通過用戶在登錄服務(wù)器時輸入合法的用戶名和密碼來實現(xiàn)的。一個從需求分析，概念結(jié)構(gòu)設(shè)計，邏輯結(jié)構(gòu)設(shè)計，物理設(shè)計，數(shù)據(jù)庫實施，數(shù)據(jù)庫運行與維護的完整過程。不過，對于我們來說，編寫程序代碼是比較困難的一個步驟，如存儲過程的創(chuàng)建，觸發(fā)器的編寫，由于平時上課，這些內(nèi)容也不是掌握的很好，這次在課程設(shè)計過程中遇到了
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號-1