毕 业 设 计(论 文)
题目:网上拍卖系统设计与开发
I
摘 要
现代经济快节奏发展以及不断完善升级的信息化技术,让传统数据信息的管
理升级为软件存储,归纳,集中处理数据信息的管理方式。本网上拍卖系统就是
在这样的大环境下诞生,其可以帮助使用者在短时间内处理完毕庞大的数据信息,
使用这种软件工具可以帮助管理人员提高事务处理效率,达到事半功倍的效果。
此网上拍卖系统利用当下成熟完善的 SSM 框架,使用跨平台的可开发大型商业
网站的 Java 语言,页面采用 JSP 技术,以及最受欢迎的 RDBMS 应用软件之一
的 MySQL 数据库进行程序开发。网上拍卖系统有管理员,用户,卖家三个角色。
管理员功能有个人中心,用户管理,卖家管理,商品类型管理,拍卖商品管理,
用户竞拍管理,成交通知管理,用户评价管理,留言交流,系统管理。卖家可以
注册登录,发布拍卖商品,查看用户竞拍,对成交用户进行通知,查看用户评价
等操作。用户可以注册登录,查看拍卖商品,对商品进行竞拍,查看成交通知和
进行评价操作等。网上拍卖系统的开发根据操作人员需要设计的界面简洁美观,
在功能模块布局上跟同类型网站保持一致,程序在实现基本要求功能时,也为数
据信息面临的安全问题提供了一些实用的解决方案。可以说该程序在帮助使用者
高效率地处理工作事务的同时,也实现了数据信息的整体化,规范化与自动化。
关键词:网上拍卖系统;SSM 框架;MySQL;自动化;JSP
II
Abstract
The fast-paced development of the modern economy and the continuous improvement
and upgrading of information technology have upgraded the management of
traditional data information to a management method of software storage, induction,
and centralized processing of data information. This online auction system was born
in such a big environment. It can help users process huge data information in a short
time. Using this software tool can help managers improve transaction processing
efficiency and achieve multiplier effect with half the effort. This online auction
system utilizes the current mature and perfect SSM framework, uses the
cross-platform Java language that can develop large-scale commercial websites, uses
JSP technology for pages, and uses MySQL database, one of the most popular
RDBMS application software, for program development. The online auction system
has three roles: administrator, user, and seller. The administrator functions include
personal center, user management, seller management, commodity type management,
auction commodity management, user bidding management, transaction notification
management, user evaluation management, message exchange, and system
management. Merchants can register and log in, publish auction products, view user
bids, notify users of transactions, and view user reviews. Users can register and log in,
view auction products, bid for products, view transaction notifications, and perform
evaluation operations. The development of the online auction system is designed
according to the needs of operators. The interface is simple and beautiful, and the
layout of functional modules is consistent with the same type of website. When the
program realizes the basic required functions, it also provides some practical solutions
for the security problems faced by data and information. . It can be said that this
program not only helps users to deal with work affairs efficiently, but also realizes the
integration, standardization and automation of data information.
Key Words:Online auction system; SSM framework; MySQL; automation; JSP
III
目 录
目 录 ..............................................III
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 .....................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................3
2.1 B/S 结构介绍 ...................................................................................................3
2.2 MYSQL 数据库介绍........................................................................................3
2.3 SSM 框架介绍 .................................................................................................4
2.4 JSP 介绍 ...........................................................................................................5
3 系统分析............................................7
3.1 系统可行性分析 .............................................................................................7
3.1.1 技术可行性分析 ..................................................................................7
3.1.2 经济可行性分析 ..................................................................................7
3.1.3 运行可行性分析 ..................................................................................7
3.2 系统性能分析 .................................................................................................8
3.2.1 易用性指标 ..........................................................................................8
3.2.2 可扩展性指标 ......................................................................................8
3.2.3 健壮性指标 ..........................................................................................8
3.2.4 安全性指标 ..........................................................................................9
3.3 系统流程分析 .................................................................................................9
3.3.1 操作流程分析 ......................................................................................9
3.3.2 登录流程分析 ....................................................................................10
3.3.3 信息添加流程分析 ............................................................................11
3.3.4 信息删除流程分析 ............................................................................12
IV
4 系统设计...........................................13
4.1 系统概要设计 ...............................................................................................13
4.2 系统功能结构设计 .......................................................................................13
4.3 数据库设计 ...................................................................................................14
4.3.1 数据库 E-R 图设计............................................................................14
4.3.2 数据库表结构设计 ............................................................................16
5 系统实现...........................................21
5.1 管理员模块功能 ...........................................................................................21
5.1.1 用户管理 ............................................................................................21
5.1.2 卖家管理 ............................................................................................21
5.1.3 商品类型管理 ....................................................................................22
5.2 卖家模块功能 ...............................................................................................23
5.2.1 拍卖商品管理 ....................................................................................23
5.2.2 用户竞拍管理 ....................................................................................23
5.3 用户管理 .......................................................................................................24
5.3.1 拍卖商品 ............................................................................................24
5.3.2 公告信息 ............................................................................................25
5.3.3 用户竞拍 ............................................................................................25
6 系统测试...........................................27
6.1 系统测试的特点 .........................................................................................27
6.2 测试结果分析 ...............................................................................................27
结 论...............................................29
致 谢...............................................30
参考文献.............................................31