taobao.sql

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

insert into photoinfo values('image/taobaoluntan/emo/em29.gif')
insert into photoinfo values('image/taobaoluntan/emo/em30.gif')
insert into photoinfo values('image/taobaoluntan/emo/em31.gif')
insert into photoinfo values('image/taobaoluntan/emo/em32.gif')
insert into photoinfo values('image/taobaoluntan/emo/em33.gif')
insert into photoinfo values('image/taobaoluntan/emo/em34.gif')
insert into photoinfo values('image/taobaoluntan/emo/em35.gif')
insert into photoinfo values('image/taobaoluntan/emo/em36.gif')
insert into photoinfo values('image/taobaoluntan/emo/em37.gif')
insert into photoinfo values('image/taobaoluntan/emo/em38.gif')
insert into photoinfo values('image/taobaoluntan/emo/em39.gif')
insert into photoinfo values('image/taobaoluntan/emo/em40.gif')
insert into photoinfo values('image/taobaoluntan/emo/em41.gif')
insert into photoinfo values('image/taobaoluntan/emo/em42.gif')
insert into photoinfo values('image/taobaoluntan/emo/em43.gif')
insert into photoinfo values('image/taobaoluntan/emo/em44.gif')
insert into photoinfo values('image/taobaoluntan/emo/em45.gif')
insert into photoinfo values('image/taobaoluntan/emo/em46.gif')
insert into photoinfo values('image/taobaoluntan/emo/em47.gif')
insert into photoinfo values('image/taobaoluntan/emo/em48.gif')
insert into photoinfo values('image/taobaoluntan/emo/em49.gif')

insert into photoinfo values('image/face/1.gif')
insert into photoinfo values('image/face/2.gif')
insert into photoinfo values('image/face/3.gif')
insert into photoinfo values('image/face/4.gif')
insert into photoinfo values('image/face/5.gif')
insert into photoinfo values('image/face/6.gif')
insert into photoinfo values('image/face/7.gif')
insert into photoinfo values('image/face/8.gif')
insert into photoinfo values('image/face/9.gif')
insert into photoinfo values('image/face/10.gif')
insert into photoinfo values('image/face/11.gif')
insert into photoinfo values('image/face/12.gif')

insert into photoinfo values('image/face/13.gif')
insert into photoinfo values('image/face/14.gif')
insert into photoinfo values('image/face/15.gif')
insert into photoinfo values('image/face/16.gif')
insert into photoinfo values('image/face/17.gif')
insert into photoinfo values('image/face/18.gif')
insert into photoinfo values('image/face/19.gif')
insert into photoinfo values('image/face/20.gif')
insert into photoinfo values('image/face/21.gif')
insert into photoinfo values('image/face/22.gif')
insert into photoinfo values('image/face/23.gif')
insert into photoinfo values('image/face/24.gif')

insert into photoinfo values('image/face/25.gif')
insert into photoinfo values('image/face/26.gif')
insert into photoinfo values('image/face/27.gif')
insert into photoinfo values('image/face/28.gif')
insert into photoinfo values('image/face/29.gif')
insert into photoinfo values('image/face/30.gif')
insert into photoinfo values('image/face/31.gif')
insert into photoinfo values('image/face/32.gif')
insert into photoinfo values('image/face/33.gif')
insert into photoinfo values('image/face/34.gif')
insert into photoinfo values('image/face/35.gif')

select * from photoinfo

go
/*==============================================================*/
/* Table: shopinfo                                              */
/*==============================================================*/
create table shopinfo (
   sid                  int    identity(1,1)               not null,
   tid                  int                  null,
   stateid              int                  null,
   userid               int                  null,
   shopname             varchar(50)          null,
   price                float                null,
   shopmake             varchar(50)          null,
   shopphoto            varchar(50)          null,
   shopdesc             varchar(200)         null,
   constraint PK_SHOPINFO primary key (sid)
)
go
insert into shopinfo values(1,1,1,'海南野马',88000,'海南马自达公司','image/shop/car/car1.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,2,'劳斯莱茨',5000000,'美国劳斯莱茨公司','image/shop/car/car2.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,1,'韩国起亚',100000,'韩国起亚公司','image/shop/car/car3.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,2,'长安奔奔',68000,'长安奔放公司','image/shop/car/car4.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,1,'五菱汽车',32000,'中国五菱公司','image/shop/car/car5.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,2,'福特汽车',82000,'美国福特汽车制造公司','image/shop/car/car6.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,1,'广州本田',120000,'日本本田汽车公司','image/shop/car/car7.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,2,'东风标志',80000,'日本东风有限公司','image/shop/car/car8.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,1,'日本铃木',120000,'日本铃木有限公司','image/shop/car/car9.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,2,'美洲狮',160000,'瑞士美洲狮公司','image/shop/car/car10.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,1,'奇瑞QQ',52000,'中国芜湖奇瑞公司','image/shop/car/car11.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(1,1,2,'一汽大众',110000,'上海大众公司','image/shop/car/car12.jpg','宽敞的车身，惊人的速度')

insert into shopinfo values(2,1,1,'罗基亚01',1200,'美国罗基亚公司','image/shop/shouji/shouji1.jpg','超薄的机身,超强的信号')
insert into shopinfo values(2,1,1,'摩托罗拉',1360,'美国摩托罗拉公司','image/shop/shouji/shouji2.jpg','带有笔记本功能,超方便')
insert into shopinfo values(2,1,1,'三星A6',1800,'韩国三星公司','image/shop/shouji/shouji3.jpg','先进的技术,时尚的造型')
insert into shopinfo values(2,1,1,'天雨86',900,'中国北京天雨通讯公司','image/shop/shouji/shouji4.jpg','用的开心,我们才真正开心')
insert into shopinfo values(2,1,1,'海信36',1400,'中国海南海信通讯公司','image/shop/shouji/shouji5.jpg','先进的高科技技术,时尚')
insert into shopinfo values(2,1,1,'波导100',1500,'中国北京波导通讯公司','image/shop/shouji/shouji6.jpg','信号强,质量特别优越')
insert into shopinfo values(2,1,1,'KCL3188',2300,'韩国KCL通讯公司','image/shop/shouji/shouji7.jpg','时尚,流行,帅气,有品位')
insert into shopinfo values(2,1,1,'长虹52',1180,'中国长虹通讯公司','image/shop/shouji/shouji8.jpg','采用高科技尖端技术研制')
insert into shopinfo values(2,1,1,'佳能200',800,'中国佳能通讯公司','image/shop/shouji/shouji9.jpg','强大的功能,才能然您满意')
insert into shopinfo values(2,1,1,'高通900',1080,'中国高能通讯公司','image/shop/shouji/shouji10.jpg','高科技的通讯技术,质量好')
insert into shopinfo values(2,1,1,'家通895',1600,'中国家通通讯公司','image/shop/shouji/shouji11.jpg','家家都通才是我们的目标')
insert into shopinfo values(2,1,1,'LG8611',1520,'中国联想集团','image/shop/shouji/shouji12.jpg','国际最流行的款式,包质量')
insert into shopinfo values(2,1,1,'LY5300',1200,'中国兰芽通讯公司','image/shop/shouji/shouji13.jpg','超强的通讯尖端设备')
insert into shopinfo values(2,1,1,'联想',1300,'中国联想集团','image/shop/shouji/shouji14.jpg','没有做不到的,只有想不到的')

insert into shopinfo values(3,1,1,'JUSTYLE裤',99,'韩国AK公司','image/shop/fuzhuang/fz1.gif','JUSTYLE热卖480件五袋裤包邮')
insert into shopinfo values(3,1,1,'依蕾斯吊带',69,'韩国依蕾斯集团','image/shop/fuzhuang/fz2.gif','依蕾斯三肩带超集中文胸[包邮]')
insert into shopinfo values(3,1,1,'唐狮休闲服',199,'浙江唐狮公司','image/shop/fuzhuang/fz3.gif','运动起来灵活，舒适，清爽')
insert into shopinfo values(3,1,1,'分体泳衣',59,'中国李宁公司','image/shop/fuzhuang/fz4.gif','女裙式分体游泳衣【限量50件抢购】')
insert into shopinfo values(3,1,1,'海南服饰',50,'海南之家公司','image/shop/fuzhuang/fz5.gif','老百姓的衣柜，海南之家')
insert into shopinfo values(3,1,1,'西域牛仔',60,'中国西域牛仔公司','image/shop/fuzhuang/fz6.gif','西域人士的大度，豪气澎湃')
insert into shopinfo values(3,1,1,'清爽服饰',160,'海南之家公司','image/shop/fuzhuang/fz7.gif','限量100件抢购之中，快')
insert into shopinfo values(3,1,1,'男士短裤',20,'深圳友爱服饰公司','image/shop/fuzhuang/fz8.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(3,1,1,'可爱童装',120,'上海爱心服饰公司','image/shop/fuzhuang/fz9.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(3,1,1,'劲霸男装',1500,'美国劲霸公司','image/shop/fuzhuang/fz10.gif','真正的男人，霸气十足，豪迈')
insert into shopinfo values(3,1,1,'圣马休闲服',120,'圣马服饰公司','image/shop/fuzhuang/fz11.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(3,1,1,'雅戈尔西服',800,'雅戈尔服饰公司','image/shop/fuzhuang/fz12.gif','轻松，帅气，清朗，风度')

insert into shopinfo values(4,1,1,'登山黄包',100,'海南马自达公司','image/shop/pibao/pb1.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'休闲挎包',8000,'海南马自达公司','image/shop/pibao/pb2.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'清朗小提包',4500,'海南马自达公司','image/shop/pibao/pb3.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'逛街花包',6222,'海南马自达公司','image/shop/pibao/pb4.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'羊皮',1200,'海南马自达公司','image/shop/pibao/pb5.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'狗皮黑包',100,'海南马自达公司','image/shop/pibao/pb6.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'猫皮白包',8000,'海南马自达公司','image/shop/pibao/pb7.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'猪皮黄包',4500,'海南马自达公司','image/shop/pibao/pb8.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'牛皮灰包',6222,'海南马自达公司','image/shop/pibao/pb9.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'羊皮',1200,'海南马自达公司','image/shop/pibao/pb10.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'狗皮黑包',100,'海南马自达公司','image/shop/pibao/pb11.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'猫皮白包',8000,'海南马自达公司','image/shop/pibao/pb12.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'猪皮黄包',4500,'海南马自达公司','image/shop/pibao/pb13.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'牛皮灰包',6222,'海南马自达公司','image/shop/pibao/pb14.gif','宽敞的车身，惊人的速度')
insert into shopinfo values(4,1,1,'羊皮',1200,'海南马自达公司','image/shop/pibao/pb15.gif','宽敞的车身，惊人的速度')


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

insert into shopinfo values(6,1,1,'七彩耳钉',10,'南京夫子庙','image/shop/shoushi/七彩水钻.jpg','[i&xin瑷昕]七彩水钻耳钉 低于1折')
insert into shopinfo values(6,1,2,'蓝水晶蝴蝶',19,'南京夫子庙','image/shop/shoushi/image/shop/shoushi/七彩水钻.jpg','[威妮华]蓝水晶蝴蝶满钻项链')
insert into shopinfo values(6,1,1,'大众#D',12000,'海南马自达公司','image/goods/12.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大众#3FD',12000,'海南马自达公司','image/goods/12.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大运摩多',12000,'海南马自达公司','image/goods/5.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,2,'一汽红旗',12000,'海南马自达公司','image/goods/6.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大众#D',12000,'海南马自达公司','image/goods/12.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大众#3FD',12000,'海南马自达公司','image/goods/12.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大运摩多',12000,'海南马自达公司','image/goods/5.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,2,'一汽红旗',12000,'海南马自达公司','image/goods/6.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大众#D',12000,'海南马自达公司','image/goods/12.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(6,1,1,'大众#3FD',12000,'海南马自达公司','image/goods/12.jpg','宽敞的车身，惊人的速度')

insert into shopinfo values(7,1,1,'牛肉葱面',30,'家信火锅店','image/shop/meishi/meishi1.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(7,1,2,'桂圆莲子羹',20,'温馨饭店','image/shop/meishi/meishi2.jpg','爽口营养，享受美味在其中')
insert into shopinfo values(7,1,1,'爆葱豆腐',68,'老爸火锅店','image/shop/meishi/meishi3.jpg','提供佐料和烹饪方法，快哦！')
insert into shopinfo values(7,1,2,'蛋桶全家福',20,'温馨饭店','image/shop/meishi/meishi4.jpg','全家一齐吃，才是最开心的')
insert into shopinfo values(7,1,1,'麻辣鸡翅',58,'温馨饭店','image/shop/meishi/meishi5.jpg','香滑的肌肉，爽口的佐料')
insert into shopinfo values(7,1,2,'红心白仁包',30,'家信火锅店','image/shop/meishi/meishi6.jpg','谁都可以动手，快行动吧')
insert into shopinfo values(7,1,1,'紫竹春笋',40,'温馨饭店','image/shop/meishi/meishi7.jpg','仿佛到了雨林，雨后春笋，爽')
insert into shopinfo values(7,1,2,'将军蟹',80,'老爸火锅店','image/shop/meishi/meishi8.jpg','富含各种维生素，美味，健康')
insert into shopinfo values(7,1,1,'花菇菊花鱼',40,'老爸火锅店','image/shop/meishi/meishi9.jpg','菊花与鱼的集合，水土相容')
insert into shopinfo values(7,1,2,'月季巧克力',50,'家信火锅店','image/shop/meishi/meishi10.jpg','花和食物的结合，美得自然')
insert into shopinfo values(7,1,1,'满载而归',98,'温馨饭店','image/shop/meishi/meishi11.jpg','让你好好享受地一下日本美食')
insert into shopinfo values(7,1,2,'雪丽白花虾',90,'家信火锅店','image/shop/meishi/meishi12.jpg','细腻爽口美味的虾仁，美观营养')

insert into shopinfo values(8,1,1,'客厅套装',16000,'宏信家具城','image/shop/jiaju/jiaju1.jpg','让客人大吃一惊，美吧，哼')
insert into shopinfo values(8,1,1,'按摩椅',15000,'宏信家具城','image/shop/jiaju/jiaju2.jpg','你的第二个老婆，按摩，嘿')
insert into shopinfo values(8,1,1,'客厅装潢',11000,'宏信家具城','image/shop/jiaju/jiaju3.jpg','让自己的家更漂亮一点，奇')
insert into shopinfo values(8,1,1,'动感餐桌',580,'宏信家具城','image/shop/jiaju/jiaju4.jpg','一股浓厚的复古气息照着你')
insert into shopinfo values(8,1,1,'书房桌椅',990,'宏信家具城','image/shop/jiaju/jiaju5.jpg','书中自有黄金屋，气派啊')
insert into shopinfo values(8,1,1,'美丽的家',8000,'宏信家具城','image/shop/jiaju/jiaju6.jpg','家永远是最漂亮和温暖的')
insert into shopinfo values(8,1,1,'双人沙发',600,'宏信家具城','image/shop/jiaju/jiaju7.jpg','老婆和老公一起看电视')
insert into shopinfo values(8,1,1,'议事桌椅',500,'宏信家具城','image/shop/jiaju/jiaju8.jpg','小而巧，美妙而让人陶醉')
insert into shopinfo values(8,1,1,'新婚暖床',2000,'宏信家具城','image/shop/jiaju/jiaju9.jpg','充满了爱的温馨，永远幸福')
insert into shopinfo values(8,1,1,'唐代大吊床',980,'宏信家具城','image/shop/jiaju/jiaju10.jpg','让我们穿越时空去唐朝享受')
insert into shopinfo values(8,1,1,'丝绸长沙发',8000,'宏信家具城','image/shop/jiaju/jiaju11.jpg','全家人拥在一起看电视，爱')
insert into shopinfo values(8,1,1,'书房座椅',600,'宏信家具城','image/shop/jiaju/jiaju12.jpg','看上去便有了书的气息，好')

insert into shopinfo values(9,1,1,'宝马f4',12000,'海南马自达公司','image/goods/13.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'法拉利D7',12000,'海南马自达公司','image/goods/14.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'莱克林W2',12000,'海南马自达公司','image/goods/15.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'奔驰A6',12000,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'宝马f4',12000,'海南马自达公司','image/goods/13.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'法拉利D7',12000,'海南马自达公司','image/goods/14.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'莱克林W2',12000,'海南马自达公司','image/goods/15.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'奔驰A6',12000,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'宝马f4',12000,'海南马自达公司','image/goods/13.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'法拉利D7',12000,'海南马自达公司','image/goods/14.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'莱克林W2',12000,'海南马自达公司','image/goods/15.jpg','宽敞的车身，惊人的速度')
insert into shopinfo values(9,1,1,'奔驰A6',12000,'海南马自达公司','image/goods/16.jpg','宽敞的车身，惊人的速度')