jsp+struts+jdbc在线销售系统源码电子商务类网站

Create table product( productId int(20) auto_increment primary key, name varchar(20) not null, inPrice double not null, outPrice double not null, stock int(10) not null, hasSend int(10) not null, detail varchar(500), image varchar(200), byArea varchar(20)not null, byScene varchar(20) not null ); 地区：大陆,欧美,港台，日韩 情节:喜剧片,动作片,伦理片，恐怖片，言情片，电视剧，卡拉OK，流行音乐，影视音乐,卡通动漫 高兴 好看 select * from product where byScene='喜剧片' and (name like '%高%' or detail like '%高%' or byScene like '%高%' or byArea like '%高%'); alter table product modify name char(20) binary not null; insert into product values(2004,'高兴',20,30,1000,50,'垃圾电影，毛骗','C:\\Documents and Settings\\Administrator\\桌面\\电影\\大陆影片\\大陆影片喜剧片\\gaoxin.jpg','大陆','喜剧片'); insert into product values(2005,'生死格斗',20,50,1000,50,'好看电影，毛骗','C:\\Documents and Settings\\Administrator\\桌面\\电影\\欧美\\欧美动作片\\生死格斗.jpg','欧美','动作片'); insert into product values(2006,'不存在的女儿',20,50,1000,50,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\欧美\\欧美伦理片\\不存在的女儿.jpg','欧美','伦理片'); insert into product values(2025,'不存在的女儿',20,50,1000,50,'测试同名','C:\\Documents and Settings\\Administrator\\桌面\\电影\\欧美\\欧美伦理片\\不存在的女儿.jpg','欧美','喜剧片'); insert into product values(2007,'保险套惹的祸',20,50,1000,50,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\欧美\\欧美喜剧片\\保险套惹的祸.jpg','欧美','喜剧片'); insert into product values(2008,'荒岛惊魂',20,50,1000,50,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\欧美\\欧美恐怖片\\荒岛惊魂.jpg','欧美','恐怖片'); insert into product values(2009,'与盖弄潮',20,50,1000,5000,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\欧美\\欧美言情片\\与盖弄潮.jpg','欧美','言情片'); insert into product values(2010,'血风筝',20,50,1000,50,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\大陆影片\\大陆影片恐怖片\\血风筝.jpg','大陆','恐怖片'); insert into product values(2011,'耳朵大有福',20,50,1000,578,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\大陆影片\\大陆影片喜剧片\\耳朵大有福.jpg','大陆','喜剧片'); insert into product values(2012,'一言为定',20,50,1000,512,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\大陆影片\\大陆影片言情片\\一言为定.jpg','大陆','言情片'); insert into product values(2013,'太极宗师',20,50,1000,512,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\大陆影片\\大陆影片动作片\\太极宗师.jpg','大陆','动作片'); insert into product values(2014,'少女潘金莲',20,50,1000,592,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\大陆影片\\大陆影片伦理片\\少女潘金莲.jpg','大陆','伦理片'); insert into product values(2015,'开心鬼上错身',20,50,1000,123,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\港台影片\\港台影片喜剧片\\开心鬼上错身.jpg','港台','喜剧片'); insert into product values(2016,'恋爱女王',20,50,1000,754,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\港台影片\\港台影片言情片\\恋爱女王.jpg','港台','言情片'); insert into product values(2017,'等待飞鱼',20,50,1000,758,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\港台影片\\港台影片伦理片\\等待飞鱼.jpg','港台','伦理片'); insert into product values(2018,'少林寺',20,50,1000,888,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\港台影片\\港台影片动作片\\少林寺.jpg','港台','动作片'); insert into product values(2019,'艳魂印',20,50,1000,855,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\港台影片\\港台影片恐怖片\\艳魂印.jpg','港台','恐怖片'); insert into product values(2020,'男人之苦',20,50,1000,355,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\日韩影片\\日韩影片喜剧片\\男人之苦.jpg','日韩','喜剧片'); insert into product values(2021,'两个人',20,50,1000,345,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\日韩影片\\日韩影片言情片\\两个人.jpg','日韩','言情片'); insert into product values(2022,'生死谍交',20,50,1000,335,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\日韩影片\\日韩影片动作片\\生死谍交.jpg','日韩','动作片'); insert into product values(2023,'蝙蝠',20,50,1000,360,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\日韩影片\\日韩影片恐怖片\\蝙蝠.jpg','日韩','恐怖片'); insert into product values(2024,'我的风流丈夫',20,50,1000,360,'好看电影','C:\\Documents and Settings\\Administrator\\桌面\\电影\\日韩影片\\日韩影片伦理片\\我的风流丈夫.jpg','日韩','伦理片'); //电视剧 insert into product values(2030,'纸醉金迷',20,50,1000,377,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\大陆电视剧\\纸醉金迷.jpg','大陆','电视剧'); insert into product values(2031,'潜伏',20,50,1000,387,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\大陆电视剧\\潜伏.jpg','大陆','电视剧'); insert into product values(2032,'通天干探',20,50,1000,332,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\港台电视剧\\通天干探.jpg','港台','电视剧'); insert into product values(2033,'天龙八部',20,50,1000,432,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\港台电视剧\\天龙八部.jpg','港台','电视剧'); insert into product values(2034,'红唇战役 第一季',20,50,1000,332,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\欧美电视剧\\红唇战役 第一季.jpg','欧美','电视剧'); insert into product values(2035,'加里森敢死队',20,50,1000,3332,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\欧美电视剧\\加里森敢死队.jpg','欧美','电视剧'); insert into product values(2036,'秘密部队第三季',20,50,1000,3342,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\欧美电视剧\\秘密部队第三季.jpg','欧美','电视剧'); insert into product values(2037,'明成皇后',20,50,1000,3842,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\日韩电视剧\\明成皇后.jpg','日韩','电视剧'); insert into product values(2038,'医道',20,50,1000,442,'好看电视剧','C:\\Documents and Settings\\Administrator\\桌面\\电视剧\\日韩电视剧\\医道.jpg','日韩','电视剧'); 音乐 insert into product values(2040,'光辉岁月卡拉OK全集',20,50,1000,642,'好听音乐剧','C:\\Documents and Settings\\Administrator\\桌面\\音乐\\大陆音乐\\光辉岁月卡拉OK全集.jpg','大陆','卡拉OK'); insert into product values(2041,'剑蝶',20,50,1000,342,'好听音乐剧','C:\\Documents and Settings\\Administrator\\桌面\\音乐\\大陆音乐\\剑蝶.jpg','大陆','影视音乐'); insert into product values(2042,'一首独唱的歌',20,50,1000,342,'好听音乐剧','C:\\Documents and Settings\\Administrator\\桌面\\音乐\\大陆音乐\\一首独唱的歌.jpg','大陆','流行音乐'); insert into product values(2043,'上华经典卡拉OK',20,50,1000,342,'好听音乐剧','C:\\Documents and Settings\\Administrator\\桌面\\音乐\\大陆音乐\\上华经典卡拉OK.jpg','大陆','卡拉OK'); insert into product values(2044,'北京奥运会主题曲',20,50,1000,1342,'好听音乐剧','C:\\Documents and Settings\\Administrator\\桌面\\音乐\\大陆音乐\\北京奥运会主题曲.jpg','大陆','流行音乐'); select * from user_order,order_item,product where user_order.userId=36 and user_order.orderNo=order_item.orderId and order_item.productId=product.productId;