用Java EE 5实现的网上书店实例

create table "BOOK"."CUSTOMER"
(
"CUSTOMER_ID" CHAR(12) not null primary key,
"CUSTOMER_NAME" VARCHAR(30),
"EMAIL" VARCHAR(40)
);
insert into customer values ( 'ada', 'Ada Li', 'ada.li@sun.com');
insert into customer values ( 'joey', 'Joey Shen', 'joey.shen@sun.com');
insert into customer values ( 'michael', 'Michael Li', 'tao.li@sun.com');
create table "BOOK"."PRODUCT"
(
"PRODUCT_ID" INTEGER not null primary key,
"PRODUCT_NAME" VARCHAR(100),
"PURCHASE_COST" DECIMAL(12,2)
);
insert into product values ( 1, 'Java(TM) EE 5 Tutorial', 34.64);
insert into product values ( 2, 
'Java EE 5 Development using Glassfish Application Server', 32.50);
insert into product values ( 3, 'Enterprise JavaBeans 3.0', 31.49);
insert into product values ( 4, 
'Sun Certified Enterprise Architect for Java EE study Guide', 32.99);
insert into product values ( 5, 'Java ME Game Programming', 49.99);
create table "BOOK"."PURCHASE_ORDER"
(
"ORDER_NUM" INTEGER not null primary key,
"CUSTOMER_ID" CHAR(12) not null,
"PRODUCT_ID" INTEGER not null,
"QUANTITY" SMALLINT
);
insert into PURCHASE_ORDER values ( 1, 'ada', 1, 1);
insert into PURCHASE_ORDER values ( 2, 'ada', 5, 1);
insert into PURCHASE_ORDER values ( 3, 'joey', 2, 2);