shop.sql

这是我们做的一个网上购物系统,包手用户和管理员两大功能模块,采用jsp+servlet+java bean技术.

# SQL Manager 2005 for MySQL 3.7.7.1
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : shop


/*!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 gbk */;

SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `shop`
    CHARACTER SET 'gbk'
    COLLATE 'gbk_chinese_ci';

USE `shop`;

#
# Structure for the `account` table : 
#

CREATE TABLE `account` (
  `account_id` int(10) NOT NULL auto_increment,
  `account_userId` int(10) NOT NULL,
  `account_money` double NOT NULL,
  PRIMARY KEY  (`account_id`),
  KEY `account_userId` (`account_userId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `product` table : 
#

CREATE TABLE `product` (
  `product_id` int(10) NOT NULL auto_increment,
  `product_name` varchar(50) NOT NULL,
  `product_price` double NOT NULL,
  `product_descr` varchar(100) default NULL,
  `product_cId` int(10) default '0',
  `product_image` varchar(100) default NULL,
  PRIMARY KEY  (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `sales` table : 
#

CREATE TABLE `sales` (
  `sales_id` int(10) NOT NULL auto_increment,
  `sales_productId` int(10) NOT NULL,
  `sales_productNum` int(10) NOT NULL,
  `sales_userId` int(10) NOT NULL,
  `sales_state` int(10) default '1',
  `sales_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`sales_id`),
  KEY `sales_productId` (`sales_productId`),
  KEY `sales_userId` (`sales_userId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `sales2` table : 
#

CREATE TABLE `sales2` (
  `sales_id` int(10) NOT NULL auto_increment,
  `sales_productId` int(10) NOT NULL,
  `sales_productNum` int(10) NOT NULL,
  `sales_userId` int(10) NOT NULL,
  `sales_state` int(10) default '1',
  `sales_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`sales_id`),
  KEY `sales_productId` (`sales_productId`),
  KEY `sales_userId` (`sales_userId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `user` table : 
#

CREATE TABLE `user` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `pwd` varchar(100) NOT NULL,
  `phone` varchar(40) default NULL,
  `addr` varchar(255) default NULL,
  `rdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `power` varchar(20) NOT NULL,
  `money` double NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Structure for the `vote` table : 
#

CREATE TABLE `vote` (
  `vote_id` int(11) NOT NULL auto_increment,
  `vote_class` int(11) default NULL,
  `vote_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`vote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Data for the `account` table  (LIMIT 0,500)
#

INSERT INTO `account` (`account_id`, `account_userId`, `account_money`) VALUES 
  (8,163583,100),
  (9,163583,123544),
  (11,198996,100000),
  (12,198996,123654),
  (13,198996,66666),
  (14,164032,2345);

COMMIT;

#
# Data for the `product` table  (LIMIT 0,500)
#

INSERT INTO `product` (`product_id`, `product_name`, `product_price`, `product_descr`, `product_cId`, `product_image`) VALUES 
  (29,'戴尔 Vostro 1100',5999,'低价',1,'nb_dell_vostro_1000__m.jpg'),
  (30,'戴尔 500(R520463)',5899,'低价,家用,较重',1,'nb-dell_500__m.jpg'),
  (31,'戴尔 Vostro 1200(R520253)',7999,'低价,轻薄,商用',1,'nb_dell_vostro_1200_1_m.jpg'),
  (32,'惠普 Compaq 2210b(KS292PA)',8999,'中端,超轻薄,商用',2,'nb_hp_b2210__m.jpg'),
  (33,'惠普 Compaq 6515b(KF087PA)',5999,'轻便,商用',2,'nb_hp_compaq_6510b__m.jpg'),
  (34,'惠普 Compaq Presario V3804TX(KS397PA)',6999,'低价,轻便,家用,3D',2,'nb_hp_compaq_6510b__m.jpg'),
  (35,'华硕 Eee PC 8G版(香港)',2999,'低价,超便携',3,'nb_asus_eeepc__m.jpg'),
  (36,'华硕 F5SL F5Q237SL-SL',4999,'较重,家用,3D',3,'nb_asus_f5r__m.jpg'),
  (37,'华硕 F5RL F5Q237RL-DR',4999,'低价,较重',3,'nb_asus_m51_1_m.jpg'),
  (38,'联想 IdeaPad Y510AT5450-P',5999,'中端,家用,较重,3D',4,'nb_lenovo_y510_1_m.jpg'),
  (39,'联想 IdeaPad Y710AX7900-L(TV TUNER)',12999,'高端,家用,替代台式,3D',4,'nb_lenovo_y710_1_m.jpg'),
  (40,'联想 旭日C466LT1400-B',4999,'低价,轻便',4,'nb_lenovo_c467__m.jpg'),
  (41,'联想 旭日N220GT7250 W21024160BVCW3b',5999,'中低端,轻薄,家用',4,'nb_lenovo_xuri_n220__m.jpg'),
  (42,'联想 昭阳E42AT5550',5999,'中低端,轻便,商用',4,'nb_lenovo_c467__m.jpg'),
  (43,'神舟 承运F545T',2999,'低价,轻便,家用,3D',5,'nb_hasee_ty_q530c_m.jpg'),
  (44,'神舟 商禧C300N',2999,'低价,轻薄,商用',5,'nb_hasee_sx_c300n_m.jpg'),
  (45,'神舟 商禧F700C',3999,'低价,轻便,家用',5,'nb_hasee_yy_hp600__m.jpg'),
  (46,'神舟 天运F1500',2599,'非迅驰平台',5,'nb_hasee_ty_f1500_1_m.jpg'),
  (47,'佳能 IXUS 80 IS ',1999,'佳能 IXUS 80 IS拥有800万有效像素,配备IS光学影像稳定器',10,'dc_canon_80is_1_m.jpg'),
  (48,'索尼 T300 ',1299,'MS Duo记忆棒,MS Pro Duo记忆棒,MS Pro-HG Duo记忆棒 ',10,'dc_sony_t300_1l_m.jpg'),
  (49,'佳能 EOS 450D ',4800,'存储介质：SD卡,SDHC卡 ',10,'dc_conon_eos450d_1_m.jpg'),
  (50,'尼康 S52 ',3599,'光学变焦倍数：3倍光学变焦',10,'dc_nikon_s52_1l_m.jpg'),
  (51,'奥林巴斯 E-510(双镜头套装)',3599,'传感器类型：CCD传感器 ',10,'dc_olympus_e510_1l_m.jpg'),
  (52,'松下 FX33 ',5999,'存储介质：MMC卡,SD卡,SDHC卡',10,'dc_panasonic_dmc_fx33_2l_m.jpg'),
  (53,'富士 F100fd ',6599,'xD卡,SD卡,SDHC卡,最大支持2G ',10,'dc_fuji_f100fd_1_m.jpg'),
  (54,'佳能 IXUS 970 IS ',3699,'5倍光学变焦',10,'dc_cannon_970_1l_m.jpg'),
  (55,'尼康 D60(配18-55mm VR防抖镜头套机)',6999,'1020万像素',10,'dc_nikon_d60_1_m.jpg'),
  (56,'诺基亚 1200 ',299,'诺基亚 1200是一款时常手机,支持频段 GSM900-1800MHz',11,'mobile_nokia_1200_1l_m.jpg'),
  (57,'诺基亚 2630 ',630,'专门针对低端市场而推出的机型,直板设计的诺基亚2630机身仅有不足1cm的机身厚度',11,'mobile_nokia_2630_1l_m.jpg'),
  (58,'诺基亚 6300 ',1399,'拥有1670万色QVGA像素屏幕,200万像素摄像头',11,'mobile_nokia_6300_1l_m.jpg'),
  (59,'诺基亚N93i',4680,'创新式旋转屏幕设计(可在手机模式,DV模式和笔记本模式中自由切换)',11,'mobile_nokia_n93i_4l_m.jpg'),
  (60,'摩托罗拉 Q8',2699,'内置摄像头,内存容量128MB,摩托罗拉 Q8支持蓝牙,wap2',11,'mobile_moto_gsm_1l_m.jpg'),
  (61,'摩托罗拉ROKR Z6',2399,'升级到了2英寸QVGA等级.另外,Z6采用的是Linux系统,内置200万像素摄像头',11,'mobile_moto_z6_1l_m.jpg'),
  (62,'步步高 DL339 ',2299,'16:9高清晰TFT液晶显示屏,4:3/16:9两种画面选择',6,'dvd_bubugao_dl339_1l_m.jpg'),
  (63,'步步高 DL339',2299,'屏幕特性：16:9高清晰TFT液晶显示屏,4:3/16:9两种画面选择 ',7,'dvd_bubugao_dl339_1l_m.jpg'),
  (64,'三星 SCH-W159',3180,'数据业务：GPRS ',11,'mobile_samsung_w159_1l_m.jpg'),
  (65,'宏碁 TravelMate 6492-301G12Mn',8800,'处理器：Intel Core2 Duo(Merom) T7300(2.0G) ',8,'nb_acer_tm6492_2_m.jpg'),
  (67,'联想 IdeaPad Y710AX7900-L(TV TUNER) ',22999,'处理器：Intel Core2 Duo(Merom XE) X7900(2.8G) ',4,'nb_lenovo_xuri_n220__m.jpg'),
  (68,'联想 IdeaPad Y510AT8100-P(TV TUNER) ',11000,'处理器：Intel Core2 Duo(Penryn) T8100(2.1G) ',4,'nb_lenovo_y510_1_m.jpg'),
  (69,'戴尔 Vostro 1400(R520281) ',5999,'处理器：Intel Celeron M 540(1.86G) ',1,'nb_dell_vostro_1200_1_m.jpg'),
  (71,'戴尔 500(R520463)',5899,'低价,家用,较重',1,'nb_hasee_sx_c300n_m.jpg');

COMMIT;

#
# Data for the `sales` table  (LIMIT 0,500)
#

INSERT INTO `sales` (`sales_id`, `sales_productId`, `sales_productNum`, `sales_userId`, `sales_state`, `sales_date`) VALUES 
  (27,69,2,139166,1,'2008-06-13 23:38:59'),
  (28,34,1,139166,0,'2008-06-13 22:44:22'),
  (29,49,1,139166,1,'2008-06-13 23:38:49'),
  (30,49,1,139166,1,'2008-06-13 23:39:06'),
  (31,33,1,139166,0,'2008-06-13 22:45:58'),
  (32,48,1,139166,0,'2008-06-13 22:46:09'),
  (33,48,1,139166,0,'2008-06-13 22:46:45'),
  (34,69,1,163557,1,'2008-06-13 23:39:19'),
  (35,37,1,163557,0,'2008-06-13 23:18:22'),
  (36,68,5,163583,0,'2008-06-13 23:25:28'),
  (37,30,1,163583,1,'2008-06-13 23:39:26'),
  (38,33,1,163583,0,'2008-06-13 23:26:31'),
  (39,67,1,163583,1,'2008-06-13 23:39:15'),
  (40,69,1,163583,1,'2008-06-13 23:39:03'),
  (41,33,1,163583,1,'2008-06-13 23:39:10'),
  (42,30,1,140121,0,'2008-06-13 23:37:12'),
  (43,37,1,140121,1,'2008-06-13 23:39:13'),
  (44,36,1,140121,1,'2008-06-13 23:39:17'),
  (45,68,1,140121,1,'2008-06-13 23:39:22'),
  (46,43,1,140121,1,'2008-06-13 23:39:24'),
  (47,63,1,140121,0,'2008-06-13 23:37:12'),
  (48,48,1,140121,0,'2008-06-13 23:37:13'),
  (49,59,1,140121,1,'2008-06-13 23:38:42'),
  (50,56,1,140121,0,'2008-06-13 23:37:47'),
  (51,64,1,140121,0,'2008-06-13 23:37:47'),
  (52,52,1,140121,1,'2008-06-13 23:38:55');

COMMIT;

#
# Data for the `sales2` table  (LIMIT 0,500)
#

INSERT INTO `sales2` (`sales_id`, `sales_productId`, `sales_productNum`, `sales_userId`, `sales_state`, `sales_date`) VALUES 
  (13,69,4,139166,0,'2008-06-13 23:32:33'),
  (14,34,1,139166,0,'2008-06-13 22:44:22'),
  (15,49,2,139166,0,'2008-06-13 22:45:46'),
  (16,33,3,139166,0,'2008-06-13 23:32:33'),
  (17,48,3,139166,0,'2008-06-13 23:37:13'),
  (18,37,2,163557,0,'2008-06-13 23:37:12'),
  (19,68,6,163583,0,'2008-06-13 23:37:12'),
  (20,30,2,163583,0,'2008-06-13 23:37:12'),
  (21,67,1,163583,0,'2008-06-13 23:26:32'),
  (22,36,1,140121,0,'2008-06-13 23:37:12'),
  (23,43,1,140121,0,'2008-06-13 23:37:12'),
  (24,63,1,140121,0,'2008-06-13 23:37:13'),
  (25,59,1,140121,0,'2008-06-13 23:37:47'),
  (26,56,1,140121,0,'2008-06-13 23:37:47'),
  (27,64,1,140121,0,'2008-06-13 23:37:47'),
  (28,52,1,140121,0,'2008-06-13 23:37:47');

COMMIT;

#
# Data for the `user` table  (LIMIT 0,500)
#

INSERT INTO `user` (`id`, `name`, `pwd`, `phone`, `addr`, `rdate`, `power`, `money`) VALUES 
  (1244,'admin','21232F297A57A5A743894A0E4A801FC3','a','df','2008-06-04 22:20:39','admin',10),
  (139166,'邱永刚','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','新安花苑','2008-06-13 22:40:56','member',1000000),
  (140121,'王志英','633DE4B0C14CA52EA2432A3C8A5C4C31','15898537967','湘潭大学金瀚林','2008-06-07 22:03:47','member',90921),
  (153684,'邱永胜','633DE4B0C14CA52EA2432A3C8A5C4C31','','','2008-06-07 22:03:48','member',100000),
  (163557,'谢磊','633DE4B0C14CA52EA2432A3C8A5C4C31','158','金瀚林','2008-06-13 15:36:04','member',100000),
  (163583,'邱永刚','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','湘潭大学','2008-06-13 14:49:46','member',1165610),
  (172688,'夏静','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','','2008-06-07 22:03:52','member',50051),
  (173564,'敬章龙','633DE4B0C14CA52EA2432A3C8A5C4C31','','','2008-06-04 22:25:01','member',100000),
  (177583,'吕书甫','633DE4B0C14CA52EA2432A3C8A5C4C31','','','2008-06-07 22:03:53','member',100000),
  (182381,'刘洋','633DE4B0C14CA52EA2432A3C8A5C4C31','','','2008-06-07 22:03:56','member',100000),
  (191081,'夏静','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','金瀚林5栋621','2008-06-07 22:03:57','member',7811),
  (198592,'丁俊','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','湘潭大学','2008-06-07 22:03:59','member',64744),
  (198996,'王志英','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','金瀚林','2008-06-07 22:04:05','member',96820),
  (198997,'nftdx','745FFCF026645ECE8E97C7706661720F','15898537967','金瀚林','2008-06-07 22:04:40','admin',1000000),
  (198998,'qyg','633DE4B0C14CA52EA2432A3C8A5C4C31','2350110','湘潭大学','2008-06-13 15:01:44','member',99999);

COMMIT;

#
# Data for the `vote` table  (LIMIT 0,500)
#

INSERT INTO `vote` (`vote_id`, `vote_class`, `vote_date`) VALUES 
  (65,1,'2008-06-04 22:48:00'),
  (66,1,'2008-06-04 22:48:07'),
  (67,1,'2008-06-07 22:48:16'),
  (68,1,'2008-06-07 22:48:24'),
  (69,1,'2008-06-07 22:48:26'),
  (70,1,'2008-06-07 22:48:27'),
  (71,1,'2008-06-07 22:48:28'),
  (72,1,'2008-06-07 22:48:29'),
  (73,1,'2008-06-07 22:48:30'),
  (74,1,'2008-06-07 22:48:32'),
  (75,2,'2008-06-07 22:48:51'),
  (76,2,'2008-06-07 22:48:53'),
  (77,2,'2008-06-07 22:48:55'),
  (78,2,'2008-06-07 22:48:55'),
  (79,2,'2008-06-07 22:48:56'),
  (80,2,'2008-06-07 22:48:58'),
  (81,2,'2008-06-07 22:49:00'),
  (82,2,'2008-06-07 22:49:01'),
  (83,3,'2008-06-07 22:49:06'),
  (84,3,'2008-06-07 22:49:08'),
  (85,3,'2008-06-07 22:49:09'),
  (86,4,'2008-06-07 22:49:15'),
  (87,1,'2008-06-07 22:49:20'),
  (88,1,'2008-06-07 22:49:21'),
  (89,1,'2008-06-07 22:49:22'),
  (90,2,'2008-06-07 22:49:27'),
  (91,2,'2008-06-07 22:49:32'),
  (92,2,'2008-06-07 22:49:34'),
  (93,2,'2008-06-07 22:49:35'),
  (94,2,'2008-06-07 22:49:36'),
  (95,2,'2008-06-07 22:49:37'),
  (96,2,'2008-06-07 22:49:38'),
  (97,2,'2008-06-07 22:49:39'),
  (98,2,'2008-06-07 22:49:41'),
  (99,2,'2008-06-07 22:49:42');

COMMIT;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;