毕 业 设 计（论 文）
题目：自习室预订座位管理系统设计与实现
I
摘 要
使用旧方法对自习室预订座位管理信息进行系统化管理已经不再让人们信
赖了，把现在的网络信息技术运用在自习室预订座位管理信息的管理上面可以解
决许多信息管理上面的难题，比如处理数据时间很长，数据存在错误不能及时纠
正等问题。
这次开发的自习室预订座位管理系统管理员，学生。管理员功能有个人中心，
学生管理，座位分类管理，座位信息管理，座位预约管理，暂离信息管理，签到
信息管理，退座信息管理。学生功能有个人中心，座位信息管理，座位预约管理，
暂离信息管理，签到信息管理，推座信息管理。经过前面自己查阅的网络知识，
加上自己在学校课堂上学习的知识，决定开发系统选择 B/S 模式这种高效率的模
式完成系统功能开发。这种模式让操作员基于浏览器的方式进行网站访问，采用
的主流的 Java 语言这种面向对象的语言进行自习室预订座位管理系统程序的开
发，在数据库的选择上面，选择功能强大的 MySQL 数据库进行数据的存放操作。
自习室预订座位管理系统被人们投放于现在的生活中进行使用，该款管理类
软件就可以让管理人员处理信息的时间介于十几秒之间。在这十几秒内就能完成
信息的编辑等操作。有了这样的管理软件，自习室预订座位管理信息的管理就离
无纸化办公的目标更贴近了。
关键词：自习室预订座位管理系统；Java；MySQL；SSM 框架
II
Abstract
Using the old method to systematically manage the seat reservation management
information in the study room is no longer trusted by people. Applying the current
network information technology to the management of the seat reservation
management information in the study room can solve many problems in information
management, such as long data processing time, data errors can not be corrected in
time and so on.
The development of the study room booking seat management system administrator,
students. Administrator functions include personal center, student management, seat
classification management, seat information management, seat reservation
management, temporary leave information management, check-in information
management and seat withdrawal information management. Student functions include
personal center, seat information management, seat reservation management,
temporary leave information management, sign in information management and seat
pushing information management. After looking up the network knowledge in front of
me, plus the knowledge I learned in the school classroom, I decided to choose the B /
S mode to complete the system function development. This mode allows the operator
to visit the website based on the browser. The mainstream Java language, which is the
object-oriented language, is used to develop the program of the study room
reservation management system. In the selection of the database, the powerful
MySQL database is selected to store the data.
Study room reservation management system has been put into use in people's life, the
management software can let managers process information between ten seconds. In
these ten seconds can complete the information editing and other operations. With
such a management software, the management of seat reservation management
information in the study room is closer to the goal of paperless office.
Key Words：Study room reservation management system; Java； MySQL； SSM
framework
III
目 录
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................3
2.1 SSM 框架介绍 .................................................................................................3
2.2 B/S 架构介绍 ...................................................................................................3
2.3 MYSQL 数据库介绍........................................................................................4
2.4 JAVA 语言介绍 ...............................................................................................5
3 系统分析............................................6
3.1 系统可行性分析 ..............................................................................................6
3.1.1 技术可行性分析 ..................................................................................6
3.1.2 经济可行性分析 ..................................................................................6
3.1.3 运行可行性分析 ..................................................................................6
3.2 系统性能分析 ..................................................................................................7
3.2.1 系统安全性 ..........................................................................................7
3.2.2 数据完整性 ..........................................................................................7
3.2.3 系统可扩展性 .......................................................................................8
3.3 系统流程分析 ..................................................................................................8
3.3.1 系统登录流程 .......................................................................................9
3.3.2 信息添加流程 .....................................................................................10
3.3.3 信息删除流程 .....................................................................................10
4 系统设计...........................................12
4.1 系统概要设计 ................................................................................................12
4.2 系统功能结构设计 ........................................................................................12
IV
4.3 数据库设计 ....................................................................................................13
4.3.1 数据库 E-R 图设计.............................................................................13
4.3.2 数据库表结构设计 ............................................................................14
5 系统实现...........................................18
5.1 座位分类管理 ...............................................................................................18
5.2 学生信息管理 ...............................................................................................18
5.3 座位信息管理 ...............................................................................................19
5.4 座位预约管理 ...............................................................................................19
6 系统测试 ...........................................20
6.1 本系统测试 .................................................................................................20
6.1.1 登录功能测试 .....................................................................................20
6.1.2 修改密码功能测试 .............................................................................21
6.2 测试结果分析 ................................................................................................21
结 论...............................................22
参考文献.............................................24
致 谢...............................................25
