數(shù)據(jù)庫(kù)課程設(shè)計(jì)-客房信息管理系統(tǒng)-wenkub
2022-12-26 23:04:07 本頁(yè)面
【正文】 =======*/ /* Table: room */ /*==============================================================*/ create table room ( room_id int not null, roo_type_id int null, book_id int null, type_id int not null, state varchar(10) null, constraint PK_ROOM primary key (room_id) ) Go /*==============================================================*/ /* Table: roomtype */ /*==============================================================*/ create table roomtype ( type_name varchar(20) null, introduction text null, facility varchar(20) null, breakfast bit null, subsfee varchar(20) null, bendesc varchar(20) null, type_id int not null, price int null, constraint PK_ROOMTYPE primary key (type_id) ) go /*==============================================================*/ /* Table: user */ /*==============================================================*/ create table user ( user_id int not null, client_id int null, user_name varchar(20) null, user_sex char(2) null, user_age int null, signature varchar(100) null, telephone varchar(15) null, loginaccount varchar(20) null, password varchar(20) null, right int null, constraint PK_USER primary key (user_id) ) 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 17 Go ： 圖 數(shù)據(jù)庫(kù) 截圖 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 18 圖 Book 表 圖 Room 表 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 19 圖 Room_type 表 圖 Client 表 圖 User 表 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 20 基本操作： 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 21 update roomtype set breakfast=39。 create view [dbo].[accountInfo] as select [user_id],loginAccount,password from [user] 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 22 賬號(hào)信息視圖 單視圖 CREATE view [dbo].[bill] as select distinct 訂單號(hào) , 客戶姓名 , 房間號(hào) ,type_name 類型名 , 單價(jià) ,days 天數(shù) ,prePay 預(yù)支 , 消費(fèi)金額 ,balance 余額 ,liveTime 入住時(shí)間 from book,client,room,roomType,[level] where = and = and = 賬單視圖 create view [dbo].[clientInfo] as SELECT client_name, client_sex, identityld, , totalConsume, [level].level_name, [level].rate FROM client INNER JOIN [level] ON = [level].level_id 數(shù)據(jù)庫(kù)原理 課程設(shè)計(jì)說(shuō)明書 23 客戶信息視圖 create view [dbo].[emptyRoom] as SELECT AS 房間號(hào) , AS 房間類型 , AS 床位描述 , AS 價(jià)格 , AS 訂金 , AS 狀態(tài) FROM room INNER JOIN roomType ON = WHERE ( = 39。 where room_id=room_id END CREATE PROCEDURE [dbo].[leaveRoom] book_id int, totalConsume decimal(18,1), room_id int, fee decimal(18,1), balance decimal(18,1), client_id int, state varchar(10), bookState varchar(20), liveState varchar(20), leaveTime datetime AS BEGIN UPDATE book SET leaveTime = leaveTime, liveState = liveState, bookState = bookState, fee = fee, balance = balance where book_id =book_id UPDATE room SET state = state where room_id=room_id UPDATE client SET totalConsume = totalConsume where client_
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1