分类号：TP315 U D C：D10621-408-(2007)XXXX-0
密 级：公 开 编 号：2003215017
成 都 信 息 工 程 学 院
学 位 论 文
在线教学质量评价系统的设计与实现
论 文 作 者 姓 名 ：
李 洋
申 请 学 位 专 业 ：
网 络 工 程
申 请 学 位 类 别 ：
工 学 学 士
指导教师姓名（职称）：
李 谊 瑞(研究员)
论 文 提 交 日 期 ：
2007 年 6 月 10 日
在线教学质量评价系统的设计与实现
摘 要
在线教学质量评价系统可以方便和全面地收集教师教学工作的数据，提供师
生网上评教的评分结果，快速集中收集各方面的评教信息，使教务管理部门能够
及时了解教学动态和师资情况，为教务老师提供相关决策支持，为职称评聘提供
教学工作质量的科学依据，同时减轻了教务老师的工作量。
系统用户分为三类，分别是学生、教师和管理员。学生可以在互联网上选课
并对教师及其所教授的课程进行打分、留言，教师可以查看学生对自己的评教结
果和留言以及对其同行的教学质量进行评估，管理者可以对学生以及教师同行评
教的信息进行查询和统计,同时可以查看教师排行榜并打印。查询可根据查询条
件的不同显示不同的查询结果，同时也可根据统计要求显示不同的结果。
系统是基于 Windows XP 操作系统,采用 JSP 开发，并使用 SQL SERVER
2000 数据库来实现。
关键词：教学；评教；数据库；统计；JSP:
Design and Implementation of Online Teaching Quality
Evaluation System
Abstract
The online teaching quality evaluation system can collect the data of teaching
work conveniently and comprehensively, offer the score results of online teaching
evaluation by teachers and students, collect the information of teaching evaluation
from different fields fast, enable the administrative department to find out about
teaching development and teachers' situation in time, offer relevant decision support
to the teachers of educational administration, offer the scientific basis of teaching
work quality for the thing that the professional title is commented and engaged ,
reduce the work load for the teachers of educational administration at the same time .
The users of this system are divided into three kinds that include student, teacher
and administrator. Students may select the lesson and give a score, make comments to
the teacher on Internet; the teacher can look over the results and comments of the
teaching evaluation and evaluate teaching quality of other teachers. The administrator
can inquire the comment information and look over teacher's billboard and type the
results at the same time. Inquire that can be showing different inquiry results
according to different condition of inquiring, at the same time; it can show different
results according to the statistics request.
The system is based on Windows XP operation system, adopt JSP to develop
languages, the database is SQL SERVER 2000.
key words: teaching；evaluation of teaching；statistics；database；JSP
目 录
论文总页数：24 页
1 引 言..............................................................................................................................................1
1.1 课题背景.............................................................................................................................1
1.2 目的意义.............................................................................................................................1
2 开发工具、技术简介及运行环境................................................................................................1
2.1 开发工具简介.....................................................................................................................1
2.1.1 sql server2000 简介 ..................................................................................................1
2.1.2 Tomcat 简介 ............................................................................................................1
2.1.4 Microsoft SQL Server 2000 Driver for JDBC 简介.................................................2
2.2 开发技术简介.....................................................................................................................2
2.2.1 JSP 简介....................................................................................................................2
2.2.2 SQL 简介 ..................................................................................................................3
2.3 运行环境.............................................................................................................................3
2.3.1 软件准备..................................................................................................................3
2.3.2 环境变量的配置......................................................................................................3
2.3.3 测试默认服务器......................................................................................................4
2.3.4 测试项目..................................................................................................................4
3 需求分析........................................................................................................................................4
3.1 系统功能设计......................................................................................................................4
3.2 系统设计思想.....................................................................................................................4
3.3 数据库分析.........................................................................................................................5
3.3.1 数据库需求分析......................................................................................................5
3.3.2 数据库概念结构......................................................................................................5
3.3.3 数据库逻辑结构设计..............................................................................................6
4 总体设计.........................................................................................................................................7
4.1 系统功能设计......................................................................................................................7
4.2 系统功能图.........................................................................................................................7
4.3 系统功能流程图.................................................................................................................8
5 详细设计和实................................................................................................................................8
5.1 系统页面主体设计.............................................................................................................8
5.2 数据操作类.........................................................................................................................9
5.3 学生界面及其基本功能的实现.......................................................................................12
5.3.1 学生登录................................................................................................................12
5.3.2 个人信息显示........................................................................................................12
5.3.3 网上选课................................................................................................................12
5.3.3 网上评教................................................................................................................14
5.3.4 更改密码和退出....................................................................................................15
5.4 教师页面及基本功能的实现...........................................................................................16
5.4.1 评分查看................................................................................................................16
5.4.2 留言查看................................................................................................................17
5.5 管理员页面及其基本功能的实现...................................................................................18
6 系统测试......................................................................................................................................19
6.1 学生评教功能测试............................................................................................................20
6.2 教师查看评分和留言功能测试........................................................................................20
6.3 管理员统计功能测试.......................................................................................................21
结 论..........................................................................................................................................22
参考文献..........................................................................................................................................22
致 谢..........................................................................................................................................23
声 明..........................................................................................................................................24
