cart_product.sqlpage

来自「网上商城源代码！实现了书店的列表和增加」· SQLPAGE 代码 · 共 18 行

<?xml version="1.0" encoding="UTF-8"?>
<SQLPage nameConnection="jdbc:mysql://127.0.0.1:3306/shop">
<Statement><![CDATA[create table cart_product(
id integer primary key,
name varchar(32) not null,
description varchar(64),
price double(8,2) not null);
insert into cart_product (id,name,description,price)values(1,'core java','core java,jdk5.0',32.5);

insert into cart_product (id,name,description,price)values(2,'pen','pen',3.5);
insert into cart_product(id,name,description,price) values(3,'rubber','rubber',1.00); 
insert into cart_product(id,name,description,price) values(4,'notebook','notebook',2.00); 
insert into cart_product(id,name,description,price) values(5,'gluewater','gluewater',5.00); 
insert into cart_product(id,name,description,price) values(6,'pencilcase','pencilcase',10.00);
insert into cart_product(id,name,description,price) values(7,'ballpen','ballpen',2.00);
select * from cart_product;]]></Statement>
</SQLPage>