设计题目：购物商城系统的设计与实现
I
摘 要
网络技术和计算机技术发展至今，已经拥有了深厚的理论基础，并在现实中
进行了充分运用，尤其是基于计算机运行的软件更是受到各界的关注。加上现在
人们已经步入信息时代，所以对于信息的宣传和管理就很关键。因此商城购物信
息的管理计算机化，系统化是必要的。设计开发购物商城系统不仅会节约人力和
管理成本，还会安全保存庞大的数据量，对于商城购物信息的维护和检索也不需
要花费很多时间，非常的便利。
购物商城系统是在 MySQL 中建立数据表保存信息，运用 SSM 框架和 Java
语言编写。并按照软件设计开发流程进行设计实现。系统具备友好性且功能完善。
管理员登录进入本人后台之后，管理商品和用户，查看和回复用户对商品的评价，
管理不同状态的订单。用户管理收货地址，管理不同状态的订单，收藏商品，评
价商品。
购物商城系统在让商城购物信息规范化的同时，也能及时通过数据输入的有
效性规则检测出错误数据，让数据的录入达到准确性的目的，进而提升购物商城
系统提供的数据的可靠性，让系统数据的错误率降至最低。
关键词：购物商城系统；MySQL；SSM 框架
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 shopping information in
shopping malls. Designing and developing a shopping mall 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 shopping information in the mall,
which is very convenient.
The shopping mall system is to establish a data table in MySQL to save the
information, using SSM 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. After the administrator logs in and enters
his backstage, he manages products and users, checks and responds to users'
comments on products, and manages orders in different states. The user manages the
receiving address, manages orders in different states, collects goods, and evaluates
goods.
While the shopping mall system standardizes shopping information in the mall, it
can also detect incorrect data in a timely manner through the validity rules of data
input, so that the data entry can achieve the purpose of accuracy, thereby improving
the reliability of the data provided by the shopping mall system. The error rate of
system data is minimized.
Key Words：Shopping mall system; MySQL; SSM framework
III
目 录
1 绪论 ...............................................1
1.1 选题背景 .........................................................................................................1
1.2 选题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
2 系统开发技术........................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 SSM 框架 .........................................................................................................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 数据库设计 ....................................................................................................14
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 已支付订单 ........................................................................................24
5.2.5 我的地址 ............................................................................................24
6 系统测试 ...........................................25
6.1 系统测试的类型 ...........................................................................................25
6.2 功能测试 .......................................................................................................26
6.3 可用性测试 ...................................................................................................26
6.4 测试结果分析 ...............................................................................................26
结 论...............................................27
参考文献.............................................29
致 谢...............................................30
