jsp项目源码

-- 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