大学本科毕业设计（论文）
学生选课管理系统
Student Course Management System
学 院（系）：
专 业：
学 生 姓 名：
学 号：
指 导 教 师：
评 阅 教 师：
完 成 日 期：
学生选课管理系统
摘 要
本论文主要描述基于 b/s 模式的学生选课系统的实现。本系统是一个典型的信息管
理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方
面。前部分系统分析主要是讲解本系统数据库的实现与整体系统各个模块的设计实现，
后半部分主要是描述系统的各个部分实现，主要包括登陆，排课，选课三个主要模块
实现。
学生选课系统主要包括登陆，排课，选课三个基础功能，登陆系统主要是验证用
户信息与用户类别，然后赋予相应的权限。随之而带的是学生与教师的信息管理功能。
信息管理模块也有两个部分，主要是个人信息管理与院系课程管理，即学生与教师的
个人信息管理，院系与课程的信息管理。为了实现选课的合理性与功能的优异性，这
也要求本系统必须拥有一个科学的课程管理功能。重点也是这部分课程管理，当管理
员对新课进行排课的时候，会在数据库中先检查新课排课的合法性即为冲突检测，然
后进行发布，同时学生便可获知新课的信息。当院系学生需要选课时，通过数据库会
先进行一次添加，如果时间或人数发生冲突，便会添加失败。如果成功，会在选课人
数做修改，即为成功选课，教师也同时会得到这名选课的同学的信息。
本论文中的系统可基于 IIS 6.0 + Sql Server 2005 + Windows Server 2003 进行实现，
可以方便老师、学生方便的排课与选课。实现全校学生选课在线查询。还可以对新来
的学生信息进行信息录入。由于学生上课情况复杂，本系统利用信息返汇，实现信息
修改，及时调整学生的基本情况。
关键词：选课；学生；排课；管理
- I -
学生选课管理系统
Student Course Management System
Abstract
The article described "Student Course Management System" based on a b/s model. The
system is a typical management information system (MIS), including the development of the
establishment and maintenance of database at background and application development front-
end aspects. The first is to analysis the main database on the system with the overall system
design and implementations of each module, then the article described how to meet each part
needs. The main parts of the system are login, arrange class, and select class.
The main parts of the system are login, arrange class, and select class. The important of
the login part is to verify the user information and user type, and then give the user its
permission. And the next part is students and teachers management. Information of
management has two parts, user information and department information. The most important
item in the system is the management of class. When the administrator arranges the new class,
system will detect if the information is right and if it is true, the class will send to students.
When student want to select some class, system will try to update the class information to
database, if there is some other class in the same class or the class has enough people, system
will avoid this information. Also system will accept it and make changes in database.
This system could be made at IIS6.0 + Sql Server 2005 + Windows Server 2003. It will
make the students and teachers more convenient to arrange or select class. And it also could
update new information of students. Because of the complexity of the class, this system takes
use of message which back from users to make change of class in time.
Key Words：Course Management；Student；Arrange Class；Management
- II -
学生选课管理系统
目 录
摘 要 I
Abstract II
1 绪论 1
1.1 选题背景和意义...........................................................................................................1
1.2 国内外的发展状况.......................................................................................................2
1.3 论文的工作和内容介绍...............................................................................................3
2 相关技术介绍 4
2.1 B/S 结构简介................................................................................................................4
2.2 Microsoft SQL Server 2005 简介.................................................................................5
2.3 IIS 6.0 和 Windows Server 2003 相关简介.................................................................6
2.4 ASP 的特点与功能.......................................................................................................8
2.4.1 ASP 方法与传统静态主页的区别......................................................................8
2.4.2 ASP 的特点与功能..............................................................................................9
2.5 Ajax 技术简介............................................................................................................10
3 系统分析 12
3.1 业务分析.....................................................................................................................12
3.1.1 系统需求分析....................................................................................................12
3.1.2 业务流程分析....................................................................................................13
3.2 数据分析.....................................................................................................................16
3.3 功能模块分析.............................................................................................................19
3.4 网络拓扑结构分析.....................................................................................................21
3.5 安全性分析.................................................................................................................21
4 系统设计 23
4.1 系统结构设计.............................................................................................................23
4.2 数据库设计.................................................................................................................24
4.2.1 概念结构设计...................................................................................................24
4.2.2 逻辑结构设计....................................................................................................26
4.2.3 数据库表设计....................................................................................................27
4.3 功能设计.....................................................................................................................29
4.4 软件的运行环境.........................................................................................................31
5 系统实现 32
- III -
学生选课管理系统
5.1 系统实现概况.............................................................................................................32
5.2 登陆模块.....................................................................................................................32
5.3 排课模块.....................................................................................................................34
5.4 选课模块.....................................................................................................................36
5.4 系统测试.....................................................................................................................38
5.4.1 登陆模块............................................................................................................38
5.4.2 排课模块............................................................................................................39
5.4.3 选课模块............................................................................................................39
结 论 40
参 考 文 献 41
致 谢 42
- IV -
评论3
最新资源