【正文】 ...............................2 系統(tǒng)硬件環(huán)境 .......................................................................................................................2第 2 章 系統(tǒng)分析 .....................................................................................................................................3 需求分析 .........................................................................................................................................3 技術(shù)分析 .........................................................................................................................................3 基于 Web 的數(shù)據(jù)庫(kù)技術(shù) .......................................................................................................3 Web 數(shù)據(jù)庫(kù)管理系統(tǒng) ............................................................................................................7 綜合技術(shù)分析 .....................................................................................................................11第 3 章 項(xiàng)目設(shè)計(jì) ...................................................................................................................................16 系統(tǒng)總體結(jié)構(gòu)設(shè)計(jì) .......................................................................................................................16 總體功能結(jié)構(gòu)圖 ...................................................................................................................17 各功能模塊說(shuō)明 ...................................................................................................................17 關(guān)鍵技術(shù) .......................................................................................................................................18 頁(yè)面利用表格產(chǎn)生分欄效果 ...............................................................................................19 單獨(dú)存放公用代碼 ...............................................................................................................20 采用 javascript 語(yǔ)言作為輔助開(kāi)發(fā)語(yǔ)言 .............................................................................20 詳盡的檢索功能 ...................................................................................................................20 用戶控制 ...............................................................................................................................21 數(shù)據(jù)庫(kù)設(shè)計(jì) ...........................................................................................................................22 數(shù)據(jù)庫(kù)設(shè)計(jì) ...................................................................................................................................22 數(shù)據(jù)庫(kù)表結(jié)構(gòu) .......................................................................................................................22 表間關(guān)系 ...............................................................................................................................26 系統(tǒng) ER 圖 ...........................................................................................................................27 交互式頁(yè)面設(shè)計(jì) ...........................................................................................................................29 頁(yè)面主體框架設(shè)計(jì) ...............................................................................................................29 各權(quán)限用戶的頁(yè)面設(shè)計(jì) .......................................................................................................30 3 交互式頁(yè)面調(diào)用、包含關(guān)系 ...............................................................................................30第 4 章 項(xiàng)目的實(shí)現(xiàn) ...............................................................................................................................33 LOGO 和 BANNER.........................................................................................................................33 界面的實(shí)現(xiàn) ...................................................................................................................................33 設(shè)置服務(wù)器 ...................................................................................................................................34 IIS 服務(wù)器設(shè)置 ......................................................................................................................34 SQL Server 配置 ....................................................................................................................39 交互式頁(yè)面的實(shí)現(xiàn) .......................................................................................................................47 培訓(xùn)班管理頁(yè)面 實(shí)現(xiàn) ...........................................................................................................47 學(xué)員培訓(xùn)情況頁(yè)面 實(shí)現(xiàn) .......................................................................................................58 系統(tǒng)公共函數(shù)代碼實(shí)現(xiàn) .......................................................................................................59 系統(tǒng)安裝過(guò)程 ...............................................................................................................................62 系統(tǒng)運(yùn)行過(guò)程 ...............................................................................................................................62第 5 章 調(diào)試與優(yōu)化 ...............................................................................................................................63 調(diào)試 ...............................................................................................................................................63 調(diào)試環(huán)境及方法 ...................................................................................................................63 問(wèn)題分析 .......................................................................................................................................63 源代碼的安全隱患 ...............................................................................................................63 程序設(shè)計(jì)中的安全隱患 .......................................................................................................63 優(yōu)化方案 ...................................................................................................................................