【正文】 基于 B/S 的計(jì)算機(jī)等級考試系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)摘 要隨著計(jì)算機(jī)技術(shù)的發(fā)展及計(jì)算機(jī)的日益普及，基于 B/S 結(jié)構(gòu)的考試系統(tǒng)與無紙化辦公一樣已成為大勢所趨。論文詳細(xì)論述了一個(gè)基于 B/S 結(jié)構(gòu)的計(jì)算機(jī)等級考試系統(tǒng)的設(shè)計(jì)過程。軟件采用 2022 作開發(fā)平臺，C作編程語言，SQL Server 2022 作數(shù)據(jù)庫管理系統(tǒng)，實(shí)現(xiàn)了試題管理、試卷生成、在線考試、試卷評判、權(quán)限管理、在線報(bào)名及站內(nèi)公告等功能。系統(tǒng)符合全國計(jì)算機(jī)等級考試的要求。論文組織如下：首先闡述了該系統(tǒng)的開發(fā)背景、意義；其次介紹了相關(guān)的開發(fā)工具及技術(shù)基礎(chǔ)；接著對系統(tǒng)的需求進(jìn)行了分析，并提出了具體的設(shè)計(jì)方案和數(shù)據(jù)庫模型；然后展現(xiàn)了整個(gè)系統(tǒng)的具體實(shí)現(xiàn)，包括數(shù)據(jù)庫的設(shè)計(jì)和連接，各功能模塊的實(shí)現(xiàn)；最后對該軟件進(jìn)行了嚴(yán)格的測試。關(guān)鍵詞： B/S 結(jié)構(gòu)；計(jì)算機(jī)等級考試；考試系統(tǒng)The Design and Implementation of Computer Rank Examination System based on B/SAbstractWith the development of the puter technology and the popularization of puters, the examination system based on B/S structure has bee the trend of the times the same as the paperless office. The paper discusses in detail the development and design process of a puter rank examination system based on B/S structure. It uses 2022 as the development platform, C as the programming language, SQL Server 2022 as the database management system, and includes test questions management, examination paper production, online examinations, examination paper judgment, authority management, online enrollment and site notice, etc.. It can accord with the requirement of the national puter rank examination.The paper is anized as following: Firstly, analyzes the background and significance。 Secondly, introduces the development tools and the foundation of the technology。 Thirdly, analyses the demand of the system, gives a specific design project and a database model。 Then shows the implementation of the whole system, which includes the design and linkage of the database and the implementation of every module. Finally gives a test of the system.Key words: B/S structure。 Computer rank test。 Examination system目 錄論文總頁數(shù)：31 頁1 引 言 ............................................................................................................................................12 技術(shù)背景 ........................................................................................................................................2 B/S 結(jié)構(gòu) ...................................................................................................................................2 開發(fā)工具簡介 .........................................................................................................................2 Visual C 2022 簡介 .........................................................................................................2 SQL Sever 2022 簡介 .......................................................................................................33 系統(tǒng)分析 .........................................................................................................................................3 需求分析 ..................................................................................................................................3 系統(tǒng)需要解決的主要問題 ...............................................................................................3 系統(tǒng)應(yīng)該具備的基本功能 ...............................................................................................4 可行性分析 ..............................................................................................................................4 技術(shù)可行性分析 ...............................................................................................................4 經(jīng)濟(jì)可行性分析 ..............................................................................................................5 社會(huì)因素方面的可行性分析 ..........................................................................................54 總體設(shè)計(jì) .........................................................................................................................................5 基本設(shè)計(jì)思想及流程圖 .........................................................................................................5 系統(tǒng)功能結(jié)構(gòu)圖 .....................................................................................................................5 系統(tǒng)架構(gòu) .................................................................................................................................6 數(shù)據(jù)訪問層 .......................................................................................................................6 業(yè)務(wù)邏輯層 .......................................................................................................................7 頁面顯示層 .......................................................................................................................7 數(shù)據(jù)庫的設(shè)計(jì) ..........................................................................................................................8 創(chuàng)建數(shù)據(jù)庫 ......................................................................................................................8 創(chuàng)建表 ..............................................................................................................................8 關(guān)系設(shè)計(jì) .........................................................................................................................10 數(shù)據(jù)訪問接口及通用組件 ....................................................................................................10 獲取安全數(shù)據(jù)（GetSafeData） ...................................................................................10 構(gòu)造 SQL 語句（SQLString） ................................................................