【正文】 基于網(wǎng)絡(luò)超市商品銷售管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 摘 要 隨著互聯(lián)網(wǎng)日益深入我們的生活，網(wǎng)上商品銷售的方式也逐漸被人們所接受，因而集成銷售管理功能的網(wǎng)上銷售系統(tǒng)也顯得更加重要而實(shí)用。鑒于此，本課題設(shè)計(jì)了基于網(wǎng)絡(luò)超市的商品銷售管理系統(tǒng)。首先，論文簡單介紹了商品銷售管理系統(tǒng)的產(chǎn)生、發(fā)展和現(xiàn)狀；然后對(duì)本系統(tǒng)使用的幾項(xiàng)關(guān)鍵技術(shù)做了介紹；最后用軟件工程的分析方法從系統(tǒng)需求分析、系統(tǒng)設(shè)計(jì)、數(shù)據(jù)庫設(shè)計(jì)、系統(tǒng)實(shí)現(xiàn)等幾個(gè)方面對(duì)整個(gè)系統(tǒng)進(jìn)行了闡述。同時(shí)對(duì)系統(tǒng)的功能，包括商品目錄顯示、用戶注冊(cè)、用戶登錄、購物車、定單查詢、系統(tǒng)維護(hù)管理 等功能模塊進(jìn)行了實(shí)現(xiàn)。本系統(tǒng)主要運(yùn)用了 HTML、 JSP 編程技術(shù)與 SQL Server 數(shù)據(jù)庫等關(guān)鍵技術(shù)進(jìn)行設(shè)計(jì)、實(shí)現(xiàn)。設(shè)計(jì)中使用頁面模塊化思想，并部分采用三層架構(gòu)思想，使用 JavaBean 完成對(duì)數(shù)據(jù)庫的操作，對(duì)銷售管理、系統(tǒng)維護(hù)部分使用 Servlet 技術(shù)實(shí)現(xiàn)。當(dāng)然系統(tǒng)還存在許多不足之處有待改進(jìn)，特別是安全方面的問題還沒有很好的考慮和實(shí)現(xiàn)。 關(guān)鍵詞： 網(wǎng)絡(luò)超市；管理系統(tǒng)； JSP； JavaBean； Servlet The Design and Implement of the System of Trade and Management of Products based on Online Supermarket Abstract As the close link of Inter with our lives, the online trading has been accepted by people gradually. So the online integrating system of trade and management bees very important and useful. Therefore, this project designs the system of trade and management of products based on online supermarket. At the beginning, the paper introduces the origin, development and the current situation of the system of trade and management of products briefly. Then it describes some key technologies simply being used by the system. Finally, the system has been analyzed from several aspects, such as the analysis of requirement, designs of the whole system, database design and the implementation of system by using the methods of software engineering. Meanwhile, this project implements the functions which the system requires, including the catalogs, user registration, user login, shopping cart, order inquiry, maintenance and management of system and so on. The system builds this online shopping system based on HTML, JSP and SQL Server database. In the process of designing system, the thinking of modularization of pages and threelayer structure is adopted in the project. The operation of database is made by using JavaBean. Servlets are used to achieve some parts of the system, such as the trade management and system maintenance. But lots of improvements should be made for this system, especially the security issue which is not solved properly. Key words: Online Supermarket。 Management system。 JSP。 JavaBean。 Servlet 目 錄 論文總頁數(shù) ： 32 頁 1 引言 ...................................................................................................................... 1 選題背景 ..................................................................................................... 1 國內(nèi)外發(fā)展現(xiàn)狀 ........................................................................................... 1 本課題的研究內(nèi)容及方法 ............................................................................. 2 2 技術(shù)理論基礎(chǔ)及開發(fā)平臺(tái) ....................................................................................... 3 技術(shù)理論基礎(chǔ) ............................................................................................. 3 HTML 語言 ....................................................................................... 3 JSP 技術(shù) ............................................................................................ 4 SQL Server 數(shù)據(jù)庫 ............................................................................. 5 開發(fā)平臺(tái) .................................................................................................... 5 簡介 ................................................................................................. 5 特點(diǎn) ................................................................................................. 6 3 需求分析與設(shè)計(jì)方案 .............................................................................................. 6 需求分析 .................................................................................................... 6 需求背景 .......................................................................................... 6 可行性分析 ...................................................................................... 7 設(shè)計(jì)方案 .................................................................................................... 8 設(shè)計(jì)目標(biāo) .......................................................................................... 8 系統(tǒng)總體設(shè)計(jì) ................................................................................... 8 4 各模塊及數(shù)據(jù)庫設(shè)計(jì) .............................................................................................. 9 數(shù)據(jù)庫設(shè)計(jì) ................................................................................................. 9 數(shù)據(jù)分析 .......................................................................................... 9 概念結(jié)構(gòu)分 析 .................................................................................. 10 邏輯結(jié)構(gòu)分析 .................................................................................. 11 各模塊詳細(xì)設(shè)計(jì) ......................................................................................... 13 用戶模塊 ........................................................................................ 13 在線模塊 ........................................................................................ 14 系統(tǒng)維護(hù)模塊 ................................................................................. 17 主要核心代碼 ............................................................................................ 17 數(shù)據(jù)庫連接 .................................................................................... 17 登錄確認(rèn) ........................................................................................ 18 購物車 ........................................................................................... 19 管理員維護(hù) .................................................................................... 21 5 系統(tǒng)的運(yùn)行結(jié)果 ................................................................................................... 24 實(shí)驗(yàn)環(huán)境與結(jié)果 ........................................................................................ 24 實(shí)驗(yàn)環(huán)境 .................