设计题目：网上超市系统的设计与实现
I
摘 要
网络技术和计算机技术发展至今，已经拥有了深厚的理论基础，并在现实中
进行了充分运用，尤其是基于计算机运行的软件更是受到各界的关注。加上现在
人们已经步入信息时代，所以对于信息的宣传和管理就很关键。因此超市商品销
售信息的管理计算机化，系统化是必要的。设计开发网上超市系统不仅会节约人
力和管理成本，还会安全保存庞大的数据量，对于超市商品销售信息的维护和检
索也不需要花费很多时间，非常的便利。
网上超市系统是在 MySQL 中建立数据表保存信息，运用 SpringBoot 框架和
Java 语言编写。并按照软件设计开发流程进行设计实现。系统具备友好性且功能
完善。本系统主要让用户购买商品，在线下单，管理不同状态的订单，让管理员
对商品和订单进行集中管理。
网上超市系统在让超市商品销售信息规范化的同时，也能及时通过数据输入
的有效性规则检测出错误数据，让数据的录入达到准确性的目的，进而提升网上
超市系统提供的数据的可靠性，让系统数据的错误率降至最低。
关键词：网上超市系统；MySQL；SpringBoot 框架
II
Abstract
Network technology and computer technology have developed so far, they
already have a solid theoretical foundation and have been fully used in reality,
especially the software based on computer operation has attracted the attention of all
walks of life. In addition, now that people have entered the information age, the
promotion and management of information is very important. Therefore, it is
necessary to computerize and systemize the management of supermarket merchandise
sales information. The design and development of an online supermarket system will
not only save manpower and management costs, but also store a huge amount of data
safely, and it does not take a lot of time to maintain and retrieve supermarket
merchandise sales information, which is very convenient.
The online supermarket system builds data tables in MySQL to store information,
and uses SpringBoot framework and Java language to write. And in accordance with
the software design and development process for design and implementation. The
system is friendly and fully functional. This system mainly allows users to purchase
goods, place orders online, manage orders in different states, and allow administrators
to centrally manage goods and orders.
While the online supermarket system standardizes supermarket merchandise
sales information, it can also detect incorrect data in a timely manner through the
validity rules of data input, so that data entry can achieve the purpose of accuracy,
thereby improving the reliability of the data provided by the online supermarket
system. Minimize the error rate of system data.
Key Words：Online supermarket system; MySQL; SpringBoot framework
III
目 录
1 绪论 ...............................................1
1.1 选题背景 .........................................................................................................1
1.2 选题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
2 系统开发技术........................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 SPRINGBOOT 框架.............................................................................................3
2.3 MYSQL 数据库 ...............................................................................................4
3 系统分析............................................5
3.1 可行性研究 ......................................................................................................5
3.1.1 经济可行性 ...........................................................................................5
3.1.2 时间可行性 ...........................................................................................5
3.1.3 操作可行性 ...........................................................................................5
3.2 系统性能分析 ..................................................................................................6
3.2.1 系统易用性 ...........................................................................................6
3.2.2 系统健壮性 ...........................................................................................6
3.2.3 系统安全性 ...........................................................................................6
3.3 系统流程分析 .................................................................................................6
3.4 系统功能分析 ..................................................................................................9
4 系统设计...........................................12
4.1 系统目标 ........................................................................................................12
4.2 功能模块设计 ................................................................................................13
4.3 数据库设计 ....................................................................................................13
4.3.1 数据库 E-R 图.....................................................................................14
4.3.2 数据库表结构 ....................................................................................16
IV
5 系统实现...........................................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
5.2.3 确认下单 ............................................................................................23
5.2.4 已支付订单 ........................................................................................23
6 系统测试 ...........................................25
6.1 系统测试的类型 ...........................................................................................25
6.2 功能测试 .......................................................................................................26
6.3 可用性测试 ...................................................................................................26
6.4 测试结果分析 ...............................................................................................26
结 论...............................................27
参考文献.............................................29
致 谢...............................................30
