【正文】 informationization of the hotel. By the investigation with hotels, we have building the anization model of the management information system of guest room of the hotel. Based on that, we have carried on the detailed investigation to the business procedure of the guest room of the hotel, having set up the structure chart of the function, for instance the customers check in, the member registers, hands in the deposit retroactively, checks out to settle account etc., thus makes the management clear. To meet the real inquire, we have set up concept structure, proposed the systematic design principle and design method, provides Solution Architecture of database. We have developed a practical the management information system of guest room of unit edition hotel. Not only carried on detailed analysis and design to the system of guest room of the hotel in terms of business, but also we appraised to the system.The management system of hotel guestrooms is a typical managing information system (MIS). It39。s information and reservation information, as well as the balance data and so on. This system is based on the real situation from some certain guestroom management data, whose main purpose is to make it convenient for the hotel to look up and manage the situation of the guestrooms concentratively and improve the whole service quality.Key words: Relational database, MVC, Visualization ┊┆┆┆大連外國(guó)語(yǔ)學(xué)院 本科生畢業(yè)論文(設(shè)計(jì))目錄1 引言 .....................................................................................................................................1 國(guó)內(nèi)外現(xiàn)狀 ...................................................................1 論文研究主要內(nèi)容 .............................................................22 關(guān)鍵技術(shù)介紹 .....................................................................................................................4 關(guān)鍵性開發(fā)技術(shù)的介紹 .........................................................43 系統(tǒng)分析 .............................................................................................................................6 構(gòu)架概述 .....................................................................6 功能構(gòu)架 ..................................................................................................................................6 模塊需求描述 ..........................................................................................................................6 數(shù)據(jù)流程分析及說明 ..............................................................................................................7 系統(tǒng)開發(fā)環(huán)境 ................................................................11 系統(tǒng)任務(wù)的可行性分析 ........................................................11 技術(shù)可行性 ............................................................................................................................11 系統(tǒng)安全性分析 ....................................................................................................................114 系統(tǒng)設(shè)計(jì) ...........................................................................................................................13 酒店客房管理系統(tǒng)的用例分析 ..................................................13 功能設(shè)計(jì) ....................................................................................................................................13 系統(tǒng)的數(shù)據(jù)庫(kù)設(shè)計(jì) ............................................................15 數(shù)據(jù)庫(kù)設(shè)計(jì)原則 ...................................................................................................................15 系統(tǒng)數(shù)據(jù)庫(kù) ER 圖 ...............................................................................................................15 創(chuàng)建表 ...................................................................................................................................16 系統(tǒng)目錄結(jié)構(gòu)的設(shè)計(jì) ..........................................................19 系統(tǒng)的連接結(jié)構(gòu)設(shè)計(jì) ..........................................................19 ┊┆┆┆大連外國(guó)語(yǔ)學(xué)院 本科生畢業(yè)論文(設(shè)計(jì))5 系統(tǒng)實(shí)現(xiàn) ...........................................................................................................................20 系統(tǒng)功能實(shí)現(xiàn) ................................................................20 登錄管理模塊實(shí)現(xiàn) ..........................................................20 員工信息管理模塊 ................................................................................................................21 客房信息管理 ........................................................................................................................23 客房經(jīng)營(yíng)管理 ........................................................................................................................25 經(jīng)營(yíng)狀況統(tǒng)計(jì) ........................................................................................................................27 主要的 JAVA 類 ......................................................................................................................27 系統(tǒng)技術(shù)實(shí)現(xiàn) ................................................................29 數(shù)據(jù)庫(kù)的實(shí)現(xiàn) ................