网上选课系统ASP+SQL

目  录
前言 1
1 绪论 2
1.1 管理信息系统的产生和发展情况 2
1.2 网上选课系统的产生和发展情况 2
1.3 网上选课系统的可行性分析 3
1.4 网上选课系统的大致设计思想 4
1.4.1 系统功能划分 4
1.4.2 系统功能设计 5
1.4.3 系统结构选取 6
2 基础知识介绍 8
2.1 DREAMWEAVER 8
2.2 SQL SERVER 8
2.2.1 SQL Server 的优点 9
2.2.2 SQL语言基本语句介绍 10
2.3 ASP(ACTIVE SERVER PAGE) 11
2.4 HTML(HYPER TEXT MARKUP LANGUAGE) 14
2.5 VBSCRIPT介绍 14
2.6 B/ S 结构 16
3 需求分析 17
3.1 设计目的 17
3.2 相关定义 17
3.3 系统功能 17
3.3.1 功能需求分析 17
3.3.2 模块分析 19
3.4 系统要求 19
4 系统总体设计 21
4.1 系统结构设计 21
4.1.1 各模块功能及示意图 21
4.1.2 模块间的调用关系 21
4.1.3 模块间的接口 23
4.2 系统用例图 23
4.3数据库设计 25
5 网上选课系统的实现 29
5.1 教师/学生/管理员登录功能 29
5.2 教师/学生/管理员密码管理功能 32
5.3 学生的信息浏览/查询功能 35
5.3.1 选课课程信息查询 35
5.3.2 查询开课信息 37
5.3.3 查询公告信息 38
5.3.4 查询个人课表 38
5.3.5 浏览已发布信息 39
5.4 管理员的信息发布/增删/修改功能 40
5.4.1 课程信息发布 40
5.4.2 课程信息修改/删除 43
5.4.3 查询公告信息 45
5.4.4修改教师信息 45
5.4.5添加教师信息 46
5.4.6删除教师信息 46
5.4.7 修改学生信息 47
5.4.8 添加学生信息 47
5.4.9 删除学生信息 47

（科教作文网http://zw.ΝsΕAc.com发布）

网上选课系统
 
摘要：Internet技术的发展，进1步向人类展示了以计算机为核心的信息技术所带来的巨大效益。未来社会人们的生活、工作和学习将越来越依赖于信息技术的发展，越来越数字化、网络化、电子化、虚拟化。本文论述了1个基于浏览器/服务器(B/S，Browser /Server)模式的网络选课系统的研究与实现过程。并对在设计过程中涉及到详细设计思想和基本原理作了深入的阐述。自从高校扩招以来，在校大学生人数的不断增加，给学校各项管理工作带来沉重的负担。本系统从学生网上自主选课以及系统管理员网络排课等几个方面进行了设计，基本实现了学生的在线信息查询、选课功能以及系统管理员对课程信息的发布与排课等功能，另外也初步解决了系统中系统管理员、学生以及教师的权限问题。本程序前台采用Dreamweaver MX 2003进行页面制作，后台由SQL Server 2000数据库支持，通过使用ASP语言实现动态网页的效果，达到对数据库的操作以完成使用者的要求。本文中除了有对程序的总体设计、详细设计、功能实现等主体部分外，在这之前还介绍了相关软件及技术,并进行了可行性分析与需求分析以及国内外有关的最新动态。

关键词：选课;权限;SQL; ASP

Online Course Choosing System Based On Network
 
Abstract：With the development of Internet Technology, the huge benefit made by Information Technology which took the computer as the core had been demonstrated to the humanity in further. In our future society, the life, the work and the study of people will more rely on the development of information technology, and the society will become more digitized, network, computerization and virtualization. This article elaborates the research and the realization process of the network course choosing system which is based on the browser/Server (B/S, Browser/Server), and includes the thorough elaboration of the design concept and the basic principle. Since the expansion of the university, the collage student was increasing year by year, bringing a heavy burden to each supervisory work of the school. This system is designed from several aspects: the course choosing of student as well as the classes arrangement of system manager in Internet; and it basically realizes the online information inquiry, the course choosing function as well as the issue of the curriculum information and the arrangement of classes by system manager, moreover it had also initially solved the power question of system manager, student and teacher. This procedure used Dreamweaver MX 2004 to carry on the page manufacture, SQL Server 2000 database supports backstage, and took advantage of ASP language to realize the effect of dynamic homepage, in order to achieve the operation of database to complete the users request. Except from the main body parts such as outside procedure system design, detailed design and function realization, I also introduced the correlation software and its technology; carried on the feasibility analysis and the demand analysis as well as the related domestic and foreign newest tendencies in this article.

Key words：course choosing; Power; SQL; ASP