【正文】 1中文題目：《數(shù)據(jù)庫(kù)原理》課程在線考試系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)外文題目：THE DESIGN AND IMPLEMENTATION OF THE ONLINE EXAMINATION SYSTEM FOR THE COURSE OF DATABASE PRINCIPLE畢業(yè)設(shè)計(jì)（論文）共 72 頁(yè)（其中：外文文獻(xiàn)及譯文 15 頁(yè)）完成日期 年 月 答辯日期 年 月2摘 要如今，計(jì)算機(jī)網(wǎng)絡(luò)技術(shù)日益成熟和校園網(wǎng)的普及,為在線考試提供了良好基礎(chǔ)。利用計(jì)算機(jī)以及網(wǎng)絡(luò)技術(shù)實(shí)現(xiàn)考試的信息化,具有傳統(tǒng)考試不可比的優(yōu)點(diǎn)。因此開(kāi)發(fā)適應(yīng)信息時(shí)代的在線考試系統(tǒng)是有必要的。面對(duì)目前形勢(shì),設(shè)計(jì)出基于 B/S 結(jié)構(gòu)在線考試系統(tǒng)。 此在線考試系統(tǒng)分別采用Windows MySQL 作為服務(wù)器端操作系統(tǒng)、后臺(tái)數(shù)據(jù)庫(kù)開(kāi)發(fā)工具；系統(tǒng)體系結(jié)構(gòu)采用B/S 結(jié)構(gòu)；MYECLIPSE 為 B/S 模塊應(yīng)用程序開(kāi)發(fā)工具。實(shí)現(xiàn)教師出卷、學(xué)生考試、教師組卷、教師閱卷、分配教師閱卷等功能。在設(shè)計(jì)中，使用目前流行的 Ajax 技術(shù),提高客戶機(jī)和服務(wù)器間數(shù)據(jù)交換效率以及靈活性。在本系統(tǒng)的開(kāi)發(fā)中，還使用了例如XML、JavaScript 等技術(shù)。 本系統(tǒng)基于 Inter/Intra,將考試工作自動(dòng)化和信息化結(jié)合為一體,來(lái)達(dá)到系統(tǒng)設(shè)計(jì)的基本目標(biāo)和滿足校內(nèi)外，對(duì)考試信息共享、利用的要求。關(guān)鍵詞：在線考試；MySQL；jsp3ABSTRACT Nowadays, the popularization of puter work technology is increasingly mature and campus work, provide a good foundation for online exam. Using the puter and work technology to realize the test information, possesses the advantages of traditional exam than not. So to develop the online examination system of the information age is necessary. In the face of the current situation, design the online examination system based on B/S structure. The online examination system with Windows 7, MySQL as the server operating system, background database development tools。 The system architecture adopts B/S structure。 MYECLIPSE application development tools for B/S module. To achieve volume, exam, teacher group volume, teachers marking, distribution, marking, etc. In the design, the use of currently popular Ajax technology, improve the efficiency of data exchange between the client and the server, and flexibility. In the development of this system, and USES the technology of such as XML, JavaScript, etc. This system based on Inter/Intra, bine examination for automation and information technology as a whole, to achieve the basic purpose of system design and meet facetoface, on the requirement of information sharing and utilization of exam. Key words：The online test；MYSQL；jsp 4目 錄前言 ........................................................................71 項(xiàng)目概述 .................................................................8 研究背景 ...............................................................8 研究現(xiàn)狀 ................................................................8 系統(tǒng)結(jié)構(gòu)及研究?jī)?nèi)容和功能描述 .............................................8 業(yè)務(wù)流程描述 ............................................................10 本系統(tǒng)存在的問(wèn)題和薄弱環(huán)節(jié)分析 .........................................132 可行性分析 ..............................................................14 技術(shù)可行性 .............................................................14 操作可行性 .............................................................14 經(jīng)濟(jì)可行性 .............................................................143 需求分析 ................................................................15 總體目標(biāo) ...............................................................15 具體目標(biāo) ...............................................................15 系統(tǒng)功能建模 ...........................................................15 系統(tǒng)數(shù)據(jù)流程圖 ......................................................15 數(shù)據(jù)字典 ............................................................19 系統(tǒng)數(shù)據(jù)模型 ...........................................................214 概要設(shè)計(jì) ................................................................24 體系結(jié)構(gòu)設(shè)計(jì) ...........................................................24 外部接口 ............................................................24 內(nèi)部接口 ............................................................25 代碼設(shè)計(jì) ...............................................................25 代碼設(shè)計(jì)原則 ........................................................25 數(shù)據(jù)庫(kù)設(shè)計(jì) .............................................................26 數(shù)據(jù)庫(kù)設(shè)計(jì)原則 ......................................................26 關(guān)系模式設(shè)計(jì) ........................................................27 數(shù)據(jù)字典 ............................................................2755 輸入輸出設(shè)計(jì) ...........................................................29 輸入設(shè)計(jì) ............................................................29 輸出設(shè)計(jì) ............................................................30 運(yùn)行設(shè)計(jì) ...............................................................31 運(yùn)行環(huán)境 ............................................................31 運(yùn)行模塊的組合 ......................................................31 運(yùn)行控制 ............................................................31 運(yùn)行時(shí)間 ............................................................31 出錯(cuò)處理設(shè)計(jì) ...........................................................31 出錯(cuò)輸出信息 ........................................................31 出錯(cuò)處理對(duì)策 ........................................................32 安全保密設(shè)計(jì) ...........................................................32 數(shù)據(jù)安全性 ..........................................................32 登錄管理員的安全性 ..................................................32 維護(hù)設(shè)計(jì) ...............................................................325 詳細(xì)設(shè)計(jì) ................................................................33 老師登錄模塊定義 .......................................................33 模塊定義 ............................................................33 輸入項(xiàng) ..............................................................33 限制條件 ............................................................33 測(cè)試要點(diǎn) ............................................................33 學(xué)生登陸模塊 ............................................................33 模塊定義 ............................................................33 輸入項(xiàng) ..............................................................33 輸出項(xiàng) ..............................................................34 限制條件 ............................................................34 測(cè)試要點(diǎn) ......