LUOYANG NORMAL UNIVERSITY
****
届本毕业设计
JavaWeb精品课程网站
院 ( 系 ) 名 称 信息技术学院
专 业 名 称 软件工程
学 生 姓 名
**
学 号
******
指 导 教 师 **** 教授
完 成 时 间 ****年5月
洛阳师范学院****届本科生毕业设计
摘要
精品课程建设是教育部启动的“高等学校教学质量与教学改革工程”中的一项重要内容,而
精品课程网站建设则是高校精品课程建设的组要组成部分,它能够提高教学质量,充分利用网
络教学资源,还能使不同高校之间实现精品课程的资源共享,扩大受众群。
该精品课程网站是基于Internet/Intranet 及Web技术建立以Browser/Server 为结构模式、以
数据库为后台核心应用、以服务为目的信息平台,对资源进行科学的加工整序和管理维护,
一方面为学生或者相关爱好者提供一个学习交流的平台,在此平台上能查阅相关的专业知识
如了解Java基础知识、下载Java课程的课件、在线观看课程的讲座、在线答疑等功能。另一
方面,精品课程网站本身就是一个优质教学资源的集合体,能够满足不同地区同类课程之间
的资源共享,使得教学更加方便,不仅方便学生在家或在寝室自己学习,提高学生自学能力
还节省了学生、老师的时间。
关键词:精品课程;网站;JSP;JavaBean;Servlet;MySQL
JavaWeb 精品课程网站
JavaWeb 精品课程网站
Abstract
The high-quality curriculum construction is an important content of the Ministry of education
initiated "college teaching quality and teaching reform project", while the high-quality curriculum
w e b s i t e i s t h e i m p a r t a n t p a r t o f t h e c o n s t r u c t i o n o f th e t o p - q u a l i t y c o u r s e c o n s t r u c t i o n
i n t h e u n i v e r s i t i e s . It c a n i m p r o v e t h e q u a l i t y o f t e a c h i n g , m a k e f u l l u s e o f n e t w o r k t e a c h i n g
r e s o u r c e s , a n d a l s o m a k e t h e i m p l em e n ta t ion of excell ent curricul u m resource s h a r i n g b e t w e e n
different universities , expanding the audience.
The website is Internet/Intranet and Web technology based on the Browser/Server structure
mode, with the database as the core application, with the aim of service information platform based
o n t h e m a i n t e n a n c e , s c i e n t i f i c p r o c e s s i n g o r d e r a n d m a n a g e m e n t o f r e s o u r c e s ,
On one hand, providing students and enthusiasts provide a learning and communication platform,
on which can access to the relevant professional knowle dge, such as the unde rstanding of basic
knowledge of Java, download the Java curriculum courseware, online watch the lecture courses,
online answering understanding curriculum. On the other hand, quality course website itself is a
high-quality teaching resources to meet the same course, between different regions of the resource
sharing,not only making teaching more convenient,regardless of students at home or in the bedroom
of their learning, but also improving self-learning ability and saving the teacher's time,as well as
students`.
Keywords: Excellent course ; Website ; JSP ; JavaBean ; Servlet ; MySQL
JavaWeb 精品课程网站
目 录
LUOYANG NORMAL UNIVERSITY..................................................................................................................1
第1章 绪论.............................................................................................................................................................1
1.1 网站开发背景..........................................................................................................................................1
1.2 网站当前现状..........................................................................................................................................1
1.3 精品课程网站建设的意义......................................................................................................................2
1.5 可行性分析..............................................................................................................................................2
第2章 网站需求分析.............................................................................................................................................4
2.1 用户功能需求分析..................................................................................................................................4
2.2 网站性能要求..........................................................................................................................................5
2.3 网站功能模块展示..................................................................................................................................5
第3章 网站总体设计.............................................................................................................................................7
3.1 网站功能模块分析..................................................................................................................................7
3.1.1 教学资源.......................................................................................................................................7
3.1.2 教师简介.......................................................................................................................................8
3.1.3 教学论坛.......................................................................................................................................8
3.1.4 注册...............................................................................................................................................9
3.1.5 登录.............................................................................................................................................10
3.1.6 教学资源.....................................................................................................................................11
3.1.7实验教学......................................................................................................................................11
3.1.8试题中心......................................................................................................................................11
3.1.9学习指南......................................................................................................................................11
3.1.10精品首页....................................................................................................................................12
3.1.11 用户管理...................................................................................................................................12
3.2数据库概念结构设计.............................................................................................................................12
3.3 实体联系图............................................................................................................................................13
3.3 系统总体设计........................................................................................................................................14
第4章 系统详细设计...........................................................................................................................................15
4.1 开发工具简介........................................................................................................................................15
4.2 数据库设计............................................................................................................................................16
4.2.1 Oracle数据库简介.......................................................................................................................17
4.2.2 Oracle数据库的设计...................................................................................................................17
4.3 用户界面设计........................................................................................................................................25
4.3.1 前台登录界面.............................................................................................................................25
4.3.2 后台登录界面.............................................................................................................................26
4.3.3 管理员新建类别界面.................................................................................................................27
4.3.4 资源文件管理界面.....................................................................................................................29
4.3.5 上传文件界面.............................................................................................................................29
4.3.6 下载文档页面.............................................................................................................................37
4.3.7 在线播放界面.............................................................................................................................38
4.4 系统的难点及解决方案........................................................................................................................39
4.4.1 文件上传问题.............................................................................................................................39
4.4.2 视频播放问题.............................................................................................................................39