1、 I 摘 要 数据库技术教学网站设计与实现考试系统是一套基于 B/S 体系， 采用大型数据库 SQL Server2000 和先进的 ASP 技术开发的，以组织客观、公 正、科学合理和大规模考试为目的的标准化考试系统。 系统从功能上主要分为两个部分：前台主要用于考生在线考试和查询成绩； 后台主要用于管理员对考试信息、专业信息等进行管理。其中前台部分，考生要 根据分配的编号和密码进行登录，如果密码正确则允许登录，否则拒绝登录。登 录后选择考试课程和套题进行在线考试，同时启动计时器。如果没有在规定时间 内交卷系统会强制提交。交卷后可以查看成绩单。后台部分，管理员在身份验证 后登录，可以对管理员信息
2、、学生信息、专业信息、课程信息、套题信息、考试 成绩信息、考试题目信息等进行增加、删除、修改、查询的操作与管理。 全文根据系统的设计要求主要介绍了系统开发的背景与意义，需求分析，系 统开发所应用的技术，数据库设计，模块设计与实现等。同时还对系统进行了测 试说明并加以总结。 关键词：考试系统；ASP；SQL Server；B/S；ODBC II Abstract The design and the realization of the teaching website of -test system is a set of standardization test system based o
3、n B/S system and developed by adapting SQL Server 2000 and advanced ASP technology, and aimed to organize objective, fair, scientific and reasonable and the large-scale test as the goal standardized test system. The system can be divided into two main parts of functionality: the interface is mainly
4、used to take the examination and check the grade for examiner; the background is used to manage the examination information and the professional information for the manager. On the interface, the examiner will type in his given serial number and password, if the password is correct then the examiner
5、 can be allowed to enter; otherwise, he will be refused. After entering, the examiner can choose a test course and a test paper then at that time the Chronoscope starts up. If the examiner cannot hand over the paper within the stipulated time period, the system will forcibly hand it over. The grade
6、list can be checked after handing over the test paper. On the background part, the administrator can proceed in operating and managing, such as add, delete, correct, and check administrator information, student information, profession information, course information, test paper information, examination grade information and exam topic information. The full text mainly introduced the system development background and the significance according to the system design request，the demand analys
