摘 要

網(wǎng)絡(luò)使用的日益廣泛，使得人們對網(wǎng)站的質(zhì)量的要求越來越高。人們想要看到的網(wǎng)站已不再是文字和圖片的簡單組合，而需要網(wǎng)頁的具有審美、使用價(jià)值的同時(shí)網(wǎng)頁之間可以更完美的交互，這就給網(wǎng)站設(shè)計(jì)者帶來很大的挑戰(zhàn)
在線考試系統(tǒng)是學(xué)生學(xué)習(xí)過程中的一個(gè)輔助工具，基于Internet或者局域網(wǎng)，其主要功能是實(shí)現(xiàn)學(xué)生在學(xué)習(xí)過程中通過本系統(tǒng)對課程進(jìn)行各個(gè)章節(jié)的綜合測試和評分，以檢驗(yàn)學(xué)習(xí)效果。管理員利用本系統(tǒng)可以進(jìn)行試卷的測試。同時(shí)系統(tǒng)能過進(jìn)行分?jǐn)?shù)的統(tǒng)計(jì)以及成績的查詢，為學(xué)生及教師在學(xué)習(xí)過程中提供幫助。在線考試系統(tǒng)旨在實(shí)現(xiàn)考試的無紙化管理，對一些科目的考試可以通過互聯(lián)在線或局域網(wǎng)進(jìn)行，方便校方考務(wù)的管理，也方便了考生，尤其適在線考試系統(tǒng)旨在實(shí)現(xiàn)考試的無紙化管理，對一些科目的考試可以通過互聯(lián)在線或局域網(wǎng)進(jìn)行，方便校方考務(wù)的管理，也方便了考生。線考試系統(tǒng)（NES）是使用servlet +jsp+bean開發(fā)的一個(gè)基于Web的在線考試平臺.該考試平臺包含了考生考試，用戶管理，考試管理，試卷管理，題庫管理等多個(gè)功能，主要注重過程控制和考試檔案的管理。定位于節(jié)省考試過程中的成本，方便企業(yè)對考試工作的管理。其B/S的模式使之更容易部署推廣及方便的使用。

關(guān)鍵字：jsp；servlet；在線考試系統(tǒng)

Online examination system

Abstact

The network increasingly widely used, making it the quality of the site have become increasingly demanding. People want to see the site is no longer a simple combination of words and pictures, and aesthetic needs of the page, between the value of the same web page could be more perfect interaction, which gives web designers a great deal of challenge .
Online examination system is a learning process support tool, based on the Internet or local area network, its main function is to achieve the students in the learning process through the system in all sections of the curriculum for the comprehensive test, to test learning. The system administrator can use the test papers.At the same time the system can be made for a fraction of the statistics and the results of the inquiry, for students and teachers to assist in the learning process. Online examination system to achieve paperless management of examinations, the examination for some courses online through the Internet or LAN, to facilitate the management of the school Examination, candidates are also convenient, especially suitable for online examination system designed to achieve the non-test paper management, the examination of some subjects can be online or LAN through the Internet to facilitate the management of the school Examination, candidates are also convenient.
Online examination system (NES) is that one using servlet+jsp+bean to develop is based on Web to have an examination in the platform online, the goal is examined for the first time for the recruitment talents of the company. Having it's time for and had an examination the platform and included examinee's having an examination, users manage, manage in examination, the paper is managed, a lot of functions that the exam pool is managed,etc., pay attention to the course and control and have an examination the management of the file mainly. Orientate as sparingly the cost in the examination course, facilitate the control over work about test of enterprises. Its B/S's mode makes it apter to dispose popularizing and convenient use.

Key Words：jsp；servlet； Online Exam

目 錄
基于JSP的網(wǎng)上在線考試系統(tǒng)的設(shè)計(jì) 1
摘 要 1
ABSTACT 2
緒 論 7
1. 系統(tǒng)開發(fā)背景及意義 8
1.1系統(tǒng)開發(fā)背景 8
1.2系統(tǒng)開發(fā)意義 8
2. 網(wǎng)上考試系統(tǒng)需求分析 9
2.1現(xiàn)狀分析 9
2.2可行性分析 10
2.2.1經(jīng)濟(jì)可行性 10
2.2.2技術(shù)可行性 10
2.3設(shè)計(jì)目標(biāo) 11
2.4功能要求 11
2.5系統(tǒng)開發(fā)環(huán)境配置 12
2.6系統(tǒng)開發(fā)工具 12
2.6.1開發(fā)技術(shù)—JSP（Java Server Page） 12
2.6.2數(shù)據(jù)庫—SQLServer 2000 13
2.7小結(jié) 14
3. 網(wǎng)上考試系統(tǒng)設(shè)計(jì) 15
3.1數(shù)據(jù)庫設(shè)計(jì) 15
3.1.1數(shù)據(jù)庫需求分析 15
3.1.2數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) 16
3.2系統(tǒng)結(jié)構(gòu)設(shè)計(jì) 22
3.2.1頁面模塊化設(shè)計(jì) 23
3.2.2 MVC模式設(shè)計(jì)（Jsp+Servlet+JavaBean） 24
3.3小結(jié) 24
4. 網(wǎng)上考試系統(tǒng)實(shí)現(xiàn) 25
4.1系統(tǒng)各部分的實(shí)現(xiàn)方法 25
4.1.1建立JDBC-ODBC橋接器 25
4.1.2創(chuàng)建ODBC數(shù)據(jù)源 25
4.1.3和ODBC數(shù)據(jù)源制定的數(shù)據(jù)庫建立連接 25
4.1.3用戶及管理員登錄模塊頁面 26
4.1.4系統(tǒng)主要模塊頁面 29
4.1.5學(xué)生考試模塊的實(shí)現(xiàn)頁面 30
4.1.6教師添加試題制作試卷模塊的實(shí)現(xiàn) 37
4.2小結(jié) 41
5. 系統(tǒng)測試 43
5.1什么是軟件測試 43
5.2軟件測試的目標(biāo)與方法 43
5.3系統(tǒng)的不足和展望 44
5.4小結(jié) 44
結(jié) 論 45
致 謝 46
參考文獻(xiàn) 47
附錄1 外文參考文獻(xiàn)（譯文） 49
附錄2 外文參考文獻(xiàn)（原文） 52