设计题目：校园电子商城的设计与实现
I
摘 要
网络技术和计算机技术发展至今，已经拥有了深厚的理论基础，并在现实中
进行了充分运用，尤其是基于计算机运行的软件更是受到各界的关注。加上现在
人们已经步入信息时代，所以对于信息的宣传和管理就很关键。因此校园购物信
息的管理计算机化，系统化是必要的。设计开发校园电子商城不仅会节约人力和
管理成本，还会安全保存庞大的数据量，对于校园购物信息的维护和检索也不需
要花费很多时间，非常的便利。
校园电子商城是在 MySQL 中建立数据表保存信息，运用 SSM 框架和 Java
语言编写。并按照软件设计开发流程进行设计实现。系统具备友好性且功能完善。
管理员管理留言板和交流信息，管理商品和商品购买信息，管理商家和用户。商
家发布要售卖的商品信息，管理商品的购买信息，管理用户与商家的交流信息。
用户查看校园资讯，发布留言，查看回复，向商家咨询商品，收藏并购买商品。
校园电子商城在让校园购物信息规范化的同时，也能及时通过数据输入的有
效性规则检测出错误数据，让数据的录入达到准确性的目的，进而提升校园电子
商城提供的数据的可靠性，让系统数据的错误率降至最低。
关键词：校园电子商城；MySQL；SSM 框架
II
Abstract
Network technology and computer technology have developed so far, they have
already had a profound theoretical foundation, and they have been fully used in reality.
In particular, computer-based software has attracted attention from all walks of life. In
addition, now that people have entered the information age, the promotion and
management of information is very important. Therefore, computerization and
systematization of campus shopping information management is necessary. The
design and development of the campus electronic mall will not only save labor and
management costs, but also store a huge amount of data safely. It does not take a lot
of time to maintain and retrieve campus shopping information, which is very
convenient.
The campus electronic mall builds data tables to save information in MySQL,
and uses 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. Administrators manage message boards and exchange
information, manage products and product purchase information, and manage
businesses and users. Merchants publish product information to be sold, manage
product purchase information, and manage communication information between users
and merchants. Users check campus information, post messages, check replies,
consult merchants about products, collect and purchase products.
While the campus electronic mall standardizes campus shopping 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 campus electronic mall. The error rate of system
data is minimized.
Key Words：Campus electronic mall; 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 系统设计...........................................13
4.1 系统目标 ........................................................................................................13
4.2 功能结构设计 ................................................................................................14
4.3 数据库设计 ....................................................................................................16
4.3.1 数据库 E-R 图.....................................................................................16
4.3.2 数据库表结构 ....................................................................................19
IV
5 系统实现...........................................24
5.1 管理员功能实现 ...........................................................................................24
5.1.1 商家管理 ............................................................................................24
5.1.2 留言板管理 ........................................................................................24
5.1.3 校园资讯 ............................................................................................25
5.2 商家功能实现 ...............................................................................................25
5.2.1 商品信息管理 ....................................................................................25
5.2.2 商品购买管理 ....................................................................................26
5.2.3 交流信息管理 ....................................................................................26
5.3 用户功能实现 ...............................................................................................27
5.3.1 留言反馈 ............................................................................................27
5.3.2 商品信息 .............................................................................................27
5.3.3 校园资讯 ............................................................................................28
5.3.4 商品购买管理 ....................................................................................28
6 系统测试 ...........................................30
6.1 系统测试的类型 ...........................................................................................30
6.2 功能测试 .......................................................................................................31
6.3 可用性测试 ...................................................................................................31
6.4 测试结果分析 ...............................................................................................31
结 论...............................................32
参考文献.............................................34
致 谢...............................................35
