本科毕业设计说明书
题 目：网上选课系统的
设计与实现
山东建筑大学毕业设计说明书
I
目 录
摘 要 .....................................................................III
ABSTRACT................................................................IV
1 前 言
1.1 课题的背景和意义 .........................................................1
1.2 发展现状 .................................................................1
1.3 主要设计内容 .............................................................2
2 相关技术
2.1 BS 架构 ..................................................................3
2.2 JSP 技术 .................................................................3
2.3 MyEclipse 的介绍 .........................................................4
2.4 JavaBean 技术 ............................................................5
2.5 SQL Server 的介绍 ........................................................6
3 需求分析
3.1 系统功能概述 .............................................................7
3.2 用户权限描述 .............................................................7
3.3 数据流程 .................................................................7
3.4 系统环境 .................................................................9
3.4.1 系统运行环境 ..........................................................9
3.4.2 系统开发环境 ..........................................................9
4 概要设计
4.1 系统总体结构 ............................................................10
4.2 系统功能描述 ............................................................10
4.3 数据库设计 ..............................................................10
4.3.1 SQL 数据库的选择......................................................10
4.3.2 数据库的设计 .........................................................11
4.3.3 数据表 E-R 图 .........................................................14
山东建筑大学毕业设计说明书
II
5 详细设计和代码实现
5.1 网上选课系统教师部分过程设计与界面设计 ..................................15
5.1.1 系统总控制模块 .......................................................15
5.1.2 密码修改模块 .........................................................16
5.1.3 学生成绩添加模块 .....................................................18
5.1.4 查询模块 .............................................................21
5.2 网上选课系统学生部分设计 ................................................23
5.3 网上选课系统留言板部分设计 ..............................................26
5.3.1 学生留言功能 .........................................................26
5.3.2 教师留言功能分析 .....................................................30
5.4 网上选课系统管理员部分设计 ..............................................32
5.4.1 管理员部分功能模块 ...................................................32
6 系统测试
6.1 系统测试 ................................................................39
6.1.1 概述 .................................................................39
6.1.2 测试用例 .............................................................39
6.2 系统评价 ................................................................42
7 结论和展望
谢 辞 .....................................................................44
参考文献...................................................................45
山东建筑大学毕业设计说明书
III
摘要
设计本系统的目的是对网上选课信息进行管理。网上选课系统管理员模块主要完成的
是后台管理功能。在设计初期，首先对网上选课的流程以及各角色进行分析，分模块划分
功能，做出功能模型，大体流程为：管理员部分、教师部分、学生部分以及留言板交互部
分。实现学生的功能模块要有学生选课，删课，修改密码，留言等功能。教师则是查看学
生信息，打分，修改密码等。留言模块主要完成如下的功能：学生向已选课程教师留言、
教师回复学生留言、所有留言的查看等。在管理员一部分负责后台管理，主要是添加、修
改、删除各项信息，包括教师、学生、课程以及附属的院系、公告、留言等，课表安排，
教师与学生对应关系，账户管理等。之后根据需求做出总体设计方案，并据此分功能模块
进行编码实现。系统使用 B/S 结构设计和开发，系统的编码实现基于 Struts1.2，使用 JSP
作为开发语言，Myeclipse 和 tomcate 作为编程环境和服务系统，SQL Server 2000 作为数
据库。
论文中对课题的设计和开发进行了完整地论述。系统开发完成后，对课题要求的功能
设计出测试用例，进行功能测试，测试结果证明网上选课系统管理员部分基本实现了对该
模块的功能需求，完成了课题的主要任务。
关键词：网上选课; B/S; JSP
山东建筑大学毕业设计说明书
IV
Selecting Course Management Systems Design and Implementation
ABSTRACT
The purpose of the design of this system is to manage the online course selection
information. Online Course Selection System Administrator module to complete the background
of the major management functions. In the design stage, the first of the online course selection
process and the role of the analysis of functional sub-module to make functional model, general
procedures: administrator part of some teachers and students interact with some components and
message boards. Modules students have to achieve student course selection, delete courses,
change passwords, messages and other functions. Teachers is the view student information,
scoring, modify passwords. Message module of the completion of the following functions:
teacher of students in the selected message to the teachers the students shout back, all the
message of the view and so on. Part of the administrator responsible for managing the
background, mainly to add, modify, delete all information, including teachers, students, courses
and affiliated departments, announcements, messages, etc., curriculum arrangement,
teacher-student correspondence, account management. Design based on the demand made after
the program, and accordingly sub-function modules Coding. System uses the B / S structure
design and development, system implementation based on the coding Struts1.2, using JSP as the
development language, Myeclipse and tomcate as the programming environment and the service
system, SQL Server 2000 as the database.
Thesis on the topic of design and development for a complete exposition. Systems development
is completed, the function of the requirements of the subject test case design, functional testing,
test results show that some of the basic online course selection system administrator implements
the functional requirements of the module, completing the main task of the subject.
Key Words: Course Selection Online; B/S; JSP
