基于 JSP 的在线培训系统的设计与实现
本 科 生 毕 业 设 计
设计题目: 基于 JSP 的在线培培训系统
学生姓名：
学生学号:
指导教师：
二级院系：
专业班级：
完成时间：
- I -
基于 JSP 的在线培训系统的设计与实现
目 录
摘 要.............................................................................................................................................................IV
Abstract..........................................................................................................................................................V
第1章 概述.....................................................................................................................................................1
1.1 课题背景..........................................................................................................................................1
1.2 课题意义..........................................................................................................................................2
1.3开发工具及技术...............................................................................................................................2
1.3.1 MyEclipse..............................................................................................................................2
1.3.2 Tomcat...................................................................................................................................3
1.3.3 SqlServer................................................................................................................................3
1.3.4 JSP.........................................................................................................................................3
第2章 可行性分析及总体设计原则.............................................................................................................5
2.1可行性分析.......................................................................................................................................5
2.1.1技术可行性.............................................................................................................................5
2.1.2经济可行性.............................................................................................................................5
2.1.3社会可行性.............................................................................................................................5
2.2总体设计原则...................................................................................................................................6
第3章 系统分析.............................................................................................................................................7
3.1业务流程分析...................................................................................................................................7
3.2数据流图...........................................................................................................................................7
第4章 系统设计.............................................................................................................................................9
4.1系统功能设计...................................................................................................................................9
4.2数据库设计.....................................................................................................................................10
4.2.1概念结构设计.......................................................................................................................10
4.2.2数据库表设计.......................................................................................................................13
- II -
基于 JSP 的在线培训系统的设计与实现
第5章 系统实现...........................................................................................................................................16
5.1管理员登录.....................................................................................................................................16
5.2管理员功能模块.............................................................................................................................18
5.2.1公告信息管理.......................................................................................................................18
5.2.2答疑信息管理.......................................................................................................................21
5.2.3学习资料管理.......................................................................................................................23
5.2.4视频信息管理.......................................................................................................................26
5.2.5修改个人密码.......................................................................................................................29
5.3前台网站功能模块..........................................................................................................................29
5.3.1网站首面..............................................................................................................................29
5.3.2学习资料下载.......................................................................................................................30
5.3.3学习视频下载.......................................................................................................................32
5.3.7在线答疑模块.......................................................................................................................35
第6章软件测试............................................................................................................................................36
6.1软件测试的重要性..........................................................................................................................36
6.2测试实例的研究与选择..................................................................................................................36
6.3测试环境与测试条件......................................................................................................................37
6.4系统运行情况.................................................................................................................................37
6.5系统评价.........................................................................................................................................38
第7章 结论...................................................................................................................................................38
参考文献......................................................................................................................................................39
致谢..............................................................................................................................................................41
- III -
基于 JSP 的在线培训系统的设计与实现
摘 要
本文采用自顶向下的结构化的系统分析方法，阐述了一个功能全面的在线培训系统的开发过程
操作流程及其一些核心的技术。本文首先进行了项目概述，简单介绍了项目开发的背景、项目开发的
目的和项目开发的意义；接下来是系统规划阶段，通过实际的业务流程调研，分析了系统的组织结构
具体完成了在线培训系统的需求分析、可行性分析、现行业务流程分析，并通过对现行业务流程的优
化，得出了系统的业务流程；之后是系统分析，具体完成了数据流分析和数据字典；系统设计阶段主
要完成了功能模块的划分、数据库的设计和系统界面设计。该阶段对各个模块的功能进行了详细设计
形成了本系统的功能模块图，在此基础上选择了合适的开发模式；数据库的设计先进行了概念结构设
计，之后进行了逻辑结构设计，最后完成了数据库表的设计。
根据前几个阶段的分析和设计，本系统在设计方面采用B/S模式，同时使用JSP技术进行基本页
面的设计与功能实现，后台数据库选用SQLSERVER数据库。本系统的设计实施为在线培训系统的运
行做基础，为在线培训系统提供良好的条件。
关键词：结构化分析；B/S
- IV -
基于 JSP 的在线培训系统的设计与实现
Abstract
This paper using the top-down structured system analysis method, this paper expounds the
f u n c t i o n s o f a c o m p r e h e n s i v e c o u r s e w e b s i t e d e v e l o p m e n t p r o c e s s , o p e r a t i o n p r o c e s s a n d
so me of th e co r e t e ch n o lo g y. T hi s pa p er f ir s t o n t h e d e sc r i pt i on o f p ro j e ct , in t rod u ce d th e
project development background, the purpose of the project development and the significance
of developing project; The next stage is system planning, through the actual business process
o f t h e i n v e s t i g a t i o n a n d r e s e a r c h , a n d t h e a n a l y s i s o f s y s t e m s t r u c t u r e , s p e c i f i c c o m p l e t e d
q u a l i t y c o u r s e w e b s i t e n e e d s a n a l y s i s , f e a s i b i l i t y a n a l y s i s , t h e c u r r e n t b u s i n e s s p r o c e s s
analysis, and through to the current business process optimization, concludes that the system
of business process ，After the system analysis, specific completed the data flow analysis and
data dictionary; System design phase is completed the function module and database design
and system interface design. This phase of the function of each module of the detailed design,
f o r m e d t h e s y s t e m f u n c t i o n m o d u l e c h a r t , o n t h e b a s i s o f t h e c h o i c e o f a p p r o p r i a t e
d e v e l o p m e n t m o d e ; T h e f i r s t d a t a b a s e d e s i g n t h e c o n c e p t s t r u c t u r e d e s i g n , o n t h e l o g i c a l
structure after design, finally completed the design of database table
According to former several stages of the analysis and design, this system in the design on
t h e B / S m o d e , u s e a t t h e s a m e t i m e J S P t e c h n o l o g y o f b a s i c p a g e s d e s i g n a n d f u n c t i o n
r e a l i z a t i o n , t h e b a c k e n d d a t a b a s e c h o o s e S Q L S E R V E R d a t a b a s e . T h i s s y s t e m d e s i g n f o r
a s s e m b l y l a n g u a g e i m p l e m e n t a t i o n o f t h e o p e r a t i o n o f t h e a u x i l i a r y J i a o X u e W a n g d o
foundation, to provide auxiliary assembly language JiaoXueWang good conditions.
Key Words
：
structural analysis; B/S
- V -
