易买网JAVAWEB源码，可运行，内含sql数据

/* SQLyog 企业版 - MySQL GUI v8.14 MySQL - 5.5.40 : Database - easybuy ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`easybuy` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `easybuy`; /*Table structure for table `easybuy_news` */ DROP TABLE IF EXISTS `easybuy_news`; CREATE TABLE `easybuy_news` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键', `title` varchar(40) NOT NULL COMMENT '标题', `content` varchar(1000) NOT NULL COMMENT '内容', `createTime` varchar(10) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `PK__EASYBUY___C63B5EE724927208` (`id`), UNIQUE KEY `UQ__EASYBUY___C12AD09D276EDEB3` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=704 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_news` */ insert into `easybuy_news`(`id`,`title`,`content`,`createTime`) values (531,'会员特惠月开始了','会员特惠月开始了,亲们赶快下单啊,不到剁手誓不罢休啊,不到离婚誓不清空购物车啊。更多优惠，尽在易买网。','2010-12-22'),(597,'迎双旦促销大酬宾','迎双旦促销大酬宾','2010-12-24'),(649,'加入会员，赢千万大礼包','加入会员，赢千万大礼包','2010-12-22'),(650,'新年不夜天，通宵也是开张了','新年不夜天，通宵也是开张了','2011-05-22'),(651,'积分兑换开始了','积分兑换开始了','2010-12-22'),(653,'团购阿迪1折起','团购阿迪1折起','2010-12-22'),(664,'最新酷睿笔记本','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(675,'aa','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(676,'ResultR','ResultResultResultResultResu','2016-03-28'),(677,'会员特惠月开始了1','会员特惠月开始了','2010-12-22'),(678,'迎双旦促销大酬宾2','迎双旦促销大酬宾','2010-12-24'),(679,'加入会员，赢千万大礼包3','加入会员，赢千万大礼包','2010-12-22'),(680,'新年不夜天，通宵也是开张了4','新年不夜天，通宵也是开张了','2011-05-22'),(681,'积分兑换开始了5','积分兑换开始了','2010-12-22'),(682,'团购阿迪1折起6','团购阿迪1折起','2010-12-22'),(683,'最新酷睿笔记本7','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(684,'aa8','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(685,'ResultR9','ResultResultResultResultResu','2016-03-28'),(686,'会员特惠月开始了11','会员特惠月开始了','2010-12-22'),(687,'迎双旦促销大酬宾21','迎双旦促销大酬宾','2010-12-24'),(688,'加入会员，赢千万大礼包31','加入会员，赢千万大礼包','2010-12-22'),(689,'新年不夜天，通宵也是开张了41','新年不夜天，通宵也是开张了','2011-05-22'),(690,'积分兑换开始了51','积分兑换开始了','2010-12-22'),(691,'团购阿迪1折起61','团购阿迪1折起','2010-12-22'),(692,'最新酷睿笔记本71','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(693,'aa81','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(694,'ResultR91','ResultResultResultResultResu','2016-03-28'),(695,'会员特惠月开始了111','会员特惠月开始了','2010-12-22'),(696,'迎双旦促销大酬宾211','迎双旦促销大酬宾','2010-12-24'),(697,'加入会员，赢千万大礼包311','加入会员，赢千万大礼包','2010-12-22'),(698,'新年不夜天，通宵也是开张了411','新年不夜天，通宵也是开张了','2011-05-22'),(699,'积分兑换开始了511','积分兑换开始了','2010-12-22'),(700,'团购阿迪1折起611','团购阿迪1折起','2010-12-22'),(701,'最新酷睿笔记本711','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(702,'aa811','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(703,'ResultR911','ResultResultResultResultResu','2016-03-28'); /*Table structure for table `easybuy_order` */ DROP TABLE IF EXISTS `easybuy_order`; CREATE TABLE `easybuy_order` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `userId` int(255) DEFAULT NULL COMMENT '用户主键', `loginName` varchar(255) DEFAULT NULL, `userAddress` varchar(255) DEFAULT NULL COMMENT '用户地址', `createTime` datetime DEFAULT NULL COMMENT '创建时间', `cost` float DEFAULT NULL COMMENT '总消费', `serialNumber` varchar(255) DEFAULT NULL COMMENT '订单号', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `easybuy_order` */ insert into `easybuy_order`(`id`,`userId`,`loginName`,`userAddress`,`createTime`,`cost`,`serialNumber`) values (1,18,'shangzezhong','北京市花园路小区','2016-06-02 14:51:46',1721,'60B7487F47F9434EAA5FD1D9E22CB06C'),(2,18,'shangzezhong','北京市海淀区成府路','2016-06-02 14:52:49',8596,'8EF5E1557D55413781658A65FC301B8A'),(3,2,'admin','北京市海淀区大有庄','2016-06-03 11:41:09',456,'51718726C1274CC59504AB4E6FD64BA0'); /*Table structure for table `easybuy_order_detail` */ DROP TABLE IF EXISTS `easybuy_order_detail`; CREATE TABLE `easybuy_order_detail` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键', `orderId` int(10) NOT NULL COMMENT '订单主键', `productId` int(10) NOT NULL COMM