毕 业 设 计（论 文）
题目：国外摇滚乐队交流和周边售卖系统的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对国外摇滚乐队交流和周边售卖信息管理混乱，出错率高，
信息安全性差，劳动强度大，费时费力等问题，采用国外摇滚乐队交流和周边售
卖系统可以有效管理，使信息管理能够更加科学和规范。
国外摇滚乐队交流和周边售卖系统在 Eclipse 环境中，使用 Java 语言进行编
码，使用 Mysql 创建数据表保存本系统产生的数据。系统可以提供信息显示和相
应服务，其管理员管理周边商城的商品信息，管理各种状态的订单，管理用户和
帖子，管理音乐资讯和商品类型信息。用户查看并购买周边商品，收藏商品，评
论商品，查看音乐资讯。
总之，国外摇滚乐队交流和周边售卖系统集中管理信息，有着保密性强，效
率高，存储空间大，成本低等诸多优点。它可以降低信息管理成本，实现信息管
理计算机化。
关键词：国外摇滚乐队交流和周边售卖系统；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic management of foreign rock
band communication and peripheral sales information, high error rate, poor
information security, high labor intensity, time-consuming and labor-intensive
problems, the use of foreign rock band communication and peripheral sales systems
can be effectively managed, and information management can be more scientific and
standardized .
The foreign rock band communication and peripheral sales system is in the
Eclipse environment, using the Java language for coding, and using Mysql to create a
data table to save the data generated by the system. The system can provide
information display and corresponding services. Its administrator manages the product
information of surrounding malls, manages orders in various states, manages users
and posts, and manages music information and product type information. Users view
and purchase peripheral products, collect products, review products, and view music
information.
In short, the centralized management information of foreign rock band exchanges
and peripheral sales systems has many advantages such as strong confidentiality, high
efficiency, large storage space, and low cost. It can reduce the cost of information
management and realize the computerization of information management.
Key Words ： Foreign rock band communication and peripheral sales system; Java
language; Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................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 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................8
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计......................................12
4.1 设计原则 .......................................................................................................12
4.2 功能结构设计 ...............................................................................................12
4.3 数据库设计 ...................................................................................................14
4.3.1 数据库概念设计 ................................................................................14
IV
4.3.2 数据库物理设计 ................................................................................17
第 5 章 系统实现......................................24
5.1 管理员功能实现 ...........................................................................................24
5.1.1 周边商城管理 ....................................................................................24
5.1.2 音乐资讯 ............................................................................................24
5.1.3 已完成订单 ........................................................................................25
5.1.4 已支付订单 ........................................................................................25
5.1.5 帖子信息管理 ....................................................................................26
5.1.6 用户管理 ............................................................................................26
5.1.7 商品类型管理 ....................................................................................27
5.2 用户功能实现 ...............................................................................................27
5.2.1 商品信息 ............................................................................................27
5.2.2 音乐资讯 ............................................................................................28
5.2.3 购物车 ................................................................................................28
5.2.4 添加收货地址 ....................................................................................29
5.2.5 提交订单 ............................................................................................29
5.2.6 已支付订单 ........................................................................................30
第 6 章 系统测试......................................31
6.1 功能测试 .......................................................................................................31
6.1.1 登录功能测试 ....................................................................................31
6.1.2 修改密码功能测试 ............................................................................32
6.2 测试结果 .......................................................................................................33
结 论...............................................34
致 谢...............................................35
参考文献.............................................36
