毕 业 设 计（论 文）
题目：供电公司安全生产考试系统设计与实现
I
摘 要
使用旧方法对安全生产考试信息进行系统化管理已经不再让人们信赖了，把
现在的网络信息技术运用在安全生产考试信息的管理上面可以解决许多信息管
理上面的难题，比如处理数据时间很长，数据存在错误不能及时纠正等问题。
这次开发的供电公司安全生产考试系统管理员，教师，学生。管理员功能有
个人中心，学生管理，教师管理，主观题信息管理，主观题回答管理，主观题评
分管理，成绩信息管理，试卷管理，试题管理，考试管理。教师可以发布考试信
息，学生进行考试。经过前面自己查阅的网络知识，加上自己在学校课堂上学习
的知识，决定开发系统选择 B/S 模式这种高效率的模式完成系统功能开发。这种
模式让操作员基于浏览器的方式进行网站访问，采用的主流的 Java 语言这种面
向对象的语言进行供电公司安全生产考试系统程序的开发，在数据库的选择上面，
选择功能强大的 MySQL 数据库进行数据的存放操作。
供电公司安全生产考试系统被人们投放于现在的生活中进行使用，该款管理
类软件就可以让管理人员处理信息的时间介于十几秒之间。在这十几秒内就能完
成信息的编辑等操作。有了这样的管理软件，安全生产考试信息的管理就离无纸
化办公的目标更贴近了。
关键词：供电公司安全生产考试系统；Java；MySQL；SSM 框架
II
Abstract
The use of the old method to systematically manage the production safety
examination information is no longer trusted by people. Applying the current network
information technology to the management of production safety examination
information can solve many problems in information management, such as the long
processing time for data. , The data has errors and can’t be corrected in time.
Administrators, teachers, and students of the power supply company safety
production test system developed this time. Administrator functions include personal
center, student management, teacher management, subjective question information
management, subjective question answer management, subjective question score
management, score information management, test paper management, test question
management, and examination management. Teachers can post exam information and
students take the exam. After the network knowledge I checked before, plus the
knowledge I learned in the school classroom, I decided to choose the B/S mode as a
high-efficiency mode for the development system to complete the system function
development. This mode allows the operator to access the website based on the
browser. The mainstream Java language, an object-oriented language, is used to
develop the safety production test system program of the power supply company. In
the selection of the database, choose the powerful MySQL database Perform data
storage operations.
The safety production test system of the power supply company is used in
people's daily life. This management software allows managers to process information
within a dozen seconds. Information editing and other operations can be completed
within these ten seconds. With such management software, the management of safety
production examination information is closer to the goal of paperless office.
Key Words：Power supply company safety production test 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.2 学生信息管理 ...............................................................................................19
5.3 主观题管理 ...................................................................................................20
5.4 试题信息管理 ................................................................................................20
5.5 主观题答题 ....................................................................................................21
5.6 成绩信息统计 ................................................................................................21
6 系统测试 ...........................................22
6.1 本系统测试 .................................................................................................22
6.1.1 登录功能测试 .....................................................................................22
6.1.2 修改密码功能测试 .............................................................................23
6.2 测试结果分析 ................................................................................................23
结 论...............................................24
参考文献.............................................26
致 谢...............................................27
