productinsert.sql

全面应用Java网络Web

connect 'jdbc:rmi://localhost:1099/jdbc:cloudscape:Bookstore;create=true'
;

insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130895725','C How to Program','Prentice Hall','Deitel & Deitel','chtp3.jpg',69.95,1200,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0132261197','C How to Program','Prentice Hall','Deitel & Deitel','chtp2.jpg',49.95,1200,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130895717','C++ How to Program','Prentice Hall','Deitel & Deitel','cpphtp3.jpg',69.95,1400)
;
insert into Product (ISBN,title,publisher,author, image,price,pages) values ('0135289106','C++ How to Program','Prentice Hall','Deitel & Deitel','cpphtp2.jpg',49.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0139163050','The Complete C++ Training Course','Prentice Hall','Deitel & Deitel','cppctc3.jpg',109.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('013028419x','e-Business and e-Commerce How to Program','Prentice Hall','Deitel, Deitel & Nieto','ebechtp1.jpg',69.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130161438','Internet and World Wide Web How to Program','Prentice Hall','Deitel, Deitel & Nieto','iw3htp1.jpg',69.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130856118','The Complete Internet and World Wide Web Programming Training Course','Prentice Hall','Deitel, Deitel & Nieto','iw3ctc1.jpg',109.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130125075','Java How to Program (Java 2)','Prentice Hall','Deitel & Deitel','jhtp3.jpg',69.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0138993947','Java How to Program (Java 1.1)','Prentice Hall','Deitel & Deitel','jhtp2.jpg',49.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130852473','The Complete Java 2 Training Course','Prentice Hall','Deitel & Deitel','javactc3.jpg',109.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130829277','The Complete Java Training Course (Java 1.1)','Prentice Hall','Deitel & Deitel','javactc2.jpg',99.95,1400)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0134569555','Visual Basic 6 How to Program','Prentice Hall','Deitel, Deitel & Nieto','vbhtp1.jpg',69.95,1000)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130829293','The Complete Visual Basic 6 Training Course','Prentice Hall','Deitel, Deitel & Nieto','vbctc1.jpg',109.95,1000)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130284173','XML How to Program','Prentice Hall','Deitel, Deitel, Nieto, Lin & Sadhu','xmlhtp1.jpg',69.95,1100)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130284181','Perl How to Program','Prentice Hall','Deitel, Deitel, Nieto & McPhie','perlhtp1.jpg',69.95,1000)
;
insert into Product (ISBN,title,publisher,author,image,price,pages) values ('0130895601','Advanced Java 2 Platform How to Program','Prentice Hall','Deitel, Deitel & Santry','advjhtp1.jpg',69.95,1600)
;