酒店（宾馆）管理系统--毕业论文+文献翻译

河南科技大学本科毕业设计（论文）

中原国宾馆管理系统设计与实现

摘 要

宾馆管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面.对于前者要求建立数据一致性好、完整性强、安全的数据库.而对于后者则要求应用程序功能完备,具备使用方便等特点.该系统主要用于宾馆的日常管理。该系统界面友好，操作简单，易学易用，从总体方案上力求达到该软件所需的目标要求。

此次宾馆管理系统的设计用到的开发工具是Microsoft Visual C++6.0和Microsoft SQL Server2005.VC6.0的MFC类库为管理系统的界面设计提供了方便。SQL Server2005又有着强大的数据库创建和管理能力。使用ADO技术将VC与数据库连接。

本宾馆管理系统实现顾入住客管理，客房管理，信息查询等6个模块。系统主要实现了顾客的入住管理住宿登记，结账，信息查询，客房销售统计等功能。运用面向 对象的编程思想，将每个模块封装在不同的类里面，提高了程序的运行速度和安全性。

关键字：宾馆管理系统，面向对象， MFC类库，ADO技术

I

河南科技大学本科毕业设计（论文）

DESIGN AND IMPLEMENT OF ZHONGYUAN HOTEL

MANAGEMENT SYSTEM

ABSTRACT

Hotel management system is a system (MIS) of typical information management, its development to primarily include the establishing of backstage database to apply two aspects of the procedure's developments with maintenance and head. It requested to establish the data consistency for the former with the complete strong, data safety database that like. But then request the applied procedure function for the latter complete, etc. characteristics of easy usage. The system's interface the amity,operation is simple, easy to learn easily use, and try hard for the target request for needing of the software's from the total project.

The hotel management system design and development tool is used by Microsoft Visual c + + 6.0 and Microsoft SQL Server 2005.MFC class library of VC 6.0 provides a convenience for management system interface design. SQL Server 2005 has powerful database creation and management ability. Using ADO connect VC with database.

I have been achieving 6 modules for the hotel management such as registration of customer, management of rooms, information query. System mainly achieved the management of customer check-in registration, management of invoicing, information query, statistics of sales, and other functions. I applied the idea of Object Oriented programming, each module encapsulated in different classes. So that I improved the running speed and security for the program。 KEY WORDS：Hotel management system, Object Oriented, ADO

II

河南科技大学本科毕业设计（论文）

目 录

前 言 ................................................................................................................ 1 第1章 需求分析 ............................................................................................... 2 §1.1 系统功能分析 ........................................................................................ 2 §1.2 可行性分析 ............................................................................................ 2 §1.2.1 经济上的可行性分析 ...................................................................... 2 §1.2.2 技术上的可行性分析 ...................................................................... 3 §1.3 数据流图 ................................................................................................ 3 §1.4 数据字典 ................................................................................................ 4 §1.5 现行系统存在的主要问题 ..................................................................... 6 §1.6 解决方案 ................................................................................................ 6 §1.7 概要设计 ................................................................................................ 6 第2章 总体设计 ............................................................................................... 8 §2.1 系统总体架构设计................................................................................. 8 §2.2 系统IPO图 ............................................................................................ 8 §2.3 数据的存储设计 .................................................................................... 9 第3章 数据库设计 ......................................................................................... 11 §3.1 数据库设计及其需求分析 ................................................................... 11 §3.2 数据库建模 .......................................................................................... 11 §3.2.1 实体及属性 ................................................................................... 11 §3.2.2 实体间的联系 ............................................................................... 12 §3.2.3 E—R模型转化关系....................................................................... 12 §3.2.4 关系模式 ....................................................................................... 13 §3.3 数据库E-R图 ...................................................................................... 14 §3.4 数据库模型 .......................................................................................... 15 第4章 详细设计 ............................................................................................. 16 §4.1 系统主窗口设计 .................................................................................. 16 §4.2 系统类设计 .......................................................................................... 16

III

河南科技大学本科毕业设计（论文）

§4.3 系统菜单设计 ...................................................................................... 18 §4.4 算法描述 .............................................................................................. 19 §4.4.1 客房宿费算法 ............................................................................... 19 §4.4.2 调房模块实现 ............................................................................... 20 §4.4.3 宿费提醒的实现 ........................................................................... 21 §4.5 重要程序编码设计............................................................................... 21 §4.5.1 主面操作代码 ............................................................................... 21 §4.5.2 主窗口初始化代码 ....................................................................... 23 第5章 测试 ..................................................................................................... 26 §5.1 系统登录模块测试............................................................................... 26 §5.2 住宿管理模块测试............................................................................... 27 §5.2.1 客房预订模块测试 ....................................................................... 27 §5.2.2 住宿登记模块测试 ....................................................................... 27 §5.3 追加押金模块测试............................................................................... 28 §5.4 调房登记模块测试............................................................................... 28 §5.5 退宿结账模块测试............................................................................... 29 §5.6 测试结果分析 ...................................................................................... 30 结 论 .............................................................................................................. 31 参考文献 ........................................................................................................... 32 致 谢 .............................................................................................................. 33 附 录 .............................................................................................................. 34

IV