毕 业 设 计（论 文）
题目：小学生课外知识学习网站设计与实现
I
摘 要
互联网发展到如今也近 20 年之久，小学生课外知识学习网站一直作为互联
网发展中的一个重要角色在不断更新进化。小学生课外知识学习网站从最初的文
本显示到现在集文字、视频、音频与一体，成为一种网络多媒体浏览网站。作为
一种媒体传输媒介，小学生课外知识学习网站如今也分各个类别，各种形式。本
文着重对小学生课外知识学习网站进行分析和研究，浅析小学生课外知识学习网
站的现状和存在的一些问题并对此进行研究，通过对问题和现状的分析研究和对
用户需求的一个简单整理建模，设计并且实现一个小学生课外知识学习网站。
小学生课外知识学习网站采用的开发框架为 SSM 框架，也就是 Spring mvc、
Spring、MyBatis 这三个框架，页面设计用的是 jsp 技术作为动态页面文件设计，
jsp 文件里可以对实现 html 等界面布局的代码，采用 SpringMVC 替代传统的
struts2 框架，主要对 jsp 访问的拦截和控制，Spring 作为整个控制的核心，通过
控制反转技术和面向切面技术，让 Spring 自动对使用的类文件进行调用和导入，
MyBatis 主要作为底层操作数据库，不牵扯业务逻辑，开发工具采用 Eclipse，服
务器用的是 tomcat。编码语言是 Java，数据库采用 Mysql。
关键词：小学生课外知识学习网站；Java；MySQL；SSM 框架；VUE 框架
II
Abstract
With the development of the Internet for nearly 20 years, primary school
students' extracurricular knowledge learning websites have been constantly updated
and evolved as an important role in the development of the Internet. From the initial
text display to the present, the primary school students' extracurricular knowledge
learning website integrates text, video and audio, and has become a network
multimedia browsing website. As a media transmission medium, primary school
students' extracurricular knowledge learning websites are now divided into various
categories and forms. This paper focuses on the analysis and research of primary
school students' extracurricular knowledge learning website, analyzes the current
situation and some existing problems of primary school students' extracurricular
knowledge learning website, and studies it. Through the analysis and research of
problems and current situation and a simple sorting and modeling of user needs, a
primary school students' extracurricular knowledge learning website is designed and
implemented.
The development framework of primary school students' extracurricular
knowledge learning website is SSM framework, that is, spring MVC, spring and
mybatis are three frameworks. JSP technology is used for page design as a dynamic
page file. The code for realizing HTML and other interface layout can be used in the
JSP file. Spring MVC is used to replace the traditional struts 2 framework to intercept
and control JSP access. Spring is the core of the whole control. Through control
inversion technology and aspect oriented technology, Let spring automatically call
and import the class files used. Mybatis is mainly used as the underlying operation
database without involving business logic. The development tool adopts eclipse and
the server uses Tomcat. The coding language is Java and the database adopts mysql.
Key Words ： Primary school students' extracurricular knowledge learning website;
Java； MySQL； SSM framework; Vue framework
III
目 录
目 录 ..............................................III
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................4
2.1 SSM 框架介绍 .................................................................................................4
2.2 B/S 架构介绍 ...................................................................................................4
2.3 MYSQL 数据库介绍........................................................................................5
2.4 JAVA 语言介绍 ...............................................................................................6
2.5 VUE 框架 .........................................................................................................6
3 系统分析............................................7
3.1 系统可行性分析 ..............................................................................................7
3.1.1 技术可行性分析 ..................................................................................7
3.1.2 经济可行性分析 ..................................................................................7
3.1.3 运行可行性分析 ..................................................................................7
3.2 系统性能分析 ..................................................................................................8
3.2.1 系统安全性 ..........................................................................................8
3.2.2 数据完整性 ..........................................................................................8
3.2.3 系统可扩展性 .......................................................................................9
3.3 系统流程分析 ..................................................................................................9
3.3.1 系统登录流程 .....................................................................................10
3.3.2 信息添加流程 .....................................................................................11
3.3.3 信息删除流程 .....................................................................................11
4 系统设计...........................................13
IV
4.1 系统概要设计 ................................................................................................13
4.2 系统功能结构设计 ........................................................................................13
4.3 数据库设计 ....................................................................................................14
4.3.1 数据库 E-R 图设计.............................................................................14
4.3.2 数据库表结构设计 ............................................................................15
5 系统实现...........................................20
5.1 用户信息管理 ...............................................................................................20
5.2 知识分类管理 ...............................................................................................20
5.3 课外知识管理 ...............................................................................................21
5.4 首页信息 .......................................................................................................21
6 系统测试 ...........................................23
6.1 本系统测试 .................................................................................................23
6.1.1 登录功能测试 .....................................................................................23
6.1.2 修改密码功能测试 .............................................................................24
6.2 测试结果分析 ................................................................................................24
结 论...............................................25
参考文献.............................................27
致 谢...............................................28
