设计题目：超市积分管理系统的设计与实现
I
摘 要
进入信息时代以来，很多数据都需要配套软件协助处理，这样可以解决传统
方式带来的管理困扰。比如耗时长，成本高，维护数据困难，数据易丢失等缺点。
本次使用数据库工具 MySQL 和编程框架 SSM 开发的超市积分管理系统，可以
实现目标用户群需要的功能，其中包括会员信息管理，商品兑换管理，积分记录
管理，商品管理，公告管理等功能。
总之，超市积分管理系统是基于计算机进行数据的处理，则可以短时间内批
量完成数据的管理，就连基本的数据录入，更改错误的数据，统计数据等操作要
求都可以轻松完成，这样的系统的运用可以减少很多繁琐的工作量，让数据的管
理人员提升效率，节省数据处理投入的资金和时间。同时，超市积分管理系统本
身就有配套的数据库，用于保存系统的后台数据，对于数据保存的容量则是传统
模式不能相比的，在数据安全性上，也有相应的加密技术提供保护，所以数据泄
露和被人窃取都不是易事。
关键词：超市积分管理系统；会员；商品兑换；积分记录
II
Abstract
Since entering the information age, a lot of data needs supporting software to
assist in processing, which can solve the management problems caused by traditional
methods. For example, it is time-consuming, costly, difficult to maintain data, and
easy to lose data. This time, the supermarket points management system developed by
the database tool MySQL and the programming framework SSM can realize the
functions required by the target user group, including membership information
management, commodity exchange management, point record management,
commodity management, announcement management and other functions.
In a word, the supermarket points management system is based on the computer
for data processing, you can complete the data management in a short time, even the
basic data entry, change the wrong data, statistical data and other operational
requirements can be easily completed, such a system The application can reduce a lot
of tedious workload, allow data managers to improve efficiency, and save money and
time invested in data processing. At the same time, the supermarket points
management system itself has a supporting database to store the back-end data of the
system. The data storage capacity is incomparable to the traditional model. In terms of
data security, there is also corresponding encryption technology to provide protection,
so Neither data leakage nor being stolen is easy.
Key Words ： Supermarket points management system; member; commodity
exchange; points record
III
目 录
第一章 绪论 ...........................................1
1.1 研究背景 .........................................................................................................1
1.2 研究意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第二章 开发环境与技术 .................................3
2.1 JSP 技术 ...........................................................................................................3
2.2 MYSQL 数据库................................................................................................3
2.3 JAVA 语言 .........................................................................................................4
2.4 SSM 框架 .........................................................................................................4
第三章 系统分析 .......................................5
3.1 可行性分析 ......................................................................................................5
3.1.1 运行可行性分析 ...................................................................................5
3.1.2 经济可行性分析 ...................................................................................5
3.1.3 技术可行性分析 ...................................................................................6
3.2 系统流程分析 ..................................................................................................6
3.3 系统性能分析 .................................................................................................8
3.3.1 系统安全性 ...........................................................................................8
3.3.2 系统可扩展性 .......................................................................................9
3.3.3 系统易维护性 .......................................................................................9
3.4 系统功能分析 ..................................................................................................9
第四章 系统设计 ......................................12
4.1 布局设计原则 ................................................................................................12
4.2 功能模块设计 ................................................................................................13
4.3 数据库设计 ....................................................................................................14
4.3.1 数据库 E-R 图.....................................................................................14
4.3.2 数据库表结构 ....................................................................................17
第五章 系统实现 ......................................20
5.1 管理员功能实现 ...........................................................................................20
5.1.1 员工管理 ............................................................................................20
5.1.2 会员管理 ............................................................................................20
5.1.3 积分记录管理 ....................................................................................21
5.1.4 商品兑换管理 ....................................................................................21
5.2 员工功能实现 ...............................................................................................22
5.2.1 商品管理 ............................................................................................22
5.2.2 添加商品兑换信息 ............................................................................22
IV
5.2.3 积分记录管理 ....................................................................................23
第六章 系统测试 ......................................24
6.1 系统测试的实施 ...........................................................................................24
6.2 系统测试用例 ...............................................................................................24
6.2.1 登录功能测试 ....................................................................................24
6.2.2 添加公告类型功能测试 ....................................................................25
6.3 测试的结果 ...................................................................................................25
结 论 ...............................................26
参考文献 .............................................27
致 谢 ...............................................28
