设计题目：学生宿舍设备报修管理系统的设计与实现
I
摘 要
计算机网络发展到现在已经好几十年了，在理论上面已经有了很丰富的基础，
并且在现实生活中也到处都在使用，可以说，经过几十年的发展，互联网技术已
经把地域信息的隔阂给消除了，让整个世界都可以即时通话和联系，极大的方便
了人们的生活。所以说，学生宿舍设备报修管理系统用计算机技术来进行设计，
不仅在管理方面更加的系统化，操作性强，最重要的是关于数据的保存和使用都
能节约大量的时间，该系统非常的好用。
学生宿舍设备报修管理系统管理数据的工具是 MySQL，编码的语言是 Java，
运用的框架是 SSM 框架。该系统可以实现宿舍管理，宿舍人员管理，故障分类
管理，物品分类管理，公告管理，故障上报管理，维修人员管理，学生管理等功
能。
学生宿舍设备报修管理系统不仅能让操作人员使用更加地方便，并且设计的
也很合理，能有效的避免误操作，让数据在录入的环节就符合设计需要，极大的
规避了源头性的输入误差，顺利的让数据变得更加可控并且可靠，让出错的几率
降到最低。
关键词：学生宿舍设备报修管理系统；宿舍；故障上报
II
Abstract
Computer networks have been developed for decades, and they have a rich
theoretical foundation and are used everywhere in real life. It can be said that after
decades of development, Internet technology has transformed regional information.
The estrangement between the two has been eliminated, allowing the whole world to
communicate and contact in real time, which greatly facilitates people's lives.
Therefore, the student dormitory equipment repair management system is designed
with computer technology. It is not only more systematic in management, but also has
strong operability. The most important thing is that the storage and use of data can
save a lot of time. The system is very efficient easy to use.
The data management tool of the student dormitory equipment repair
management system is MySQL, the coding language is Java, and the framework used
is the SSM framework. The system can realize dormitory management, dormitory
personnel management, fault classification management, item classification
management, announcement management, fault reporting management, maintenance
personnel management, student management and other functions.
The student dormitory equipment repair management system not only makes it
more convenient for operators to use, but also has a very reasonable design, which can
effectively avoid misoperation, so that the data can meet the design needs in the input
process, which greatly avoids the source input. Errors, smoothly make the data more
controllable and reliable, and minimize the chance of errors.
Key Words ： Student dormitory equipment repair management system; dormitory;
fault reporting
III
目 录
1 绪论 ...............................................1
1.1 选题背景 .........................................................................................................1
1.2 选题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
2 系统开发技术........................................3
2.1 MYSQL 数据库................................................................................................3
2.2 IDEA 简介........................................................................................................3
2.3 SSM 框架 .........................................................................................................4
2.4 VUE 框架 ..........................................................................................................4
3 系统分析............................................5
3.1 可行性研究 .....................................................................................................5
3.1.1 经济可行性 ..........................................................................................5
3.1.2 时间可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统性能分析 .................................................................................................6
3.2.1 系统的安全性 ......................................................................................6
3.2.2 系统的易用性 ......................................................................................6
3.2.3 系统的健壮性 ......................................................................................6
3.3 系统流程分析 .................................................................................................7
3.4 系统功能分析 .................................................................................................9
4 系统设计...........................................12
4.1 系统设计原则 ...............................................................................................12
4.2 功能模块设计 ...............................................................................................13
4.3 数据库设计 ...................................................................................................15
4.3.1 数据库 E-R 图....................................................................................16
IV
4.3.2 数据库表结构 ....................................................................................18
5 系统实现...........................................21
5.1 管理员功能实现 ...........................................................................................21
5.1.1 宿舍管理 ............................................................................................21
5.1.2 宿舍人员管理 ....................................................................................21
5.1.3 维修人员管理 ....................................................................................22
5.1.4 公告管理 ............................................................................................22
5.1.5 学生管理 ............................................................................................23
5.2 维修人员功能实现 .......................................................................................23
5.2.1 故障上报管理 ....................................................................................23
5.2.2 公告查看 ............................................................................................24
5.3 学生功能实现 ...............................................................................................24
5.3.1 故障上报管理 ....................................................................................24
5.3.2 宿舍查看 ............................................................................................25
5.3.3 宿舍人员查看 ....................................................................................25
6 系统测试...........................................27
6.1 功能测试 .......................................................................................................27
6.2 可用性测试 ...................................................................................................27
6.3 测试结果分析 ...............................................................................................28
结 论...............................................29
参考文献.............................................31
致 谢...............................................32
