insert_data.sql

一个简易的网上书店（jsp+sqlservler+struts）。

use eshop;
insert into supplier  values(10001,'xxxx电子出版社','1','北京xxx路xxx号','','北京','北京','100082','1234567');

insert into category values('001','计算机图书','最新的计算机图书');
insert into category values('002','English图书','英语考试类、普及读物等');
insert into category values('003','VCD','流行电影,VCD光盘');

INSERT INTO product VALUES ('4512331123','001','使用WSAD开发Web应用','WSAD开发案例，详细介绍了在WSAD下开发J2EE Web应用的教程');
INSERT INTO product VALUES ('4512331124','001','Webshpere管理参考','管理Webshpere应用服务器的必备书籍');
INSERT INTO product VALUES ('4512331125','001','DB2 参考手册','管理DB2服务器的必备书籍');
INSERT INTO product VALUES ('1931182140','001','Building Applications with IBM WebSphere Studio and JavaBeans: A Guided Tour','Building Applications with IBM WebSphere Studio and JavaBeans: A Guided Tour');
INSERT INTO product VALUES ('032118579X','001','Enterprise Java Programming with IBM WebSphere, Second Edition','Enterprise Java Programming with IBM WebSphere, Second Edition');
INSERT INTO product VALUES ('0471133051','001','IBM Data Warehousing: With IBM Business Intelligence Tools','IBM Data Warehousing: With IBM Business Intelligence Tools');
INSERT INTO product VALUES ('0201616173','001','Enterprise Java Programming with IBM WebSphere','详细介绍在WebSphere下开发EJB');
INSERT INTO product VALUES ('0764543660','001','Professional IBM WebSphere 5.0 Application Server','WebSphere 5.0 Application Server专业书籍');
INSERT INTO product VALUES ('0123456789','001','IBM Best Practices for Developing WebSphere based Applications 2002','IBMBest Practices for Developing WebSphere based Applications 2002');
INSERT INTO product VALUES ('1885068921','001','Exploring IBM e-Business Software: Become an Instant Insider on IBM s Internet','Exploring IBM e-Business Software: Become an Instant Insider on IBM s Internet');

INSERT INTO product VALUES ('7505391496','002','大学英语四级考试大全','书中收集了1995年1月至2003年6月，共计18套试题，旨在给读者提供更多的实践机会...');
INSERT INTO product VALUES ('750122076X','002','GRE写作','充分认识GRE作文考试对你提出的严峻挑战，不迷信任何号称一步登天的捷径，而是脚踏实地地努力提高自己的综合素质...');

INSERT INTO product VALUES ('321s12312','003','傲慢与偏见:BBC十六项大奖（6VCD)','奥斯汀传世经典，英国BBC公司1995年巨制，重现英国十九世纪初社会风貌，优雅的文化，幽默的对白，沁人心脾的爱情……');

insert into item values('04061003a','1931182140',49.2,59.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061003b','1931182140',45.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061003c','1931182140',30.0,37.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061004a','032118579X',55.2,66.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/032118579X.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061004b','032118579X',45.2,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/032118579X.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061004c','032118579X',35.2,46.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/032118579X.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061005a','0123456789',39.2,55.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061005b','0123456789',33.5,45.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061005c','0123456789',15.0,27.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061006a','0201616173',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061006b','0201616173',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061006c','0201616173',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061007a','4512331123',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061007b','4512331123',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061007c','4512331123',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061008a','4512331124',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061008b','4512331124',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061008c','4512331124',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061009a','4512331125',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061009b','4512331125',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061009c','4512331125',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061010a','0471133051',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061010b','0471133051',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061010c','0471133051',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061011a','1885068921',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061011b','1885068921',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061011c','1885068921',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061012a','750122076X',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061012b','750122076X',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061012c','750122076X',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

insert into item values('04061013a','7505391496',56.2,69.5,10001,'1','精装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061013b','7505391496',47.5,56.5,10001,'1','普通装图书','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');
insert into item values('04061013c','7505391496',32.0,35.5,10001,'1','电子版','内容介绍：','相关产品：','封面：<img src="http://images.amazon.com/images/P/1931182140.01.MZZZZZZZ.jpg">','评论：');

INSERT INTO sequence VALUES('orders', 1000);
INSERT INTO sequence VALUES('ordernum', 1000);
INSERT INTO sequence VALUES('creditcardinfo', 1000);