kjgl_table.sql

JSP+oracle开发实例精粹》随书光盘

prompt PL/SQL Developer import file
prompt Created on 2006年10月21日 by Jerry
set feedback off
set define off
prompt Creating ADMIN...
create table ADMIN
(
  ID       NUMBER,
  NAME     VARCHAR2(100),
  PASSWORD VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating CLASSES...
create table CLASSES
(
  ID        NUMBER,
  TEA_ID    NUMBER,
  COUR_ID   NUMBER,
  COUR_TIME VARCHAR2(1000),
  ROOM_ID   VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating COURSE...
create table COURSE
(
  ID      NUMBER,
  NAME    VARCHAR2(100),
  MARK    NUMBER,
  DEP     VARCHAR2(100),
  PREPARE VARCHAR2(1000)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating ENROL...
create table ENROL
(
  STU_ID   NUMBER,
  CLASS_ID NUMBER,
  ACCEPT   VARCHAR2(100) default '0',
  SCORE    NUMBER default 0
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating STUDENT...
create table STUDENT
(
  ID         NUMBER,
  NAME       VARCHAR2(100),
  PASSWORD   VARCHAR2(100),
  JIGUAN     VARCHAR2(200),
  DEPARTMENT VARCHAR2(100),
  SEX        VARCHAR2(100),
  TEL        VARCHAR2(100),
  EMAIL      VARCHAR2(200),
  MARK       NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating TEACHER...
create table TEACHER
(
  ID       NUMBER,
  NAME     VARCHAR2(100),
  TITLE    VARCHAR2(200),
  PASSWORD VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for ADMIN...
alter table ADMIN disable all triggers;
prompt Disabling triggers for CLASSES...
alter table CLASSES disable all triggers;
prompt Disabling triggers for COURSE...
alter table COURSE disable all triggers;
prompt Disabling triggers for ENROL...
alter table ENROL disable all triggers;
prompt Disabling triggers for STUDENT...
alter table STUDENT disable all triggers;
prompt Disabling triggers for TEACHER...
alter table TEACHER disable all triggers;
prompt Deleting TEACHER...
delete from TEACHER;
commit;
prompt Deleting STUDENT...
delete from STUDENT;
commit;
prompt Deleting ENROL...
delete from ENROL;
commit;
prompt Deleting COURSE...
delete from COURSE;
commit;
prompt Deleting CLASSES...
delete from CLASSES;
commit;
prompt Deleting ADMIN...
delete from ADMIN;
commit;
prompt Loading ADMIN...
insert into ADMIN (ID, NAME, PASSWORD)
values (1, 'admin', 'admin');
commit;
prompt 1 records loaded
prompt Loading CLASSES...
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (1, 1, 1, 'Mon_2', '101');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (2, 2, 2, 'Mon_1', '103');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (3, 1, 1, 'Fri_3', '306');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (4, 1, 1, 'Thurs_2', '102');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (5, 1, 1, 'Wed_2', '201');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (7, 2, 2, 'Tues_1', '103');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (6, 2, 2, 'Wed_1', '202');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (8, 3, 3, 'Mon_3', '105');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (9, 3, 3, 'Tues_3', '205');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (10, 5, 5, 'Thurs_3', '304');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (11, 4, 5, 'Wed_2', '201');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (12, 6, 11, 'Thurs_3', '101');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (14, 6, 1, 'Fri_3', '303');
insert into CLASSES (ID, TEA_ID, COUR_ID, COUR_TIME, ROOM_ID)
values (15, 5, 7, 'Wed_3', '301');
commit;
prompt 14 records loaded
prompt Loading COURSE...
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (1, '电子商务', 2, '计算机', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (2, '计算机文化', 2, 'public', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (3, '计算机图形学', 4, '计算机', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (4, '数学分析', 4, '数学系', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (5, '线性代数', 3, '数学系', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (6, '微积分', 4, '数学系', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (7, '数字电路', 4, '信电系', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (8, '逻辑电路', 4, '信电系', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (9, '概率', 2, '数学系', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (10, '操作系统', 4, '计算机', '0');
insert into COURSE (ID, NAME, MARK, DEP, PREPARE)
values (11, 'C语言', 4, '计算机', '0');
commit;
prompt 11 records loaded
prompt Loading ENROL...
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050001, 1, '1', 60);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050001, 2, '1', 80);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050001, 8, '1', 80);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050001, 10, '1', 70);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050001, 12, '1', 80);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050001, 15, '1', 90);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050004, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050002, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050003, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050005, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050006, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050007, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050008, 3, '1', 0);
insert into ENROL (STU_ID, CLASS_ID, ACCEPT, SCORE)
values (20050009, 3, '1', 0);
commit;
prompt 14 records loaded
prompt Loading STUDENT...
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050005, '张三', '123456', '北京', '计算机', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050002, '沈哈哈', '123456', '陕西', '计算机', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050003, '吴杰瑞', '123456', '河南', '计算机', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050001, '沈大伟', '123456', '浙江', '计算机', '男', null, null, 12);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050004, '王二', '123456', '江苏', '计算机', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050006, '李四', '123456', '上海', '机电系', '女', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050007, '陈五', '123456', '浙江', '信电系', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050008, '诸葛七', '123456', '北京', '数学系', '女', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050009, '赵十', '123456', '广东', '数学系', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050010, '吴大卫', '123456', '浙江', '机电系', '男', null, null, 0);
insert into STUDENT (ID, NAME, PASSWORD, JIGUAN, DEPARTMENT, SEX, TEL, EMAIL, MARK)
values (20050011, '周颖', '123456', '上海', '信电系', '女', null, null, 0);
commit;
prompt 11 records loaded
prompt Loading TEACHER...
insert into TEACHER (ID, NAME, TITLE, PASSWORD)
values (1, '吴呵呵', '讲师', '123456');
insert into TEACHER (ID, NAME, TITLE, PASSWORD)
values (2, '张老师', '教授', '123456');
insert into TEACHER (ID, NAME, TITLE, PASSWORD)
values (3, '王老师', '讲师', '123456');
insert into TEACHER (ID, NAME, TITLE, PASSWORD)
values (4, '赵老师', '教授', '123456');
insert into TEACHER (ID, NAME, TITLE, PASSWORD)
values (5, '周老师', '讲师', '123456');
insert into TEACHER (ID, NAME, TITLE, PASSWORD)
values (6, '陈老师', '教授', '123456');
commit;
prompt 6 records loaded
prompt Enabling triggers for ADMIN...
alter table ADMIN enable all triggers;
prompt Enabling triggers for CLASSES...
alter table CLASSES enable all triggers;
prompt Enabling triggers for COURSE...
alter table COURSE enable all triggers;
prompt Enabling triggers for ENROL...
alter table ENROL enable all triggers;
prompt Enabling triggers for STUDENT...
alter table STUDENT enable all triggers;
prompt Enabling triggers for TEACHER...
alter table TEACHER enable all triggers;
set feedback on
set define on
prompt Done.