摘 要
随着网络技术的发展，Internet变成了一种处理日常事务的交互式的环境。互联网上开展各种服务已经成为许多企业和部门的急切需求。Web的普遍使用从根本上改变了人们的生活方式、工作方式，也改变了企业的经营方式和服务方式。人们可以足不出户办理各种事情。网上购物也受到越来越多的人的青睐，而团购更是为消费者、商家以及网站管理者三方都带来了益处。
美嘉网站的系统功能：前台包括用户注册登录，今日团购，往期团购，购物车，论坛，广告等。后台包括用户管理，权限管理，商品管理，订单管理，发布公告，发送邮件，统计等内容。本文首先对系统需求分析做了详细介绍，然后对系统的概要设计进行了阐述，并重点介绍了美嘉网站的功能模块的具体设计和实现。
本系统是用MySQL5.1数据库、Java语言和MyEclipse9.0平台编写实现的。使用SSH2框架整合，框架结构清晰，开发流程一目了然，开发人员可以很好的掌控开发的过程。系统不仅拥有友好方便的前台操作界面，也有稳定的后台支持。作为一种该研究方向的探索，系统旨在提供一个可以操作、功能完全、特色突出的费用审批系统。
关键词：团购网站；JAVA；MyEclipse9.0；MySQL5.1
With the development of the network technology,the Internet has become an interactive environment to hand daily affairs. Many enterprises and departments are in great needs of carrying out various services on the Internet.The widespread of Web fundamentally changes people’s style of living and workiing as well as the way of processing business and service in the enterprises. Peolpe can deal with a variety of things at home. Nowadays shopping online has been more and more popular, especially group purchase,which brings benefits for consumers,businesses and the website manager.
The foreground views of website Meijia includes: users registering and logining, today merchandise,previous merchandise, shopcart, forum, advertisement etc. The background functions of website Meijia includes: users management, priviledge management, merchandise management,order management,announce management, sending E-mail and making statistics .etc.In this report, we firstly make a detailed introduction of the system requirements analysis.Then the sysytem design is described while at last we take a lot of space to explain the function module and how to design and implementation.
The system uses MySQL5.1 database ，java language and MyEclipse9.0 to achieve．It not only has a convenient and friendly front interface，but also consist a stable background support． As an exploration of the research,the system is designed to provide an operable，fully functional and distinctive group purchase system．
Key words：group puechase system；JAVA；MyEclipse9.0；MySQL5.1
目 录
1.1 选题背景………………………………………………………………………………………….. 2
1.2 团购网发展………………………………………………………………………………………. 3
1.3 团购网意义………………………………………………………………………………………. 3
2.1 系统需求分析…………………………………………………………………………………… 5
2.2 系统开发工具…………………………………………………………………………………… 6
2.2.1 MyEclipse9.0………………………………………………………………………………. 6
2.2.2 MySQL5.1………………………………………………………………………………….. 6
3.1系统功能结构设计…………………………………………………………………………….. 8
3.2系统业务流程设计…………………………………………………………………………….. 9
3.3数据库设计………………………………………………………………………………………. 11
3.3.1数据库概念设计……………………………………………………………………… 11
3.3.2数据库逻辑设计…………………………………………………………………….. 19
3.4数据库连接方法………………………………………………………………………………. 22
4.1团购网前台……………………………………………………………………………………… 23
4.1.1用户注册模块………………………………………………………………………… 23
4.1.2用户登录模块………………………………………………………………………… 25
4.1.3首页商品列表及详情……………………………………………………………… 28
4.1.4商品检索……………………………………………………………………………….. 30
4.1.5购物车及订单模块…………………………………………………………………. 31
4.1.6个人中心……………………………………………………………………………….. 33
4.1.7火热论坛模块………………………………………………………………………… 35
4.2后台功能模块………………………………………………………………………………….. 38
4.2.1系统登录模块………………………………………………………………………… 38
4.2.2主页面…………………………………………………………………………………… 40
4.2.3用户管理模块………………………………………………………………………… 41
4.2.3.1权限控制……………………………………………………………………… 41
4.2.3.2个人信息……………………………………………………………………… 44
4.2.3.3普通用户……………………………………………………………………… 46
4.2.3.4管理员…………………………………………………………………………. 49
4.2.3商品管理模块………………………………………………………………………… 53
4.2.4订单管理模块………………………………………………………………………… 54
4.2.5发布公告模块………………………………………………………………………… 57
4.2.6邮件管理模块………………………………………………………………………… 58
4.2.7广告管理模块………………………………………………………………………… 61
4.2.8统计模块……………………………………………………………………………….. 62
5.1系统测试…………………………………………………………………………………………. 64
5.1.1测试过程……………………………………………………………………………….. 64
5.1.2测试目的……………………………………………………………………………….. 64
5.1.3测试方法和工具…………………………………………………………………….. 65
5.2系统运行…………………………………………………………………………………………. 65
5.3系统维护…………………………………………………………………………………………. 66
Ⅰ 英文原文…………………………………………………………………………………………. 69
Ⅱ 中文译文…………………………………………………………………………………………. 73
