毕 业 设 计（论 文）
题目：高校宿舍管理系统的设计与实现
I
摘 要
本文是对高校宿舍管理系统的概括总结，主要从开题背景，课题意义，研究
内容，开发环境与技术，系统分析，系统设计，系统实现这几个角度来进行本高
校宿舍管理系统的阐述。
高校宿舍管理系统运用 Eclipse 工具进行开发，使用 Java 语言进行编码，后
台框架采用 SSM 框架(Spring 框架、SpringMVC 框架，MyBaites 框架)进行设计
上的分离，数据库采用的是 Mysql 数据库，用来保存本系统产生的数据。系统可
以提供信息显示和相应服务，本系统管理员管理宿舍访客和宿舍信息，管理宿舍
水表和电表以及对应的缴费信息，管理报修与学生信息。宿舍管理员管理宿舍卫
生检查信息和学生缺勤信息。学生查询电表和水表余额以及其对应的缴费信息，
登记物品报修，查询宿舍卫生检查和缺勤信息。
关键词：高校宿舍管理系统；Java 语言；Mysql
II
Abstract
This article is a general summary of the college dormitory management system,
mainly from the background of the topic, the meaning of the topic, the research
content, the development environment and technology, system analysis, system
design, and system implementation to explain the college dormitory management
system.
The university dormitory management system is developed using Eclipse tools
and coding in Java. The back-end framework adopts SSM framework (Spring
framework, SpringMVC framework, MyBaites framework) for design separation, and
the database adopts Mysql database to save the generation of this system. The data.
The system can provide information display and corresponding services. The system
administrator manages dormitory visitors and dormitory information, manages
dormitory water and electricity meters and corresponding payment information, and
manages repairs and student information. The dormitory administrator manages the
dormitory sanitation inspection information and student absence information. Students
inquire about the balance of electricity and water meters and their corresponding
payment information, apply for repairs of registered items, and inquire about
dormitory sanitation inspection and absenteeism information.
Key Words：College dormitory management system; Java language; Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................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 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................8
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计......................................13
4.1 设计原则 .......................................................................................................13
4.2 功能结构设计 ...............................................................................................13
4.3 数据库设计 ...................................................................................................16
4.3.1 数据库概念设计 ................................................................................16
IV
4.3.2 数据库物理设计 ................................................................................19
第 5 章 系统实现......................................24
5.1 管理员功能实现 ...........................................................................................24
5.1.1 访客管理 ............................................................................................24
5.1.2 学生管理 ............................................................................................24
5.1.3 宿舍信息管理 ....................................................................................25
5.1.4 公告管理 ............................................................................................25
5.2 宿舍管理员功能实现 ...................................................................................26
5.2.1 卫生检查管理 ....................................................................................26
5.2.2 缺勤管理 ............................................................................................26
5.2.3 电表管理 ............................................................................................27
5.3 学生功能实现 ...............................................................................................28
5.3.1 添加报修信息 ....................................................................................28
5.3.2 电表缴费查询 ....................................................................................28
5.3.3 水表查询 ............................................................................................29
第 6 章 系统测试......................................30
6.1 功能测试 .......................................................................................................30
6.1.1 登录功能测试 ....................................................................................30
6.1.2 修改密码功能测试 ............................................................................31
6.2 测试结果 .......................................................................................................31
结 论...............................................32
致 谢...............................................33
参考文献.............................................34
