基于CS的多用戶在線考試系統(tǒng)

摘 要
隨著現(xiàn)代教學(xué)改革的深入和計算機信息管理的飛速發(fā)展，教學(xué)的各個方面都向系統(tǒng)化、規(guī)范化、自動化的方向發(fā)展。面對傳統(tǒng)的人工出題不僅費時費力而且效率低的弊端，有必要開發(fā)使用計算機來管理試題并可以自動出題、組卷的軟件系統(tǒng)——試題庫管理系統(tǒng)，以提高教育教學(xué)的工作質(zhì)量，提高教師的工作效率。通過這樣的系統(tǒng)，可以做到試題的規(guī)范管理、科學(xué)出卷、快速查詢，從而減少教師的勞動量，提高教學(xué)的效率和質(zhì)量。
試題庫管理系統(tǒng)是典型的管理信息系統(tǒng)，其系統(tǒng)開發(fā)主要包括數(shù)據(jù)庫的規(guī)劃設(shè)計與維護、客戶端應(yīng)用程序的開發(fā)兩個方面。對于前者建立起的數(shù)據(jù)庫具有完整性和一致性，且具有一定的數(shù)據(jù)安全性，而對于后者則要求程序界面友好、功能完備、容易使用，具有流行軟件的操作習(xí)慣等特點。
試題庫管理系統(tǒng)包括系統(tǒng)管理、試題管理、試卷管理、課程管理等模塊。
利用計算機技術(shù)實現(xiàn)無紙化考試，取代傳統(tǒng)的手工考試方式，是近年來計算機技術(shù)的一個非?；钴S的研究領(lǐng)域。
網(wǎng)絡(luò)考試可實現(xiàn)真正意義上的無紙化考試，不僅是建設(shè)節(jié)約社會的需要，同時網(wǎng)絡(luò)考試還具有快捷、方便、高效、安全等許多優(yōu)點，考試的信度、效度都可大大提高。目前國際上著名的認證考試，如Sun公司的認證考試、Cisco認證考試都采用了這種方式，因此，采用標(biāo)準(zhǔn)化網(wǎng)絡(luò)考試方式將是以后考試發(fā)展的趨勢。
本文利用網(wǎng)絡(luò)技術(shù)和數(shù)據(jù)庫技術(shù)以及.net技術(shù)，開發(fā)了基于C/S的多用戶在線考試系統(tǒng)。該系統(tǒng)使用方便、操作簡單，現(xiàn)階段能實現(xiàn)多用戶同時在線考試時間控制、自動閱卷，試題錄入及修改、用戶管理、成績管理等重要功能，也就實現(xiàn)了無紙化考試，滿足任何授權(quán)的考生隨時隨地考試并迅速獲得成績。
考試系統(tǒng)選用 SQL Server 2000 作為后臺數(shù)據(jù)庫，利用功能強大的visual studio 2005應(yīng)用程序作為網(wǎng)站的開發(fā)軟件，采用的.net技術(shù)使生成動態(tài)交互式Web主頁的工作變得十分簡單。同時對.net、IIS(Internet Information Server)等關(guān)鍵技術(shù)進行了探討。
網(wǎng)站在實現(xiàn)方法上，采用ASP的ADO組件實現(xiàn)網(wǎng)頁與數(shù)據(jù)庫之間的連接，采用字段的匹配實現(xiàn)學(xué)生登錄和教師管理登錄功能，通過數(shù)據(jù)庫語句實現(xiàn)對考生詳細的成績分析與試卷分析的功能。
該系統(tǒng)完成了教學(xué)改革課題設(shè)計要求的任務(wù)，達到了簡化試卷的出、答、改、管理的目的。

關(guān)鍵詞：考試系統(tǒng)，ASP，.NET，試卷生成，數(shù)據(jù)庫，C/S

 
Abstract
With the deepening of modern teaching reform and the rapid development of computer information management， all aspects of teaching develop to the systematic, standardized and automated direction. Faced with the traditional title of not only laborious and time-consuming but also shortcomings of low efficiency, it’s a need to develop the software system ---- Item Management System, which uses computers to manage the test and automatically create test paper to enhance the quality of their work in the education and teaching and their work efficiency. Through such a system, we may be able to manage the test in a standardized way, create a test paper and the volume scientifically, search the test quickly, thus reduce the workforce of teachers and improve the efficiency and quality of teaching.
Item Management System is a typical management information system, whose system development mainly includes two aspects：database planning design and maintenance, the client application development. With regard to the former setting up a database with integrity and consistency, it has a certain degree of data security, while the latter claims a friendly process interface, full function, easy to use and needs a peculiarity of operating the popular software and so on.
Item Management System includes system management, examination questions management, examination paper management, curriculum management, and other modules.
The way that non-paper examination based on computer technology substitutes for tradition manual examination has recently become an active research field.
The network examination can carry out the real meaning of the examination without the paper, not only is a demand that constructs the economy society, at the same time the network examination but also has fast, convenience, efficiently, safety etc. many advantages, examination of reliability, effects can raise consumedly. Currently, the attestation of international last examination, if the attestation of the company of Sun examination, the Cisco attestation examination all adopted this kind of way, therefore, adoption standardize the network examination method will be later the trend of the examination development.
An on-line examination system based on network, database and .net  technology is proposed. The system has the feature of convenient utilization and simple operation, and it realizes the functions such as multi-users on-line examination, time control, automatic paper reading, paper subject inputting and modification, user’s management and score management etc. Take the function of no-paper examination for example, it provides examination for every authorized student and gives the score timely.
This system choose Microsoft SQL Server 2000 as its background database ; powerful Adobe Dreamweaver as the software which is used to develop the web site; The technology ASP adopted by this web site make lovely dynamic interactive. Web home page easier. Finally, this system discusses following key technologies: .net, IIS, (Internet Information Server) etc. 
In point of realizing, make use of ADO package of ASP to connect the web page to the database. Make use of match of the word section to realize student’s log-in and teacher’s management of the log-in function. Make use of SQL sentence to realize the function that can select the test results and the paper detail.
The system accomplishes the assignment of requested teaching reform project and achieves the goal of predigesting exam process.

Key Words: Examination System，ASP，.net，Generation papers，Database，C/S
 
目 錄
前 言 1
1  緒論 2
1.1 課題研究的背景及意義 2
1.1.1 課題研究的背景 2
1.1.2課題研究的意義 3
1.2 在線考試系統(tǒng)的研究現(xiàn)狀 4
2  相關(guān)技術(shù)和理論 7
2.1 ASP技術(shù)介紹 7
2.1.1 ASP的原理 7
2.1.2 ASP的特點 8
2.1.3 ASP的常用內(nèi)建對象 8
2.1.4 ADO組件 10
2.2  ACCESS數(shù)據(jù)庫簡介 11
2.3 開發(fā)工具Dreamweaver8簡介 12
2.4 IIS 12
2.4.1 IIS的特點 12
2.4.2 IIS 的功能 14
2.5 Visual studio 2005 15
2.5.1 visual studio 2005的特點 15
2.5.2 C\S架構(gòu) 16
3  系統(tǒng)可行性分析與需求分析 17
3.1 可行性分析 17
3.2 需求分析 18
4  系統(tǒng)整體設(shè)計 20
4.1系統(tǒng)開發(fā)平臺和開發(fā)工具 20
4.1.1系統(tǒng)平臺 20
4.1.2 Web服務(wù)器平臺 20
4.1.3 應(yīng)用開發(fā)工具 21
4.2 系統(tǒng)功能 23
4.2.1 考生子系統(tǒng)的功能 23
4.2.2 教師子系統(tǒng)的功能 24
4.2.3評分系統(tǒng)功能 24
4.3 數(shù)據(jù)庫設(shè)計 25
4.3.1 數(shù)據(jù)庫設(shè)計概念 25
4.3.2數(shù)據(jù)庫設(shè)計方法及準(zhǔn)則 25
4.3.3 數(shù)據(jù)結(jié)構(gòu)設(shè)計 26
4.4 系統(tǒng)安全機制的研究 27
4.4.1 安全隱患分析 27
4.4.2 提高安全性的方法 28
5  系統(tǒng)詳細設(shè)計及功能介紹 30
5.1 系統(tǒng)流程圖 30
5.2 各模塊分析 31
5.2.1考生登錄模塊 31
5.2.2 教師管理模塊 32
5.2.3 在線考試模塊 34
6 系統(tǒng)測試 36
6.1 測試目標(biāo) 36
6.2 測試方法 36
6.3 測試總結(jié) 37
結(jié) 論 38
致 謝 40
參考文獻 41