酒店管理系統(tǒng)數(shù)據(jù)庫課程設(shè)計(參考版)
2025-04-12 08:04本頁面
【正文】 因此，這次設(shè)計的過程雖然艱辛，但我們很快樂。不過，俗話說，有利必有弊，這次設(shè)計充分的暴露了我們的不足，但也給了我們一個學(xué)習(xí)的平臺。雖然通過不斷的查閱課本，我們努力的更正了，還是有很多地方需要通過網(wǎng)絡(luò)才能解決。但是由于我們實力有限，現(xiàn)在還無法設(shè)計出比較繁瑣的程序，我們以后會加倍努力，爭取有所提高，希望在以后的日子里，能夠設(shè)計出真正適應(yīng)市場、適應(yīng)時代的設(shè)計。對于酒店客服管理來說，可能某些方面并不全面，一個酒店要運行得暢并不是這點東西就能解決的。 運行exec pro_sum_subscribe四、系 統(tǒng) 調(diào) 試 出 現(xiàn) 的 問 題 及 解 決 情 況(編譯語法錯誤及修改，重點是運行邏輯問題修改和調(diào)整)錯誤1：在有多重括號時，有括號遺漏。+convert(char(10),count)+39。運行exec pro_sum_leave（3）預(yù)訂房間記錄統(tǒng)計create procedure pro_sum_subscribe asdeclare count intselect count=COUNT(*) from order_logwhere plan_enter_date is not null and enter_date is nullprint39。+convert(char(10),count)+39。 運行exec pro_sum_live（2）退房結(jié)賬記錄統(tǒng)計create procedure pro_sum_leave asdeclare count intselect count=COUNT(*) from order_logwhere leave_date is not nullprint39。+convert(char(10),count)+39。 信息查詢功能設(shè)計（1）查詢在住客人列表create procedure pro_select_cust asdeclare cust_id char(20)declare getCur cursor forselect cust_id from order_logwhere enter_date is not null and leave_date is nullopen getCurfetch getCur into cust_idselect cust_id 證件號碼,ptype_id 證件號類型,cust_name 姓名,sex 性別,phone 聯(lián)系電話from customerwhere cust_id=cust_idclose getCurdeallocate getCur運行exec pro_select_cust （2）查詢預(yù)訂客人信息create procedure pro_select_subscribe asdeclare cust_id char(20)declare getCur cursor forselect cust_id from order_logwhere plan_enter_date is not null and enter_date is nullopen getCurfetch getCur into cust_idselect cust_id 證件號碼,ptype_id 證件號類型,cust_name 姓名,sex 性別,phone 聯(lián)系電話from customerwhere cust_id=cust_idclose getCurdeallocate getCur運行exec pro_select_subscribe 查詢歷史客人信息create procedure pro_select_past1 asdeclare cust_id char(20)declare getCur cursor forselect cust_id from order_logwhere leave_date is not nullopen getCur fetch getCur into cust_idselect cust_id 證件號碼,ptype_id 證件號類型,cust_name 姓名,sex 性別,phone 聯(lián)系電話from customerwhere cust_id=cust_idclose getCurdeallocate getCur運行exec pro_select_past1 報表統(tǒng)計功能設(shè)計（1）開房記錄統(tǒng)計create procedure pro_sum_live asdeclare count intselect count=COUNT(*) from order_logwhere enter_date is not null and leave_date is nullprint39。where room_id in(select room_idfrom book_roomwhere order_id=order_id)delete from order_logwhere order_id=order_iddelete from book_roomwhere order_id=order_iddelete from customerwhere cust_id=cust_idclose getCurdeallocate getCur運行exec pro_cancel_subscribe 39。,300（3）解除預(yù)訂刪除訂房信息(訂單號,房號) 【觸發(fā)器實現(xiàn)】create trigger trig_dele_book_room on order_log for delete asdelete book_room from book_room,deleted where =輸入訂單編號,刪除客人信息、訂單對應(yīng)的房號、訂單信息并把對應(yīng)的房間狀態(tài)改成空閑（取消預(yù)訂）create procedure pro_cancel_subscribe order_id char(10) asdeclare cust_id char(20)declare getCur cursor forselect cust_id from order_logwhere order_id=order_idopen getCurfetch getCur into cust_idupdate roomset rstate=39。,39。,39。where room_id=room_idselect room_id 房號,rstate 房狀態(tài) from room where room_id=room_id運行exec pro_change_rstate_into_live 101輸入訂單信息（訂單編號，預(yù)計離開日期，入住日期，應(yīng)付金額）create procedure pro_subscribe_to_live order_id char(10),plan_leave_date datetime,enter_date datetime,order_money int asupdate order_log set plan_le
公司管理相關(guān)推薦
鄂ICP備17016276號-1