华东交通大学
毕业设计（论文）
题目： 基于 springboot 的宾馆预定管理系统的设计与实现
学 院:
软件学院
专 业:
软件开发
班 级:
二班
学生姓名:
孔涛
学 号:
2015211001000607
指导教师:
尧艳华
完成日期:
2019 年 4 月 26 日
基于 springboot 的宾馆预定管理系统的设计与实现
摘 要
在当今的时代里，节假日出行旅游已经大家的假期安排首选，然而现在很多小城市的
宾馆都不支持网上预定的功能。所以本文针对这种情况和进行对开发该系统的可行性分析
后，于是设计出一个快捷、简便地来查询宾馆信息，以及可以及时的提供住宿房间的一个
系统。系统具有预定房间、展示房间信息、提供简单的餐饮、在线支付、评论等功能。
这次项目的开发前端采用的技术是 html+thymeleaf 模板引擎， 后端的设计采用的是
当前比较热门的 springboot，而数据库使用的是 Mysql，并且通过使用 jdbcTemplate 进
行访问。本文将通过对宾馆系统进行一次全面分析。对于整个系统，将根据系统功能不同
进行模块的划分，然后进行模块开发；对于数据库层次，将严格按照范式的要求进行表结
构的设计，并且对数据库的安全也会进行考虑；在测试阶段，将会进行深度的测试，通过
解决发现的 bug 来提升自己系统的安全性以及稳定性，优化用户的体验，完善系统功能。
最终对系统进行客观的评价，提出自己对系统功能的改进建议。
这次的系统设计，使我对项目的开发有了进一步的了解，同时自己的开发能力也有很
大的提升，也让自己明白，实践与理论并行才能更快的提升能力。
关键词：宾馆预订管理系统；SpringBoot；MySQL
Design and Implementation of Hotel Reservation
Management System Based on Springboot
Abstract
In today's era, holiday travel has been the first choice for everyone's holiday arrangements,
but now many small city hotels do not support the online booking function. Therefore, in
response to this situation and the feasibility analysis of the development of the system, this paper
designed a system that can quickly and easily query hotel information and provide
accommodation in a timely manner. The system has the function of booking a room, displaying
room information, providing simple dining, online payment, comments and more.
The technology used in the development front end of this project is the html+thymeleaf
template engine. The backend design uses the currently popular springboot, while the database
uses Mysql and is accessed by using jdbcTemplate. This article will conduct a comprehensive
analysis of the hotel system. For the whole system, the modules will be divided according to the
system functions, and then the module development; for the database level, the table structure
will be designed strictly according to the requirements of the paradigm, and the security of the
database will also be considered; in the testing phase, It will conduct in-depth testing to improve
the security and stability of your system by solving bugs found, optimize user experience, and
improve system functions. Finally, the system is evaluated objectively, and suggestions for
improvement of system functions are proposed.
This system design has enabled me to further understand the development of the project,
and at the same time, my own development capabilities have also been greatly improved, and I
also understand that practice and theory can be paralleled to improve capabilities faster.
Keywords: Hotel Reservation Management System; SpringBoot;MySQL
目录
1 绪 论 .....................................................................1
1.1 研究的背景及意义 .......................................................1
1.2 系统目标 ...............................................................1
1.3 系统开发核心技术 .......................................................1
1.4 系统开发工具 ...........................................................1
2 系统分析 ..................................................................2
2.1 需求分析 ...............................................................2
2.1.1 用户模块 ...........................................................2
2.1.2 订单模块 ...........................................................2
2.1.3 房间模块 ...........................................................3
2.2 可行性分析 .............................................................3
2.2.1 技术可行性 .........................................................3
2.2.2 社会可行性 .........................................................4
2.2.3 经济可行性 .........................................................4
2.3系统业务流程分析........................................................4
2.4 数据流程分析 ...........................................................5
2.4.1 前台子系统 .........................................................5
2.4.2 后台子系统 .........................................................6
2.4.3 数据字典 ...........................................................6
3 系统设计 ..................................................................7
3.1 系统功能设计 ...........................................................7
3.1.1 前台子系统模块设计 .................................................7
3.1.2 后台管理系统模块设计 ..............................................8
3.2 外部接口 ...............................................................9
3.3 内部接口 ...............................................................9
3.3.1 用户模块主要接口 ...................................................9
3.3.2 订单模块主要接口 ..................................................11
3.3.3 房间模块主要接口 ..................................................12
4 数据库设计 ...............................................................15
4.1 概念结构设计 ..........................................................15
4.1.1 引言 ..............................................................15
4.1.2 各功能 E-R 图 ......................................................15
4.2 逻辑结构设计 ..........................................................18
4.2.1 设计思路 ..........................................................18
4.2.2 逻辑模型 ..........................................................19
4.3 物理结构设计 ..........................................................20
4.3.1 存取方式 ..........................................................20
4.3.2 存储结构 ..........................................................20
5 详细设计 .................................................................20
