客房管理Visual C++界面设计及编程实现_论文

题目：

本科毕业设计

客房管理Visual C++界面设计及编程实现

学 院: 专 业: 学 号: 学生姓名: 指导教师:

日 期:

二○一一年六月一日

摘 要

随着经济的全球化和社会不断地快速发展，在宾馆住宿的人变得越来越多，而宾馆住宿管理系统能够为宾馆管理人员提供一个快速安全可靠的管理平台，所以宾馆住宿管理系统扮演着越来越重要的角色。

酒店管理系统其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强.数据安全性好的数据库。而对于后者则要求应用程序功能完备,易使用等特点。

本文介绍了宾馆住宿管理系统的开发过程，论文详尽论述了从需求分析、数据库设计，VC++的程序编写，以及最后的程序测试。本宾馆管理系统采用Microsoft Visual C++6.0和SQL Server 2000 数据库作为开发工具。

本系统实现了系统管理员的登录，客房的查询，客户的登记以及客户的结账，基本完成了一个简单的宾馆住宿管理系统。

关键词：宾馆住宿管理系统；登录；查询；登记；结账。

Abstract

With the globalization of economy and society in constantly fast development, people lived in the hotel become more and more. Hotel management system can provide hotel management personnel to provide a quick safe and reliable management platform, so hotel management system to play an increasingly important role.

Hotel management system its development mainly includes the setting and maintenance of database and the programming of the frontend application. The former required establish data consistency and integrality. The data security good database. For the latter requires the application program function complete, easy to use, etc.

This paper introduces hotel management system development process, this paper discussed detail from requirement analysis, database design, programming of the vc + + and the final program test. This system uses Microsoft Visual C++6.0 and SQL Server 2000 takes the development kit.

This system realizes the system administrator login, guest inquires the registration and customers, customers the check-out, basic completed a simple hotel management system.

Key words: Hotel management system; Register; Query; Registration; Check-out

目 录

1 绪论 ...................................................................................................................................... 1

1.1 系统开发背景 ........................................................................................................... 1 1.2 本系统的作用 ........................................................................................................... 1 1.3 系统开发工具 ........................................................................................................... 1

1.3.1 Microsoft Visual C++ 6.0简介 ...................................................................... 2 1.3.2 SQL Server2000简介 .................................................................................... 2

2 系统需求分析 ...................................................................................................................... 4

2.1 需求分析 ................................................................................................................... 4 2.2 功能需求 ................................................................................................................... 4 2.3 系统流程图 ............................................................................................................... 4 3 系统数据库设计 .................................................................................................................. 5

3.1 局部E-R图 .............................................................................................................. 5 3.2 整体E-R图 .............................................................................................................. 7 3.3 数据库表设计 ........................................................................................................... 7

3.3.1 各表设计 ........................................................................................................ 8 3.3.2 关系图 ............................................................................................................ 9 3.3.3 视图设计 ...................................................................................................... 10

4 系统界面设计及代码 ........................................................................................................ 11

4.1 关于MFC ............................................................................................................... 11 4.2 VC++ 6.0访问SQL Server数据库的原理 ........................................................... 11

4.2.1 CDatabase类 ................................................................................................ 11 4.2.2 CRecordSet类 .............................................................................................. 12 4.2.3 记录查询 ...................................................................................................... 12 4.2.4 记录添加 ...................................................................................................... 14 4.2.6 记录修改 ...................................................................................................... 14 4.2.7 直接执行 SQL语句 ............................................... …… 此处隐藏：10565字，全部文档内容请下载后查看。喜欢就下载吧 ……