oracle.sql

来自「网上书城源代码~~在学习JAVA的时候做的」· SQL 代码 · 共 47 行

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 table orderform(
	id number primary key,
    	cost number(8,2),
	orderdate date,
    	customerid number references customer(id)
);

create table book(
	id number primary key,
	name varchar2(100),
	price number(8,2)
);
create table orderline(
	id number primary key,
	num number not null,
	orderid number references orderform(id),	
	bookid number references book(id)
);

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 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;