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

關(guān)鍵詞：試題生成；試題庫(kù)系統(tǒng)；JSP；SQL Sever；試題自動(dòng)隨機(jī)生成
 
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è)計(jì)思想 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ù)庫(kù)的連接 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 注冊(cè)模塊 16
3.3.3 用戶模塊 16
3.3.4 管理員模塊 17
4 系統(tǒng)總體設(shè)計(jì) 18
4.1 系統(tǒng)詳細(xì)流程設(shè)計(jì) 18
4.1.1 登錄流程 18
4.1.2 用戶流程 19
4.1.3 管理員流程 20
4.2 數(shù)據(jù)流程設(shè)計(jì) 26
4.3 業(yè)務(wù)流程設(shè)計(jì) 28
5 系統(tǒng)詳細(xì)設(shè)計(jì)與功能實(shí)現(xiàn) 29
5.1 數(shù)據(jù)庫(kù)的設(shè)計(jì) 29
5.1.1 數(shù)據(jù)庫(kù)約束 29
5.1.2 數(shù)據(jù)庫(kù)的實(shí)現(xiàn) 29
5.1.3 配置SQL Server 2005 31
5.2 系統(tǒng)界面的實(shí)現(xiàn) 32
5.2.1 登錄頁(yè)面 32
5.2.2 用戶界面 32
5.2.3 管理員界面 37
5.3 功能實(shí)現(xiàn)設(shè)計(jì) 42
5.3.1 系統(tǒng)登錄功能的實(shí)現(xiàn) 42
5.3.2 留言板功能的實(shí)現(xiàn) 45
5.3.3 注冊(cè)功能的實(shí)現(xiàn) 46
5.3.4 用戶功能的實(shí)現(xiàn) 46
5.3.5 管理員功能的實(shí)現(xiàn) 48
6 系統(tǒng)測(cè)試 52
6.1 測(cè)試目的 52
6.2 測(cè)試方法 53
6.3 測(cè)試過(guò)程 55
6.3.1 登錄模塊的測(cè)試 55
6.3.2 添加試題模塊的測(cè)試 55
6.3.3 生成試題模塊的測(cè)試 55
6.3.4 刪除用戶模塊的測(cè)試 55
6.3.5 瀏覽器刷新按鈕的測(cè)試 56
7 總結(jié)和展望 57
致謝 58
參考文獻(xiàn) 59