毕业设计（论文）
I
编号：
毕业设计(论文)任务书
题 目： 酒店预订系统的设计与实现
院 （系）：
专 业：
学生姓名：
学 号：
指导教师单位：
姓 名：
职 称：
题目类型：
理论研究
实验研究
工程设计
工程技术研究
□
√
软件开发
应用研究
2016 年 1 月 4 日
网上酒店预定系统
II
摘要
课题目标是设计并实现一个 B/S 体系结构的酒店客房预订系统。结合实践，理解网
页开发技术和数据库的基本知识，学习相关开发工具和应用软件，熟悉系统设计的过程，
熟练掌握网络数据库编程方法。
本系统用 JSP 技术来编写本系统，数据库用 MySQL 来连接系统。本论文主要涉及
软件，数据库与网络技术等。涵盖知识面广，可有效地提高学生综合运用所学知识分析
解决问题的能力，增强学生对事物的理解与掌握能力，培养学生掌握科学的研究方法，
正确的设计思想，独立思考，勇于进取，探索创新，为今后进一步学习与工作奠定了良
好的基础。
关键词：酒店客房预订系统；数据库；JSP
毕业设计（论文）
III
Abstract
The topic goal is designs and realizes a B/S architecture hotel guest room reservation
system. The union practice, understood that the homepage development technology and the
database elementary knowledge, the study related development kit and the application
software, the familiar system design's process, masters the network database programming
method skilled. this system arranges the comp book system with the JSP technology, the
database uses the MySQL connected systems. The present paper mainly involves the software,
the database and the networking and so on. The covering aspect of knowledge is broad, but
enhances the student to synthesize the utilization effectively to study the knowledge analysis
to solve the question ability, strengthens the student the understanding with to grasp ability to
the thing, trains the student to grasp the science the research technique, the correct design
concept, the independent thinking, dares enterprising, the exploration innovation, will further
study and the work for the present has laid the good foundation.
Key words: Hotel guest room reservation system; Database; JSP
网上酒店预定系统
IV
目 录
摘要 ............................................................................................................................................II
Abstract .....................................................................................................................................III
前 言...........................................................................................................................................1
第一章 绪论...............................................................................................................................2
1.1 酒店计算机管理信息系统发展历史...........................................................................2
1.2 酒店管理信息系统的作用...........................................................................................2
1.3 酒店管理信息系统的构成...........................................................................................4
1.4 国内酒店软件系统.......................................................................................................5
第二章 编程环境基础知识.......................................................................................................5
2.1 JSP 介绍.......................................................................................................................6
2.2 JSP 优点.......................................................................................................................6
2.3 MySQL 简介...................................................................................................................8
2.5 JDBC..............................................................................................................................9
2.5 脚本习惯说明............................................................................................................10
第三章 系统分析设计.............................................................................................................10
3.1 可行性分析................................................................................................................10
3.2 设计目标....................................................................................................................11
3.3 总体功能设计.............................................................................................................12
第四章 数据库设计.................................................................................................................14
4.1 用户表........................................................................................................................14
4.2 酒店信息表................................................................................................................15
4.3 酒店预定排行列表....................................................................................................15
4.4 酒店订单信息列表....................................................................................................15
4.5 管理员信息列表........................................................................................................15
4.6 留言信息列表............................................................................................................15
第五章 功能模块设计.............................................................................................................16
5.1 系统前台主页面........................................................................................................16
5.2 预订房间....................................................................................................................17
5.3 客房搜索.....................................................................................................................18
5.4 预订记录查询.............................................................................................................19
5.5 留言功能....................................................................................................................19
5.6 网站后台登陆界面....................................................................................................20
5.7 客房管理..................................................................................................................21
5.8 客房类别管理............................................................................................................22
5.9 剩余房间查询............................................................................................................23
5.9.1 用户管理................................................................................................................23
毕业设计（论文）
V
第六章 测试及性能分析.........................................................................................................24
结束语.......................................................................................................................................25
致谢...........................................................................................................................................26
参考文献...................................................................................................................................27
