摘 要
通用題庫管理系統是為了適應學校考試制度的改革而設計的，它能夠使教考分離，減輕教師工作壓力，提高試卷生成效率。本文首先分析了當前試題庫系統開發中所存在的問題，由此提出了自己的試題庫管理系統的思想。本文共分四章，著重闡述了該系統的設計原則、功能實現以及系統研制過程中遇到的難題和必須解決的關鍵技術等問題；而且通過介紹題庫的建立及各個模塊的具體功能，闡述了本系統的實用性。
本系統前臺是面向對象的可視化編程工具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
