sql

网上购物车的JAVA代码实现版

create table cart_user(
        id integer primary key,
        name varchar(32) not null unique,
        password varchar(32) not null,
        address varchar(512),
        postcode varchar(10),
        email varchar(32),
        home_phone varchar(32),
        cell_phone varchar(32),
        office_phone varchar(32)
);
insert into cart_user(id,name,password,address,postcode,email,home_phone,cell_phone,office_phone) 
	values(1,'zhufl','zhufl','shangdong','100081','[e-mail]','62136369','62136369','62136369');

create table cart_product(
 	id integer primary key,
 	name varchar(32) not null,
	description varchar(64),
	price number(8,2) not null
 );
 insert into cart_product(id,name,description,price) values(1,'pencil','pencil',2.00);
 insert into cart_product(id,name,description,price) values(2,'pen','pen',5.00);
 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);
 
 
 create table cart_order(
 	id integer primary key,
 	status number(2) ,
 	user_id integer not null references cart_user(id),
 	cost number(10,2)
 );
 
 
 create table cart_order_item(
 	id integer primary key,
 	amount integer,
 	cost number,
 	product_id integer not null references cart_product(id),
 order_id integer not null references cart_order(id)
 );
 
create sequence cart_user_seq ;
 create sequence cart_order_seq;
 create sequence cart_order_item_seq;