网上选课系统的设计与实现

论文字数:9928,页数:29

摘  要

随着教育改革的不断深化，建立一套能够适应这些改变的行政管理方案也就显得尤为重要。在高等院校的日常工作中，每个学期都要面临学生的选课工作。以往在选课工作的各个阶段都是手工操作，不但效率低下、工作繁琐，而且容易出错，于是开发一套适合校情的网上选课系统便成为了教务处的迫切需求。
本文设计是根据部分学校的实际情况，在Visual Studio 2005环境中，利用ASP.NET、SQL Server数据库等技术开发了基于B/S模式的网上在线选课系统。在设计中完成了院系、专业、课程、教师、学生信息的管理功能及在线选课、查看选课学生、权限限制等功能。经测试，此系统满足教务系统用户需求，能够促进当前高校教务工作的管理水平，有一定的实际应用价值。

关键词：选课；SQL Server；ASP.NET；教务管理

The Design and Implementation of an Online Course-Choosing System
Abstract
With the continuous deepening of the educational reform, the construction and development of universities play an increasingly important role to raise the overall quality. For this, to establish an administration solution to adapt these changes is particularly important. In the day-to-day work, each student is faced with the course-choosing. For the past, in each stage, the work has done not only inefficient, cumbersome, but also prone to error. So an Online Course-Choosing System which is suitable for the school conditions becomes a exigent demand.
This project is based on some university’s basic needs and developed by Visual Studio 2005 and ASP.NET, SQL Server. This system completed the function of department management, major management, course management, teacher management, student management and online-course-choosing and so on. When the B/S system in working, the Users only need a personal computer can access the site for completing course-choosing and relating information management. This system can meet the current college's needs.

Key words: Course-Choosing; SQL Server; ASP.NET; Education Manage

目  录

1 引言 1
1.1 课题背景 1
1.2 课题目标 1
1.3 课题意义 1
2 开发平台、相关技术的介绍 2
2.1 ASP.NET 2
2.2 SQL Server 3
2.3 C#简介 4
3 需求分析 5
3.1 应解决的问题 5
3.2 系统架构 5
3.3 设计原则 6
3.3.1 实用性原则 6
3.3.2 可扩展性与可维护性原则 6
3.3.3 安全可靠性原则 6
3.3.4 用户界面设计原则 6
3.3.5 数据库设计原则 6
3.4 中间件引用 6
4 系统设计与实现 6
4.1 数据库设计 6
4.2 模块设计 11
4.2.1 登录模块设计 11
4.2.2 院系管理模块设计 12
4.2.3 专业管理模块设计 13
4.2.4 课程管理模块设计 13
4.2.5 学生管理模块设计 14
4.2.6 教师管理模块设计 14
4.2.7 学生个人信息维护模块设计 14
4.2.8 选课模块设计 16
4.2.9 担任课程查看模块设计 17
4.2.10 选课学生信息查看模块设计 18
4.2.11 数据库链接设计 19
5 部署与测试 19
5.1 部署图 19
5.2 模块测试 19
结论 21
参考文献 21
致谢 23
声明 24