【正文】 安徽大學(xué) 本科畢業(yè)論文（設(shè)計(jì)） （內(nèi)封面） 題 目： 賓館客房管理信息系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 學(xué)生姓名： 學(xué)號： 院（系）： 計(jì)算機(jī)科學(xué)與技術(shù)學(xué)院 專業(yè)： 軟件工程 入學(xué)時(shí)間： 年 月 導(dǎo)師姓 名： 職稱 /學(xué)位： 副教授 /碩士 導(dǎo)師所在單位： 安徽大學(xué)計(jì)算機(jī)科學(xué)與技術(shù)學(xué)院 賓館客房管理信息系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 摘 要 隨著人員流動(dòng)規(guī)模的不斷擴(kuò)大，賓館數(shù)量的急劇增加，有關(guān)客房管理的各種信息量也在不斷成倍增長。面對龐大的信息量，要想提高勞動(dòng)生產(chǎn)率，降低成本，提高服務(wù)質(zhì)量和管理水平，促進(jìn)經(jīng)濟(jì)效益，必須借助計(jì)算機(jī)來進(jìn)行現(xiàn)代化的信息管理，利用客房信息管理系統(tǒng)來提高客房管理工作的效率。通過這樣的系統(tǒng)，我們可以做到信息的規(guī)范管理和快速查詢，從而減少管理方面的工作量?！顿e館客房管理信息系統(tǒng)》正是為此而設(shè)計(jì)的，該系統(tǒng)基于客戶機(jī)服務(wù)器模式（ C/S）結(jié)構(gòu)設(shè)計(jì)，能夠?qū)崿F(xiàn)多臺客戶機(jī)同時(shí)遠(yuǎn)程管理，運(yùn) 用 Microsoft SQL Server 2021數(shù)據(jù)庫系統(tǒng)和 Visual Basic 程序語言開發(fā)實(shí)現(xiàn)，主要包括客房登記、調(diào)換客房、退房登記、客房 管理、房態(tài)查看等模塊。本論文按照軟件工程的方法，闡述了賓館管理信息系統(tǒng)的分析、總體設(shè)計(jì)、詳細(xì)設(shè)計(jì)、系統(tǒng)實(shí)現(xiàn)、測試等過程，重點(diǎn)解決系統(tǒng)安全性問題。 關(guān) 鍵詞：賓館；客房；管理信息系統(tǒng) Design and Implementation of Hotel Room Management Information System Abstract With the movement of the expansion, the sharp increase in the number of hotels, the hotel management information has been doubled and redoubled. Faced with an enormous amount of information, in order to raise labor productivity, reduce costs, improve service quality and management level, the promotion of economic efficiency, to use the puter to carry out the modernization of information management, information management system for the use of room to improve the efficiency of hotel management. The adoption of such a system, we can standardize the management of information and fast information, thereby reducing the workload of management. Hotel Room Management Information System is designed for this purpose, the system is based on clientserver model (C / S) structural design, to achieve more than one client at the same time remote management, the use of Microsoft SQL Server 2021 database system and Visual Basic the development of programming languages to achieve, including hotel registration, change rooms, checkout registration, room management, room state to view modules. In this paper, in accordance with the method of software engineering on the hotel management information system analysis, design, detailed design, system test, etc., focused on solving the problem of system security. . Keywords： hotel； room； management information system 目 錄 第一章 前 言 ........................................................................................................................... 1 賓館客房管理信息系統(tǒng)的項(xiàng)目背景 ............................................................................... 1 賓館客房管理信息系統(tǒng)的現(xiàn)實(shí)意義 ............................................................................... 1 賓館客房管理信息系統(tǒng)發(fā)展歷史 .................................................................................. 2 第二章 賓館客房管理系統(tǒng)分析 ................................................................................................... 2 系統(tǒng)的初步調(diào)查 ............................................................................................................... 3 需求分析 ........................................................................................................................... 3 可行性分析 ....................................................................................................................... 4 技術(shù)可行性 ............................................................................................................ 4 經(jīng)濟(jì)可行性 ............................................................................................................ 4 管理可行性 ............................................................................................................ 5 數(shù)據(jù)字典 ........................................................................................................................... 5 數(shù)據(jù)項(xiàng) .................................................................................................................... 5 數(shù)據(jù)存儲 ................................................................................................................ 7 處理過程 ................................................................................................................ 8 第三 章 賓館客房管理系統(tǒng)的總體設(shè)計(jì) ....................................................................................... 9 系統(tǒng)結(jié)構(gòu)設(shè)計(jì) ................................................................................................................... 9 硬件結(jié)構(gòu) ................................................................................................................ 9 軟件結(jié)構(gòu) .............................................................................................................. 10 系統(tǒng)平臺選擇 ................................................................................................................. 11 系統(tǒng)功能模塊設(shè)計(jì) ......................................................................................................... 11 客戶機(jī)服務(wù)器（ C/S）通訊協(xié)議設(shè)計(jì) ........................................................................... 12 多用戶并發(fā)操作時(shí)數(shù)據(jù)同步的設(shè)計(jì) ............................................................................. 14 系統(tǒng)安全性設(shè)計(jì) ............................................................................................................. 16 通訊安全性設(shè)計(jì) .................................................................................................. 17 數(shù)據(jù)庫用戶密碼安全性設(shè)計(jì) .............................................................................. 18 第四章 數(shù)據(jù)庫設(shè)計(jì) ..................................................................................................................... 18 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì) ..................................................................................................... 18 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) ..................................................................................................... 20 第五章 賓館客房管理系統(tǒng)的詳細(xì)設(shè)計(jì)與實(shí)現(xiàn) ......................................................................... 21 數(shù)據(jù)庫的實(shí)現(xiàn) ................................................................................................................. 21 服務(wù)器 主窗體的