网上教学辅助系统的设计与实现(JSP SQL2000)

摘要 [资料来源：THINK58.com]

随着计算机技术的飞速发展，信息网络已成为社会发展的重要保证。如何以网络为纽带快速、高效、方便地实现知识传递，以现代化手段促进教学改革，是教育工作者要解决的问题。传统的教学方式体现出教师和学生不能同步的问题，现在有一种教学方式就是基于网络的教学，它实现了在网络上学生和教师互动。
网上教学辅助系统是面向教师和学生的辅助系统， 基于JSP技术的网络教学平台是体现校园网的优势，通过此平台，学生、老师可以不受时间、空间、地域的限制，进行教学互动。相比较传统教学更容易提高教学效率。
     整个系统界面简洁、操作方便，包含了用户操作模块：普通用用户登录；学生提交作业、查看课件、提出问题和在线答题；教师发布课件、批改作业、更新试卷、解答问题等；还包含了管理员操作模块：系统管理员登录、维护等功能。
     本系统语言选择java,具体采用JSP +SQL Server开发。系统的实现是在SQL Server数据库上并基于B/S结构。
 

关键词：软件工程网上教学 JSPB/SSQL SERVER 2000 [资料来源：http://THINK58.com]

                         ABSTRACT
With the computer technically developing so fast, the information network has become the important guarantee that the society develop. To take the network as the link fast, it is how highly effective,how to improve the reform of teaching, conveniently realizes the knowledge transmission. In the platform, the student may be spatial, the region limited, not really realizing the on-line browsing course content, to complete the study work, function and so on .Now,there is a way of teaching students based on networks.It can be made student and teacher in the same platform.
The on-line teach assistant system faces to the teacher and students’ network teaching system, In this platform system structure, the function has carried on the detailed analysis, and introduced in the design uses essential technology and could be unlimited time and district.Compared to old system,it can improve the efficiency better. [资料来源：http://think58.com]
The system is succinct in every management, containing the general user and registration, search , examination and download. The students submit  the studywork, the examination class and the result. It focus on how to solve the problem that is hard to solve and it provides some ways about design idea.
The system adopts java ,JSP  and  SQL Server 200 technology. The System adopts SQL Server database and based on the B / S structure. [资料来源：http://www.THINK58.com]

Keywords: Software ProjectTeaching Network  JSP；B/S；SQL SERVER 2000

[来源：http://www.think58.com]

[资料来源：http://think58.com]

目    录
1. 引言
1.1  课题的来源.意义和目标 1
1.2. 完成的内容与设计结果 1
1.2.1.设计的内容 1
1.2.2.设计结果 2
2.  总体设计与实施方案
2.1.总体设计 3
2.1.1.设计目标 3
2.1.2.系统结构 3
2. 1. 3.系统数据流图…………………………………………………………………...4
2.2.实施方案 4
2.2.1. 设计环境需求与程序设计语言选择 4
2.2.2.方案与实施步骤 5
2.2.2.1.设计方案………………………………………………………………………5
2.2.2.2.实施步骤………………………………………………………………………6 
3.  系统的设计与实现/程序的编制
3.1. 数据设计 7
3.1.1. 数据库信息表设计 7
3.1.2. 数据库的实现 11
3.2. 系统模块的设计 12
3. 2. 1用户操作模块 12
3. 2. 2管理员操作模块 25
4. 程序的调试及故障分析
  4.1设计错误…………………………………………………………………………..28
4.2配置错误…………………………………………………………………………..28
5.  设计的结果与讨论

[资料来源：THINK58.com]

预览图：