小型超市管理系统的设计与实现
小型超市管理系统的设计与实现
摘 要
在我国经济飞速发展的背景下，国内的小型综合性超市正在向实现管理信息化的目标
前进，研究超市管理方法以期发展超市管理信息化，实现一个更加适用的超市管理系统成
为了一项非常有意义的研究。本文以盖州市百姓超市为例，经过周密的调研之后，设计并
开发出一套超市管理系统。项目的实施充分利用了软件工程提出的工程化思想，严格按照
软件的生命周期为主线来展开项目进度。软件设计部分采用面向对象的软件设计方法，利
用UML的标准对系统的主要部分进行建模和设计。
本系统采用B/S结构，以MyEclipse8.5为开发平台，通过Java程序设计语言及三层架构
的思想对项目进行开发。系统后台利用SQL Server2008作为数据库服务器支持，实现了商
品信息管理、进货信息管理、销售信息管理、库存信息管理、员工信息管理等功能，使信
息整理快速、准确、简单，从而提高了超市管理的效率和质量。
关键词：B/S；管理系统；SQL Server2008；销售管理
小型超市管理系统的设计与实现
Design and implementation of a small supermarket management
system
ABSTRACT
U n d e r t h e b a c k g r o u n d o f r a p i d e c o n o m i c d e v e l o p m e n t i n o u r c o u n t r y , t h e l a r g e - s c a l e
c o m p r e h e n s i v e s u p e r m a r k e t i s t o r e a l i z e t h e m a n a g e m e n t i n f o r m a t i z a t i o n g o a l , s u p e r m a r k e t
management information research supermarket management methods in order to development, to
implement a more suitable supermarket management system management system has become a
very meaningful study.In this paper,taking Gaizhou Baixing supermarket as an example, after a
c a r e f u l i n v e s t i g a t i o n a n d r e s e a r c h , d e s i g n a n d d e v e l o p a s e t o f s u p e r m a r k e t m a n a g e m e n t
system.The implementation of the project engineering proposed by make full use of the software
engineering ideas, in strict accordance with the software life cycle as the main line to launch the
project schedule.Software design part adopts the object-oriented software design method, using
UML standards for the main part of the system modeling and design.
This system adopts B/S structure to MyEclipse8.5 as development platform, through the Java
p r o g r a m m i n g l a n g u a g e a n d t h r e e l a y e r a r c h i t e c t u r e o f t h o u g h t t o d e v e l o p t h e p r o j e c t . S y s t e m
u s i n g S Q L S e r v e r 2 0 08 a s b a c k g r o u n d d a t a b a s e s e r v e r s u p p o r t , t o a c h i e v e t h e
C o m m o d i t y i n f o r m a t i o n m a n a g e m e n t, P u r c h a s e i n f o r m a t i o n m a n a g e m e n t,S a l e s i n f o r m a t i o n
management,Inventory information management,employee information management, and other
functions, make the information fast, accurate and simple, so as to improve the efficiency of the
supermarket management and quality.
Key words: B/S; management system; SQL Server2008; Sales management
小型超市管理系统的设计与实现
目 录
1 前言.................................................................................................................................................................1
1.1 系统概述..............................................................................................................................................1
1.2 超市管理国内外现状..........................................................................................................................1
1.3 论文主要工作和内容..........................................................................................................................2
2 系统可行性分析.............................................................................................................................................3
2.1 经济可行性..........................................................................................................................................3
2.2 技术可行性..........................................................................................................................................3
2.3 操作可行性..........................................................................................................................................4
2.4 社会可行性..........................................................................................................................................4
3 系统需求分析.................................................................................................................................................5
3.1 系统的业务流程分析..........................................................................................................................5
3.1.1 业务流程符号说明...................................................................................................................5
3.1.2 本系统的业务流程分析...........................................................................................................6
3.2 系统的功能需求分析..........................................................................................................................6
3.3 系统的数据流图设计..........................................................................................................................7
3.3.1 数据流图概述...........................................................................................................................7
3.3.2 数据流图符号...........................................................................................................................7
3.3.3 本系统数据流图.......................................................................................................................7
4 总体设计.......................................................................................................................................................12
4.1 总体设计概述....................................................................................................................................12
4.2 系统功能模块结构图........................................................................................................................12
4.3 功能模块详细描述............................................................................................................................13
4.4 系统数据库设计................................................................................................................................14
4.4.1系统E-R图设计........................................................................................................................14
4.4.2 数据字典.................................................................................................................................16
4.4.3 数据库表结构设计.................................................................................................................18
5 详细设计与系统实现...................................................................................................................................22
5.1 系统流程图设计................................................................................................................................22
5.2 系统开发工具....................................................................................................................................23
5.3 模块详细设计....................................................................................................................................24
5.3.1 用户登录设计.........................................................................................................................24
5.3.2 商品供货商管理模块.............................................................................................................26
5.3.3 员工信息管理模块.................................................................................................................27
5.3.4 超市商品管理模块.................................................................................................................30
5.3.5 商品进货管理模块.................................................................................................................32
小型超市管理系统的设计与实现
5.3.6 库存盘点模块.........................................................................................................................34
5.3.7 商品进货统计模块.................................................................................................................34
5.3.8 商品销售统计模块.................................................................................................................35
5.3.9 超市工作人员子系统.............................................................................................................35
6 系统测试.......................................................................................................................................................37
6.1 测试原理及测试方法概述................................................................................................................37
6.2 测试用例............................................................................................................................................40
6.3 软件测试结论....................................................................................................................................41
6.3.1 软件能力.................................................................................................................................41
6.3.2 缺陷和限制.............................................................................................................................41
6.3.3 建议.........................................................................................................................................41
6.3.4 测试结论.................................................................................................................................41
7 结 论..............................................................................................................................................................43
参考文献..........................................................................................................................................................44
致 谢.................................................................................................................................................................45
小型超市管理系统的设计与实现
