摘 要
互联网技术的不断发展与完善,引发了电子商务应用的迅猛发展,国内企业正经历
着前所未有的营销环境变化。作为营销者来说,必须充分认识到营销环境的巨大改变,
并正确、全面、创新地掌握营销策略,才能在瞬息万变的互联网环境中取得胜利。C2C
作为电子商务中重要的应用模式之一,近几年来在我国得到了迅速的发展,而以淘宝、
易趣为代表的电子商务网站在 2008 已实现了逾 300 亿元的交易额。
高校二手交易平台网站的建立采用的是结构化分析和设计方法,JSP 开发技术,使用
的是关系数据库等技术进行设计和开发,目前可以在 sql server 2000 数据库和 tomcat 服
务器下正确运行。本文首先介绍了电子商务网站的现状及课题的开发背景,然后论述了
系统的设计目标,系统需求和总体设计方案,较详细的论述了系统的详细设计和实现。
最后,本文对我所设计的高校二手交易平台网站进行了系统检测并提出了还需要改进的
问题。
通过对系统进行一系列的需求分析、设计、编码、测试等工作,实现了系统基本功
能。本系统经过测试,运行效果稳定,操作方便、快捷;实现了一个功能全面、技术先
进、实用性好、安全性高,并具有良好的可扩展性、可移植性和可维护性的信息平台。
在具体的应用过程中,有可能会出现一些问题,今后还会对本系统不断地进行完善、更
新。
关键字:电子商务,C2C,JSP, sql
Online Shopping Mall merchandise auction
sale model design and implementation
Abstract
The continuous development of Internet technology and improvement has led to a rapid
development of e-business applications, domestic enterprises are experiencing unprecedented
changes in the marketing environment. As marketers, it must be fully aware of the
tremendous changes in marketing environment, and the correct, comprehensive and
innovative marketing strategies to master in order to fast-changing Internet environment win.
C2C e-commerce as an important mode of application, in recent years in China has been rapid
development, and to Taobao, eBay e-commerce sites, represented by 2005 has been achieved
in more than 100 billion transactions.
Online Shopping Mall merchandise auction site sales model is based on the establishment
of a structured analysis and design methods, JSP development, using technologies such as
relational database design and development, currently available in sql server 2000 database
and tomcat server is running correctly. This paper first introduces the current status of
e-commerce sites and the development of the background of the subject, and then discusses
the system design objectives, system requirements and design program, more detailed
discussion of the detailed design of the system and realized. Finally, the design of my online
mall merchandise auction site sales model system to detect and also raised the issue of the
need to improve.
The system through a series of needs analysis, design, coding, testing, etc., to achieve the
basic functions of the system. The system tested the effect of stable operation, easy to operate,
fast; the realization of a full-featured, technologically advanced, practical, and safe and has
good scalability, portability and maintainability of the information platform. Specific
applications in the process, there may be some problems, the future of the system will
constantly improve and update.
Key word: E-commerce, C2C, JSP, SQL Server
–1–
目 录
Professor Sun Xiujie..........................................................................................................3
毕业设计(论文)任务书................................................................................................I
摘 要..................................................................................................................................I
Abstract.............................................................................................................................I
目 录 ...............................................................................................................................1
第 1 章 绪 论 ...................................................................................................................4
1.1 课题背景........................................4
1.2 国内外现状......................................4
1.3 论文的研究内容 ..................................5
1.4 论文的组织结构 ..................................6
第 2 章 电子商务网站概述 .............................................................................................7
2.1 电子商务的类型..................................7
2.2 C2C 电子商务网站的特征 ..........................8
2.3 我国 C2C 电子商务网站的现状及市场分析 ...........8
2.3.1 我国 C2C 电子商务网站概况......................8
2.3.2 C2C 市场竞争分析 ..............................9
第 3 章 高校二手交易平台的需求分析 .......................................................................12
3.1 系统概述 .......................................12
3.1.1 系统的一般描述...............................12
3.1.2 系统运行环境.................................12
3.2 系统技术需求 ...................................13
3.2.1 JSP 简介 .....................................13
3.2.2 EJB 简介 .....................................13
3.2.3 Eclipse 开发工具 .............................14
–2–
3.2.4 JDBC 简介 ....................................14
3.2.5 SQL Server 技术 ..............................15
3.3 业务流程分析 ...................................16
3.4 系统数据流程图分析 .............................16
3.4.1 系统顶层数据流程图分析.......................17
3.4.2 系统数据流程图一层图分析如下图 3.5 ...........18
3.4.3 商品信息模块流程图分析 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙18
3.4.4 拍卖信息模块流程图分析 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙19
3.4.5 求购信息模块流程图分析 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙19
3.4.6 竞价报表信息模块流程分析 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙20
3.4.7 用户信息模块流程分析 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙20
3.5 数据字典 .......................................21
第 4 章 高校二手交易平台设计 ...................................................................................25
4.1 高校二手交易平台介绍 ...........................25
4.2 系统功能需求 ...................................25
4.3 系统功能模块设计 ...............................25
4.3.1 商品信息模块功能设计 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙25
4.3.2 用户信息管理模块 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙26
4.3.3 拍卖管理模块 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙26
4.4 系统总体结构图 .................................26
4.5 数据库设计 .....................................27
4.5.1 数据库设计概述 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙27
4.5.2 系统数据库设计 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙27
第 5 章 高校二手交易平台的具体实现 .......................................................................31
5.1 校园网登录首页如下图 5.1........................31
5.2 用户注册模块 ...................................32
5.3 拍卖信息模块 ...................................32
第 6 章 系统的测试与运行 ...........................................................................................34
6.1 系统测试概述 ...................................34
–3–
6.2 系统测试 .......................................34
6.2.1 系统入口测试要点 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙34
6.2.2 注册信息测试要点 ∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙34
6.3 系统测试效果 ...................................35
第 7 章 总结 ...................................................................................................................36
参考文献 .........................................................................................................................37
致 谢 ...............................................................................................................................38