pointbase.createproducts.sql~

来自「精通EJB3.0一书的全部随书实例的源代码。」· SQL~ 代码 · 共 13 行

drop table productsbean;

create table productsbean (productId varchar(64), name varchar(64), basePrice numeric(18), description varchar(64));


insert into productsbean values ('1', 'Pentium III', 2000, 'Intel brand, 256k Level2 cache');
insert into productsbean values ('2', 'Celeron', 800, 'Low-end mainstream machine');
insert into productsbean values ('3', 'Pentium I', 500, 'Refurbished machine');
insert into productsbean values ('4', 'Mac', 2500, 'Color iMac');
insert into productsbean values ('5', 'Pentium II', 500, 'Mid-level machine');
insert into productsbean values ('6', 'Athlon', 3500, 'AMD Flagship');