关键词：酒店管理系统；SQL SERVER 2000；数据库；VB.NET
 
The design of the Small Hotel Management System
Abstract
As the competition getting more force in the hotel industry, the fight for the customers among the hotels is becoming more and more severe, the hotel uses brand new computer management system. This will become one of the important methods for increasing the management efficiency of the hotel management, improving the service level.
The small hotel management system has some excellence, like operating stably, user interfacing simple and attractive, easy to use. Basically including hotel's major business functions. It is divided into basic in fracture, business management, hotel room management, three major groups. There is guest room type configuration and guest room information configuration functions in the basic in fracture portion; the business management portion includes booking management, check-in management, consumption bookkeeping, and check-out pay bill functions; hotel room management may configuration based on the real requirement and changes the room states in real time. The system is developed by using C/S model, using VB.NET language development technology, and SQL server 2000 database. It is operating stably under Windows XP/NT/2003, and has high reliability. This proper use of this system could increase the management efficiency of the hotel, decrease operating cost.
This paper will introduce a database systems based on Microsoft SQL Server 2000 and developed and realized hotel management system using VB.NET programming language. It emphasized the developing process of this system, through a rather detailed analyzing and describing on the various steps of the requirement of the system analysis, solution analysis, module design, data structure design, to system testing.

Key words: Hotel management system；SQL SERVER 2000;Data base；VB.NET
目  录
论文总页数：24页
1 引言 1
1.1 课题背景 1
1.2 国内外研究现状 1
1.3 本课题研究的意义 2
2 相关的理论基础 2
2.1 开发环境 2
2.2.1 C/S模式简介 2
2.2.2 .NET介绍 3
2.2.3 VB.NET介绍 3
2.2 编程运行环境 4
2.2.1 硬件环境 4
2.2.2 软件环境 4
3 设计方案介绍 4
3.1 系统功能模块设置 4
3.1.1 基础设置 4
3.1.2 业务管理 4
3.1.3 房间管理 5
3.2 数据库设计 5
3.2.1数据库设计思想 5
3.2.2酒店管理系统E-R图 10
4 具体模块设计 11
4.1 系统主要功能模块的实现及部分代码 11
4.1客房信息设置 11
4.2 预定管理功能 15
4.3 入住管理功能 16
4.4 房间管理 18
4.5 退出系统 21
结    论 21
参考文献 22
致    谢 23
声    明 24
 
参考文献
[1] 彭明柳.Visual Basis.Net[M].北京:中国铁道出版社,2003。
[2] 卢镇波,李青，万晶. Visual Basis.Net[M].北京:清华大学出版社，2005。
[3] 王俊伟，史创明. SQL Server 2000 数据库管理与应用 [M].北京:清华大学出版社,2006。
[4] 徐国智,汪孝宜. SQL Server 数据库开发实例精粹 [M].北京:电子工业出版社,2006。
[5] 王黯,马里杰. SQL Server 数据库开发经典案例解析 [M].北京: 清华大学出版社,2006。
[6] 方睿，吴四久. 网络数据库原理及应用 [M]. 四川:四川大学出版社,2005。