毕 业 设 计（论 文）
题目：精品在线试题库系统设计与实现
I
摘 要
使用旧方法对作业管理信息进行系统化管理已经不再让人们信赖了，把现在
的网络信息技术运用在作业管理信息的管理上面可以解决许多信息管理上面的
难题，比如处理数据时间很长，数据存在错误不能及时纠正等问题。这次开发的
精品在线试题库系统有管理员，教师，学生三个角色。管理员功能有个人中心，
专业管理，学生管理，教师管理，试卷管理，试题管理，考试管理。教师可以管
理试题和试卷，查看学生考试记录和错题本。学生可以参加考试，查看试卷和错
题本以及考试记录。经过前面自己查阅的网络知识，加上自己在学校课堂上学习
的知识，决定开发系统选择 B/S 模式这种高效率的模式完成系统功能开发。这种
模式让操作员基于浏览器的方式进行网站访问，采用的主流的 Java 语言这种面
向对象的语言进行精品在线试题库系统程序的开发，在数据库的选择上面，选择
功能强大的 MySQL 数据库进行数据的存放操作。精品在线试题库系统被人们投
放于现在的生活中进行使用，该款管理类软件就可以让管理人员处理信息的时间
介于十几秒之间。在这十几秒内就能完成信息的编辑等操作。有了这样的管理软
件，作业管理信息的管理就离无纸化办公的目标更贴近了。
关键词：精品在线试题库系统；Java；MySQL；Spring Boot 框架
II
Abstract
Using the old method to systematically manage job management information is no
longer trusted by people. Applying the current network information technology to the
management of job management information can solve many problems in information
management. There are problems such as errors that cannot be corrected in time. The
high-quality online test question bank system developed this time has three roles of
administrator, teacher and student. The administrator functions include personal
center, professional management, student management, teacher management, test
paper management, test question management, and test management. Teachers can
manage test questions and papers, and view student test records and error books.
Students can take exams, view exam papers and error books, and exam records. Based
on the network knowledge I consulted earlier, plus the knowledge I 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 access the website based on the browser, and uses the mainstream Java
language, an object-oriented language, to develop high-quality online test question
bank system programs. Data storage operation. The high-quality online test question
bank system is put into use in today's life, and this management software allows
managers to process information within a dozen seconds. The editing and other
operations of the information can be completed within these ten seconds. With such
management software, the management of job management information is closer to
the goal of paperless office.
Key Words ： High-quality online test bank system; Java; MySQL; Spring Boot
framework
III
目 录
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................3
2.1 SPRING BOOT 框架简介..................................................................................3
2.2 B/S 架构介绍 ...................................................................................................3
2.3 MYSQL 数据库介绍........................................................................................3
2.4 JAVA 语言介绍 ...............................................................................................4
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
5.5 试题管理 .......................................................................................................20
5.6 考试管理 .......................................................................................................21
5.7 错题本 ...........................................................................................................21
5.8 考试记录 .......................................................................................................22
6 系统测试 ...........................................23
6.1 本系统测试 .................................................................................................23
6.1.1 登录功能测试 .....................................................................................23
6.1.2 修改密码功能测试 .............................................................................24
6.2 测试结果分析 ................................................................................................24
结 论...............................................25
参考文献.............................................27
致 谢...............................................28
