毕 业 设 计（论 文）
题目：高校学生管理系统设计与实现
I
摘 要
使用旧方法对校园活动信息进行系统化管理已经不再让人们信赖了，把现在
的网络信息技术运用在校园活动信息的管理上面可以解决许多信息管理上面的
难题，比如处理数据时间很长，数据存在错误不能及时纠正等问题。
这次开发的高校学生管理系统有管理员，教师，学生三个角色。有个人中心，
教师管理，学生管理，学生请假管理，课表信息管理，院系班级管理，学生奖惩
管理，学生成绩管理，培养计划管理，课程信息管理。教师和学生都可以注册登
录，教师主要对学生请假信息进行审核，对其他信息进行管理。经过前面自己查
阅的网络知识，加上自己在学校课堂上学习的知识，决定开发系统选择 B/S 模式
这种高效率的模式完成系统功能开发。这种模式让操作员基于浏览器的方式进行
网站访问，采用的主流的 Java 语言这种面向对象的语言进行高校学生管理系统
程序的开发，在数据库的选择上面，选择功能强大的 MySQL 数据库进行数据的
存放操作。
高校学生管理系统被人们投放于现在的生活中进行使用，该款管理类软件就
可以让管理人员处理信息的时间介于十几秒之间。在这十几秒内就能完成信息的
编辑等操作。有了这样的管理软件，校园活动信息的管理就离无纸化办公的目标
更贴近了。
关键词：高校学生管理系统；Java；MySQL；SSM 框架
II
Abstract
The systematic management of campus activity information using the old
methods is no longer trusted by people. Applying the current network information
technology to the management of campus activity information can solve many
problems in information management, such as the long time of processing data, the
error of data can not be corrected in time and so on.
The college student management system developed this time has three roles:
administrator, teacher and student. There are personal center, teacher management,
student management, student leave management, schedule information management,
department class management, student reward and punishment management, student
achievement management, training plan management and curriculum information
management. Both teachers and students can register and log in. Teachers mainly
review students' leave information and manage other information. After the network
knowledge consulted by myself in front and the knowledge learned in the school
classroom, I decided to develop the system and choose the B / S mode, which is an
efficient mode to complete the system function development. This mode allows the
operator to visit the website based on the browser, and use the mainstream Java
language, which is an object-oriented language, to develop the program of college
student management system. In the selection of database, select the powerful MySQL
database for data storage operation.
College student management system is put into use by people in today's life. This
management software allows managers to process information in more than ten
seconds. The information editing and other operations can be completed within more
than ten seconds. With such management software, the management of campus
activity information is closer to the goal of paperless office.
Key Words：College student 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 系统实现...........................................19
5.1 管理员模块的实现 .......................................................................................19
5.1.1 教师信息管理 ....................................................................................19
5.1.2 学生信息管理 ....................................................................................19
5.2 学生模块的实现 ...........................................................................................20
5.2.1 学生请假管理 ....................................................................................20
5.2.2 课表信息管理 ....................................................................................21
5.3 教师模块的实现 ...........................................................................................22
5.3.1 学生请假审核 ....................................................................................22
5.3.2 学生成绩管理 ....................................................................................22
6 系统测试 ...........................................24
6.1 本系统测试 .................................................................................................24
6.1.1 登录功能测试 .....................................................................................24
6.1.2 修改密码功能测试 .............................................................................25
6.2 测试结果分析 ................................................................................................25
结 论...............................................26
参考文献.............................................28
致 谢...............................................29
