北京邮电大学毕业设计

JSP精品课程网站

摘 要

在21世纪这个信息高度发达、高速流通的时代，计算机的普及以及计算机网络的广泛应用，让普通人能够接触到比以往更多的知识。面对信息时代的信息大“爆炸”现象，怎么样才能使教育跟上时代的步伐，而不至于被时代抛在后面？很多专家一直都在思考这个问题“如何把教育资源移置到网络上去，使更多的人可以享有这些资源”。作为一个以传播知识为主要职能的机构，学校建立一个自己的精品课程网站是十分必要的事情，这不仅能使更多的人享用宝贵的教育资料源，同时也对于提升学校自身的知名度，提高学生自学能力，有相当大的帮助。

本设计的开发是基于B/S结构，采用采用Struts、Ajax技术及SQL Server 2005数据库进行开发。首先对精品课程网站做了详细的需求分析；然后给出了精品课程网站所需的功能，重点探讨了精品课程网站的设计法案；最后对精品课程网站进行了较详细的设计，并给出了具体实现步骤；通过测试分析，该系统的运行稳定、可靠，具有一定的实用价值。

关键词：精品课程网站；网站设计；Struts；Ajax；SQL Server 2005

i

北京邮电大学毕业设计

JSP exquisite course website

Abstract

Is highly developed in the 21st century this information, the high speed circulation time, computer's popularization as well as computer network's widespread application, let the average person be able to contact compared to formerly more knowledge. Is big “the detonation” facing information age's information the phenomenon, how can cause the education to follow the time the step, but as for is not left behind by the time? Many experts have been pondering this question “how does transpose the educational resources to the network comes up, enables more people to be possible to enjoy these resources”. As a take spread knowledge as main function's organization, the school establishes an own curriculum website is the very essential matter, not only this can cause more people to enjoy the precious education source of information, simultaneously also regarding promotes school own popularity, enhances the student to study independently ability, has the quite big help.

This design's development is based on the B/S structure, uses Struts, the Ajax technology and SQL the Server 2005 databases carries on the development. First has made the detailed demand analysis to the curriculum website; Then has given the function which the curriculum website needs, has discussed the curriculum website design bill with emphasis; Finally has carried on the detailed design to the curriculum website, and gave has realized the step specifically; Through the test analysis, this system's movement is stable, is reliable, has certain use value.

Key words: Curriculum website; Website design; Struts;Ajax; SQL Server 2005

ii

北京邮电大学毕业设计

目 录

摘 要 ................................................................... i Abstract ................................................................ ii 1 绪论 .................................................................. 1

1.1 选题目的 ......................................................... 1 1.2 课题意义 ......................................................... 1

1.2.1 有利于基础知识的理解 ....................................... 1 1.2.2 有利于逻辑思维的锻炼 ....................................... 2 1.2.3 有利于与其他学科的整合 ..................................... 2 1.2.4 有利于治学态度的培养 ....................................... 2 1.3 设计思想 ......................................................... 2 1.4 可行性分析 ....................................................... 3

1.4.1 技术可行性 ............................................... 3 1.4.2 经济可行性 ............................................... 3 1.4.3 社会可行性 ............................................... 3 1.5 总体设计原则 ..................................................... 3 2 系统环境和主要技术 .................................................... 5

2.1 系统开发环境和工具 ............................................... 5 2.2 系统运行环境 ..................................................... 5 2.3 Struts技术 ...................................................... 6 2.4 AJAX技术 ........................................................ 6

2.4.1 AJAX工作原理 ............................................... 7 2.4.2 AJAX的基本原则 ............................................. 7 2.5 SQL SEVER2005 .................................................... 7 2.6 JDBC概述 ........................................................ 8 2.7 Web数据库的发展历程 ............................................. 9

2.7.1 主机/终端结构 .............................................. 9 2.7.2 客户机/服务器结构 .......................................... 9 2.7.3 浏览器/服务器结构 ......................................... 10

3 系统开发与设计 ....................................................... 12

3.1 本网站建设的原则 ................................................ 12

3.1.1 以学生为目的的原则 ........................................ 12 3.1.2 网站设计与评价指标相统一原则 .............................. 12 3.1.3 教学内容与教学设计相结合原则 .............................. 12 3.1.4 教学实用性原则 ............................................ 12 3.1.5 交互设计原则 .............................................. 12 3.2 网站设计的方法 .................................................. 13 3.3 系统功能模块划分 ................................................ 13

3.3.1 功能模块图 ................................................ 13 3.3.2 系统模块介绍 .............................................. 14 3.4 数据库设计 ...................................................... 15

3.4.1 数据库设计需求分析 ........................................ 15