毕 业 设 计（论 文）
题目：小型超市管理系统设计与实现
I
摘 要
使用旧方法对超市信息进行系统化管理已经不再让人们信赖了，把现在的网
络信息技术运用在超市信息的管理上面可以解决许多信息管理上面的难题，比如
处理数据时间很长，数据存在错误不能及时纠正等问题。
这次开发的小型超市管理系统有管理员，用户，员工。管理员功能有个人中
心，用户管理，员工管理，供应商管理，商品分类管理，商品信息管理，商品入
库管理，商品出库管理，商品采购管理，系统管理，订单管理等。员工可以管理
供应商，商品信息，入库和采购。用户可以在前台购买商品。经过前面自己查阅
的网络知识，加上自己在学校课堂上学习的知识，决定开发系统选择 B/S 模式这
种高效率的模式完成系统功能开发。这种模式让操作员基于浏览器的方式进行网
站访问，采用的主流的 Java 语言这种面向对象的语言进行小型超市管理系统程
序的开发，在数据库的选择上面，选择功能强大的 MySQL 数据库进行数据的存
放操作。
小型超市管理系统被人们投放于现在的生活中进行使用，该款管理类软件就
可以让管理人员处理信息的时间介于十几秒之间。在这十几秒内就能完成信息的
编辑等操作。有了这样的管理软件，超市信息的管理就离无纸化办公的目标更贴
近了。
关键词：小型超市管理系统；Java；MySQL
II
Abstract
The use of the old method to systematically manage supermarket information is
no longer trusted by people. The application of current network information
technology to the management of supermarket information can solve many problems
in information management, such as processing data for a long time and data errors.
Can not correct the problems in time.
The small supermarket management system developed this time has
administrators, users, and employees. Administrator functions include personal center,
user management, employee management, supplier management, product
classification management, product information management, product storage
management, product delivery management, product procurement management,
system management, order management, etc. Employees can manage suppliers,
product information, warehousing and purchasing. Users can purchase goods at the
front desk. After the network knowledge I checked before, plus the knowledge I
learned in the school classroom, I decided to choose the B/S mode as a
high-efficiency mode for the development system to complete the system function
development. This mode allows the operator to access the website based on the
browser. The mainstream Java language, an object-oriented language, is used for the
development of the small supermarket management system program. In the selection
of the database, the powerful MySQL database is selected for data. Storage operation.
The small supermarket management system is used by people in their daily lives.
This management software allows managers to process information within a dozen
seconds. Information editing and other operations can be completed within these ten
seconds. With such management software, the management of supermarket
information is closer to the goal of paperless office.
Key Words：Small supermarket management system; Java; MySQL
III
目 录
目 录 ..............................................III
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................3
2.1 SSM 框架介绍 .................................................................................................3
2.2 B/S 架构介绍 ...................................................................................................3
2.3 MYSQL 数据库介绍........................................................................................4
2.4 JAVA 语言介绍 ...............................................................................................5
3 系统分析............................................6
3.1 系统可行性分析 ..............................................................................................6
3.1.1 技术可行性分析 ..................................................................................6
3.1.2 经济可行性分析 ..................................................................................6
3.1.3 运行可行性分析 ..................................................................................6
3.2 系统性能分析 ..................................................................................................7
3.2.1 系统安全性 ..........................................................................................7
3.2.2 数据完整性 ..........................................................................................7
3.2.3 系统可扩展性 .......................................................................................8
3.3 系统流程分析 ..................................................................................................8
3.3.1 系统登录流程 .......................................................................................9
3.3.2 信息添加流程 .....................................................................................10
3.3.3 信息删除流程 .....................................................................................10
4 系统设计...........................................12
4.1 系统概要设计 ................................................................................................12
IV
4.2 系统功能结构设计 ........................................................................................12
4.3 数据库设计 ....................................................................................................13
4.3.1 数据库 E-R 图设计.............................................................................13
4.3.2 数据库表结构设计 ............................................................................14
5 系统实现...........................................21
5.1 用户信息管理 ................................................................................................21
5.2 员工信息管理 ...............................................................................................21
5.3 商品信息管理 ...............................................................................................22
5.4 商品购买管理 ................................................................................................22
5.5 我的订单管理 ................................................................................................23
6 系统测试 ...........................................25
6.1 本系统测试 .................................................................................................25
6.1.1 登录功能测试 .....................................................................................25
6.1.2 修改密码功能测试 .............................................................................26
6.2 测试结果分析 ................................................................................................26
结 论...............................................27
参考文献.............................................29
致 谢...............................................30
