毕 业 设 计（论 文）
题目：在线互动学习网站
I
摘 要
现代经济快节奏发展以及不断完善升级的信息化技术，让传统数据信息的管
理升级为软件存储，归纳，集中处理数据信息的管理方式。本在线互动学习网站
就是在这样的大环境下诞生，其可以帮助管理者在短时间内处理完毕庞大的数据
信息，使用这种软件工具可以帮助管理人员提高事务处理效率，达到事半功倍的
效果。此在线互动学习网站利用当下成熟完善的 SpringBoot 框架，使用跨平台的
可开发大型商业网站的 Java 语言，以及最受欢迎的 RDBMS 应用软件之一的
Mysql 数据库进行程序开发。实现了用户在线选择试题并完成答题，在线查看考
核分数。管理员管理字典管理、试卷表管理、试题表管理、考试记录表管理、答
题详情表管理、错题表管理、讨论管理、公告信息管理、回答管理、课程管理、
课程视频管理、课程留言管理、老师管理、用户管理、作业管理、管理员管理等
功能。在线互动学习网站的开发根据操作人员需要设计的界面简洁美观，在功能
模块布局上跟同类型网站保持一致，程序在实现基本要求功能时，也为数据信息
面临的安全问题提供了一些实用的解决方案。可以说该程序在帮助管理者高效率
地处理工作事务的同时，也实现了数据信息的整体化，规范化与自动化。
关键词：在线互动学习网站；SpringBoot 框架；Mysql；自动化
II
Abstract
The fast-paced development of the modern economy and the continuous
improvement and upgrading of information technology have allowed the management
of traditional data information to be upgraded to software storage, induction, and
centralized management of data information management methods. This online
examination system was born under such a large environment. It can help managers to
process huge data information in a short time. Using this software tool can help
managers improve transaction processing efficiency and achieve twice the result with
half the effort. This online test system utilizes the mature and complete SpringBoot
framework, uses the cross-platform Java language that can develop large commercial
websites, and the Mysql database, one of the most popular RDBMS application
software, for program development. It enables users to select test questions online,
complete their answers, and view the asseSpringBootent scores online. The
administrator manages question bank information, test paper information, and view
student scores and other functions. The development of the online examination system
is based on the operator's needs. The interface is simple and beautiful. The layout of
the functional modules is consistent with that of the same type of website. The
program also provides some practical solutions to the security problems of data and
information when it implements the basic required functions . It can be said that this
program helps managers to efficiently handle work affairs, and also realizes the
integration, standardization and automation of data information.
Key Words ： Online examination system; SpringBoot framework; Mysql;
Automation
III
目 录
目 录 ..............................................III
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 .....................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................3
2.1 SPRINGBOOT 框架介绍.....................................................................................3
2.2 B/S 结构介绍 ...................................................................................................3
2.3 MYSQL 数据库介绍..........................................................................................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 健壮性指标 ..........................................................................................7
3.2.4 安全性指标 ..........................................................................................8
3.3 系统流程分析 .................................................................................................8
3.3.1 操作流程分析 ......................................................................................8
3.3.2 登录流程分析 ......................................................................................9
3.3.3 信息添加流程分析 ............................................................................10
3.3.4 信息删除流程分析 ............................................................................11
3.4 系统功能分析 ...............................................................................................11
IV
4 系统设计...........................................12
4.1 系统概要设计 ...............................................................................................12
4.2 系统功能结构设计 .......................................................................................12
4.3 数据库设计 ...................................................................................................13
4.3.1 数据库 E-R 图设计............................................................................13
4.3.2 数据库表结构设计 ............................................................................14
5 系统实现...........................................15
5.1 管理员功能介绍 ...........................................................................................15
5.1.1 课程列表 ............................................................................................15
5.1.2 公告信息管理 ....................................................................................15
5.1.3 公告类型管理 .....................................................................................16
6 系统测试...........................................17
6.1 系统测试的特点 .........................................................................................17
6.2 系统功能测试 ...............................................................................................18
6.2.1 登录功能测试 ....................................................................................18
6.2.2 添加班级功能测试 ............................................................................18
6.3 测试结果分析 ...............................................................................................18
结 论...............................................20
致 谢...............................................21
参考文献.............................................22
