Mysql+Spring+SpringMVC+Mybaits电商项目源代码.zip

# Host: localhost (Version: 5.1.65-community) # Date: 2016-09-28 15:38:10 # Generator: MySQL-Front 5.3 (Build 4.13) /*!40101 SET NAMES utf8 */; # # Source for table "t_category" # DROP TABLE IF EXISTS `t_category`; CREATE TABLE `t_category` ( `cate_id` int(11) NOT NULL AUTO_INCREMENT, `cate_name` varchar(100) NOT NULL, `cate_pic` varchar(50) DEFAULT NULL, PRIMARY KEY (`cate_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; # # Data for table "t_category" # INSERT INTO `t_category` VALUES (1,'女装','/images/cate/1.png'),(2,'男装','/images/cate/2.png'),(3,'女士内衣','/images/cate/3.png'),(4,'男士内衣','/images/cate/4.png'),(5,'女鞋','/images/cate/5.png'),(6,'男鞋','/images/cate/6.png'),(7,'孕妇装','/images/cate/7.png'),(8,'儿童装','/images/cate/8.png'),(9,'婴幼儿装','/images/cate/9.png'),(10,'配饰','/images/cate/10.png'),(11,'箱包','/images/cate/11.png'),(13,'测试分类1','/images/cate/1454665448253.jpg'),(15,'测试分类2','/images/cate/1454722861160.jpg'); # # Source for table "t_color" # DROP TABLE IF EXISTS `t_color`; CREATE TABLE `t_color` ( `color_id` int(11) NOT NULL AUTO_INCREMENT, `color_name` varchar(50) NOT NULL, PRIMARY KEY (`color_id`), UNIQUE KEY `color_name` (`color_name`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; # # Data for table "t_color" # INSERT INTO `t_color` VALUES (1,'黑色'),(2,'白色'),(3,'红色'),(4,'黄色'),(5,'绿色'),(6,'蓝色'),(7,'紫色'),(8,'灰色'),(9,'天蓝色'),(10,'藏青色'),(11,'米白色'),(12,'浅灰色'),(13,'粉红色'),(14,'湖蓝色'),(15,'草绿色'),(16,'米黄色'),(17,'深蓝色'),(18,'土黄色'),(19,'棕色'),(20,'深棕色'),(21,'鹅黄色'),(22,'西瓜红色'),(23,'浅黄色'),(24,'浅绿色'),(25,'玫瑰红色'),(26,'卡其色'); # # Source for table "t_goods" # DROP TABLE IF EXISTS `t_goods`; CREATE TABLE `t_goods` ( `goods_id` int(11) NOT NULL AUTO_INCREMENT, `cate_id` int(11) NOT NULL, `goods_name` varchar(50) NOT NULL, `goods_disc` text NOT NULL, `goods_price` float NOT NULL, `goods_discount` float DEFAULT NULL, `goods_stock` int(11) NOT NULL, `goods_origin` varchar(50) DEFAULT NULL, `goods_material` varchar(200) DEFAULT NULL, `goods_postalfee` float DEFAULT NULL, `goods_date` date DEFAULT NULL, `goods_sales` int(11) DEFAULT NULL, `goods_pic` varchar(50) DEFAULT NULL, PRIMARY KEY (`goods_id`), KEY `cate_id` (`cate_id`), CONSTRAINT `cate_id` FOREIGN KEY (`cate_id`) REFERENCES `t_category` (`cate_id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; # # Data for table "t_goods" # INSERT INTO `t_goods` VALUES (1,1,'女装 军旅式短茄克1','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,233,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-01',0,'/images/goods/1_1.jpg'),(2,1,'女装 军旅式短茄克2','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,243,0,'上海','棉56% 聚酯纤维30%',10,'2016-01-29',0,'/images/goods/1_2.png'),(3,1,'女装 军旅式短茄克3','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,32,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_3.png'),(4,1,'女装 军旅式短茄克4','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,235,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_1.jpg'),(5,1,'女装 军旅式短茄克5','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,233,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_2.png'),(6,1,'女装 军旅式短茄克6','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,122,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_3.png'),(7,1,'女装 军旅式短茄克7','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,134,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_1.jpg'),(8,1,'女装 军旅式短茄克8','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,134,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_2.png'),(9,1,'女装 军旅式短茄克9','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,177,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_3.png'),(10,1,'女装 军旅式短茄克10','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,177,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_3.png'),(11,1,'女装 军旅式短茄克11','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽的样式，能适度修饰脸型。短款的设计，可与宽腿裤等宽松的下装搭配打造具有平衡感的造型。',399,177,0,'上海','棉56% 聚酯纤维30%',12,'2016-01-30',0,'/images/goods/1_1.jpg'),(12,1,'女装 军旅式短茄克12','施有强水洗加工的军旅式外套。富有张力的面料，洋溢着十足的军旅气息。带盖口袋的金属圆形纽扣、兜帽口的锯齿形压线，彰显经典的军旅外套细节。大兜帽�