摘 要

一直以來人們使用傳統(tǒng)人工的方式管理超市的各項工作，這種管理方式存在著許多缺點(diǎn)，如：效率低、保密性差，另外時間一長，將產(chǎn)生大量的冗余文件和數(shù)據(jù)，這給查找和統(tǒng)計等工作帶來了很大的困難。隨著超市規(guī)模的發(fā)展，商品數(shù)量的急劇增加，有關(guān)商品的各種信息量也成倍增長，傳統(tǒng)的人工記憶方式也慢慢的無法適應(yīng)形勢的變化。只有采用智能化現(xiàn)代化的管理手段才能適應(yīng)時代的潮流，在計算機(jī)技術(shù)迅速發(fā)展的今天，將計算機(jī)技術(shù)應(yīng)用到超市的管理中將極大的改善超市的管理水平。

本文就是基于以上的背景，提出了基于B/S模式的超市銷售管理系統(tǒng)。通過本系統(tǒng)可以實(shí)現(xiàn)超市智能化高效化的管理。本系統(tǒng)根據(jù)超市的實(shí)際運(yùn)營流程來設(shè)計實(shí)現(xiàn)，主要包括商品銷售模塊、采購進(jìn)貨模塊、庫存管理模塊，此外還提供了系統(tǒng)管理和財務(wù)管理兩個模塊實(shí)現(xiàn)了對本系統(tǒng)的管理和超市運(yùn)營狀況的全面分析，用戶根據(jù)它們即可維護(hù)系統(tǒng)和了解超市當(dāng)前的運(yùn)營狀況。本文從系統(tǒng)需求、系統(tǒng)設(shè)計到系統(tǒng)開發(fā)環(huán)境搭建和功能實(shí)現(xiàn)等多個方面做了全面的研究和分析。首先分析了當(dāng)前超市行業(yè)的管理狀況，然后從經(jīng)濟(jì)和技術(shù)等各個方面分析了開發(fā)本系統(tǒng)的可行性，接下來進(jìn)行系統(tǒng)設(shè)計從功能設(shè)計和數(shù)據(jù)庫設(shè)計兩個方面做了詳細(xì)分析，最后以不同用戶類型的功能權(quán)限作為主線介紹了系統(tǒng)的實(shí)現(xiàn)并作出了系統(tǒng)測試。通過本文即可全面了解本系統(tǒng)。

本系統(tǒng)基于B/S結(jié)構(gòu)，應(yīng)用MyEclipse開發(fā)平臺，采用JSP語言和ExtJS框架，并以Tomcat作為服務(wù)器Mysql作為數(shù)據(jù)庫進(jìn)行開發(fā)的。

關(guān)鍵詞 超市銷售管理；B/S；ExtJS；MVC；JSP

Abstract

Has been the work of the traditional manual way to manage small supermarket, this management approach has many shortcomings, such as: low efficiency, poor security, the other over time, will produce a lot of redundant files and data, which givesFind and statistical work has brought great difficulties. With the development of small supermarket scale, the number of commodities increase sharply, about a variety of goods the amount of information doubling the traditional artificial memory Only intelligent modern management tools in order to adapt to the trend of the times, the rapid development in computer technology today, the application of computer technology to the supermarket management will greatly improve the management level of the supermarket.

This article is based on the above background, a small supermarket management system based on B / S mode. Small supermarket intelligent and efficient management can be achieved through this system. The system is designed and implemented based on the actual operational processes of the supermarket, including merchandise sales module, purchase module procurement, inventory management module, in addition also provides two modules of the system management and financial management to achieve comprehensive management of the system and supermarket operator status analysis, the user they can maintain the current operational status of the system and understanding of the supermarket. First analysis of the current management situation of small supermarket industry, and then from the other aspects of economic and technical analysis of the feasibility of developing the system, followed by a detailed analysis of system design from the two aspects of functional design and database design, and finally to the different the functional competence of the user type as the main line of the realization of the system and make the system test. Through this article can be a comprehensive understanding of the system.

The system is based on B / S structure, application MyEclipse platform tools, using the JSP language and ExtJS framework and Tomcat as the server Mysql as the database developed.

Keywords  small supermarket management; B/S; ExtJS; MVC; JSP

目 錄

緒 論 1

1 系統(tǒng)概述 2

1.1 系統(tǒng)背景介紹 2

1.2 系統(tǒng)功能概述 2

1.3 系統(tǒng)開發(fā)環(huán)境 3

1.3.1 開發(fā)環(huán)境介紹 3

1.3.2 開發(fā)環(huán)境搭建 3

1.3.3 系統(tǒng)實(shí)現(xiàn)模式 3

2 可行性分析和需求分析 5

2.1 可行性研究 5

2.1.1  經(jīng)濟(jì)可行性 5

2.1.2  技術(shù)可行性 5

2.2 系統(tǒng)需求分析 5

2.2.1 功能需求分析 5

2.2.2系統(tǒng)性能需求 6

3 系統(tǒng)設(shè)計 7

3.1 系統(tǒng)功能設(shè)計 7

3.1.1 總體設(shè)計 7

3.1.2 詳細(xì)設(shè)計 8

3.2 系統(tǒng)用例分析 9

3.2.1 用例分析 9

3.2.2 用例詳細(xì)說明 10

3.3 數(shù)據(jù)庫需求分析 11

3.4 創(chuàng)建數(shù)據(jù)庫 15

4 系統(tǒng)實(shí)現(xiàn) 20

4.1 銷售員功能模塊實(shí)現(xiàn) 20

4.1.1 登錄模塊的實(shí)現(xiàn) 20

4.1.2 商品銷售模塊的實(shí)現(xiàn) 22

4.2 管理員功能模塊實(shí)現(xiàn) 25

4.2.1 系統(tǒng)管理模塊的實(shí)現(xiàn) 25

4.2.2 商品進(jìn)貨模塊的實(shí)現(xiàn) 28

4.2.3 商品庫存模塊的實(shí)現(xiàn) 30

4.2.4 財務(wù)管理模塊的實(shí)現(xiàn) 32

5 系統(tǒng)測試 35

5.1 測試方案 35

5.2　測試用例 35

5.2.1測試環(huán)境 35

5.2.2測試方案 35

5.3　測試結(jié)果 36

結(jié)束語 37

致謝 38

參考文獻(xiàn) 39