【正文】 This thesis introduces a virtual shopping system that is developed by JSP shopping system is divided into foreground management system and the background management this system, these two aspects to achieve the following functions: membership registration、 shopping car management、 goods searching、 information modify etc. It has also provided managers with goods management 、 customer information management 、 news management 、 order management and so on. The total bargaining is achieved by the the foreground management system and the background management system. It is designed with B/S mode of threelevel structure, and used JSP technology in dynamic page design. Considering from the security and reusing code of the system, key codes has been secured by JavaBean technology. SQL Server2021 database has been used as the background database. Key Words:JSP； B/S structure； JavaBean； SQL Server2021 網(wǎng)上招生錄取 系統(tǒng)設(shè)計與實現(xiàn) 第 3 頁 共 40 頁 目 錄 前 言 ................................................................................................... 5 一 概 述 ........................................................................................... 6 系統(tǒng)說 明 ....................................................................................................................... 6 系統(tǒng)特點 ....................................................................................................................... 6 系統(tǒng)功能簡介 ................................................................................................................ 6 基本功能 ............................................................................................................... 6 高級功能 .............................................................................................................. 7 二 開發(fā)環(huán)境介紹 .............................................................................. 7 JSP 簡介 ........................................................................................................................ 7 Struts 構(gòu)架技術(shù)簡介 .......................................................................................................... 9 2． 3 系統(tǒng)數(shù)據(jù)庫介紹 ........................................................................................................ 12 數(shù)據(jù)庫的概念 ...................................................................................................... 12 “結(jié)構(gòu)化查詢語言”（ SQL）簡介 ....................................................................... 13 系統(tǒng)運行環(huán)境配置 ......................................................................................................... 14 三 總體設(shè)計 ..................................................................................... 14 開 發(fā)背景 ........................................................................................................................ 14 功能分析 ........................................................................................................................ 15 邏輯結(jié)構(gòu) ............................................................................................................ 16 物理結(jié)構(gòu) ............................................................................................................ 17 四 數(shù)據(jù)庫設(shè)計 ................................................................................. 17 數(shù)據(jù)表的介紹 ................................................................................................................. 17 用戶模塊設(shè)計概述 .......................................................................................................... 21 系統(tǒng)原理 ............................................................................................................. 21 五 詳細設(shè)計 ..................................................................................... 22 管理員 ......................................................................................................................... 22 管理員登錄 ........................................................................................................ 26 添加系統(tǒng)用戶 ..................................................................................................... 28 添加院校 ............................................................................................................ 28 院校信息設(shè)置 ..................................................................................................... 29 管理員修改密碼 ................................................................................................. 30 添加考生 ............................................................................................................ 31 院校設(shè)置專業(yè) .............................................................................................................. 32 錄取 ................................................................................................................... 33 報表 ................................................................................................................... 34 考生 ............................................................................................................................ 37 考生填報 ............................................................................................................ 37 網(wǎng)上招生錄取 系統(tǒng)設(shè)計與實現(xiàn) 第 4 頁 共 40 頁 } .................................................................................................................................. 38 六 總 結(jié) ........................................................................................... 38 參考文獻 ............................................................................................. 39 致 謝 .............................................................