course.sql

基于struts和ORACLE的课程查询

DROP TABLE coursetype CASCADE CONSTRAINTS;
CREATE TABLE coursetype(	
	id 		NUMBER 		PRIMARY KEY,
	name		VARCHAR2 (100) 	NOT NULL
);

DROP TABLE course CASCADE CONSTRAINTS;
CREATE TABLE course(	
	id 		NUMBER 		PRIMARY KEY,
	classno		VARCHAR2 (20) 	NOT NULL,
	coursename	VARCHAR2 (100) 	NOT NULL,
	price		NUMBER   	NULL,
	place		VARCHAR2 (100) 	NULL,
	time		VARCHAR2 (200) 	NULL,
	detail		VARCHAR2 (4000) NULL,
	condition	VARCHAR2 (200) 	NULL,
	coursetypeid 	NUMBER  
			REFERENCES coursetype(id) ON DELETE CASCADE 	
);

insert into coursetype values(1,'软件工程师就业班');
insert into coursetype values(2,'电脑美术就业班');

insert into course values(1,'J101','Java就业班',5000,'中关村','周一~周五','Java就业班','专科',1);
insert into course values(2,'c102','软件测试班',4000,'中关村','周一~周五','软件测试班','专科',1);