本科毕业设计论文
题目：二手商品交易平台设计与实现
系 别：
XX 系（全称）
专 业：
软件工程
班 级：
软件工程 15201
学生姓名：
学生学号：
指导教师：
导师 1 导师 2
毕业设计论文
摘 要
信息数据从传统到当代，是一直在变革当中，突如其来的互联网让传统的信息管理
看到了革命性的曙光，因为传统信息管理从时效性，还是安全性，还是可操作性等各个
方面来讲，遇到了互联网时代才发现能补上自古以来的短板，有效的提升管理的效率和
业务水平。传统的管理模式，时间越久管理的内容越多，也需要更多的人来对数据进行
整理，并且数据的汇总查询方面效率也是极其的低下，并且数据安全方面永远不会保证
安全性能。结合数据内容管理的种种缺点，在互联网时代都可以得到有效的补充。结合
先进的互联网技术，开发符合需求的软件，让数据内容管理不管是从录入的及时性，查
看的及时性还是汇总分析的及时性，都能让正确率达到最高，管理更加的科学和便捷。
本次开发的二手商品交易平台实现了收货地址管理、购物车管理、字典管理、公告信息
管理、商家管理、商品管理、商品收藏管理、商品评价管理、商品订单管理、用户管理、
管理员管理等功能。系统用到了关系型数据库中王者 MySql 作为系统的数据库，有效的
对数据进行安全的存储，有效的备份，对数据可靠性方面得到了保证。并且程序也具备
程序需求的所有功能，使得操作性还是安全性都大大提高，让二手商品交易平台更能从
理念走到现实，确确实实的让人们提升信息处理效率。
关键字：信息管理，时效性，安全性，MySql
毕业设计论文
Abstract
Information data has been changing from traditional to contemporary, and the sudden
Internet has allowed traditional information management to see a revolutionary dawn, because
traditional information management is in terms of timeliness, security, or operability. It was
only after encountering the Internet era that it was able to make up for the shortcomings since
ancient times, and effectively improve the management efficiency and business level. The
traditional management model, the longer the time, the more content is managed, and more
people are needed to organize the data, and the efficiency of data aggregation and query is
extremely low, and data security will never guarantee security performance. Combined with
various shortcomings of data content management, they can be effectively supplemented in
the Internet era. Combined with advanced Internet technology, develop software that meets
the needs, so that the data content management can maximize the accuracy rate from the
timeliness of entry, the timeliness of viewing, and the timeliness of summary analysis. The
train ticket selling system developed this time has realized the functions of online booking,
online payment, online change of ticket, and online refund of train tickets. The system uses
MySql, the king of the relational database, as the system database, which effectively stores the
data safely and effectively backs up, ensuring the reliability of the data. And the program also
has all the functions required by the program, which greatly improves the operability or
security, so that the train ticket sales system can go from concept to reality, and it really
allows people to improve the efficiency of information processing.
Key Words：Information management, timeliness, security, MySql
毕业设计论文
目 录
摘 要 .........................................................................................................................................I
目 录.......................................................................................................................................III
第 1 章 绪论...............................................................................................................................1
1.1 研究背景 ..............................................................................................................................1
1.2 目的和意义...........................................................................................................................1
1.3 论文研究内容 ......................................................................................................................1
第 2 章 程序开发技术...............................................................................................................3
2.1 MYSQL 数据库 ......................................................................................................................3
2.2 JAVA 语言..............................................................................................................................3
第 3 章 系统分析.......................................................................................................................5
3.1 可行性分析...........................................................................................................................5
3.1.1 技术可行性分析........................................................................................................5
3.1.2 经济可行性分析........................................................................................................5
3.1.3 操作可行性分析........................................................................................................6
3.2 系统运行环境.......................................................................................................................6
3.3 系统流程分析.......................................................................................................................6
第 4 章 系统设计.....................................................................................................................10
4.1 系统设计的原则 ................................................................................................................10
4.2 系统结构设计 ....................................................................................................................10
4.3 功能结构设计.....................................................................................................................11
4.4 数据库设计.........................................................................................................................12
4.4.1 数据库 E-R 图 ........................................................................................................12
4.4.2 数据库表结构.........................................................................................................13
第 5 章 系统实现.....................................................................................................................17
5.1 管理员功能实现.................................................................................................................17
5.1.1 商品管理.................................................................................................................17
5.1.2 公告信息管理.........................................................................................................17
毕业设计论文
5.1.3 公告类型管理..........................................................................................................18
第 6 章 系统测试.....................................................................................................................19
6.1 系统测试方法.....................................................................................................................19
6.2 系统功能测试 ....................................................................................................................20
6.2.1 用户登录测试.........................................................................................................20
6.2.2 添加账户功能测试.................................................................................................20
6.3 系统测试分析 ....................................................................................................................20
结 论.......................................................................................................................................21
致 谢.......................................................................................................................................22
参考文献...................................................................................................................................23
