河北农业大学

本科毕业论文(设计)

题 目： 网络教学系统——后台管理

摘要

随着信息技术与网络技术的发展和普及，基于Internet和Intranet的教育模式蓬勃发展，这也促进了以网络多媒体教育管理系统为基础的现代教育理论的发展。其中“数字化校园”的概念作为一种崭新的教育方式逐渐运用到实际的教学活动中，成为现代教育体系中重要的组成部分。

如何有效的管理各种教学资源与学生资料，实现对原有系统的整合与优化；如何方便快捷的实施教学，建立灵活全面的多媒体教学环境是网络教学管理平台需要解决的主要问题。网络教学代表了教育的一个发展方向, 本文介绍的网络化教学系统，是基于Internet

开展现代远程教育而开发的，采用三层设计结构，通过运用Java、Servlet、Sql Server数据库等软件的强大功能完成了系统中的后台管理，本系提供了对数据库中用户表，资源表，作业表，课程表，选课表，公告表的增删改查，以实现注册新用户，选课管理，上传课件，浏览课件，课程查询等功能。

关键词：教学系统 ；JSP；SQL2008；网上教学

Abstract

As information technology and network technology to the development and

popularization Based on Internet and Intranet mode of education to flourish. This

also contributes to network multimedia education management system as the

foundation of modern educational theory development. These "digital campus"

concept as a new education methods are applied to the actual teaching activities.

as a modern education system an important component.

How effective management of a variety of teaching resources and student

information, the realization of the original system integration and optimization;

How convenient and efficient implementation of teaching, establish flexible and

comprehensive multimedia teaching environment is teaching network management

platform need to resolve the main issues. Network teaching represents an

orientation to the development of education, The system of network teaching

presented in this thesis is an absolutely necessary teaching media for network

teaching which is developed on the basis of Internet for the purpose of the

development of modern long-distance teaching. Three-tier design structure, through

the use of powerful Java, Servlet, Sql Server database software such as complete

systems management background, the department provides the user tables in the

database, resource tables, schedules, curriculum, course selection table ,

deletions announcement table to the investigation, in order to achieve the new

user registration, course management, upload courseware, browse courseware,

curriculum query.

Keywords: Teaching System,JSP,SQL2008,Online Teaching

目录

1绪论 .......................................................... 1

1.1开发背景 .................................................. 1

1.2发展动态 .................................................. 2

1.2.1系统的体系结构 ......................................... 2

1.2.2开发运行环境 ........................................... 2

1.3网络教学管理系统的发展现状 ................................ 2

1.4论文的组织结构 ............................................ 3

2系统规划 ...................................................... 4

2.1系统的基本功能 ............................................ 4

2.2系统的特点 ................................................ 4

2.2.1课题的内容和要求 ....................................... 4

2.2.2系统开发技术 ........................................... 4

3系统分析 ...................................................... 5

3.1用户需求分析 .............................................. 5

3.2总体结构设计 .............................................. 5

3.2.1系统功能结构图 ......................................... 5

3.2.2系统各模块简要说明 ..................................... 5

3.2.3数据库概念结构设计 ..................................... 6

3.2.4数据库逻辑结构设计 ..................................... 8

3.2.5建表的SQL语句 ........................................ 10

4系统的具体实现 ............................................... 12

4.1准备工作 ................................................. 12

4.2数据库连接模块 ........................................... 12

4.3用户模块 ................................................. 13

4.4课程模块 ................................................. 14

4.5教学资源模块 ............................................. 14

4.6课程作业模块 ............................................. 15

4.7课程公告模块 ............................................. 16

5总结 ......................................................... 17

参考文献 ....................................................... 18

致谢 ........................................................... 19