摘  要
考試管理工作中，從組織出卷到試卷的印制及試卷的管理等工作非常繁瑣且工作量很大，更重要的是試卷的標(biāo)準(zhǔn)化程度、難易程度、題量大小等各方面難以控制，難以形成有效的試題庫，不利于充分發(fā)揮歷年來的優(yōu)秀試題的作用。鑒于這種情況，試題庫自動生成系統(tǒng)就顯得尤為必要。
本文首先分析了當(dāng)前試題庫系統(tǒng)開發(fā)中所存在的問題，接著提出了自己的試題庫管理系統(tǒng)的思想，著重闡述了該系統(tǒng)的設(shè)計原則、功能實現(xiàn)以及系統(tǒng)研制過程中遇到的難題和必須解決的關(guān)鍵技術(shù)等問題，而且通過介紹題庫的建立及各個模塊的具體功能，闡述了本系統(tǒng)的實用性。
本系統(tǒng)是用JSP在網(wǎng)絡(luò)上架構(gòu)一個動態(tài)的網(wǎng)站，它是在Windows XP下，以SQL Server 2005為數(shù)據(jù)庫開發(fā)平臺，Tomcat網(wǎng)絡(luò)信息服務(wù)作為應(yīng)用服務(wù)器，采用JSP(Java Server Pages)技術(shù)開發(fā)的網(wǎng)上試題庫系統(tǒng)。他分前臺部分和后臺部分，前臺部分由用戶使用，主要包括用戶注冊，添加試題，隨機生成所需要的類型(試題的屬性和題量)的試題，留言板留言等功能；后臺部分由管理員使用，主要包括管理員注冊，添加專業(yè)，刪除專業(yè)，添加科目，刪除科目，為科目添加試題類型，刪除用戶，留言板留言和管理等功能。
本系統(tǒng)開發(fā)過程引入軟件工程的思想，測試結(jié)果表明該系統(tǒng)運行良好，功能較為完善。能夠初步滿足按照教師需求自動生成試卷的要求。

關(guān)鍵詞：試題生成；試題庫系統(tǒng)；JSP；SQL Sever；試題自動隨機生成
 
ABSTRACT
In the examination management, work such as printing and management of the paper are very tedious and the work load is very large, the more important is the standardized intensity of the paper, complexity, question amount size, etc. are difficult to control, it is difficult to form effective trying the question-bank, it is unfavorable to fully giving play to the role of outstanding examination question over the years. In the view of this kind of situation, the management system of test question-bank seems particularly essential.
At the beginning the article analyzed the problems which are in the development of the presently-used test question-bank systems, so next I put forward my own thought to the management system of test question-bank, 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 system is trying to use JSP in a dynamic network of e-commerce websites structure, which is in Windows XP, SQL Server 2005 for database development in platform, Tomcat application server as a network information services, use JSP (Java Server Pages) technology development online question manager system. Prospects and the background of some of his hours, the prospects of users, including users registered, add question, Produce question at random, give message on the message board function; the prospects of users, including manager register, add professional, delete professional, add subject, delete subject, add question type, delete user, give message and manage the message board function.
This system introduce the thought of the soft project in the course of the development, the test result indicates that this system running is well, the function is comparatively complete. It can satisfy the requirement that producing the paper automatically according the teacher’s demand.

Key Words: Produce Questions; Question System; JSP; SQL Sever; Produce Question at random
目  錄
1 緒論 1
1.1 本課題研究的背景 1
1.2 現(xiàn)行狀況綜述 1
1.3 系統(tǒng)設(shè)計思想 2
1.4 課題主要研究的意義 3
2 系統(tǒng)開發(fā)環(huán)境和工具及可行性分析 4
2.1 系統(tǒng)開發(fā)環(huán)境及工具介紹 4
2.1.1硬軟件環(huán)境 4
2.1.2 JSP技術(shù)原理 4
2.1.3 SQL Server 2005 5
2.1.4 HTML 7
2.1.5 JDK 7
2.1.6 Eclipse 8
2.1.7數(shù)據(jù)庫的連接 8
2.2 系統(tǒng)開發(fā)環(huán)境搭建技術(shù)介紹 9
2.2.1 JDK安裝與配置 9
2.2.2 Tomcat5.0服務(wù)器安裝與配置 10
2.2.3 Tomcat連接池連接SQL Server 2005 Express 10
2.2.4在Eclipse中用JDBC連接SQL Server 2005 11
2.3 可行性分析 12
3 系統(tǒng)需求分析 14
3.1 系統(tǒng)要求概述 14
3.2 系統(tǒng)基本要求 14
3.3 系統(tǒng)功能模塊論述 15
3.3.1 系統(tǒng)登錄模塊 15
3.3.2 注冊模塊 16
3.3.3 用戶模塊 16
3.3.4 管理員模塊 17
4 系統(tǒng)總體設(shè)計 18
4.1 系統(tǒng)詳細(xì)流程設(shè)計 18
4.1.1 登錄流程 18
4.1.2 用戶流程 19
4.1.3 管理員流程 20
4.2 數(shù)據(jù)流程設(shè)計 26
4.3 業(yè)務(wù)流程設(shè)計 28
5 系統(tǒng)詳細(xì)設(shè)計與功能實現(xiàn) 29
5.1 數(shù)據(jù)庫的設(shè)計 29
5.1.1 數(shù)據(jù)庫約束 29
5.1.2 數(shù)據(jù)庫的實現(xiàn) 29
5.1.3 配置SQL Server 2005 31
5.2 系統(tǒng)界面的實現(xiàn) 32
5.2.1 登錄頁面 32
5.2.2 用戶界面 32
5.2.3 管理員界面 37
5.3 功能實現(xiàn)設(shè)計 42
5.3.1 系統(tǒng)登錄功能的實現(xiàn) 42
5.3.2 留言板功能的實現(xiàn) 45
5.3.3 注冊功能的實現(xiàn) 46
5.3.4 用戶功能的實現(xiàn) 46
5.3.5 管理員功能的實現(xiàn) 48
6 系統(tǒng)測試 52
6.1 測試目的 52
6.2 測試方法 53
6.3 測試過程 55
6.3.1 登錄模塊的測試 55
6.3.2 添加試題模塊的測試 55
6.3.3 生成試題模塊的測試 55
6.3.4 刪除用戶模塊的測試 55
6.3.5 瀏覽器刷新按鈕的測試 56
7 總結(jié)和展望 57
致謝 58
參考文獻(xiàn) 59