mysqldata

基于jsp+javabean+mysql三层结构的动态购物网站。网站用户接口（即界面）由jsp完成

#
# Dumping data for table 'shop_news_imgs'
#
INSERT INTO shop_news_imgs VALUES("1", "2", "1035232067730.jpg");
INSERT INTO shop_news_imgs VALUES("2", "3", "1035235151310.jpg");
INSERT INTO shop_news_imgs VALUES("5", "13", "1035476634150.jpg");
INSERT INTO shop_news_imgs VALUES("6", "13", "1035476634150.jpg");
INSERT INTO shop_news_imgs VALUES("7", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("8", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("9", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("10", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("11", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("12", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("13", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("14", "14", "1035481502480.jpg");
INSERT INTO shop_news_imgs VALUES("32", "29", "1035568450580.jpg");
INSERT INTO shop_news_imgs VALUES("25", "18", "1035564626390.jpg");
INSERT INTO shop_news_imgs VALUES("27", "20", "1035566301950.jpg");
INSERT INTO shop_news_imgs VALUES("31", "28", "1035568441290.jpg");
INSERT INTO shop_news_imgs VALUES("30", "22", "1035566737340.jpg");


#
# Table structure for table 'shop_news_info'
#

CREATE TABLE `shop_news_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type_id` int(10) unsigned NOT NULL default '0',
  `topic` varchar(255) NOT NULL default '',
  `original_content` text NOT NULL,
  `content` text NOT NULL,
  `content_type` tinyint(4) NOT NULL default '0',
  `pagination` varchar(14) NOT NULL default '',
  `keywords` varchar(50) NOT NULL default '',
  `click` int(11) NOT NULL default '0',
  `source` varchar(200) NOT NULL default '',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_news_info'
#
INSERT INTO shop_news_info VALUES("1078", "9", "大减价", "hgjgh", "hgjgh", "0", "", "ghjg", "4", "ghj", "2003-07-04 23:25:57");
INSERT INTO shop_news_info VALUES("1081", "9", "疯狂减价！！！！！！", "疯狂减价！！！！！！疯狂减价！！！！！！疯狂减价！！！！！！", "疯狂减价！！！！！！疯狂减价！！！！！！疯狂减价！！！！！！", "0", "", "fghfgh", "4", "商城热讯", "2003-07-05 00:37:50");
INSERT INTO shop_news_info VALUES("1082", "9", "hhhhhhhhhhhhhh", "hhhhhhhhhhhh", "hhhhhhhhhhhh", "0", "", "hhh", "0", "hhhh", "2003-07-05 02:42:52");


#
# Table structure for table 'shop_news_type'
#

CREATE TABLE `shop_news_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_news_type'
#
INSERT INTO shop_news_type VALUES("9", "商城热讯");


#
# Table structure for table 'shop_orders_main'
#

CREATE TABLE `shop_orders_main` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `product_id` int(11) NOT NULL default '0',
  `r_info_id` int(11) NOT NULL default '0',
  `price` float unsigned NOT NULL default '0',
  `quantity` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_orders_main'
#
INSERT INTO shop_orders_main VALUES("31", "basic", "43", "16", "4554", "1");
INSERT INTO shop_orders_main VALUES("36", "leobasic", "51", "19", "644", "1");
INSERT INTO shop_orders_main VALUES("35", "leobasic", "48", "19", "54645", "1");
INSERT INTO shop_orders_main VALUES("30", "basic", "45", "16", "200", "6");
INSERT INTO shop_orders_main VALUES("29", "basic", "46", "16", "100", "1");
INSERT INTO shop_orders_main VALUES("28", "basic", "47", "16", "4444", "18");
INSERT INTO shop_orders_main VALUES("32", "basic", "44", "16", "5334", "2");
INSERT INTO shop_orders_main VALUES("33", "leobasic", "45", "17", "200", "1");
INSERT INTO shop_orders_main VALUES("34", "basic", "51", "18", "644", "18");
INSERT INTO shop_orders_main VALUES("37", "jimy", "49", "20", "465", "1");
INSERT INTO shop_orders_main VALUES("38", "jimy", "51", "20", "644", "1");
INSERT INTO shop_orders_main VALUES("39", "jimy", "50", "20", "444", "1");
INSERT INTO shop_orders_main VALUES("40", "jimy", "50", "21", "444", "1");
INSERT INTO shop_orders_main VALUES("41", "jimy", "49", "21", "465", "1");
INSERT INTO shop_orders_main VALUES("42", "q", "55", "23", "9.55", "17");
INSERT INTO shop_orders_main VALUES("43", "q", "57", "23", "9.5", "7");
INSERT INTO shop_orders_main VALUES("44", "q", "60", "24", "13", "14");


#
# Table structure for table 'shop_orders_r_info'
#

CREATE TABLE `shop_orders_r_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `r_name` varchar(20) NOT NULL default '',
  `r_address` varchar(200) NOT NULL default '',
  `r_tel` varchar(100) NOT NULL default '',
  `note` text NOT NULL,
  `status` tinyint(4) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_orders_r_info'
#
INSERT INTO shop_orders_r_info VALUES("16", "帅哥1", "深圳市1", "1", "", "0", "2003-07-06 01:27:09");
INSERT INTO shop_orders_r_info VALUES("17", "赵", "各个各个各个各个", "133333333333333", "", "1", "2003-07-07 08:14:53");
INSERT INTO shop_orders_r_info VALUES("18", "帅哥1", "深圳市1", "4444444", "dddddddddddddddd", "1", "2003-07-07 23:39:16");
INSERT INTO shop_orders_r_info VALUES("19", "赵向雄", "肇庆", "999", "送货前请先电话联系！", "0", "2003-07-09 23:31:19");
INSERT INTO shop_orders_r_info VALUES("20", "leo102", "广东省肇庆市端洲区体育路12号305", "13333333", "你！！", "0", "2003-07-10 21:27:30");
INSERT INTO shop_orders_r_info VALUES("21", "砖洞高手", "广东省肇庆市端洲区体育路12号305", "13333333", "", "0", "2003-07-10 21:40:58");
INSERT INTO shop_orders_r_info VALUES("22", "q", "qfgd", "456456", "jk", "0", "2003-07-10 22:57:23");
INSERT INTO shop_orders_r_info VALUES("23", "q", "qfgd", "456456", "i", "0", "2003-07-10 23:03:17");
INSERT INTO shop_orders_r_info VALUES("24", "q", "qfgd", "456456", "ppppppppppppp", "0", "2003-07-10 23:13:14");


#
# Table structure for table 'shop_product_info'
#

CREATE TABLE `shop_product_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `catalog_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `keywords` varchar(100) NOT NULL default '',
  `img_path` varchar(200) NOT NULL default '',
  `price` float unsigned NOT NULL default '0',
  `absence` tinyint(4) NOT NULL default '0',
  `show_out` tinyint(4) NOT NULL default '0',
  `importance_show` tinyint(3) unsigned NOT NULL default '0',
  `click` int(11) NOT NULL default '0',
  `purchase_num` int(11) NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;



#
# Dumping data for table 'shop_product_info'
#
INSERT INTO shop_product_info VALUES("52", "51", "EEG Twins2003最新专辑", "EEG Twins2003最新专辑", "Twins", "upload_img/1057845973300.jpg", "16", "0", "1", "0", "2", "0", "2003-07-10 22:06:48");
INSERT INTO shop_product_info VALUES("53", "51", "皆大欢喜结局篇 真假皇后（20集）", "皆大欢喜结局篇 真假皇后（20集）", "皆大欢喜", "upload_img/1057846154560.jpg", "89", "0", "1", "0", "2", "0", "2003-07-10 22:09:15");
INSERT INTO shop_product_info VALUES("54", "51", "中国相声大全 马志明相声集（5集）", "中国相声大全 马志明相声集（5集）", "马志明,相声", "upload_img/1057846227610.jpg", "25", "0", "1", "0", "2", "3", "2003-07-10 22:10:29");
INSERT INTO shop_product_info VALUES("55", "51", "偶像在线 滨崎步", "偶像在线 滨崎步", "滨崎步", "upload_img/1057846378270.jpg", "9.55", "0", "1", "0", "22", "0", "2003-07-10 22:12:59");
INSERT INTO shop_product_info VALUES("56", "55", "红唇妙女郎", "三位韩国人气女星为你带来无限欢笑之韩国喜剧！三位妙龄靓女，一位英俊管家，还有一位江湖老大，你爱我，我爱她，谁爱谁……精彩纷呈，笑声殴打飞过海法", "红唇妙女郎,韩国", "upload_img/1057846715730.jpg", "93", "0", "1", "1", "3", "0", "2003-07-10 22:18:36");
INSERT INTO shop_product_info VALUES("57", "39", "色彩胎教音乐3", "医学专家和专业音乐编辑历时数月的心血之作，培养未来宝宝先天完美人格的音乐盒，奉献给所有伟大的孕妈咪和可爱的的小天使。伟大音乐造就和殴打飞过海法", "色彩胎教音乐", "upload_img/1057846772360.jpg", "9.5", "0", "1", "1", "10", "0", "2003-07-10 22:19:35");
INSERT INTO shop_product_info VALUES("58", "41", "中国成语故事大全", "日积月累受益无限。 　　本片是目前国产时间最长、集数最多的一部大型成语故事动画系列片，已在多家电视台播出。片中凝聚了大量的历史知识殴打飞过海法", "成语故事", "upload_img/1057846858870.jpg", "92", "0", "1", "0", "7", "5", "2003-07-10 22:20:59");
INSERT INTO shop_product_info VALUES("59", "62", "克莱恩先生", "克莱恩先生", "克莱恩先生", "upload_img/1057846974760.jpg", "10", "0", "1", "0", "2", "0", "2003-07-10 22:22:56");
INSERT INTO shop_product_info VALUES("60", "49", "纵横四海（DVD-9）", "纵横四海（DVD-9）", "纵横四海", "upload_img/1057847024410.jpg", "13.9", "0", "1", "0", "4", "1", "2003-07-10 22:23:45");