【正文】 nowadays bee the trend that Web uses gradually users more thoughtful and more humanized service after offering to the masses of work, and the shopping website is exactly this kind of concrete form of expression of moving about. Although the development of online shopping in our country is not so good as America and Europe, nowadays develop quickly, emerge constantly, have relatively on behalf of if eBay E, taobao, 1pai,etc. With Inter popularization and emerce of our country ripe being, there are bigger and bigger consumption colonies。 網(wǎng)絡(luò)購物系統(tǒng)的完善和便捷將是 現(xiàn)代社會必然的需求。對網(wǎng)絡(luò)銷售系統(tǒng)不合時宜的設(shè)計，不僅無助于問題的解決，而且會耽誤商機，使自己處于被動地位。與傳統(tǒng) C/S相比， B/S更具優(yōu)勢（如客戶端無須安裝軟件等）。 網(wǎng)上購物在我國的發(fā) 展雖不如歐美，但當今發(fā)展很快，眾多網(wǎng)上購物網(wǎng)站不斷涌現(xiàn)，較有代表的如 eBay易趣、taobao 淘寶、 1pai雅虎新浪一拍等。 畢業(yè)設(shè)計說明書 基于 JSP的在線書店銷售系統(tǒng)的設(shè)計與實現(xiàn) 專業(yè) 學生姓名 班級 學號 指導教師 完成日期 本科生畢業(yè)設(shè)計說明書（ 2021） 基于 JSP的在線書店銷售系統(tǒng)的設(shè)計與實現(xiàn) 摘要： 21世紀，隨著計算機科學技術(shù)的發(fā)展， 貿(mào)易的全球化和網(wǎng)絡(luò)的全球化兩大特征走到了一起，形成了如今風靡全球的電子商務(wù)。 電子商務(wù)在 Inter 中的應(yīng)用越來越廣泛，為廣大網(wǎng)絡(luò)用戶提供了更加周到和人性化的服務(wù)已逐漸成為當今 Web 應(yīng)用的潮流， 而購物網(wǎng)站正是這種活動的具體表現(xiàn)形式。 隨著我國互聯(lián)網(wǎng)的更加普及和電子商務(wù)的日趨成熟，會有越來越大的消費群體，市場潛力會得到充分發(fā)揮。合理規(guī)劃和設(shè)計 B/S 模式的電子商務(wù)網(wǎng)站，直接關(guān)系到網(wǎng)絡(luò)銷售系統(tǒng)的運行效率，以及消費者的興趣。臨淵羨魚，不如退而結(jié)網(wǎng)。 任務(wù)書研究了基于 JSP 技術(shù)和 SQL Server 數(shù)據(jù)庫開發(fā)網(wǎng)絡(luò)圖書銷售系統(tǒng)的全過程。 the market potential will be given full play to. Compared with traditional C/S, B/S has even more advantages (such as needn39。 interest directly. The unseasonable design to the marketing system of the work is not only helpless to the settlement of the problem, but alse delay the business opportunity, will make oneself in the passive position. It39。s inevitable demands. This text has studied the whole course of books marketing system of work on the basis of JSP technology and SQL Server database. Key words： Emerce。 ASP 本科生畢業(yè)設(shè)計說明書（ 2021） 目 錄 1 概 述 .................................................................................................................................. 1 課題背景 ..............................................................................................................1 課題研究的意義和現(xiàn)狀 .......................................................................................1 課題的系統(tǒng)概述 ...................................................................................................2 2 在線書店銷售系統(tǒng)的相關(guān)技術(shù)介紹 .............................................................................. 3 BROWSER/SERVER 結(jié)構(gòu) ................................................................................................3 三層結(jié)構(gòu) ............................................................................................................4 JSP 的運作模式 ....................................................................................................4 SQL SERVER 2021 簡介 ...........................................................................................5 3 基于 JSP的在線書店銷售系統(tǒng)的設(shè)計 .......................................................................... 5 需求分析 ...............................................................................................................5 系統(tǒng)需要解決的主要問題 ................................................................................5 系統(tǒng)開發(fā)環(huán)境 ....................................................................................................6 系統(tǒng)具備的功能 ...................................................................................................6 用例模型 ...............................................................................................................6 用戶 USE CASE圖 ...............................................................................................6 管理員 USE CASE圖 ...........................................................................................7 書店銷售系統(tǒng) ER 圖 ........................................................................................7 數(shù)據(jù)庫的設(shè)計與實現(xiàn) ...........................................................................................8 數(shù)據(jù)庫的需求分析 ............................................................................................8 數(shù)據(jù)庫的邏輯設(shè)計 ............................................................................................8 數(shù)據(jù)庫的結(jié)構(gòu)創(chuàng)建 ..............................................................................................9 4 基于 JSP 的在線書店銷售系統(tǒng)的實現(xiàn) ......................................................................... 12 后臺系統(tǒng)和數(shù)據(jù)庫的配置 .................................................................................12 后臺服務(wù)器配置 ..............................................................................................12 后臺數(shù)據(jù)庫的配置 ..........................................................................................12 后臺全局配置文件 ..........................................................................................12 前端網(wǎng)絡(luò)頁面的開發(fā)與設(shè)計 ............................................................................13 用戶注冊網(wǎng)頁 ..................................................................................................13 用戶登錄頁面 ..................................................................................................17 管理員操作頁面 ..............................................................................................18 用戶購物操作 ..................................................................................................20 管理員管理頁面 ..............................................................................................23 個人資料修改頁面 ..........................................................................................24 5 系統(tǒng)測試 ......................................................................................................................... 26 軟件測試的目的和原則 ....................................................................................26 測試的方法 .................................................................................................