deitelbooks.sql

来自「java web services how to program」· SQL 代码 · 共 32 行

connect 'jdbc:cloudscape:rmi:deitelbooks;create=true'
;

drop table titles
;

create table titles (
	isbn varchar (20) NOT NULL,
	title varchar (100) NOT NULL,
   authors varchar (255) NOT NULL,
   description varchar (255) NOT NULL,
	coverImageURL varchar (255) NOT NULL,
	constraint pk_titles primary key (isbn)
) 
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130895725','C How to Program','Deitel & Deitel','C Description','http://www.deitel.com/books/cHTP3/images/cHTP3_thumb.jpg' )
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130895717','C++ How to Program','Deitel & Deitel','C++ Description','http://www.deitel.com/books/cppHTP3/images/cppHTP3_thumb.jpg')
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130308978','Internet and World Wide Web How to Program','Deitel, Deitel & Nieto','IW3HTP Description','http://www.deitel.com/books/iw3HTP2/images/iw3HTP2_thumb.jpg')
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130341517','Java How to Program','Deitel & Deitel','Java Description','http://www.deitel.com/books/jHTP4/images/jHTP4_thumb.jpg' )
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0134569555','Visual Basic .NET How to Program','Deitel, Deitel & Nieto','VB.NET Description','http://www.deitel.com/books/vbnetHTP2/images/vbnetHTP2_thumb.jpg' )
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130293636','XML How to Program','Deitel, Deitel, Nieto, Lin & Sadhu','XML Description','http://www.deitel.com/books/xmlHTP1/images/xmlHTP1_thumb.jpg')
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130284181','Perl How to Program','Deitel, Deitel, Nieto & McPhie','Perl Description','http://www.deitel.com/books/perlHTP1/images/perlHTP1_thumb.jpg')
;
insert into titles (isbn,title,authors,description,coverImageURL) values ('0130895601','Advanced Java 2 Platform How to Program','Deitel, Deitel & Santry','Advanced Java Description','http://www.deitel.com/books/advjHTP1/images/advjHTP1_thumb.jpg')
;