毕 业 设 计（论 文）
题目：小程序公考学习平台的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对高校教师成果信息管理混乱，出错率高，信息安全性差，
劳动强度大，费时费力等问题，采用小程序公考学习平台可以有效管理，使信息
管理能够更加科学和规范。
小程序公考学习平台使用 Java 语言进行编码，使用 Mysql 创建数据表保存
本系统产生的数据。系统可以提供信息显示和相应服务，其管理小程序公考学习
平台信息，查看小程序公考学习平台信息，管理小程序公考学习平台。
总之，小程序公考学习平台集中管理信息，有着保密性强，效率高，存储空
间大，成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机化。
关键词：小程序公考学习平台；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic information management of
CET-4, high error rate, poor information security, high labor intensity, and
time-consuming and labor-consuming problems, the use of the web-based CET-4
online test system can effectively manage the information and make information
management more scientific and standardized.
The web-based English Level 4 online examination system uses Java language
for coding, and uses Mysql to create data tables to save the data generated by the
system. The system can provide information display and corresponding services. Its
administrator manages the test papers and the information of the question bank that
composes the test papers, checks the scores of the student test papers, and manages
classes and students. Students choose the test questions to answer the questions, and
they can view the answer scores.
In short, the web-based English Level 4 online examination system centrally
manages information and has many advantages such as strong confidentiality, high
efficiency, large storage space, and low cost. It can reduce the cost of information
management and realize the computerization of information management.
Key Words：Web-based English Level 4 online examination system; Java language;
Mysql
III
目 录
目 录..............................................III
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JAVA 语言 .........................................................................................................3
2.3 微信小程序技术 .............................................................................................4
2.4 SPRINGBOOT 框架.............................................................................................5
2.5 B/S 架构 ...........................................................................................................6
2.6 TOMCAT 介绍...................................................................................................6
2.7 HTML 简介......................................................................................................7
2.8 MYECLIPSE 开发工具.......................................................................................8
第 3 章 系统分析.......................................9
3.1 可行性分析 .....................................................................................................9
3.1.1 技术可行性 ..........................................................................................9
3.1.2 经济可行性 ..........................................................................................9
3.1.3 操作可行性 ..........................................................................................9
3.2 系统流程 .......................................................................................................10
3.2.1 操作流程 ............................................................................................10
3.2.2 登录流程 ............................................................................................10
3.2.3 删除信息流程 ....................................................................................11
3.2.4 添加信息流程 ....................................................................................12
3.3 性能需求 .......................................................................................................12
第 4 章 系统设计......................................14
IV
4.1 设计原则 .......................................................................................................14
4.2 功能结构设计 ...............................................................................................15
4.3 数据库设计 ...................................................................................................15
4.3.1 数据库物理设计 ................................................................................16
第 5 章 系统实现......................................19
5.1 用户信息管理 ........................................................................................19
5.2 视频信息管理 .......................................................................................20
5.3 公告信息管理 ........................................................................................22
5.1 论坛信息管理 ........................................................................................24
第 6 章 系统测试......................................27
6.1 测试的任务 .................................................................................................27
6.2 测试的目标 .................................................................................................27
6.3 测试方案 .....................................................................................................28
6.4 功能测试 .......................................................................................................29
6.4.1 登录功能测试 ....................................................................................30
6.5 测试结果 .......................................................................................................30
结 论...............................................31
致 谢...............................................32
参考文献.............................................33
