taobao.sql

一个仿造淘宝的jsp网站。功能比较完善

insert into shopinfo values(10,1,1,'狗皮黑包',100,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'猫皮白包',8000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'猪皮黄包',4500,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'牛皮灰包',6222,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'羊皮',1200,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'狗皮黑包',100,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'猫皮白包',8000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'猪皮黄包',4500,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'牛皮灰包',6222,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'羊皮',1200,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'狗皮黑包',100,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'猫皮白包',8000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'猪皮黄包',4500,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'牛皮灰包',6222,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(10,1,1,'羊皮',1200,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')


insert into shopinfo values(11,1,1,'东风雪铁龙',12000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'丰田',12000,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'本田',12000,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'莱斯莱斯',12000,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'东风雪铁龙',12000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'丰田',12000,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'本田',12000,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'莱斯莱斯',12000,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'东风雪铁龙',12000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'丰田',12000,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'本田',12000,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(11,1,1,'莱斯莱斯',12000,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')

insert into shopinfo values(12,1,1,'柯达相机',12000,'飞利浦公司','image/shop/shuma/shuma1.jpg','你的世界丰富多彩，亮')
insert into shopinfo values(12,1,2,'索尼A3电脑',12000,'日本索尼公司','image/shop/shuma/shuma2.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(12,1,1,'彬峰MP3',12000,'飞利浦公司','image/shop/shuma/shuma3.jpg','感受音乐，感受世界的美好')
insert into shopinfo values(12,1,1,'思恋MP3',12000,'日本索尼公司','image/shop/shuma/shuma4.jpg','你快回来，把我的思恋带回来')
insert into shopinfo values(12,1,1,'液晶电视机',12000,'飞利浦公司','image/shop/shuma/shuma5.jpg','我的世界将变得更闪亮')
insert into shopinfo values(12,1,2,'天有耳机',12000,'天有电子厂','image/shop/shuma/shuma6.jpg','那天我听到他的针掉地上了')
insert into shopinfo values(12,1,1,'雨点耳机',12000,'飞利浦公司','image/shop/shuma/shuma7.jpg','无伤害，绝对保护你的耳朵')
insert into shopinfo values(12,1,1,'BOYSTE',12000,'日本索尼公司','image/shop/shuma/shuma8.jpg','太漂亮了，我喜欢，我要')
insert into shopinfo values(12,1,1,'阿克相机',12000,'飞利浦公司','image/shop/shuma/shuma9.jpg','怎样去看世界在于你用的')
insert into shopinfo values(12,1,2,'索尼耳机',12000,'日本索尼公司','image/shop/shuma/shuma10.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(12,1,1,'飞利浦01',12000,'飞利浦公司','image/shop/shuma/shuma11.jpg','跳楼价，赶快去买，机会')
insert into shopinfo values(12,1,1,'TCK22相机',12000,'日本索尼公司','image/shop/shuma/shuma12.jpg','把世界收藏起来，好玩')

insert into shopinfo values(13,1,1,'狗皮黑包',100,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'猫皮白包',8000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'猪皮黄包',4500,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'牛皮灰包',6222,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'羊皮',1200,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'狗皮黑包',100,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'猫皮白包',8000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'猪皮黄包',4500,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'牛皮灰包',6222,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'羊皮',1200,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'狗皮黑包',100,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'猫皮白包',8000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'猪皮黄包',4500,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'牛皮灰包',6222,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(13,1,1,'羊皮',1200,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')


insert into shopinfo values(14,1,1,'东风雪铁龙',12000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'丰田',12000,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'本田',12000,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'莱斯莱斯',12000,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'东风雪铁龙',12000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'丰田',12000,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'本田',12000,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'莱斯莱斯',12000,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'东风雪铁龙',12000,'海南马自达公司','image/goods/17.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'丰田',12000,'海南马自达公司','image/goods/18.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'本田',12000,'海南马自达公司','image/goods/19.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(14,1,1,'莱斯莱斯',12000,'海南马自达公司','image/goods/20.jpg','宽敞的车身，惊人的速度')

insert into shopinfo values(15,1,1,'昭贵面贴膜',7.8,'中国香港美容公司','image/shop/meirong/mr1.jpg','网络明星品牌昭贵面贴膜')
insert into shopinfo values(15,1,2,'隐性丝袜',39,'珠海美容公司','image/shop/meirong/mr2.jpg','大象腿变细,丝袜也能隐形')
insert into shopinfo values(15,1,1,'拒绝当油物',19,'安利美容中国分公司','image/shop/meirong/mr3.jpg','美容大王最爱拒绝当油物')
insert into shopinfo values(15,1,1,'蜂抢菲诗',26,'美莲开中国分公司','image/shop/meirong/mr4.jpg','韩国人气第一,蜂抢菲诗小铺')
insert into shopinfo values(15,1,1,'Glister',12000,'中国香港美容公司','image/shop/meirong/mr5.jpg','美白保湿我还是选它')
insert into shopinfo values(15,1,2,'折平全家福',12000,'中国香港美容公司','image/shop/meirong/mr6.jpg','我全家都用它，我信它')
insert into shopinfo values(15,1,1,'祛痘霜',12000,'中国香港美容公司','image/shop/meirong/mr7.jpg','让你的脸告别痘痘时代')
insert into shopinfo values(15,1,1,'海飞丝系列',12000,'海飞丝公司','image/shop/meirong/mr8.gif','清爽每一天，使用海飞丝系列')
insert into shopinfo values(15,1,1,'龙力奇祛痱粉',12000,'龙力奇化妆品公司','image/shop/meirong/mr9.gif','让你不怕蚊虫叮咬')
insert into shopinfo values(15,1,2,'旁氏洗盐泥',58,'旁氏美容公司','image/shop/meirong/mr10.gif','去除皮肤中的脏物杂质')
insert into shopinfo values(15,1,1,'祛痘霜',60,'美莲开中国分公司','image/shop/meirong/mr11.gif','还你没有烦恼的快乐青春')
insert into shopinfo values(15,1,1,'美白霜',100,'美莲开中国分公司','image/shop/meirong/mr12.gif','让你的肌肤一天比一天白')


select * from shopinfo
go
/*==============================================================*/
/* Table: shopnuminfo                                           */
/*==============================================================*/
create table shopnuminfo (
   kid                  int    identity(1,1)               not null,
   sid                  int                  null,
   shopnumber           int                  null,
   constraint PK_SHOPNUMINFO primary key (kid)
)
go
insert into shopnuminfo values(1,20)
insert into shopnuminfo values(2,20)
insert into shopnuminfo values(3,20)
insert into shopnuminfo values(4,20)
insert into shopnuminfo values(5,20)
insert into shopnuminfo values(6,20)
insert into shopnuminfo values(7,20)
insert into shopnuminfo values(8,20)
insert into shopnuminfo values(9,20)
insert into shopnuminfo values(10,20)
insert into shopnuminfo values(11,20)
insert into shopnuminfo values(12,20)
insert into shopnuminfo values(13,20)
insert into shopnuminfo values(14,20)
insert into shopnuminfo values(15,20)
insert into shopnuminfo values(16,20)
insert into shopnuminfo values(17,20)
insert into shopnuminfo values(18,20)
insert into shopnuminfo values(19,20)
insert into shopnuminfo values(20,20)
insert into shopnuminfo values(21,20)
insert into shopnuminfo values(22,20)
insert into shopnuminfo values(23,20)
insert into shopnuminfo values(24,20)
insert into shopnuminfo values(25,20)
insert into shopnuminfo values(26,20)
insert into shopnuminfo values(27,20)
insert into shopnuminfo values(28,20)
insert into shopnuminfo values(29,20)
insert into shopnuminfo values(30,20)
insert into shopnuminfo values(31,20)
insert into shopnuminfo values(32,20)
insert into shopnuminfo values(33,20)
insert into shopnuminfo values(34,20)
insert into shopnuminfo values(35,20)
insert into shopnuminfo values(36,20)
insert into shopnuminfo values(37,20)
insert into shopnuminfo values(38,20)
insert into shopnuminfo values(39,20)
insert into shopnuminfo values(40,20)
insert into shopnuminfo values(41,20)
insert into shopnuminfo values(42,20)
insert into shopnuminfo values(43,20)
insert into shopnuminfo values(44,20)
insert into shopnuminfo values(45,20)
insert into shopnuminfo values(46,20)
insert into shopnuminfo values(47,20)
insert into shopnuminfo values(48,20)
insert into shopnuminfo values(49,20)
insert into shopnuminfo values(50,20)
insert into shopnuminfo values(51,20)
insert into shopnuminfo values(52,20)
insert into shopnuminfo values(53,20)
insert into shopnuminfo values(54,20)
insert into shopnuminfo values(55,20)
insert into shopnuminfo values(56,20)
insert into shopnuminfo values(57,20)
insert into shopnuminfo values(58,20)
insert into shopnuminfo values(59,20)
insert into shopnuminfo values(60,20)
insert into shopnuminfo values(61,20)
insert into shopnuminfo values(62,20)
insert into shopnuminfo values(63,20)
insert into shopnuminfo values(64,20)
insert into shopnuminfo values(65,20)
insert into shopnuminfo values(66,20)
insert into shopnuminfo values(67,20)
insert into shopnuminfo values(68,20)
insert into shopnuminfo values(69,20)
insert into shopnuminfo values(70,20)
insert into shopnuminfo values(71,20)
insert into shopnuminfo values(72,20)
insert into shopnuminfo values(73,20)
insert into shopnuminfo values(74,20)
insert into shopnuminfo values(75,20)
insert into shopnuminfo values(76,20)
insert into shopnuminfo values(77,20)
insert into shopnuminfo values(78,20)
insert into shopnuminfo values(79,20)
insert into shopnuminfo values(80,20)
insert into shopnuminfo values(81,20)
insert into shopnuminfo values(82,20)
insert into shopnuminfo values(83,20)
insert into shopnuminfo values(84,20)
insert into shopnuminfo values(85,20)
insert into shopnuminfo values(86,20)
insert into shopnuminfo values(87,20)
insert into shopnuminfo values(88,20)
insert into shopnuminfo values(89,20)
insert into shopnuminfo values(90,20)
insert into shopnuminfo values(91,20)
insert into shopnuminfo values(92,20)
insert into shopnuminfo values(93,20)
insert into shopnuminfo values(94,20)
insert into shopnuminfo values(95,20)
insert into shopnuminfo values(96,20)
insert into shopnuminfo values(97,20)
insert into shopnuminfo values(98,20)
insert into shopnuminfo values(99,20)
insert into shopnuminfo values(100,20)
insert into shopnuminfo values(101,20)
insert into shopnuminfo values(102,20)
insert into shopnuminfo values(103,20)