摘 要
网上购物系统是一个基于Internet，采用C2C(Consumers to Consumers)模式，并根据现有的网上购物系统的现状而设计开发的J2EE电子商务平台。它不但可以扩大商家的规模和市场影响力，而且可以减少企业的经营成本，提高工作效率，同时也改变着人们的生活。
本文首先介绍了网上购物系统的现状及开发背景，然后论述了系统的设计目标，系统需求和总体设计方案，较详细的论述了系统的详细设计和实现。最后，本文对网上购物系统系统进行了系统检测并提出了还需要改进的问题。
在设计方面，该课题研究主要是用java语言开发，基于B/S架构，服务端是Apache Tomcat，系统采用MVC三层结构，同时使用JSP技术，后台数据库选用SQL Server 2005。主要实现网上购物的 基本功能，通过相关开发工具的使用，掌握基本的编程方法，熟悉java平台应用程序的开发过程。
关键词：网上购物系统；J2EE；B/S结构；JSP；SQL Server；
ABSTRACT
Online shopping system is one based on Internet, using C2C (Consumers to Consumers) model, and based on the existing status of the online shopping system design and development of J2EE e-commerce platform. It can not only expand the business scale and market influence, and can reduce the operating costs of enterprises, improve work efficiency, but also changing people's lives.
This paper introduces the online shopping system status and development background, and then discusses the system design goals, system requirements and overall design, a more detailed exposition of the detailed design and implementation. Finally, on-line shopping system if the system detects the system and presents the question needs to be improved.
In terms of design, the research is mainly used java language development, based on B / S architecture, the server is Apache Tomcat, the system uses three-tier MVC architecture, using JSP technology, background database use SQL Server 2005. The main achievement of the basic functions of online shopping through related development tools, master basic programming, familiar with the java platform application development process.
Online shopping system is a typical J2EE e-commerce platform, which bases on the existing status of the online shopping system, and uses C2C (Consumers to Consumers) model. Online shopping system can not only expand the business scale and market influence, but also reduce the operating costs of enterprises, improve work efficiency, and change people's lives.
This paper first introduces the online shopping system status and development background, latter discusses the system design goals, system requirements and overall design, and then elaborates a more detailed exposition of the detailed design and implementation. Finally, the paper shows the results of the systematical test and the exiting problems.
In terms of design, the research uses java as language tool, bases on B/S architecture, and uses Apache Tomcat as the server. The system also uses three-tier MVC architecture, JSP technology, SQL Server 2005 as database. In this online shopping system, the basic functions are achieved. By using the related development tools, I have mastered basic programming method and the java platform application development process.
Key words: online store; J2EE; B/S Structure; Java
湖南科技大学本科生毕业设计（论文）
目 录
第一章 引 言 ...............................................................................................................................................2
1.1 系统开发背景 ...........................................................................................................................................2 1.2 系统实现的目标 .......................................................................................................................................3
第二章 系统理论与技术 ............................................................................................................................4
2.1 开发技术的选择 .......................................................................................................................................4 2.2 JSP简介 ....................................................................................................................................................4 2.3 B/S体系结构 ............................................................................................................................................5 2.4 基于MVC的应用开发模型 ....................................................................................................................6 2.5 SQL Server数据库介绍............................................................................................................................7 2.6 Myeclipse开发工具 ..................................................................................................................................7
第三章 系统分析与设计..........................................................................................................................9
3.1 系统总体设计目标 ...................................................................................................................................9 3.2 系统的可行性分析 ...................................................................................................................................9 3.3 系统设计思想 ...........................................................................................................................................9 3.4 系统功能需求 .........................................................................................................................................10 3.5 系统总的功能模块图 ............................................................................................................................. 11 3.6 系统各模块的流程分析 .........................................................................................................................12
3.6.1 购物过程总体流程 ......................................................................................................................12 3.6.2 注册功能流程 ..............................................................................................................................12 3.6.3 用户登录流程 ..............................................................................................................................13 3.6.4 商品搜索流程 ..............................................................................................................................14 3.6.5 购物车流程 ..................................................................................................................................15 3.7 数据库设计 .............................................................................................................................................15
第四章 系统功能的具体实现 .............................................................................................................17
4.1 搭建开发环境 .........................................................................................................................................17
4.1.1 JAVA虚拟机的安装 ....................................................................................................................17 4.1.2 Tomcat环境搭建 .........................................................................................................................17 4.2 数据库的实现与连接技术 .....................................................................................................................17
4.2.1 数据表结构 ..................................................................................................................................17 4.2.2 数据库连接技术 ............................................................................................................................20 4.3 前台功能模块设计 .................................................................................................................................21
4.3.1 系统主页面结构 ..........................................................................................................................21 4.3.2 用户管理模块 ..............................................................................................................................22 4.3.3 购物车模块 ..................................................................................................................................25 4.3.4 订单查看模块 ..............................................................................................................................26 4.3.5 公告模块 ......................................................................................................................................27 4.3.6 商品搜索模块 ..............................................................................................................................27 4.3.7 订单信息管理模块 ......................................................................................................................29 4.5 后台功能模块设计 .................................................................................................................................29
湖南科技大学本科生毕业设计（论文）
4.5.1 管理员登录 ..................................................................................................................................29 4.5.2 用户信息管理模块 ......................................................................................................................30 4.5.3 店铺信息管理模块 ......................................................................................................................30 4.5.4 公告管理模块 ..............................................................................................................................31 4.5.5 商品类别管理模块 ......................................................................................................................31
第五章 系统测试及问题分析 .............................................................................................................33
5.1 系统测试 .................................................................................................................................................33 5.2 单元测试 .................................................................................................................................................33
5.2.1 注册模块测试 ..............................................................................................................................33 5.2.2 登录模块测试 ..............................................................................................................................33 5.2.3 用户信息管理测试 ......................................................................................................................33 5.2.4 购物车模块测试 ..........................................................................................................................34 5.2.5 订单模块测试 ..............................................................................................................................35 5.2.6 店铺申请模块测试 ......................................................................................................................36 5.2.7 公告新闻模块测试 ......................................................................................................................36 5.2.8 商品类别模块测试 ......................................................................................................................36 5.3 集成测试 .................................................................................................................................................37 5.4 难点分析 .................................................................................................................................................37
5.4.1 高并发访问 ..................................................................................................................................37 5.4.2 大数据处理 ..................................................................................................................................37 5.4.3 界面友好性 ..................................................................................................................................37
参 考 文 献 .....................................................................................................................................................39 致 谢 ..................................................................................................................................................................40
湖南科技大学本科生毕业设计（论文）
第一章 引 言
随着当今世界网络、通信和信息技术的发展，Internet在全球迅速普及，使得商业空间发展到全球的规模，同时也使得现代商业化企业需要具有不间断地供货能力、不断增长的客户需求和不断增强的全球竞争三大特征，这使得任何一个商业组织都必须调整自己的经营方式和产业结构，以适应新的市场发展的需要。随之出现了日益走入我们生活的网上购物。
伴随着Internet的蓬勃发展，网络购物系统作为电子商务的一种形式正以其高效，低成本的优势，逐步成为新兴的经营模式和理念，人们已经不再满足用途信息的浏览和发布，而是渴望着能够充分享受网络所带来的更加多的便利。网络购物正适应了当今社会快节奏的生活，使顾客足不出户便可以方便快捷轻松的选购自己喜欢的商品。
网络购物主要服务于国际性网络购物。1997年，当互联网在中国刚出现不久，一些精明的网站就立即意识到，将便捷的互联网与商业服务结合，就会体现出巨大的商业价值。网络购物服务能帮助顾客购买互联网上的国内外网站商品，从而既绕过了国内物流、资金流的瓶颈，又发挥了网络信息“天涯咫尺”的时空便利性。通过网络购物，用户可以规避在国际性的个人购物行为中所伴随的有关外汇管制、国际信用卡管理、进出口法规限制、海关办事效率、尚不完善的国际电子商务模式、泛滥的黑客病毒、英语读写能力限制、严重的经济风险等问题。这种“网络购物服务”使中国网民在浏览海外网站时，无需国际信用卡、无需麻烦国外亲友转寄，就能安全方便地从专业购物网站处买到各种国内没有或价格偏高的海外商品和国内正品，因此大受消费者欢迎。
网上购物正是基于这样的一个大背景下应运而生，它将传统的现金交易方式演化为网上的数字交易，大大节省了人们挑选物品的时间，加速商品的流通。
而本次设计的任务是，构建一个网上购物平台，采用的主要技术是基于java和SQLServer数据库，以及网页编程语言HTML、javascript等等。
1.1 系统开发背景
信息化的发展带来的是足不出户就可以买到自己想买的东西。越来越多的人都喜欢网络购物，网络购物满足了人们不喜欢逛商场、不喜欢像菜市场一样砍价、不喜欢走路的要求。同时，由于网上系统的营运成本低，利润低，所以通常网上系统的价格比一般实体店的价格低5%-10%左右，再者，网上系统由于中间省却了经销商、代理商环节，所以同样一种商品，可能在网上上市了半个月，而在实体店还买不到这些新品，这些中间环节省去的成本使得商品的价格变得更低，带给了消费者和服务者双重利益，所以网上购物变得越来越火。
网上系统的自身优势经过近几年的发展已经表现的较为突出。随着人们观念的改变，个性的体现被越来越多的人推崇，越来越多的年轻人钟情于奢侈品和品牌消费，但是由于工作环境的限制，时间的不充裕，还有收入水平并不能完全满足他们购买品牌产品的欲望，而网络购物则解决了他们的这点困扰，因为购物商品在价格上具有绝对的优势，而且省时又便捷，选择较国内更加丰富，地区差异的存在就会促使消费需求的产生，消费需求的产生就会衍生