毕 业 设 计（论 文）
题目：在线考试与学习交流网页平台的设计与实现
摘 要
如今社会上各行各业，都在用属于自己专用的软件来进行工作，互联网发展
到这个时候，人们已经发现离不开了互联网。互联网的发展，离不开一些新的技
术，而新技术的产生往往是为了解决现有问题而产生的。针对于考试信息与学习
交流信息管理方面的不规范，容错率低，管理人员处理数据费工费时，采用新开
发的在线考试与学习交流网页平台可以从根源上规范整个数据处理流程的正规
性和合法性。
在线考试与学习交流网页平台能够实现学习视频管理，试卷管理，考试管理，
试题管理，论坛管理等功能。该系统采用了 Mysql 数据库，Java 语言，Spring Boot
框架等技术进行编程实现。
在线考试与学习交流网页平台可以提高考试信息与学习交流信息管理问题
的解决效率，优化考试信息与学习交流信息处理流程，并且能够保证存储数据的
安全，它是一个非常可靠，非常安全的应用程序。
关键词：在线考试与学习交流网页平台；Mysql 数据库；Java 语言
Abstract
Nowadays, all walks of life in society are using their own dedicated software for
work. At this point in the development of the Internet, people have found that they
cannot do without the Internet. The development of the Internet is inseparable from
some new technologies, and the emergence of new technologies is often produced to
solve existing problems. In view of the irregularities in the management of
examination information and learning exchange information, the low fault tolerance
rate, and the time-consuming and labor-intensive processing of data by managers, the
newly developed online examination and learning exchange web platform can
standardize the formality and efficiency of the entire data processing process from the
root. legality.
The online test and learning exchange web platform can realize the functions of
learning video management, test paper management, test management, test question
management, forum management and so on. The system uses Mysql database, Java
language, Spring Boot framework and other technologies for programming.
The online examination and learning exchange web platform can improve the
efficiency of solving problems in the management of examination information and
learning exchange information, optimize the processing flow of examination
information and learning exchange information, and ensure the safety of stored data.
It is a very reliable and very safe application.
Key Words ： Online exam and learning exchange web platform; Mysql database;
Java language
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 MYSQL 数据库 ...............................................................................................3
2.3 IDEA 开发工具................................................................................................4
2.4 SPRING BOOT 框架............................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................5
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................7
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计 ........................................................................................................12
4.1 功能结构设计 ...............................................................................................12
4.2 数据库设计 ...................................................................................................13
4.2.1 数据库概念设计 ................................................................................13
4.2.2 数据库物理设计 ................................................................................16
第 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.2.3 错题表 ................................................................................................24
5.2.4 论坛信息 ............................................................................................25
第 6 章 系统测试 ........................................................................................................26
6.1 功能测试 .......................................................................................................26
6.1.1 登录功能测试 ....................................................................................26
6.1.2 修改密码功能测试 ............................................................................27
6.2 系统测试结果 ...............................................................................................28
结 论 ..........................................................................................................................29
参考文献 ......................................................................................................................31
致 谢 ..........................................................................................................................32
