设计题目：手工艺品销售系统的设计与实现
I
摘 要
计算机网络发展到现在已经好几十年了，在理论上面已经有了很丰富的基础，
并且在现实生活中也到处都在使用，可以说，经过几十年的发展，互联网技术已
经把地域信息的隔阂给消除了，让整个世界都可以即时通话和联系，极大的方便
了人们的生活。所以说，手工艺品销售系统用计算机技术来进行设计，不仅在管
理方面更加的系统化，操作性强，最重要的是关于数据的保存和使用都能节约大
量的时间，该系统非常的好用。
手工艺品销售系统管理数据的工具是 MySQL，编码的语言是 Java，运用的
框架是 Spring Boot 框架。该系统可以实现手工艺品管理，手工艺品评价管理，
手工艺品订单管理，购物车管理，手工艺品求购管理，商家管理等功能。
手工艺品销售系统不仅能让操作人员使用更加地方便，并且设计的也很合理，
能有效的避免误操作，让数据在录入的环节就符合设计需要，极大的规避了源头
性的输入误差，顺利的让数据变得更加可控并且可靠，让出错的几率降到最低。
关键词：手工艺品销售系统；手工艺品；评价；订单
II
Abstract
Computer networks have been developed for decades, and they have a rich
theoretical foundation and are used everywhere in real life. It can be said that after
decades of development, Internet technology has transformed regional information.
The estrangement between the two has been eliminated, allowing the whole world to
communicate and contact in real time, which greatly facilitates people's lives.
Therefore, the handicraft sales system is designed with computer technology. It is not
only more systematic in management, but also has strong operability. The most
important thing is that the storage and use of data can save a lot of time. The system is
very easy to use. .
The tool for the handicraft sales system to manage data is MySQL, the coding
language is Java, and the framework used is the Spring Boot framework. The system
can realize handicraft management, handicraft evaluation management, handicraft
order management, shopping cart management, handicraft purchase management,
business management and other functions.
The handicraft sales system not only makes the operator more convenient to use,
but also has a very reasonable design, which can effectively avoid misoperation, make
the data meet the design needs in the process of input, and greatly avoid the source
input error. Smoothly make the data more controllable and reliable, minimizing the
chance of errors.
Key Words：handicraft sales system; handicraft; evaluation; order
III
目 录
1 绪论 ...............................................1
1.1 选题背景 .........................................................................................................1
1.2 选题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
2 系统开发技术........................................3
2.1 MYSQL 数据库................................................................................................3
2.2 IDEA 简介........................................................................................................3
2.3 SPRING BOOT 框架............................................................................................4
2.4 VUE 框架 ..........................................................................................................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 系统流程分析 .................................................................................................7
3.4 系统功能分析 .................................................................................................9
4 系统设计...........................................15
4.1 系统设计原则 ...............................................................................................15
4.2 功能模块设计 ...............................................................................................16
4.3 数据库设计 ...................................................................................................18
4.3.1 数据库 E-R 图....................................................................................19
IV
4.3.2 数据库表结构 ....................................................................................21
5 系统实现...........................................26
5.1 管理员功能实现 ...........................................................................................26
5.1.1 商家管理 ............................................................................................26
5.1.2 论坛管理 ............................................................................................26
5.1.3 手工艺品求购管理 ............................................................................27
5.2 商家功能实现 ...............................................................................................27
5.2.1 手工艺品管理 ....................................................................................27
5.2.2 手工艺品评价管理 ............................................................................28
5.2.3 手工艺品订单管理 ............................................................................29
5.3 用户功能实现 ...............................................................................................29
5.3.1 手工艺品信息 ....................................................................................29
5.3.2 确认下单 ............................................................................................30
5.3.3 手工艺品订单 ....................................................................................30
5.3.4 购物车 ................................................................................................31
6 系统测试...........................................32
6.1 测试任务 .......................................................................................................32
6.2 测试目标 .......................................................................................................32
6.3 测试方案 .......................................................................................................33
6.4 功能测试 .......................................................................................................34
6.5 可用性测试 ...................................................................................................35
6.6 测试结果分析 ...............................................................................................35
结 论...............................................36
参考文献.............................................38
致 谢...............................................39
