摘 要
通用题库管理系统是为了适应学校考试制度的改革而设计的，它能够使教考分离，减轻教师工作压力，提高试卷生成效率。本文首先分析了当前试题库系统开发中所存在的问题，由此提出了自己的试题库管理系统的思想。本文共分四章，着重阐述了该系统的设计原则、功能实现以及系统研制过程中遇到的难题和必须解决的关键技术等问题；而且通过介绍题库的建立及各个模块的具体功能，阐述了本系统的实用性。
本系统前台是面向对象的可视化编程工具Visual Basic，后台是 SQL Server 2000数据库。文中介绍了VB和SQL的功能、特点，还着重说明了该系统的特色，例如：在试题操作模块允许教师加题、改题和删题，其中的批量自动加题给老师们带来了极大的方便。
由于毕业设计的时间有限，所以此试题库管理系统中还有许多有待完善的地方，在设计的过程中已经留下了可扩展的空间，而且在文中最后，说明了需完善之处的实现方法。
关键词：试题库管理系统，实用性，关键技术，功能模块，Word
The General Management System of Test Question-bank
Abstract
The general management system of test question-bank is designed in order to be suitable for some schools’ reforms . It can separate teaching from examining, release the pressure of teachers and improve the forming rate of the paper. At the beginning the article analyzed the problems which are in the development of the presently-used test question-bank systems. So I put forward my own thought to the management system of test question-bank. The article is divided into four chapters. Moreover, the article expounds the principle of the system designing , implementation of the system, the key techniques and so on. Furthermore, the utility of the management system of test question-bank is expressed in this article by the establishment of the test question-bank and the functions of all modules.
The foreground of the system is object-oriented tools---Visual Basic and the background is SQL Server 2000.The function and feature of VB and SQL are introduced in the article. What’s more, the article also describes the feature of the system, for example: The teachers can add, modify, delete questions in the questions operation module, especially the adding question automatically in batch offers the convenience to teachers too much.
Because of the limited time, the management system of test question-bank has still some aspects to be perfected. But the writer has kept the space to extend them. In addition, the method to implement those aspects is illustrated at the last of the article.
Keywords: the management system of test question-bank, utility, key techniques, functional module, Word .
目 录
摘要------------------------------------------------I
Abstract-------------------------------------------Ⅱ
绪论------------------------------------------------1
1环境-----------------------------------------------5
2需求分析-------------------------------------------7
2.1调查分析-----------------------------------------7
2.1.1 用户的需要----------------------------------7
2.2 调查分析的结果----------------------------------8
2.2.1 “检索浏览”功能及应用------------------------9
2.2.2 “系统维护”功能及应用------------------------9
2.2.3 “试题操作”功能及应用------------------------9
3 总体设计-----------------------------------------10
3.1系统的功能模块图--------------------------------10
3.2 系统功能描述-----------------------------------10
3.2.1 试题操作模块-------------------------------10
3.2.2 系统维护模块-------------------------------10
3.2.3用户模块------------------------------------10
3.3 数据库设计-------------------------------------12
4 详细设计-----------------------------------------18
4.1 用户模块---------------------------------------18
4.1.1 修改密码-----------------------------------18
4.1.2 退出系统-----------------------------------18
4.2 系统维护模块-----------------------------------18
4.2.1 用户管理-----------------------------------18
4.2.2 新建库-------------------------------------21
4.2.3 修改库-------------------------------------26
4.2.4 删除库 ------------------------------------29
4.2.5 统计库-------------------------------------32
4.3 试题操作模块-----------------------------------36
4.3.1 填加试题-----------------------------------37
4.4.2 修改试题-----------------------------------41
4.4.3 删除试题-----------------------------------46
结论----------------------------------------------49
致谢----------------------------------------------50
参考文献-------------------------------------------51
附录----------------------------------------------52
英文原文-----------------------------------------52
中文译文-----------------------------------------67
