电子商务网站毕业设计

电子商务毕业论文1. 前言 41.1 什么是电子商务 41.2 电子商务在中国的发展 51.3 建立一个电子商务网站的必备条件 61.4 本论文的目的和内容 71.5 范围说明 81.6 产品标识 81.7 产品概述 81.8 术语定义 82. 项目概述 82.1 产品描述 82.2 系统功能 92.3 客户特点 93. 系统亮点展示 93.1 功能上的亮点： 93.2 技术亮点 124. 数据库设计 135. 项目实施 16代码实现 16系统java源代码设计按照DAO模式设计分为3个包 16Cd包放一些bean类： 16Run包： 26Util包： 666. 运行应用程序的环境 716.1 硬件需求： 716.2 软件需求： 72
1. 前言1.1  什么是电子商务
随着互联网的普及和发展，电子商务将是企业和商家的最终选择；它具有开放性、国际性、实时性、互动性和低成本的特点，是“永不关门”的商场。经济的市场化与全球化和互联网的普及使电子商务迅猛发展。一个企业要想在短时间内了解世界或让世界了解自己，最好的方式就是登录互联网。互联网开放性、交互性的特性不仅可以保证企业在互联网中查询到自己所需要的信息，还允许企业发布自己的信息或进行网络经营。因此，制定和实施电子商务发展战略，已成为很企业优先考虑的目标，唯有这样才能站在未来企业发展的至高点，才能适应WTO和全球经济一体化的发展趋势，才能进一步提高企业核心竞争力。电子商务作为一种独立的经济形态，已初具规模。特别是以Yahoo、AOL、Amazon为代表的最早一批网站的成功，标志着Internet所创造的巨大神话以及给人类生活所带来的巨大影响。电子商务给企业带来的好处不言而喻，在市场上，电子商务被炒得沸沸扬扬，但如何建立企业的电子商务，如何把企业业务建在Internet上，这涉及到建立电子商务网站、开发符合Internet特点的有效的业务应用、管理网上的交易信息、保证网上数据安全、快速反应市场变化及充分满足Internet业务进一步发展的要求等等。因此，对于一个要求进行运营商业网站的企业来说，电子商务网站是它们生存的理由和基础，同时也是企业对外展示信息、从事商务活动的窗口和界面。因此，电子商务网站在建立企业的电子商务的诸多过程和环节中占有非常重要的地位，应予以足够的重视。如何设计、建立一个经济、实用、安全、高效、稳定的网站，是每个商业网站必须考虑的问题。
1.2  电子商务在中国的发展
近年来，随着Internet的发展和普及，我国也出现了电子商务的热潮，电子商务网站数量、规模不断增长和扩大。但我国的电子商务还未成熟，电子商务交易的电子化水平也不高，这体现在以下几个方面：（1） 目前大多数中国企业的网站还仅仅处于介绍企业的阶段。很多企业已经发展Internet为他们日常所需要处理的无数客户支持、产品咨询和问题解答提供了最好的解决方案，网络客户支持已经在90年代末期被广泛使用。不过在先进企业中，Internet网站已经全面引入到了企业的产品销售当中，也   就是通过建立企业自己的网上商店来直接销售产品和提供服务。（2） 电子商务网站数量、规模也进入了高度膨胀期。但电子商务网站的创造力去却远远滞后，盲目追随成功网站的模式使得电子商务网站呈现“百站一面”的尴尬局面。（3） 虽然目前中国绝大多数电子商务网站都已实现了网上发布产品信息以及完成订货过程，并提供网上支付，但用户多采用在线订购，离线支付。这说明这些网站尚不是真正意义上的电子商务网站，表明我国的电子商务尚未成熟、电子商务交易的电子化水平不高。（4） 网上商品价格不具竞争力，大多数产品加上运费后和传统的价格基本持平。（5） 用户对目前网上交易的安全性普遍不信任，八成以上网民对网上经营者的信誉和付款的安全性表示担忧。在这么一个充满挑战和机遇的时代大背景下，我们选择了《家家乐网站连锁系统》作为毕业设计课题。此网站系统是销售各种商品的电子商务网站。
1.3  建立一个电子商务网站的必备条件商店名称：它就象是注册商标，在网络上称为域名，整个网络世界它是唯一的。一个与您公司名称相关的网络名称可以使顾客更容易记住您的商店。     商店地点：也就是开设您的商店的网络服务器地址，高速的网络连接，就象是把商店开设闹市黄金地段，可以使顾客快速容易地抵达，这对客户的影响是十分关键的。      商店装修：网站的设计对用户来讲自然非常重要，动人的网页就像一流装修的商场，不但吸引顾客，而且增加顾客的信心。     货物摆放：在网上商店中，其反映在如何建立商品的目录结构，提供何种网站导航和搜索功能，以使得用户可以快速、便利地寻找到他需要的商品和相关信息。     购物车：方便灵巧的购物车可以使顾客感觉到受到良好的服务，增加顾客的信心。它是连接商品和付款台的关键环节。     货币结算：支付系统是网络交易的重要环节。在美国和欧洲，信用卡已经成为最普遍的电子交易方式。通过提供必要的个人信用卡资料，商店就可以通过银行计算机网络与顾客进行结算。这也是建立网络商店的必要条件。而且货币结算的安全可靠，不但关系到顾客的切身利益，同时直接关系到您商业经营的安全可靠。     商品盘点更新：对网络商店的日常维护，例如去除销售完的商品，摆上新货等等，是必须经常进行的业务。      库存商品管理：后勤保证是任何商务运作的基础。无论网络商店还是真实商店，货物和货币都是一样真实的，对库存货物的存储和管理也是一样真实的。      商品最终送达用户：网上购物实际上是邮购。最后一个步骤自然是通过邮政或其他系统将货物快速可靠地送达最终用户手中。 232CD在线商店销售系统设计|电子商务网站毕业设计|电子商务毕业论文|免费论文售后服务：不言而喻，这同样是现代商品销售的重要环节。而网络技术可以为用户提供24小时不间断的服务，这也是网络商店的优势之一。通常网络商店还要提供30天的退/换货承诺。 因此一个企业在进入电子商务领域时必须考虑如下的问题：如何申请一个自己的域名？   如何设立一个电子商务服务器？   服务器如何和Internet连接？   如何设计这个网上商店，实现各种功能？谁来设计？   谁来维护这个网站？   如何实现在线交易？   如何安全可靠地进行网络电子货币结算？   网上商店和商品库存之间如何协调？   如何快速便利地将商品投递到用户手中？   售后服务如何进行？   电子商务索引网提供全套电商解决方案
1.4  本论文的目的和内容
由于受时间和条件所限，此系统可能不能作为大型企业商品销售的网络解决方案。但该系统可适合中小型企业或中小型商店的网络销售方案。我在设计时尽量做到界面友好，容易操作。我们采用了前台与后台兼可以在浏览器中操作，但又分离的结构。此类电子商务网站的结构的特点在于1、安全性好，只有正式会员才能购买商品 。2、界面直观并容易使用。任何具有网络使用的经验的用户都可以轻松上手。3、维护方便。只要用户具有网站内部使用权限，在任何时候、任何地方只要能够进入网站就可以进行维护。4、网站更新、信息发布快速，强大、简单的后台管理功能，不需要专业的管理人员就可以管理网站后台，进行公司新闻的发布，产品的推行，会员的管理，招聘信息的发布，留言的管理。1.5  范围说明
Cdshop在线销售系统主要是针对cd的在线销售，以及cd销售的评估和测量，为彩电cd销售做为一个更有效的销售方法展示出来！
1.6  产品标识在线cd销售商店1.7  产品概述该产品cd的在线销售和彩电cd管理彩电cd信息统计。1.8  术语定义序号 术语或缩写 定义1.  系统管理员 对全部组织和用户进行管理的人员，至少一个。2.  普通用户 在网上经过注册后产生的会员，能够有权进行cd购买等服务.3.  登陆 对注册的顾客给于登陆后可进行标示功能4.  注册 对顾客给于账号和密码后可有在网站上拥有相应功能
2. 项目概述2.1  产品描述（可采用把本产品与其他产品相对比的方法、分部说明的方法及其他方法进行阐述，内容包括：功能、接口、所使用的硬件、外围设备和环境等。）本产品对管理员提供cd提供查询和出入库管理；对cd提供添加、修改、删除功能和版本控制，提供添加、修改、删除组织和用户，以及现有CD管理； 添加新CD；添加CD分类；订单管理； 用户管理； 销售统计； 退出管理等功能。在用户级别是CD浏览 ；我的购物车 ； 订单信息 ； 用户积分/等级 ； CD销售排行 ；登录/注册 等功能。本产品可用于小型局域网中，客户端可运行于windows95及以上版本，服务器端可运行于windows NT4.0及以上版本。2.2  系统功能编号 功能名称 功能描述1 Cd浏览 Cd产品的列表,cd详细信息以及不同类别的cd进行查询以及模糊查询2 我的购物车 对会员之前购买产品进行纪录和管理3 订单信息 对会员以前所有的购买进行纪录对会员的购买给于奖励措施4 会员等级 对会员按照一定的标准进行不同的标示5 Cd销售统计 对商店的cd进行销售统计，和给于顾客一定参考6 登陆注册 对未进行登陆的顾客给于登陆，和未注册的顾客给于注册功能。7 管理员入口 对进行管理的人员进入管理功能的通道8 现有cd管理 对商店中所拥有的cd进行查询，修改和删除功能9 添加新cd 添加新拥有产品的信息10 添加cd分类 添加新cd分类信息标示11 订单管理 对用户所购买cd的订单进行管理12 删除组织 从系统中删除一个组织13 销售统计 对商店中的销售情况进行查询14 添加员工 向组织中添加员工15 删除员工 从系统中删除员工16 修改员工信息 修改员工的相关信息17 移出员工 解除某一员工与所属组织的关系18 用户退出系统 在用户退出系统时做相应的操作
2.3  客户特点本产品针对需要cd服务的顾客以最快最方便和清晰的信息显示。3. 系统亮点展示3.1  功能上的亮点：1、页面模块化本系统在界面设计上都采用了模块化处理思想，把很多页面共有部分集成一个模块，例如页面的头，尾和导航条，这样在开发时遇到这些相似的页面部分，就不需要重新编写，而只要以一句：<%@include file = "CDshop/inc/head.inc" %>重用这部分即可，大大提高了开发效率。为了提高代码的重用性，我们把管理界面部分相同头和尾做成两个模块分别命名为adm_head.inc和adm_tail.inc。读者可以在光盘里的，本章源代码的inc文件夹下找到这两个文件。两个文件都是纯html代码这里就不详细介绍了。读者可以用一个简单的jsp文件，其中只需写上以下两句代码，运行后就可以看见页面头尾的效果。<%@include file=" CDshop /inc/adm_head.inc"%><%@include file=" CDshop /inc/adm_tail.inc"%>为了提高代码的重用性，我们把客户界面部分相同头和尾做成两个模块分别命名为head.inc和tail.inc。读者可以在光盘里本章源代码的inc文件夹下找到这两个文件。两个文件都是纯html代码这里就不详细介绍了。读者可以用一个简单的jsp文件，其中只需写上以下两句代码，就可以看见页面头尾效果。<%@include file=" CDshop /inc/head.inc"%><%@include file=" CDshop /inc/tail.inc"%>2、功能全面客户界面的系统功能模块图如图1-1所示。 图1-1 客户界面的功能模图管理界面的功能模块图如图1-2所示。CD在线商店销售系统设计图1-2管理界面的功能模块图3、人性化设计：本系统导航的另一个亮点就是导航明晰。这样，不管客户位于本“商店”的哪个角落，都不会迷路。图1-3是客户正确登录后的第一个界面。从图中可以看出，客户登录后可以购买，可以查看CD详细资料，可以按关键字/分类查询CD，也可以方便快捷的转到本系统其他功能模块。 图1-3 客户登录后的主界面图1-4为管理员登录后的主界面。从图中可以看出，管理员登录后，可以查看/修改CD资料，可以删除CD资料，也可以迅速转到其他功能模块。对比图1-3、1-4，细心的读者便可以发现它们有很多类似的地方，这种类似主要体现在页面的头和尾上。头和尾是单独的两个模块，模块化思想是本实例的亮点。模块化可以提高代码的重用性，可以节省人力财力，提高开发效率。 图1-4 管理员登录后的主界面3.2  技术亮点1、三层结构设计本系统采用三层结构设计，即程序逻辑结构分为用户界面层、业务逻辑处理层和数据存储层。三层在实际的物理结构上也是独立的，业务逻辑处理层采用javaBean实现，用户界面与业务逻辑分离，系统的安全性、可维护性、重用性和可扩展性都大大提高。它的工作原理如图1-5所示。 图1-5 三层架构的工作原理图采用三层架构以后，用户界面层通过统一的接口向业务层发送请求，业务层按自己的逻辑规则将请求处理之后进行数据库操作，然后将数据库返回的数据封装成类的形式返回给用户界面层。这样用户界面层甚至可以不知道数据库的结构，它只要维护与业务层之间的接口即可。这种方式在一定程度上增加了数据库的安全性，同时也降低了对用户界面层开发人员的要求，因为它根本不需要进行任何数据库操作。上面javaBean通过返回对象的形式来返回数据，在类的内部可以规定哪些数据可访问，那些数据是只读的等，从而通过封装数据达到再一次提高数据的安全性的目的。2、面向对象设计系统中将用户、CD等都封装成相应的类，同时每个类都有自己对应的操作类，从而再次提高了对数据库操作的安全性和程序的可扩展性。图1-6为系统包图。 图1-6 系统包图从图1-6中可以看到，在run包下有五个类，其中各个类的作用如下： login类：管理用户登录。 op_cd类：管理CD，包括CD的查询，修改，删除，添加等。 op_cdclass类：管理CD分类包括CD分类的查询，添加和删除。 op_buy类：管理订单，包括订单的查询，添加，修改和删除等。 op_user类：管理用户，包括用户的查询，添加，删除和修改等。 op_sale_statistics类：管理CD的销售统计。在util包下有两个类，其中各个类的作用如下： DataBase类：该类主要负责数据库的连接。 dataFormat类：该类负责数据的格式转换，例如将字符串格式化成 HTML 代码输出等。在cd包下有6个类，其中各个类的作用如下： allorder类：订单列表类。 cd类：CD类，是CD实体的抽象。 cdclass类：CD分类类，是CD分类实体的抽象。 order类：订单类，是订单实体的抽象。 shopcar：购物车类，是购物车实体的抽象。 user类：用户类，是用户实体的抽象4. 数据库设计在做了调查后，了解了有关本系统的有关信息以及阅读一些有关这方面的资料后，开始建立数据库。本系统的主要数据库包括6张表：CDadmin，CDclass，allorder，orders，shop_user，CD。其中shop_user 表 存储会员信息，orders表 存储客户在购买商品时放入购物车的信息，allorder 表存储客户的全部定单信息，CDclass 表存储cd的种类信息，CD 表存储每类商品里不同类型，型号的cd信息，CDadmin表存储管理员的信息。CD在线商店销售系统设计if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[updateUserPoint]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[updateUserPoint]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CDadmin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CDadmin]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CDclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CDclass]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[allorder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[allorder]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[orders]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[shop_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[shop_user]GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[CD]GO//管理员表CREATE TABLE [dbo].[CDadmin] ( [AdminUser] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [AdminPass] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO//cd分类表CREATE TABLE [dbo].[CDclass] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [ClassName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY]GO//订单管理表CREATE TABLE [dbo].[allorder] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [orderId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [CDNo] [int] NOT NULL , [Amount] [int] NULL ) ON [PRIMARY]GO//用户订单表CREATE TABLE [dbo].[orders] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [orderId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserId] [int] NOT NULL , [SubmitTime] [datetime] NOT NULL , [ConsignmentTime] [datetime] NULL , [TotalPrice] [float] NULL , [content] [text] COLLATE Chinese_PRC_CI_AS NULL , [IPAddress] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [IsPayoff] [int] NULL , [IsSales] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO//用户表CREATE TABLE [dbo].[shop_user] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [PassWord] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Names] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [Address] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL , [Phone] [varchar] (25) COLLATE Chinese_PRC_CI_AS NULL , [Post] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [RegTime] [datetime] NULL , [RegIpAddress] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [userpoint] [int] NULL ) ON [PRIMARY]GO//cd信息表 CREATE TABLE [dbo].[CD] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [CDName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL , [CDClass] [int] NOT NULL , [Singer] [varchar] (25) COLLATE Chinese_PRC_CI_AS NULL , [Publish] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL , [CDNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [MusicList] [text] COLLATE Chinese_PRC_CI_AS NULL , [Price] [float] NULL , [Amount] [int] NULL , [Leav_number] [int] NULL , [RegTime] [datetime] NOT NULL , [picture] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO
SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO//创建存储过程更新会员点数create  PROCEDURE dbo.updateUserPoint (@userid varchar(10),@point varchar(10))ASdeclare @sql varchar(8000)beginset @sql='update shop_user set userpoint=userpoint+'+@point+' where id='+@userid ;exec (@sql)end
GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO电子商务网站毕业设计5. 项目实施
代码实现
系统java源代码设计按照DAO模式设计分为3个包
Cd包放一些bean类：allorder.java类package cdshop.cd;/** *

Title:

 */public class allorder {        private long Id;   //ID序列号        private long orderId;   //订单号表序列号        private long cdNo;   //CD表序列号        private int Amount;   //购买数量
        public allorder() {                Id = 0;                orderId = 0;                cdNo = 0;                Amount = 0;        }        public long getId() {                return Id;        }        public void setId(long newId) {                this.Id = newId;        }        public long getOrderId() {                return orderId;        }        public void setOrderId(long orderId) {                this.orderId = orderId;        }        public long getcdNo() {                return cdNo;        }        public void setcdNo(long newcdNo) {                this.cdNo = newcdNo;        }        public int getAmount() {                return Amount;        }        public void setAmount(int newAmount) {                this.Amount = newAmount;        }}cd.javapackage cdshop.cd;
/** *

CD类

 */
public class cd {        private long Id;  //ID序列号        private String cdName;         //CD名称        private int cdClass;  //CD类别        private String classname ;      //CD类别名        private String Singer;  //歌手        private String Publish;  //发行公司        private String cdNo ;  //CD编号        private String musiclist ; //歌曲列表        private float Price ;  //售价        private int Amount ;  //总数量        private int Leav_number ; //剩余数量        private String RegTime ; //登记时间        private String picture ; //CD封面文件的名称        /**         * 图书的初始化         */        public cd() {                Id = 0;                cdName = "";                cdClass = 0;                classname = "";                Singer = "";                Publish = "";                cdNo = "";                musiclist = "";                Price = 0;                Amount = 0;                Leav_number = 0;                RegTime = "";        }        public void setId(long newId){                this.Id = newId;        }        public long getId(){                return Id;        }        public void setcdName(String newcdName) {                this.cdName = newcdName;        }        public String getcdName() {                return cdName;        }        public void setcdClass(int newcdClass) {                this.cdClass = newcdClass;        }        public int getcdClass() {                return cdClass;        }        public void setClassname(String cname) {                this.classname = cname;        }        public String getClassname() {                return classname;        }        public void setSinger(String newSinger) {                this.Singer = newSinger;        }        public String getSinger() {                return Singer;        }        public void setcdNo(String newcdNo) {                this.cdNo = newcdNo;        }        public String getcdNo() {                return cdNo;        }        public void setPublish(String newPublish) {                this.Publish = newPublish;        }        public String getPublish() {                return Publish;        }        public void setmusiclist(String newmusiclist) {                this.musiclist= newmusiclist;        }        public String getmusiclist() {                return musiclist;        }        public void setPrice(float newPrice) {                this.Price = newPrice;        }        public float getPrice() {                return Price;        }        public void setAmount(int newAmount) {                this.Amount = newAmount;        }        public long getAmount() {                return Amount;        }        public void setLeav_number(int newLeav_number) {                this.Leav_number = newLeav_number;        }        public int getLeav_number() {                return Leav_number;        }        public void setRegTime(String newRegTime) {                this.RegTime = newRegTime;        }lwfree.cncdclass.javapackage cdshop.cd;/** *

CD分类类

 */public class cdclass {        private int Id;   //ID序列号        private String ClassName; //CD类别        public cdclass() {                Id = 0;                ClassName = "";              }        public cdclass(int newId, String newname) {                Id = newId;                ClassName = newname;              }        public int getId() {                return Id;              }电子商务网站毕业设计   public void setId (int newId) {                this.Id = newId;              }        public String getClassName() {                return ClassName;             }        public void setClassName(String newname) {                this.ClassName = newname;            }}order.javapackage cdshop.cd;/** *

订单类

 */public class order {        private long Id;   //ID序列号        private String orderId;          //订单编号        private long UserId;   //用户序列号        private String SubmitTime;  //提交订单时间        private String ConsignmentTime;         //交货时间        private float TotalPrice;  //总金额        private String content;          //用户备注        private String IPAddress;  //下单时IP        private boolean IsPayoff;  //用户是否已付款        private boolean IsSales;  //是否已发货
        public order() {                Id = 0;                orderId = "";                UserId = 0;                SubmitTime = "";                ConsignmentTime = "";                TotalPrice = 0;                content = "";                IPAddress = "";                IsPayoff = false;                IsSales = false;        }        public long getId() {                return Id;        }        public void setId(long newId){                this.Id = newId;        }        public String getOrderId() {                return orderId;        }        public void setOrderId(String neworderId) {                this.orderId = neworderId;        }        public long getUserId() {                return UserId;        }        public void setUserId(long newUserId){                this.UserId = newUserId;        }        public String getSubmitTime() {                return SubmitTime;        }        public void setSubmitTime(String newSubmitTime) {                this.SubmitTime = newSubmitTime;        }        public String getConsignmentTime() {                return ConsignmentTime;        }        public void setConsignmentTime(String con_time) {                ConsignmentTime = con_time;        }        public float getTotalPrice() {                return TotalPrice;        }        public void setTotalPrice(float newTotalPrice){                this.TotalPrice = newTotalPrice;        }        public String getContent() {                return content;        }        public void setContent(String newContent) {                this.content = newContent;        }        public String getIPAddress() {                return IPAddress;        }        public void setIPAddress(String newIPAddress) {                this.IPAddress = newIPAddress;        }        public boolean getIsPayoff() {                return IsPayoff;        }        public void setIsPayoff(boolean newIsPayoff){                this.IsPayoff = newIsPayoff;        }        public boolean getIsSales() {                return IsSales;        }        public void setIsSales(boolean newIsSales){                this.IsSales = newIsSales;        }}shopcar.javapackage cdshop.cd;/** *

Title:

 */public class shopcar {
 private long cdId;  //CDID编号 private int quanlity;  //选购数量
 public shopcar(){   cdId = 0;   quanlity = 0;  }  public long getcdId() {   return cdId;  }  public void setcdId(long newcdId) {   cdId = newcdId;  }lwfree.cnpackage cdshop.cd;/** *

用户类

 */public class user {        private long Id;  //ID序列号        private String UserName; //购物用户名        private String PassWord;        //用户密码        private String Names;  //用户联系用姓名        private String Sex;  //用户性别        private String Address;  //用户联系地址        private String Phone;  //用户联系电话        private String Post;  //用户联系邮编        private String Email;    //用户电子邮件        private String RegTime;  //用户注册时间        private String RegIpAddress;    //用户注册时IP地址        private int UserPoint;          //用户积分        public user() {                Id = 0;                UserName = "";                PassWord = "";                Names = "";                Sex = "";                Address = "";                Phone = "";                Post = "";                Email = "";                RegTime = "";                RegIpAddress = "";                UserPoint=0;        }        public long getId() {                return Id;        }        public void setId(long newId) {                this.Id = newId;        }        public String getUserName() {                return UserName;        }        public void setUserName(String newUserName) {                this.UserName = newUserName;        }        public String getPassWord() {                return PassWord;        }        public void setPassWord(String newPassWord) {                this.PassWord = newPassWord;电子商务毕业论文 }        public String getNames() {                return Names;        }        public void setNames(String newNames) {                this.Names = newNames;        }        public String getSex() {                return Sex;        }        public void setSex(String newSex) {                this.Sex = newSex;        }        public String getAddress() {                return Address;        }        public void setAddress(String newAddress) {                this.Address = newAddress;        }        public String getPhone() {                return Phone;        }        public void setPhone(String newPhone) {                this.Phone = newPhone;        }        public String getPost() {                return Post;        }        public void setPost(String newPost) {                this.Post = newPost;        }        public String getEmail() {                return Email;        }        public void setEmail(String newEmail) {                this.Email = newEmail;        }        public String getRegTime() {                return RegTime;        }        public void setRegTime(String newRegTime) {                this.RegTime = newRegTime;        }        public String getRegIpAddress() {                return RegIpAddress;        }        public void setRegIpAddress(String newRegIpAddress) {                this.RegIpAddress = newRegIpAddress;        }        public int getUserPoint() {                return UserPoint;        }        public void setUserPoint(int userpoint) {                this.UserPoint = userpoint;        }
}Run包：login.javapackage cdshop.run;/** *

管理用户登录的类

 */import cdshop.util.*;public class login extends DataBase {        private String username; //登录用户名        private String passwd;  //登录密码        private boolean isadmin; //是否管理员登录        private long userid=0;  //用户ID号        public login() throws Exception{                super();                username = "";                passwd = "";                isadmin = false;        }        public String getUsername() {                return username;        }        public void setUsername(String newusername) {                username = newusername;        }        public String getPasswd() {                return passwd;        }        public void setPasswd(String newpasswd) {                passwd = newpasswd;        }        public boolean getIsadmin() {                return isadmin;        }        public void setIsadmin(boolean newIsadmin) {                isadmin = newIsadmin;        }        public long getUserid() {                return userid;        }        public void setUserid (long uid) {                userid = uid;        }        /**         * 获得查询用户信息的sql语句         * @return         */        public String getSql() {                if (isadmin) {                        sqlStr = "select * from cdAdmin where adminuser = '" +                            dataFormat.toSql(username) + "' and adminpass = '" +                            dataFormat.toSql(passwd) + "'";                }else {                        sqlStr = "select * from shop_user where username = '" +                            username + "' and password = '" + passwd + "'";                }                return sqlStr;        }        /**         * 执行查询         * @return         * @throws java.lang.Exception         */        public boolean excute() throws Exception {                boolean flag = false;                DataBase db = new DataBase();                db.connect();                stmt = db.conn.createStatement ();                rs = stmt.executeQuery(getSql());                if (rs.next()){                        if (!isadmin)                        {                                userid = rs.getLong("id");CD在线商店销售系统设计          }                        flag = true;                }                close();                return flag;        }};
op_buy.java类：package cdshop.run;
/** *

Title:

 *

Description:

 *

Copyright: Copyright (c) 2004

 *

Company:

 * @Singer not attributable * @version 1.0 */
import java.sql.*;import java.util.Vector;import cdshop.util.*;import cdshop.cd.*;import javax.servlet.http.*;import java.util.*;public class op_buy extends DataBase {
    private javax.servlet.http.HttpServletRequest request; //建立页面请求    private HttpSession session; //页面的session;    private boolean sqlflag = true; //对接收到的数据是否正确    private Vector purchaselist; //显示CD列表向量数组    private Vector allorder; //订购单列表    private Vector order_list; //订单清单列表    private int cdnumber = 0; //购买CD总数量    private float all_price = 0; //购买CD总价钱    private boolean isEmpty = false; //库中的CD数量是否够购买的数    private int leavecd = 0; //库存数量    private String orderId = ""; //用户订单号    private boolean isLogin = true; //用户是否登录！    private int page = 1; //显示的页码    private int pageSize = 15; //每页显示的订单数    private int pageCount = 0; //页面总数    private long recordCount = 0; //查询的记录总数
    Calendar date = Calendar.getInstance();    long time=date.getTimeInMillis();
 
    public op_buy() {      super();  }    public Vector getPurchaselist() {      return purchaselist;    }    public Vector getOrder_list() {      return order_list;    }    public Vector getAllorder() {      return allorder;    }    public boolean getSqlflag() {      return sqlflag;    }    public void setIsEmpty(boolean flag) {      isEmpty = flag;    }    public boolean getIsEmpty() {      return isEmpty;    }    public void setLeavecd(int bknum) {      leavecd = bknum;    }    public int getLeavecd() {      return leavecd;    }    public void setOrderId(String newId) {      orderId = newId;    }    public String getOrderId() {      return orderId;    }    public void setIsLogin(boolean flag) {      isLogin = flag;    }    public boolean getIsLogin() {      return isLogin;    }    public int getPage() { //显示的页码      return page;    }    public void setPage(int newpage) {      page = newpage;    }    public int getPageSize() { //每页显示的图书数      return pageSize;    }    public void setPageSize(int newpsize) {      pageSize = newpsize;    }    public int getPageCount() { //页面总数      return pageCount;    }    public void setPageCount(int newpcount) {      pageCount = newpcount;    }    public long getRecordCount() {      return recordCount;    }    public void setRecordCount(long newrcount) {      recordCount = newrcount;    }    public String getGbk(String str) {      try {        return new String(str.getBytes("ISO8859-1"));      }      catch (Exception e) {        return str;      }    }
    public String getSql() {      sqlStr = "select id,classname from cd order by id";      return sqlStr;    }    /**     * 往购物车中添加选购的图书     * @param newrequest     * @return     */    public boolean addnew(HttpServletRequest newrequest) {      request = newrequest;      String ID = request.getParameter("cdid");      String Amount = request.getParameter("amount");      long cdid = 0;      int amount = 0;      try {        cdid = Long.parseLong(ID);        amount = Integer.parseInt(Amount);      }      catch (Exception e) {        return false;      }      if (amount < 1)        return false;      session = request.getSession(false);      if (session == null) {        return false;      }      purchaselist = (Vector) session.getAttribute("shopcar");      sqlStr = "select leav_number from cd where id=" + cdid;      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        rs = stmt.executeQuery(sqlStr);        if (rs.next()) {          if (amount > rs.getInt(1)) {            leavecd = rs.getInt(1);            isEmpty = true;            return false;          }        }        close();      }      catch (SQLException e) {        return false;      }
      allorder iList = new allorder();      iList.setcdNo(cdid);      iList.setAmount(amount);      boolean match = false; //是否购买过该图书CD在线商店销售系统设计|电子商务网站毕业设计|电子商务毕业论文|免费论文 if (purchaselist == null) { //第一次购买        purchaselist = new Vector();        purchaselist.addElement(iList);      }
      else { // 不是第一次购买        for (int i = 0; i < purchaselist.size(); i++) {          allorder itList = (allorder) purchaselist.elementAt(i);          if (iList.getcdNo() == itList.getcdNo()) {            itList.setAmount(itList.getAmount() + iList.getAmount());            purchaselist.setElementAt(itList, i);            match = true;            break;          } //if name matches结束        } // for循环结束        if (!match)          purchaselist.addElement(iList);      }      session.setAttribute("shopcar", purchaselist);      return true;    }    /**     * 修改已经放进购物车的数据     * @param newrequest     * @return     */    public boolean modiShoper(HttpServletRequest newrequest) {      request = newrequest;      String ID = request.getParameter("cdid");      String Amount = request.getParameter("amount");      long cdid = 0;      int amount = 0;      try {        cdid = Long.parseLong(ID);        amount = Integer.parseInt(Amount);      }      catch (Exception e) {        return false;      }      if (amount < 1)        return false;      session = request.getSession(false);      if (session == null) {        return false;      }      purchaselist = (Vector) session.getAttribute("shopcar");      if (purchaselist == null) {        return false;      }      sqlStr = "select leav_number from cd where id=" + cdid;      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        rs = stmt.executeQuery(sqlStr);        if (rs.next()) {          if (amount > rs.getInt(1)) {            leavecd = rs.getInt(1);            isEmpty = true;            return false;          }        }        close();      }      catch (SQLException e) {        return false;      }      for (int i = 0; i < purchaselist.size(); i++) {        allorder itList = (allorder) purchaselist.elementAt(i);        if (cdid == itList.getcdNo()) {          itList.setAmount(amount);          purchaselist.setElementAt(itList, i);          break;        } //if name matches结束      } // for循环结束      return true;    }    /**     *删除购物车中数据     * @param newrequest     * @return     */    public boolean delShoper(HttpServletRequest newrequest) {      request = newrequest;      String ID = request.getParameter("cdid");      long cdid = 0;      try {        cdid = Long.parseLong(ID);      }      catch (Exception e) {        return false;      }      session = request.getSession(false);      if (session == null) {        return false;      }      purchaselist = (Vector) session.getAttribute("shopcar");      if (purchaselist == null) {        return false;      }
      for (int i = 0; i < purchaselist.size(); i++) {        allorder itList = (allorder) purchaselist.elementAt(i);        if (cdid == itList.getcdNo()) {          purchaselist.removeElementAt(i);          break;        } //if name matches结束      } // for循环结束      return true;    }    /**     * 提交购物车     * @param newrequest     * @return     * @throws java.lang.Exception     */    public boolean payout(HttpServletRequest newrequest) throws Exception {      op_user opUser=new op_user();      request = newrequest;      session = request.getSession(false);    // System.out.print("f1");      if (session == null) {        return false;      }      String Userid = (String) session.getAttribute("userid"); //取得用户ID号      long userid = 0;      if (Userid == null || Userid.equals("")) {        isLogin = false;        return false;      }      else {        try {          userid = Long.parseLong(Userid);        }        catch (NumberFormatException e) {        //  System.out.print(e.getMessage());          return false;        }      }lwfree.cn      String TotalPrice = request.getParameter("totalprice");      float payPrice=(Float.parseFloat(TotalPrice))*opUser.getUserRate(Userid);      long timeInMillis = System.currentTimeMillis();  //System.out.println("f4");      sqlStr = "insert into orders (orderId,UserId,SubmitTime,ConsignmentTime,TotalPrice,content,IPAddress,IsPayoff,IsSales) values (";      orderId=""+timeInMillis;//以系统时间产生位移的订单编号      sqlStr = sqlStr  + orderId + ",'";      sqlStr = sqlStr + userid + "',GETDATE(),GETDATE()+7,'";      sqlStr = sqlStr + payPrice + "','";      sqlStr = sqlStr + dataFormat.toSql(Content) + "','";      sqlStr = sqlStr + IP + "',1,1)";    //  System.out.print(sqlStr);    //String setIdSql="udate orders set orderid=orderid+id where UserId = " + userid;      try {        stmt.execute(sqlStr);        //stmt.execute(setIdSql);       // sqlStr = "select max(id) from orders where UserId = " + userid;       // rs = stmt.executeQuery(sqlStr);电子商务网站毕业设计//long indentid = 0;       // while (rs.next()) {         // indentid = rs.getLong(1);        //}        //close();        for (int i = 0; i < purchaselist.size(); i++) {          allorder iList = (allorder) purchaselist.elementAt(i);          sqlStr =              "insert into allorder (orderId,cdNo,Amount) values (";          sqlStr = sqlStr + orderId + ",'";          sqlStr = sqlStr + iList.getcdNo() + "','";          sqlStr = sqlStr + iList.getAmount() + "')";          stmt.execute(sqlStr);          sqlStr = "update cd set leav_number=leav_number - " +              iList.getAmount() + " where id = " + iList.getcdNo();          stmt.execute(sqlStr);          //更新用户积分          String priceString=TotalPrice.toString();          int point=Integer.parseInt((priceString).substring(0,priceString.indexOf(".")));          System.out.println("dddddd:"+point);          op_user oper=new op_user();          oper.updateUserPoint(""+userid,point);
        }        return true;      }      catch (SQLException e) {        System.out.print(e.getMessage());        return false;      }
    }    /**     * 查询指定用户id的所有订单     * @param userid     * @return     */    public boolean getOrder(long userid) {      sqlStr = "select * from orders where userid = '" + userid +          "' order by id desc";      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        rs = stmt.executeQuery(sqlStr);        allorder = new Vector();        while (rs.next()) {          order ind = new order();          ind.setId(rs.getLong("id"));          ind.setOrderId(rs.getString("orderId"));          ind.setUserId(rs.getLong("userid"));          ind.setSubmitTime(rs.getString("submitTime"));          ind.setConsignmentTime(rs.getString("ConsignmentTime"));          ind.setTotalPrice(rs.getFloat("TotalPrice"));          ind.setContent(rs.getString("content"));          ind.setIPAddress(rs.getString("IpAddress"));          if (rs.getInt("IsPayoff") == 1)            ind.setIsPayoff(false);          else            ind.setIsPayoff(true);          if (rs.getInt("IsSales") == 1)            ind.setIsSales(false);          else            ind.setIsSales(true);          allorder.addElement(ind);        }        close();        return true;      }      catch (SQLException e) {        return false;      }    }    /**     * 查询指定订单编号的订单     * @param iid     * @return     */    public boolean getSinggleOrder(String order_id) {      sqlStr = "select * from orders where orderId = '" + order_id +          "' ";      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        rs = stmt.executeQuery(sqlStr);        allorder = new Vector();        while (rs.next()) {          order ind = new order();          ind.setId(rs.getLong("id"));          ind.setOrderId(rs.getString("orderId"));          ind.setUserId(rs.getLong("userid"));          ind.setSubmitTime(rs.getString("submitTime"));          ind.setConsignmentTime(rs.getString("ConsignmentTime"));          ind.setTotalPrice(rs.getFloat("TotalPrice"));          ind.setContent(rs.getString("content"));          ind.setIPAddress(rs.getString("IpAddress"));          if (rs.getInt("IsPayoff") == 1)            ind.setIsPayoff(false);          else            ind.setIsPayoff(true);          if (rs.getInt("IsSales") == 1)            ind.setIsSales(false);          else            ind.setIsSales(true);          allorder.addElement(ind);          System.out.print("allorder:"+allorder.size());        }        close();        return true;      }      catch (SQLException e) {        System.out.print(e.getMessage());        return false;      }    }    /**     * 查询商店的所有订单数据     * @return     */    public boolean getOrder() {      sqlStr = "select count(*) from orders"; //取出记录数      int rscount = pageSize;      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        ResultSet rs1 = stmt.executeQuery(sqlStr);        if (rs1.next())          recordCount = rs1.getInt(1);        rs1.close();      }      catch (SQLException e) {        return false;      }      //设定有多少pageCount      if (recordCount < 1)        pageCount = 0;      else        pageCount = (int) (recordCount - 1) / pageSize + 1;        //检查查看的页面数是否在范围内      if (page < 1)        page = 1;      else if (page > pageCount)        page = pageCount;
      rscount = (int) recordCount % pageSize; // 最后一页记录数
      //sql为倒序取值      sqlStr = "select  * from orders ";      if (page == 1) {        sqlStr = sqlStr + " order by Id desc";      }      else {        sqlStr = sqlStr + " order by Id desc  limit "+(recordCount - pageSize * page) +","+ (recordCount - pageSize * (page - 1));
      }
      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        rs = stmt.executeQuery(sqlStr);        allorder = new Vector();        while (rs.next()) {          order ind = new order();          ind.setId(rs.getLong("id"));          ind.setOrderId(rs.getString("orderid"));          ind.setUserId(rs.getLong("userid"));CD在线商店销售系统设计|电子商务网站毕业设计|电子商务毕业论文|免费论文ind.setSubmitTime(rs.getString("submitTime"));          ind.setConsignmentTime(rs.getString("ConsignmentTime"));          ind.setTotalPrice(rs.getFloat("TotalPrice"));          ind.setContent(rs.getString("content"));          ind.setIPAddress(rs.getString("IpAddress"));          if (rs.getInt("IsPayoff") == 1)            ind.setIsPayoff(false);          else            ind.setIsPayoff(true);          if (rs.getInt("IsSales") == 1)            ind.setIsSales(false);          else            ind.setIsSales(true);          allorder.addElement(ind);        }        close();        return true;      }      catch (SQLException e) {        System.out.println(e);        return false;      }    }    /**     * 获得订单列表     * @param nid     * @return     */    public boolean getAllorder(String order_id) {      sqlStr = "select * from allorder where orderId = '" + order_id + "'";      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();
        rs = stmt.executeQuery(sqlStr);        order_list = new Vector();        while (rs.next()) {          allorder identlist = new allorder();          identlist.setId(rs.getLong("id"));          identlist.setOrderId(rs.getLong("orderId"));          identlist.setcdNo(rs.getLong("cdNo"));          identlist.setAmount(rs.getInt("Amount"));          order_list.addElement(identlist);        }        close();        return true;      }      catch (SQLException e) {        System.out.print(e.getMessage());        return false;      }    }    /**     * 修改订单，修改付款标志     * @param res     * @return     */    public boolean update(HttpServletRequest res) {      request = res;      int payoff = 1;      int sales = 1;      //long orderId = 0;      try {        System.out.println("payoff:"+request.getParameter("payoff"));        payoff = Integer.parseInt(request.getParameter("payoff"));        sales = Integer.parseInt(request.getParameter("sales"));        orderId =request.getParameter("indentid");        sqlStr = "update orders set IsPayoff = '" + payoff + "',IsSales='" +            sales + "' where orderId =" + orderId;        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();                  System.out.print(sqlStr);        stmt.execute(sqlStr);        return true;      }      catch (Exception e) {        System.out.print(e.getMessage());        return false;      }    }    /**     * 删除订单     * @param id     * @return     */    public boolean delete(long id) {      try {        DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();        sqlStr = "delete from allorder where id =" + id;        stmt.execute(sqlStr);        sqlStr = "delete from orders where id= " + id;        stmt.execute(sqlStr);        return true;      }      catch (SQLException e) {        return false;      }    }
  }op_cd.java类：package cdshop.run;/** *

管理CD的类，包括CD的修改、查询，删除，添加

 */import java.sql.*;import java.util.Vector;import cdshop.util.*;import cdshop.cd.*;import javax.servlet.http.HttpServletRequest;
public class op_cd extends DataBase{  private cd acds = new cd();                        //新的CD类        private javax.servlet.http.HttpServletRequest request; //建立页面请求        private boolean sqlflag = true ;      //对接收到的数据是否正确        private Vector cdlist;       //显示CD列表向量数组        private int page = 1;           //显示的页码        private int pageSize=10;    //每页显示的CD数        private int pageCount =0;    //页面总数        private long recordCount =0;           //查询的记录总数        public String sqlStr="";        public Vector getcdlist() {                return cdlist;        }        public boolean getSqlflag() {                return sqlflag;        }        public String to_String( String str) {                try                {                        return new String(str.getBytes("ISO8859-1"));                }                catch (Exception e)                {                        return str;                }        }        /**         * 将页面表单传来的资料分解         */public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {  boolean flag = false;  try{   request = newrequest;   String ID = request.getParameter("id");   long cdid = 0;   try{           cdid = Long.parseLong(ID);   }catch (Exception e){   }   acds.setId(cdid);   String cdname = request.getParameter("cdname");   if (cdname==null || cdname.equals(""))   {           cdname = "";           sqlflag = false;   }   acds.setcdName(to_String(cdname));   String Singer = request.getParameter("Singer");   if (Singer==null || Singer.equals(""))   {           Singer = "";           sqlflag = false;   }   acds.setSinger(to_String(Singer));   String publish = request.getParameter("publish");;   if (publish==null)   {           publish = "";CD在线商店销售系统设计 }   acds.setPublish(to_String(publish));   String cdclass = request.getParameter("cdclass");   int bc = Integer.parseInt(cdclass);   acds.setcdClass(bc);   String cdno = request.getParameter("cdno");   if (cdno == null)   {           cdno = "";   }   acds.setcdNo(to_String(cdno));   String picture = request.getParameter("picture");   if (picture == null)   {           picture = "images/01.gif";   }   acds.setPicture(to_String(picture));   float price;   try {           price =new Float(request.getParameter("price")).floatValue();   } catch (Exception e){           price = 0;           sqlflag = false;   }   acds.setPrice(price);   int amount;   try{           amount = new Integer(request.getParameter("amount")).intValue();   }catch (Exception e){           sqlflag = false;           amount = 0;   }   acds.setAmount(amount);   String musiclist = request.getParameter("musiclist");   if (musiclist == null)   {           musiclist = "";   }   acds.setmusiclist(to_String(musiclist));   if (sqlflag)   {           flag = true;   }   return flag;                }catch (Exception e){   return flag;                }        }        /**         * 获得查询CD类别的sql语句         * @return         */public String getSql() {   sqlStr = "select id,classname from cd order by id";   return sqlStr;        }        /**         * 完成CD查询，包括分类，分页查询         * @param res         * @return         * @throws java.lang.Exception         */public boolean cd_search(HttpServletRequest res) throws Exception {   DataBase db = new DataBase();   db.connect();   stmt = db.conn.createStatement ();   request = res;   String PAGE = request.getParameter("page");   //页码   String classid = request.getParameter("classid"); //分类ID号   String keyword = request.getParameter("keyword"); //查询关键词   if (classid==null) classid="";   if (keyword==null) keyword = "";   keyword = to_String(keyword).toUpperCase();   try {           page = Integer.parseInt(PAGE);   }catch (NumberFormatException e){           page = 1;   }   //取出记录数   if (!classid.equals("") && keyword.equals("") ) {           sqlStr = "select count(*) from cd where cdclass='"+classid + "'";      }  else if (!keyword.equals("")) {      if (classid.equals("")){           sqlStr = "select count(*) from cd where upper(cdname) like '%" +                    keyword+ "%' or musiclist like '%" + keyword + "%'";      } else {          sqlStr = "select count(*) from cd where cdclass='" + classid                   + "' and  (upper(cdname) like '%" +keyword+ "%' or "+                   "musiclist like '%" + keyword + "%')";           }   } else {           sqlStr = "select count(*) from cd";          }   int rscount = pageSize;   try {           ResultSet rs1 = stmt.executeQuery(sqlStr);           if (rs1.next()) recordCount = rs1.getInt(1);           rs1.close();   }catch (SQLException e){           System.out.println(e.getMessage());           return false;   }   //设定有多少pageCount   if (recordCount < 1)            pageCount = 0;   else            pageCount = (int)(recordCount - 1) / pageSize + 1;   //检查查看的页面数是否在范围内   if (page < 1)            page = 1;  else if (page > pageCount)            page = pageCount;            rscount = (int) recordCount % pageSize;  // 最后一页记录数   //sql为倒序取值   sqlStr = "select  a.id,a.cdname,a.cdclass,b.classname,"+           "a.Singer,a.publish,a.cdno,a.musiclist,a.Price,a.amount,"+           "a.Leav_number,a.regtime,a.picture from cd a,cdclass b"+          " where a.cdclass = b.Id ";  if (!classid.equals("") && keyword.equals("") ){  //如果类别不为空，非查询           if (page == 1)           {               sqlStr = sqlStr + " and a.cdclass='" + classid + "' "+               "order by a.Id desc";           } else {               sqlStr = "select top "+ pageSize+" from (select top "+(recordCount-pageSize * (page-1)) +"from ("+sqlStr + " and a.cdclass='" + classid + "'))";
           }  } else if (!keyword.equals("")) {  //如果是查询资料    if (page == 1){      if (!classid.equals("")) {//查询某一类         sqlStr = sqlStr + "and a.cdclass='" +         classid + "' and (upper(a.cdname) like '%" +         keyword+ "%' or a.musiclist like '%" +         keyword + "%')  order by a.Id desc";      } else {  //查询所有类        sqlStr = sqlStr + " and (upper(a.cdname) like '%" +        keyword+ "%' or a.musiclist like '%" +        keyword + "%') order by a.Id desc";      }     } else {      if (!classid.equals("")){           sqlStr = "select top "+ pageSize+" from (select top "+(recordCount-pageSize * (page-1)) +"from ("+sqlStr + " and a.cdclass='" +           classid + "' and (upper(a.cdname) like '%" +           keyword+ "%' or a.musiclist like '%" +           keyword + "%') ))";      } else {            sqlStr = "select top "+ pageSize+" from (select top "+(recordCount-pageSize * (page-1)) +"from ("+sqlStr + " and (upper(a.cdname) like '%" +            keyword+ "%' or a.musiclist like '%" +            keyword + "%') ))";            }                        }  } else {//非查询，也非分类浏览    if (page == 1) {      sqlStr = sqlStr + "  order by a.Id desc ";    }    else {      sqlStr = "select top " + pageSize + " from (select top " +          (recordCount - pageSize * (page - 1)) + "from (" + sqlStr + "))";    }  }        try  {
         // System.out.println(sqlStr);
              rs = stmt.executeQuery(sqlStr);CD在线商店销售系统设计  cdlist = new Vector(rscount);              while (rs.next()){                                cd cd = new cd();                                cd.setId(rs.getLong("id"));                                cd.setcdName(rs.getString("cdname"));                                cd.setcdClass(rs.getInt("cdclass"));                                cd.setClassname(rs.getString("classname"));                                cd.setSinger(rs.getString("Singer"));                                cd.setPublish(rs.getString("publish"));                                cd.setcdNo(rs.getString("cdno"));                                cd.setmusiclist(rs.getString("musiclist"));                                cd.setPrice(rs.getFloat("Price"));                                cd.setAmount(rs.getInt("amount"));                                cd.setLeav_number(rs.getInt("leav_number"));                                cd.setRegTime(rs.getString("regtime"));                                cd.setPicture(rs.getString("picture"));                                cdlist.addElement(cd);                        }                        close();                        return true;                }catch (Exception e){                        System.out.println(e.getMessage());                        return false;                }        }        /**         * 完成CD添加         * @return         * @throws java.lang.Exception         */ public boolean insert() throws Exception {  sqlStr = "insert into cd (cdname,cdclass,Singer,Publish,cdno,"+           "musiclist,Price,Amount,Leav_number,Regtime,picture) values ('";           sqlStr = sqlStr + dataFormat.toSql(acds.getcdName()) + "','";           sqlStr = sqlStr + acds.getcdClass() + "','";           sqlStr = sqlStr + dataFormat.toSql(acds.getSinger()) + "','";           sqlStr = sqlStr + dataFormat.toSql(acds.getPublish()) + "','";           sqlStr = sqlStr + dataFormat.toSql(acds.getcdNo()) + "','";           sqlStr = sqlStr + dataFormat.toSql(acds.getmusiclist()) + "','";           sqlStr = sqlStr + acds.getPrice() + "','";           sqlStr = sqlStr + acds.getAmount() + "','";           sqlStr = sqlStr + acds.getAmount() + "',";           sqlStr = sqlStr + "GETDATE()"+ ",'";           sqlStr = sqlStr + acds.getPicture()+"')";                try{                        System.out.print(sqlStr);                        DataBase db = new DataBase();                        db.connect();                        stmt =db.conn.createStatement ();                        stmt.execute(sqlStr);                        return true;                }catch (SQLException sqle){                  System.out.print(sqle.getMessage());                        return false;                }        }        /**         * 完成CD修改         * @return         * @throws java.lang.Exception         */public boolean update() throws Exception {  sqlStr = "update cd set ";  sqlStr = sqlStr + "cdname = '" + dataFormat.toSql(acds.getcdName()) + "',";  sqlStr = sqlStr + "cdclass = '" + acds.getcdClass() + "',";  sqlStr = sqlStr + "Singer = '" + dataFormat.toSql(acds.getSinger()) + "',";  sqlStr = sqlStr + "publish = '" + dataFormat.toSql(acds.getPublish()) + "',";  sqlStr = sqlStr + "cdno = '" + dataFormat.toSql(acds.getcdNo()) + "',";  sqlStr = sqlStr + "musiclist = '" + dataFormat.toSql(acds.getmusiclist()) + "',";  sqlStr = sqlStr + "Price = '" + acds.getPrice() + "',";  sqlStr = sqlStr + "Amount = '" + acds.getAmount() + "',";  sqlStr = sqlStr + "picture = '" + acds.getPicture() + "' ";  sqlStr = sqlStr + "where id = " + acds.getId();                try{                        DataBase db = new DataBase();                        db.connect();                        stmt =db.conn.createStatement ();                        stmt.execute(sqlStr);                        return true;                } catch (SQLException e){                        System.out.print(e.getMessage());                        return false;                }
        }        /**         * 完成CD删除         * @param aid         * @return         * @throws java.lang.Exception         */        public boolean delete( int aid ) throws Exception {                sqlStr = "delete from cd where id = "  + aid ;                try                {         DataBase db = new DataBase();                          db.connect();                          stmt =db.conn.createStatement ();                          stmt.execute(sqlStr);                         return true;                }                catch (SQLException e)                {                        System.out.println(e);                        return false;                }              }              /**               * 完成CD单本查询，用于支持页面的查看CD详细资料               * @param newid               * @return               * @throws java.lang.Exception               */ public boolean getOnecd(int newid ) throws Exception {     DataBase db = new DataBase();     db.connect();     stmt =db.conn.createStatement ();     try {        sqlStr="select  a.id,a.cdname,a.cdclass,b.classname,a.Singer,"+        "a.publish,a.cdno,a.musiclist,a.Price,a.amount,a.Leav_number,"+        "a.regtime,a.picture from cd a,cdclass b where a.cdclass="+        "b.Id and a.Id = " + newid ;                        rs = stmt.executeQuery(sqlStr);                        if (rs.next())                        { cdlist = new Vector(1);                                cd cd = new cd();                                cd.setId(rs.getLong("id"));                                cd.setcdName(rs.getString("cdname"));                                cd.setcdClass(rs.getInt("cdclass"));                                cd.setClassname(rs.getString("classname"));                                cd.setSinger(rs.getString("Singer"));                                cd.setPublish(rs.getString("publish"));                                cd.setcdNo(rs.getString("cdno"));                                cd.setmusiclist(rs.getString("musiclist"));                                cd.setPrice(rs.getFloat("Price"));                                cd.setAmount(rs.getInt("amount"));                                cd.setLeav_number(rs.getInt("leav_number"));                                cd.setRegTime(rs.getString("regtime"));                                cd.setPicture(rs.getString("picture"));                                cdlist.addElement(cd);                        } else {                                close();                                return false;                        }                        close();                        return true;                }                catch (SQLException e)                {                        return false;                }        }        public int getPage() {    //显示的页码                return page;        }        public void setPage(int newpage) {                page = newpage;        }        public int getPageSize(){   //每页显示的CD数                return pageSize;        }CD在线商店销售系统设计 public void setPageSize(int newpsize) {                pageSize = newpsize;        }        public int getPageCount() {    //页面总数                return pageCount;        }        public void setPageCount(int newpcount) {                pageCount = newpcount;        }        public long getRecordCount() {                return recordCount;        }        public void setRecordCount(long newrcount) {                recordCount= newrcount;        }  public op_cd() {       }}op_cdclass.javapackage cdshop.run;/** *

Title:

 */import java.util.*;import cdshop.util.*;import cdshop.cd.*;import java.sql.*;import java.lang.String;import javax.servlet.http.HttpServletRequest;
public class op_cdclass extends DataBase{  public op_cdclass() {  }  private cdclass cdclass = new cdclass(); //新的CD分类  private javax.servlet.http.HttpServletRequest request; //建立页面请求  private Vector classlist;  //CD类别向量数组  public Vector getClasslist() {        return classlist;          }  public String getcdClassSql() {                  sqlStr = "select id,classname from cdclass order by id";                  return sqlStr;          }          //查询CD分类  public boolean seachcdClass() throws Exception {                  int id = 0;                  String classname = "";                  int rscount = 0;                  try {                  DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();                  rs = stmt.executeQuery(getcdClassSql());                  rscount = stmt.getMaxRows();                  classlist = new Vector(rscount+1);                  classlist.clear();                  while (rs.next()){                                  id = rs.getInt("id");                                  classname = rs.getString("classname");                                  cdclass bc = new cdclass(id,classname);                                  classlist.addElement(bc);                          }                          close();                          return true;                  }                  catch (SQLException sqle){                          System.out.println(sqle);              return false;                  }          }          //添加新CD分类时获得页面转递的分类名称public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {     boolean flag = false;     try{         request = newrequest;         String cdclassname = request.getParameter("cdclassname");          if (cdclassname==null || cdclassname.equals("")){              cdclassname = "";              flag = false;              }              cdclass.setClassName(cdclassname);              return true;          }catch (Exception e){            return false;            }    }    //添加新的CD分类        public boolean insert() throws Exception {           sqlStr = "insert into cdclass (classname) values ('";           sqlStr = sqlStr + dataFormat.toGb(cdclass.getClassName()) + "')";                      try                      {      System.out.print(sqlStr);                        DataBase db = new DataBase();                              db.connect();                              stmt =db.conn.createStatement ();                              stmt.execute(sqlStr);                              return true;                      }                      catch (SQLException sqle)                      {        System.out.print(sqle.getMessage());                              return false;                      }              }          //删除CD分类          public boolean delete( int aid ) throws Exception {               sqlStr = "delete from cdclass where id = "  + aid ;               try               {         DataBase db = new DataBase();                          db.connect();                          stmt =db.conn.createStatement ();                       stmt.execute(sqlStr);                       return true;               }               catch (SQLException e)               {                       System.out.println(e);                       return false;               }       }  };
op_sale_statistics.java：package cdshop.run;
/** *

Title:

 *

Description:

 *

Copyright: Copyright (c) 2004

 *

Company:

 * @Singer not attributable * @version 1.0 */import java.util.*;import cdshop.util.*;public class op_sale_statistics extends DataBase {
  ArrayList al=new ArrayList();
  public op_sale_statistics() {  }
public ArrayList getSaleNumOrder(String classid,String keyword)       {         String sql="";         if((classid!=null&&!classid.equals(""))&&(keyword==null||keyword.equals("")))          {  sql= "select top 100 cd.cdname cdname,sum(allorder.amount) num "+                   " from allorder,cd,cdclass "+                   "  where allorder.cdno=cd.id  "+                   "  and cd.cdclass=cdclass.id "+                   "  and cdclass.id='"+classid+"'"+                   "  group by cdname  "+                   "  order by num desc ";          }        else  if((classid==null||classid.equals(""))&&(keyword!=null&&!keyword.equals("")))           {  sql= "select top 100 cd.cdname cdname,sum(allorder.amount) num "+                    " from allorder,cd,cdclass "+                    "  where allorder.cdno=cd.id  "+                    "  and cd.cdclass=cdclass.id "+                    "  and cd.cdname like '%"+dataFormat.toUni(keyword)+"%' "+                    "  group by cdname  "+                    "  order by num desc ";           }        else   if((classid!=null&&!classid.equals(""))&&(keyword!=null&&!keyword.equals("")))            {  sql= "select top 100 cd.cdname cdname,sum(allorder.amount) 电子商务网站毕业设计num "+                     " from allorder,cd,cdclass "+                     "  where allorder.cdno=cd.id  "+                     "  and cd.cdclass=cdclass.id "+                     "  and cdclass.id='"+classid+"'"+                     "  and cd.cdname like '%"+dataFormat.toUni(keyword)+"%' "+                     "  group by cdname  "+                     "  order by num desc ";            }          else          {            sql = "select top 100 cd.cdname cdname,sum(allorder.amount) num from allorder,cd " +                    " where allorder.cdno=cd.id " +                    " group by cdname " +                    " order by num desc";          }
         try{             DataBase db = new DataBase();             db.connect();             stmt = db.conn.createStatement ();             System.out.println(sql);             rs=stmt.executeQuery(sql);             while (rs.next())                {                   String [] result=new String[2];                   result[0]=rs.getString("cdname");                   result[1]=rs.getString("num");                   al.add(result);                 }                   return al;             } catch (Exception e){                   System.out.println(e.getMessage());                   return null;             }
  }
}op_user.java：package cdshop.run;
/** *

Title:

 *

Description:

 *

Copyright: Copyright (c) 2004

 *

Company:

 * @Singer not attributable * @version 1.0 */import java.sql.*;import java.util.Vector;import javax.servlet.http.HttpServletRequest;import cdshop.util.*;import cdshop.cd.*;
public class op_user extends DataBase{        private user user = new user();                         //新的用户对象        private javax.servlet.http.HttpServletRequest request;  //建立页面请求        private Vector userlist;   //显示用户列表向量数组        private int page = 1;     //显示的页码        private int pageSize=8;     //每页显示的图书数        private int pageCount =0;    //页面总数        private long recordCount =0;           //查询的记录总数        private String message = "";           //出错信息提示        private String username = "";         //注册后返回的用户名        private long userid = 0;        //注册后返回的用户ID
  public op_user() {  }  //添加新用户  public boolean add(HttpServletRequest req) throws Exception {        if (getRequest(req)) {            DataBase db = new DataBase();            db.connect();            stmt = db.conn.createStatement ();            sqlStr = "select * from shop_user where username = '" +                      user.getUserName() +"'";            sqlStr = "insert into shop_user (username,password,Names,sex,"+                     "Address,Phone,Post,Email,RegTime,RegIpaddress) values ('";            sqlStr = sqlStr + dataFormat.toSql(user.getUserName()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getPassWord()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getNames()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getSex()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getAddress()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getPhone()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getPost()) + "','";            sqlStr = sqlStr + dataFormat.toSql(user.getEmail()) + "',GETDATE(),'";            sqlStr = sqlStr + user.getRegIpAddress() + "')";            try{                stmt.executeUpdate(sqlStr);                sqlStr = "select max(id) from shop_user where username = '" +                         user.getUserName()+ "'";                         rs = stmt.executeQuery(sqlStr);                         while (rs.next()){                              userid = rs.getLong(1);                              }                             close();                             return true;                }catch (Exception sqle){                  System.out.print(sqle.getMessage());                  return false;                }           } else{            return false;           }
  }  //分析页面转递的参数  public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {       boolean flag = false;       try {        request = newrequest;        String ID = request.getParameter("userid");        if (ID!=null ){        userid = 0;        try{            userid = Long.parseLong(ID);            user.setId(userid);            }catch (Exception e){                 message = message + "你要修改的用户号出错！";            }         }
         username = request.getParameter("username");         if (username==null || username.equals("")){              username = "";              message = message + "用户名为空!";              }              user.setUserName(getGbk(username));              String password = request.getParameter("passwd");              if (password==null || password.equals("")){                  password = "";                  message = message + "密码为空!";                  }              String pwdconfirm = request.getParameter("passconfirm");              if (!password.equals(pwdconfirm)){                 message = message + "确认密码不相同!";                 }              user.setPassWord(getGbk(password));              String names = request.getParameter("names");;              if (names==null){                   names = "";                   }              user.setNames(getGbk(names));              String sex = request.getParameter("sex");              user.setSex(getGbk(sex));              String address = request.getParameter("address");              if (address == null){                   address = "";                  }              user.setAddress(getGbk(address));              String post = request.getParameter("post");              if (post == null){                  post = "";                 }               user.setPost(getGbk(post));              String phone = request.getParameter("phone");              if (phone== null){                  phone = "";              }             user.setPhone(phone);             String email = request.getParameter("email");             if (email == null){                  email = "";电子商务网站毕业设计     }              user.setEmail(getGbk(email));             String IP = request.getRemoteAddr();             user.setRegIpAddress(IP);             if (message.equals("")){                  flag = true;                  }               return flag;        }catch (Exception e){            return flag;            } } //查询商店所有的用户public boolean get_alluser() throws Exception {      sqlStr = "select count(*) from shop_user";    //取出记录数      int rscount = pageSize;      try{        DataBase db = new DataBase();        db.connect();        stmt = db.conn.createStatement ();        ResultSet rs1 = stmt.executeQuery(sqlStr);        if (rs1.next()) recordCount = rs1.getInt(1);        rs1.close();        }catch (SQLException e){          System.out.print("count:"+e.getMessage());          return false;        }                                //设定有多少pageCount        if (recordCount < 1)           pageCount = 0;        else           pageCount = (int)(recordCount - 1) / pageSize + 1;                                //检查查看的页面数是否在范围内        if (page < 1)           page = 1;        else if (page > pageCount)          page = pageCount;          rscount = (int) recordCount % pageSize;  // 最后一页记录数                                //sql为倒序取值          sqlStr = "select  * from shop_user ";          if (page == 1){             sqlStr = sqlStr + " order by Id desc ";             } else {               sqlStr = "select top"+ pageSize+" from(select top "+(recordCount - pageSize * (page-1))+  sqlStr + " order by Id desc ))";               }        try{          DataBase db = new DataBase();          db.connect();          stmt = db.conn.createStatement ();          rs = stmt.executeQuery(sqlStr);          userlist = new Vector();          while (rs.next()){                user user = new user();                user.setId(rs.getLong("id"));                user.setUserName(rs.getString("username"));                user.setPassWord(rs.getString("password"));                user.setNames(rs.getString("names"));                user.setSex(rs.getString("sex"));                user.setAddress(rs.getString("address"));                user.setPhone(rs.getString("Phone"));                user.setPost(rs.getString("post"));                user.setEmail(rs.getString("email"));                user.setRegTime(rs.getString("regtime"));                user.setRegIpAddress(rs.getString("RegIpaddress"));                user.setUserPoint(rs.getInt("userpoint"));                userlist.addElement(user);                }                close();                 return true;            }catch (SQLException e){              System.out.print(e.getMessage());              return false;              }
}//修改用户public boolean update(HttpServletRequest req) throws Exception {if (getRequest(req)){sqlStr = "update shop_user set ";sqlStr = sqlStr + "username = '" + dataFormat.toSql(user.getUserName()) + "',";sqlStr = sqlStr + "password = '" + dataFormat.toSql(user.getPassWord()) + "',";sqlStr = sqlStr + "Names = '" + dataFormat.toSql(user.getNames()) + "',";sqlStr = sqlStr + "sex = '" + dataFormat.toSql(user.getSex()) + "',";sqlStr = sqlStr + "address = '" + dataFormat.toSql(user.getAddress()) + "',";sqlStr = sqlStr + "phone = '" + dataFormat.toSql(user.getPhone()) + "',";sqlStr = sqlStr + "post = '" + dataFormat.toSql(user.getPost()) + "',";sqlStr = sqlStr + "Email = '" + dataFormat.toSql(user.getEmail()) + "' ";sqlStr = sqlStr + " where id = '" + user.getId() + "'";try{                  DataBase db = new DataBase();                  db.connect();                  stmt = db.conn.createStatement ();                  stmt.execute(sqlStr);                  return true;    } catch (SQLException e){      return false;       }} else {       return false;       }
}//删除用户 public boolean delete( long aid ) throws Exception {    sqlStr = "delete from shop_user where id = "  + aid ;    try{      DataBase db = new DataBase();      db.connect();      stmt = db.conn.createStatement ();      stmt.execute(sqlStr);      return true;       }catch (SQLException e){        System.out.println(e);        return false;        }}//查询指定id的用户，用于支持页面的查看详细资料请求 public boolean  getUserinfo(long newid ) throws Exception {    try{      sqlStr="select  * from shop_user where Id = " + newid ;      DataBase db = new DataBase();      db.connect();      stmt = db.conn.createStatement ();      rs = stmt.executeQuery(sqlStr);      userlist = new Vector();      while (rs.next()){        user.setId(rs.getLong("id"));        System.out.print(rs.getLong("id"));        user.setUserName(rs.getString("username"));        user.setPassWord(rs.getString("password"));        user.setNames(rs.getString("names"));        user.setSex(rs.getString("sex"));        user.setAddress(rs.getString("address"));        user.setPhone(rs.getString("Phone"));        user.setPost(rs.getString("post"));        user.setEmail(rs.getString("email"));        user.setRegTime(rs.getString("regtime"));        user.setRegIpAddress(rs.getString("RegIpaddress"));        user.setUserPoint(rs.getInt("userpoint"));         userlist.addElement(user);         }         close();         return true;        }catch (Exception e){          System.out.print(e.getMessage());          return false;        }}//修改用户积分  public  boolean   updateUserPoint(String userid,int num)  {    String point=num+"";    String sql="EXECUTE updateUserPoint "+userid+","+point;    //String sql="update shop_user set userpoint=userpoint +"+num+" where id='"+userid+"'";    try{             DataBase db = new DataBase();             db.connect();             stmt = db.conn.createStatement ();              System.out.println(sql);             stmt.execute(sql);             return true;        } catch (SQLException e){          System.out.println(e.toString());         return false;        }  }  //取得用户的积分  public int getUserPoint(String userid)  {电子商务毕业论文String sql="select userpoint from shop_user where id='"+userid+"'";    try{             DataBase db = new DataBase();             db.connect();             stmt = db.conn.createStatement ();             rs=stmt.executeQuery(sql);             if(rs.next())               return rs.getInt("userpoint");             else return 0;        } catch (SQLException e){         return 0;        }
  }  //根据用户积分，获得用户可以享受的折扣  public float getUserRate(String userid)  {    int userPoint=this.getUserPoint(userid);    int lerver=userPoint/100;    switch (lerver)    {      case 0:return 1.0f;      case 1:return 0.95f;      case 2:return 0.90f;      case 3:return 0.85f;      case 4:return 0.80f;      case 5:return 0.75f;      default:return 0.75f;    }
  }  public String getGbk( String str) {               try  {                return new String(str.getBytes("ISO8859-1"));                }catch (Exception e){                  return str;                  }          }  public int getPage() {    //显示的页码                              return page;                      }                      public void setPage(int newpage) {                              page = newpage;                      }
                      public int getPageSize(){   //每页显示的CD数                              return pageSize;                      }                      public void setPageSize(int newpsize) {                              pageSize = newpsize;                      }
                      public int getPageCount() {  //页面总数                              return pageCount;                      }                      public void setPageCount(int newpcount) {                              pageCount = newpcount;                      }
                      public long getRecordCount() {                              return recordCount;                      }                      public void setRecordCount(long newrcount) {                              recordCount= newrcount;                      }
                      public String getMessage() {                              return message;                      }
                      public void setMessage(String msg) {                              message = msg;                      }
                      public void setUserid(long uid) {                              userid = uid;                      }                      public long getUserid() {                              return userid;                      }
                      public void setUserName(String uName) {                              username = uName;                      }
                      public String getUserName() {                              return username;                      }                      public Vector getUserlist() {                           return userlist;                       }
};
Util包：DataBase.java：package cdshop.util;/** *

数据库连接专用包

 *

Copyright: wxy Copyright (c) 2004

 *

Company:CD Shop

 * @by :wxy * @version 1.0 */import java.sql.*;import javax.sql.*;import javax.naming.*;public class DataBase {  public Connection conn;  public Statement stmt;  public ResultSet rs=null;  public InitialContext ctx=null;  DataSource ds = null;  public String sqlStr="";
  public DataBase() {    this.connect();  } public boolean connect(){
   /*   try{        Class.forName("org.gjt.mm.mysql.Driver").newInstance();        String url ="jdbc:mysql://localhost/cdStore?user=wxy&useUnicode=true&characterEncoding=8859_1";        conn=DriverManager.getConnection(url);        stmt = conn.createStatement ();       }catch(Exception ee){        System.out.println("connect db error:"+ee.getMessage());        return false;       }      */     /* try{       ctx = new InitialContext();        if (ctx == null)          throw new Exception("没有匹配的上下文环境");
        ds = (DataSource) ctx.lookup("java:comp/env/jdbc/SqlServermidp");        if (ds == null)          throw new Exception("没有匹配的数据库");        conn = ds.getConnection();        stmt=conn.createStatement();
      }catch(Exception ee){       System.out.println("connect db error:"+ee.getMessage());       return false;      }      */
       try{       Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();       String url="jdbc:microsoft:sqlserver://localhost:1305;DatabaseName=cdstore";       String user="sa";       String password="sa";       conn= DriverManager.getConnection(url,user,password);       stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);     }catch(Exception ee){     System.out.println("connect db error:"+ee.getMessage());     return false;    }      return true;    } public void close() {电子商务网站毕业设计try{      if(rs!=null)rs.close();      if(stmt!=null)stmt.close();      if(conn!=null)conn.close();
    }catch(Exception ee){       System.out.println("connect db error:"+ee.getMessage());       return ;      }
 }
 public static void main(String[] args) {     try{            DataBase db = new DataBase();            db.connect();          }catch(Exception e){            e.printStackTrace();          }        }}
dataFormat.java：package cdshop.util;
/** *

负责字符串的处理

 */import java.lang.*;import java.util.*;
public class dataFormat {  public dataFormat() {  }  /**   * 把字符串转换成适合于网页显示的文本   * @param s   * @return   */  public static String toHtml(String s) {     if (s==null) return s;     s=strReplace(s,"&","&");     s=strReplace(s,"<","<");     s=strReplace(s,">",">");     s=strReplace(s,"\"",""");     s=parseReturn(s,"
\n    ");     return s;   }   /**    * 把字符串sBody中的sFrom用sTo替换    * @param sBody    * @param sFrom    * @param sTo    * @return    */   public static String strReplace(String sBody, String sFrom, String sTo) {      int i,j,k,l;      if (sBody==null || sBody.equals("")) return "";      i = 0;      j = sFrom.length();      k = sTo.length();      StringBuffer sss = new StringBuffer(sBody.length());      boolean bFirst=true;      l = i;      while (sBody.indexOf(sFrom,i)!=-1) {        i = sBody.indexOf(sFrom,i);        sss.append(sBody.substring(l,i));        sss.append(sTo);        i += j;        l = i;      }      sss.append(sBody.substring(l));      return sss.toString();    }    /**       * 把字符串中的"\r\n"转换成"\n"       * @param String sBody  : 要进行替换操作的字符串       * @param String sEndwith : 要替换成为的字符串       */      public static String parseReturn(String sBody, String sEndwith) {        StringTokenizer t = new StringTokenizer(sBody, "\r\n");        StringBuffer sss = new StringBuffer(sBody.length());        boolean bFirst=true;        if (sEndwith.trim().equals("")) sEndwith="\n";        while (t.hasMoreTokens()) {          String s=t.nextToken();          s=s.trim();          while (s.startsWith("　")) s=s.substring(2);          if (!s.equals("")) {             if (bFirst) {              bFirst=false;            } else {              sss.append(sEndwith);            }            sss.append(s);         }        }        return sss.toString();      }      /**          * 将字符串格式化成 HTML 代码输出          * 只转换特殊字符，适合于 HTML 中的表单区域          * @param str 要格式化的字符串          * @return 格式化后的字符串          */         public static String toHtmlInput(String str) {             if (str == null)    return null;             String html = new String(str);             html = strReplace(html, "&", "&");             html = strReplace(html, "<", "<");             html = strReplace(html, ">", ">");             return html;         }      /**     * 将普通字符串格式化成数据库认可的字符串格式     *     * @param str 要格式化的字符串     * @return 合法的数据库字符串     */    public static String toSql(String str) {        String sql = new String(str);        return strReplace(sql, "'", "''");    }    /**     * 把字符串转换成GBK编码     * @param uniStr     * @return     */    public static String toGb(String uniStr){      String gbStr = "";      if(uniStr == null){        uniStr = "";      }      try{        byte[] tempByte = uniStr.getBytes("ISO8859_1");        gbStr = new String(tempByte,"GB2312");      }      catch(Exception ex){        System.out.println(ex.toString());      }      return gbStr;    }    /**     * 把字符串转换成uincode编码     * @param gbStr     * @return     */public static String toUni(String gbStr){      String uniStr = "";      if(gbStr == null){        gbStr = "";      }      try{        byte[] tempByte = gbStr.getBytes("GB2312");        uniStr = new String(tempByte,"ISO8859_1");      }catch(Exception ex){      }      return uniStr;    }public static String toString(String gbStr){          return gbStr;        }}CD在线商店销售系统设计|电子商务网站毕业设计|电子商务毕业论文|免费论文6. 运行应用程序的环境6.1  硬件需求：服务器：CPU：PII350以上；内存：基本要求64MB，建议128MB以上；硬盘空间：至少2G或以上的剩余空间。客户端：CPU：PII350以上；内存：基本要求64MB；硬盘空间：至少1G或以上的剩余空间。6.2  软件需求：操作系统：NT Server NT4.0； Service  Pack3； Windows 2000 Server。需安装的软件：1、必须正确安装JDK，并配置好环境变量,JDK安装及环境变量配置演示。2、Tomcat必须正确安装,Tomcat安装，及简单测试演示。3、下载并正确安装连接SQL Server数据库的驱动程序从网站http://www.microsoft.com/downloads/release.asp?releaseid=38312下载驱动安装程序下载完成后双击下载的exe文件，按照提示便可以完成驱动程序的安装，安装完成后，需要复制驱动程序安装目录lib文件夹下的三个jar文件（一般在C:\Program Files\Microsoft SQL Server 2000Driver for JDBC\lib下）到tomcat安装目录的common\lib文件夹4、因为本章数据库采用的是SQL Server,所以本机必须安装SQL Server