-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.40-community
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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' */;
--
-- Create schema db_database24
--
DROP DATABASE IF EXISTS db_database24;
CREATE DATABASE IF NOT EXISTS db_database24;
USE db_database24;
set NAMES 'gbk';
--
-- Definition of table `tb_customer`
--
DROP TABLE IF EXISTS `tb_customer`;
CREATE TABLE `tb_customer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`realname` varchar(20) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`mobile` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_customer`
--
/*!40000 ALTER TABLE `tb_customer` DISABLE KEYS */;
INSERT INTO `tb_customer` (`id`,`username`,`password`,`realname`,`address`,`email`,`mobile`) VALUES
(1,'mrsoft','mrsoft',NULL,'吉林省长春市二道区xxx号xxx小区xxx门','mrsoft@mrsoft.com','139xxxx8888');
/*!40000 ALTER TABLE `tb_customer` ENABLE KEYS */;
--
-- Definition of table `tb_order`
--
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
`orderId` varchar(30) NOT NULL,
`name` varchar(50) NOT NULL,
`address` varchar(200) NOT NULL,
`mobile` varchar(11) NOT NULL,
`totalPrice` float DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`paymentWay` varchar(15) DEFAULT NULL,
`orderState` varchar(10) DEFAULT NULL,
`customerId` int(11) DEFAULT NULL,
PRIMARY KEY (`orderId`),
KEY `FKFA98EE3DD0EDC05E` (`customerId`),
CONSTRAINT `FKFA98EE3DD0EDC05E` FOREIGN KEY (`customerId`) REFERENCES `tb_customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_order`
--
/*!40000 ALTER TABLE `tb_order` DISABLE KEYS */;
INSERT INTO `tb_order` (`orderId`,`name`,`address`,`mobile`,`totalPrice`,`createTime`,`paymentWay`,`orderState`,`customerId`) VALUES
('201004201352400389678','mrsoft','吉林省长春市二道区xxx号xxx小区xxx门','139xxxx8888',120,'2010-04-20 13:52:40','POSTOFFICE_PAY','DELIVERED',1),
('201004220944580771720','mrsoft','吉林省长春市二道区xxx号xxx小区xxx门','139xxxx8888',120,'2010-04-22 09:44:58','POSTOFFICE_PAY','DELIVERED',1),
('201004220957520484473','mrsoft','吉林省长春市二道区xxx号xxx小区xxx门','139xxxx8888',0,'2010-04-22 09:57:52','POSTOFFICE_PAY','DELIVERED',1);
/*!40000 ALTER TABLE `tb_order` ENABLE KEYS */;
--
-- Definition of table `tb_orderitem`
--
DROP TABLE IF EXISTS `tb_orderitem`;
CREATE TABLE `tb_orderitem` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`productId` int(11) NOT NULL,
`productName` varchar(200) NOT NULL,
`productPrice` float NOT NULL,
`amount` int(11) DEFAULT NULL,
`orderId` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKBF076F042FE3E9B` (`orderId`),
CONSTRAINT `FKBF076F042FE3E9B` FOREIGN KEY (`orderId`) REFERENCES `tb_order` (`orderId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_orderitem`
--
/*!40000 ALTER TABLE `tb_orderitem` DISABLE KEYS */;
INSERT INTO `tb_orderitem` (`id`,`productId`,`productName`,`productPrice`,`amount`,`orderId`) VALUES
(1,1,'Java 编程词典',120,1,NULL),
(2,1,'Java 编程词典',120,1,NULL);
/*!40000 ALTER TABLE `tb_orderitem` ENABLE KEYS */;
--
-- Definition of table `tb_productcategory`
--
DROP TABLE IF EXISTS `tb_productcategory`;
CREATE TABLE `tb_productcategory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`level` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKB405573CFB37BC9D` (`pid`),
CONSTRAINT `FKB405573CFB37BC9D` FOREIGN KEY (`pid`) REFERENCES `tb_productcategory` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=350 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_productcategory`
--
/*!40000 ALTER TABLE `tb_productcategory` DISABLE KEYS */;
INSERT INTO `tb_productcategory` (`id`,`name`,`level`,`pid`) VALUES
(1,'服装',1,NULL),
(2,'品质男装',2,1),
(3,'衬衫',3,2),
(4,'男鞋',3,2),
(5,'男裤',3,2),
(6,'西服',3,2),
(7,'女鞋',2,1),
(8,'帆布',3,7),
(9,'高帮',3,7),
(10,'单鞋',3,7),
(11,'凉鞋',3,7),
(12,'鱼嘴',3,7),
(13,'内衣',2,1),
(14,'睡衣',3,13),
(15,'男内裤',3,13),
(16,'文胸',3,13),
(17,'袜',3,13),
(18,'内裤',3,13),
(19,'运动服',2,1),
(20,'夹克',3,19),
(21,'卫衣',3,19),
(22,'裤',3,19),
(23,'棉衣',3,19),
(24,'T恤',3,19),
(25,'童装',2,1),
(26,'鞋',3,25),
(27,'裤',3,25),
(28,'套装',3,25),
(29,'T恤',3,25),
(30,'孕妇装',3,25),
(31,'连衣裙',2,1),
(32,'裤',3,31),
(33,'半裙',3,31),
(34,'雪纺裙',3,31),
(35,'蕾丝裙',3,31),
(36,'运动鞋',2,1),
(37,'Nike',3,36),
(38,'李宁',3,36),
(39,'Adidas',3,36),
(40,'匡威',3,36),
(41,'休闲男装',2,1),
(42,'牛仔',3,41),
(43,'T恤',3,41),
(44,'夹克',3,41),
(45,'卫衣',3,41),
(46,'女装',2,1),
(47,'针织衫',3,46),
(48,'T恤',3,46),
(49,'短外套',3,46),
(50,'衬衫',3,46),
(51,'配饰',1,NULL),
(52,'眼镜',2,51),
(53,'烟具',3,52),
(54,'眼镜架',3,52),
(55,'太阳镜',3,52),
(56,'Zippo',3,52),
(57,'手表',2,51),
(58,'天梭',3,57),
(59,'Casio',3,57),
(60,'欧米茄',3,57),
(61,'浪琴',3,57),
(62,'服饰配件',2,51),
(63,'皮带',3,62),
(64,'颈环',3,62),
(65,'帽子',3,62),
(66,'围巾',3,62),
(67,'饰品',2,51),
(68,'戒指',3,67),
(69,'手链',3,67),
(70,'项链',3,67),
(71,'耳饰',3,67),
(72,'发饰',3,67),
(73,'珠宝',2,51),
(74,'翡翠',3,73),
(75,'婚钻',3,73),
(76,'千足金',3,73),
(77,'施华洛',3,73),
(78,'男女箱包',2,51),
(79,'男包',3,78),
(80,'肩包',3,78),
(81,'旅行',3,78),
(82,'钱包',3,78),
(83,'家居',1,NULL),
(84,'日用超市',2,83),
(85,'收纳',3,84),
(86,'伞',3,84),
(87,'礼品',3,84),
(88,'钟表',3,84),
(89,'家饰',2,83),
(90,'窗帘',3,89),
(91,'十字绣',3,89),
(92,'照片墙',3,89),
(93,'地毯',3,89),
(94,'家纺',2,83),
(95,'四件套',3,94),
(96,'靠垫',3,94),
(97,'蚊帐',3,94),
(98,'蚕丝被',3,94),
(99,'日化',2,83),
(100,'洗发',3,99),
(101,'香薰',3,99),
(102,'沐浴',3,99),
(103,'卫生巾',3,99),
(104,'家具',2,83),
(105,'床',3,104),
(106,'柜子',3,104),
(107,'茶几',3,104),
(108,'沙发',3,104),
(109,'宜家',3,104),
(110,'厨房',2,83),
(111,'茶具',3,110),
(112,'健康筷子',3,110),
(113,'餐具',3,110),
(114,'锅具',3,110),
(115,'杯',3,110),
(116,'装潢建材',2,83),
(117,'灯饰',3,116),
(118,'浴霸',3,116),
(119,'卫浴',3,116),
(120,'地板',3,116),
(121,'洁具',2,83),
(122,'晒衣',3,121),
(123,'拖把',3,121),
(124,'牙刷',3,121),
(125,'擦地拖',3,121),
(126,'母婴',1,NULL),
(127,'奶粉',2,126),
(128,'辅食',3,127),
(129,'营养',3,127),
(130,'妈妈保健',3,127),
(131,'益智',2,126),
(132,'家具',3,131),
(133,'户外',3,131),
(134,'早教',3,131),
(135,'推车',3,131),
(136,'车',3,131),
(137,'用品',2,126),
(138,'湿巾',3,137),
(139,'喂哺',3,137),
(140,'洗护',3,137),
(141,'睡袋',3,137),
(142,'尿片',3,137),
(143,'食品',1,NULL),
(144,'保健',2,143),
(145,'燕窝',3,144),
(146,'螺旋藻',3,144),
(147,'安利',3,144),
(148,'蜂蜜',3,144),
(149,'零食',2,143),
(150,'牛肉干',3,149),
(151,'春茶',3,149),
(152,'枣类',3,149),
(153,'巧克力',3,149),
(154,'民生',2,143),
(155,'水果',3,154),
(156,'私房菜',3,154),
(157,'膳食',3,154),
(158,'干货',3,154),
(159,'美容',1,NULL),
(160,'护肤',2,159),
(161,'精华',3,160),
(162,'面膜',3,160),
(163,'精油',3,160),
(164,'爽肤水',3,160),
(165,'彩妆',2
仿淘宝网站
需积分: 42 96 浏览量
2018-11-22
20:04:48
上传
评论 5
收藏 16.24MB ZIP 举报
仿淘宝网站 （302个子文件） 
ProductAction.class 12KB DaoSupport.class 7KB OrderAction.class 7KB BaseAction.class 5KB ProductInfo.class 4KB EnumType.class 3KB ProductCategoryAction.class 3KB Order.class 3KB CartAction.class 3KB DaoSupport$2.class 3KB CustomerAction.class 3KB IndexAction.class 3KB ProductCategory.class 2KB ProductDaoImpl.class 2KB UserAction.class 2KB OrderItem.class 2KB PageModel.class 2KB CustomerDaoImpl.class 2KB HibernateUtils.class 2KB UserDaoImpl.class 2KB OrderState.class 2KB Customer.class 2KB Sex.class 2KB StringUitl.class 2KB OrderDaoImpl.class 1KB DaoSupportTest.class 1KB PaymentWay.class 1KB CustomerLoginInteceptor.class 1KB UserLoginInterceptor.class 1KB DaoSupport$1.class 1KB PaymentWayConversion.class 1KB OrderStateConversion.class 1KB AppException.class 1KB SexConversion.class 1KB BaseDao.class 1KB User.class 1KB GenericsUtils.class 993B UploadFile.class 888B ProductCategoryDaoImpl.class 631B UploadFileDaoImpl.class 596B PaymentWay$1.class 547B PaymentWay$3.class 541B OrderState$2.class 541B PaymentWay$4.class 541B OrderState$3.class 538B PaymentWay$2.class 538B OrderState$1.class 538B Sex$3.class 500B Sex$1.class 497B Sex$2.class 497B PaymentWayType.class 471B OrderStateType.class 471B SexType.class 436B ProductDao.class 421B CustomerDao.class 369B UserDao.class 353B OrderDao.class 291B ProductCategoryDao.class 267B UploadFileDao.class 252B .classpath 3KB org.eclipse.wst.common.component 486B org.eclipse.wst.jsdt.ui.superType.container 49B style_index.css 6KB style_ht.css 3KB
index_25.gif 45KB cp_03.gif 28KB bg_03.gif 24KB ht_02_01.gif 12KB zc_03.gif 5KB dl_03.gif 5KB ht_02_21.gif 5KB index_06.gif 5KB tu_50.gif 4KB index_51.gif 4KB index_42.gif 4KB ht_02_03.gif 4KB zh_03.gif 3KB zh03_09.gif 3KB cp_06.gif 3KB gm_06.gif 3KB index_49.gif 3KB cp01_03.gif 2KB load.gif 2KB zh03_11.gif 2KB zh03_07.gif 2KB zh01_03.gif 2KB index_28.gif 2KB ht_02_06.gif 2KB index_47.gif 2KB 08.gif 2KB index_26.gif 2KB index_39.gif 2KB ht_02_10.gif 2KB index_19.gif 2KB index_23.gif 2KB ht_02_18.gif 2KB 03.gif 1KB 04.gif 1KB 02.gif 1KB index_14.gif 1KB共 302 条
- 1
- 2
- 3
- 4
资源评论
