estore.sql

该系统的主要功能是

create table orderform(
	id number primary key,
    	cost number(8,2),
		orderdate date,
    	customerid number references customer(id)
);

create table orderline(
	id number primary key,
	num number not null,
	orderid number references orderform(id),	
	bookid number references book(id)
);

create table book(
	id number primary key,
	name varchar2(100),
	price number(8,2)
);
insert into book values(1,'JAVA核心技术',81.00);
insert into book values(2,'UNIX技术手册',21.15);
insert into book values(3,'ORACLE9I参考手

册',108.00);
insert into book values(4,'JSP设计(第三

版)',59.25);
insert into book values(5,'JAVA SERVLET 编程(第二

版)',38.25);
insert into book values(6,'XML 高级编程(第2

版)',97.20);
insert into book values(7,'精通STRUTS:基于MVC的

JAVA WEB设计与开发',36.75);
insert into book values(8,'精通HIBERNATE：JAVA对象

持久化技术详解',44.25);
insert into book values(9,'SPRING IN ACTION中文

版',29.25);
insert into book values(10,'精通EJB 3.0',44.25);

create table customer(
	id number primary key,
	name varchar2(20),
	password varchar2(20),
	zip varchar2(20),
	address varchar2(50),
	telephone varchar2(20),
	email varchar2(30)
);

create sequence book_seq start with 1 increment by 

1;
create sequence customer_seq start with 1 

increment by 1;
create sequence orderform_seq start with 1 

increment by 1;
create sequence orderline_seq start with 1 

increment by 1;

C:\Program Files\MyEclipse 5.5.1 GA\eclipse\plugins\com.genuitec.org.hibernate.eclipse_5.5.0\lib\hibernate
#下次用hibernate时导入调用此包