【正文】
iency and the improvement of research and management level. This system is a Network Examination System developed by , SQL server 2021 and so on In Windows7 environment with IIS as the application server. The system is achieved by web technology, web technology surpasses the traditional client / server two layer system structure by using the three layer system structure ( B/S ):client / server / database, and online test and automatic scoring can be pleted In the LAN and on the Inter . This paper first introduces the background, development status of work examination system, then the related knowledge and technical support it needs. According to the demand for the subject, demand analysis, detailed analysis of system functional requirements and reasonable division of functions are done, On the basis of objectoriented analysis, Interface design, background design and database design are pleted, besides, module and flow charts of the whole system and subsystem, the ER charts of logical database design and the structure charts of physical design are given. After the system design, the system?s technology and ultimate system realization are described, what?s more, bining with the system?s deficiencies and the direction of development of work examination system, suggestions about system improvements are put forward. Keywords: Network Examination, , SQL server 2021, B/S,C II 河南理工大學(xué)畢業(yè)設(shè)計(jì)(論文)說明書 目錄 1 前言 ............................................................... 1 2 技術(shù)支持 ........................................................... 3 B/S( Browser/Server)模式 ..................................... 3 ....................................................... 4 IIS( Inter Information Services)簡介 ...................... 9 3 系統(tǒng)設(shè)計(jì) .......................................................... 10 需求分析 ..................................................... 10 系統(tǒng)功能分析 ........................................... 11 系統(tǒng)性能分析 ........................................... 12 前臺(tái)設(shè)計(jì) ..................................................... 12 界面設(shè)計(jì)目標(biāo) ........................................... 12 界面設(shè)計(jì)思路 ........................................... 13 后臺(tái)設(shè)計(jì) ..................................................... 13 系統(tǒng)總體設(shè)計(jì) ........................................... 13 子系統(tǒng)設(shè)計(jì) ............................................. 14 公用模塊設(shè)計(jì) ........................................... 23 數(shù)據(jù)庫設(shè)計(jì) ................................................... 24 數(shù)據(jù)庫概念設(shè)計(jì) ......................................... 24 數(shù)據(jù)庫物理結(jié)構(gòu)設(shè)計(jì) ..................................... 27 4 系統(tǒng)實(shí)現(xiàn) .......................................................... 31 系統(tǒng)網(wǎng)絡(luò)實(shí)現(xiàn) ................................................. 31 系統(tǒng)數(shù)據(jù)庫實(shí)現(xiàn) ............................................... 33 系統(tǒng)前臺(tái)實(shí)現(xiàn) ................................................. 36 學(xué)生子系統(tǒng) ............................................. 36 教師子系統(tǒng) ............................................. 39 管理員子系統(tǒng) ........................................... 40 公共模塊 ............................................... 41 系統(tǒng)功能實(shí)現(xiàn) ................................................. 46 III 河南理工大學(xué)畢業(yè)設(shè)計(jì)(論文)說明書 5 小結(jié)與展望 ........................................................ 51 小結(jié) ......................................................... 51 展望 ......................................................... 51 致謝 ................................................................. 53 參考文獻(xiàn) ............................................................. 54 IV 河南理工大學(xué)畢業(yè)設(shè)計(jì)(論文)說明書 1 前