【正文】 計與實現 第 2 頁 共 40 頁 ABSTRACT The online shopping system is a electronic mercial platform which has been designed according to the situation of shop online system based on Inter with B2C mode. The thesis has introduced the practical situation and the developing background of the system firstly. And then has described the designing goal、system needs and the whole designing plan, has described the detailed design and reality of the system in detail. Finally, conclusion has been drawn about the system and problem has also been raised. 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 網上招生錄取 系統(tǒng)設計與實現 第 3 頁 共 40 頁 目 錄 前 言 ................................................................................................... 5 一 概 述 ........................................................................................... 6 系統(tǒng)說 明 ....................................................................................................................... 6 系統(tǒng)特點 ....................................................................................................................... 6 系統(tǒng)功能簡介 ................................................................................................................ 6 基本功能 ............................................................................................................... 6 高級功能 .............................................................................................................. 7 二 開發(fā)環(huán)境介紹 .............................................................................. 7 JSP 簡介 ........................................................................................................................ 7 Struts 構架技術簡介 .......................................................................................................... 9 2． 3 系統(tǒng)數據庫介紹 ........................................................................................................ 12 數據庫的概念 ...................................................................................................... 12 “結構化查詢語言”（ SQL）簡介 ....................................................................... 13 系統(tǒng)運行環(huán)境配置 ......................................................................................................... 14 三 總體設計 ..................................................................................... 14 開 發(fā)背景 ........................................................................................................................ 14 功能分析 ........................................................................................................................ 15 邏輯結構 ............................................................................................................ 16 物理結構 ............................................................................................................ 17 四 數據庫設計 ................................................................................. 17 數據表的介紹 ................................................................................................................. 17 用戶模塊設計概述 .......................................................................................................... 21 系統(tǒng)原理 ............................................................................................................. 21 五 詳細設計 ..................................................................................... 22 管理員 ......................................................................................................................... 22 管理員登錄 ........................................................................................................ 26 添加系統(tǒng)用戶 ..................................................................................................... 28 添加院校 ............................................................................................................ 28 院校信息設置 ..................................................................................................... 29 管理員修改密碼 ................................................................................................. 30 添加考生 ............................................................................................................ 31 院校設置專業(yè) .............................................................................................................. 32 錄取 ................................................................................................................... 33 報表 ................................................................................................................... 34 考生 ............................................................................................................................ 37 考生填報 .....