qiuzhi_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 COMPANY...
create table COMPANY
(
  ID       NUMBER,
  COP_NAME VARCHAR2(100) default '',
  COP_MANN NUMBER default 0,
  COP_CONT NUMBER default '',
  COP_TEL  VARCHAR2(100) default '',
  COP_MAIL VARCHAR2(100) default '',
  COP_TEX  VARCHAR2(100) default '',
  COP_ADDR VARCHAR2(1000) default '',
  COP_ZIP  VARCHAR2(100) default '',
  COP_WWW  VARCHAR2(100) default '',
  COP_DESC VARCHAR2(2000) default '',
  USER_ID  NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating JOBS...
create table JOBS
(
  ID       NUMBER,
  JOB_NAME VARCHAR2(100) default '',
  JOP_MANN NUMBER default 0,
  JOB_ADDR VARCHAR2(100) default '',
  JOB_NUM  NUMBER default 0,
  JOB_GET  VARCHAR2(100) default '',
  JOB_STA  NUMBER default 0,
  JOB_END  NUMBER default 0,
  JOB_GRAD NUMBER default 0,
  JOB_AGE1 NUMBER default 0,
  JOB_AGE2 NUMBER default 0,
  JOB_EXPE NUMBER default 0,
  JOB_LANG NUMBER default 0,
  JOB_ODEM VARCHAR2(1000) default '',
  JOB_OGET VARCHAR2(200) default '',
  COP_ID   NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating REPLY...
create table REPLY
(
  ID        NUMBER,
  USER_ID   NUMBER,
  INTRO     VARCHAR2(2000),
  RESUME_ID NUMBER,
  JOB_ID    NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating RESUME...
create table RESUME
(
  ID       NUMBER,
  JOB_ID   NUMBER,
  INTRO    VARCHAR2(2000),
  USER_ID  NUMBER,
  JOB_NAME VARCHAR2(100),
  COP_NAME VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating USERS...
create table USERS
(
  USERNAME VARCHAR2(40),
  PASSWORD VARCHAR2(40),
  ID       NUMBER,
  NAME     VARCHAR2(100),
  AGE      VARCHAR2(10),
  TELPHONE VARCHAR2(100),
  ROLE     VARCHAR2(10),
  ADDRESS  VARCHAR2(1000),
  EMAIL    VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for COMPANY...
alter table COMPANY disable all triggers;
prompt Disabling triggers for JOBS...
alter table JOBS disable all triggers;
prompt Disabling triggers for REPLY...
alter table REPLY disable all triggers;
prompt Disabling triggers for RESUME...
alter table RESUME disable all triggers;
prompt Disabling triggers for USERS...
alter table USERS disable all triggers;
prompt Deleting USERS...
delete from USERS;
commit;
prompt Deleting RESUME...
delete from RESUME;
commit;
prompt Deleting REPLY...
delete from REPLY;
commit;
prompt Deleting JOBS...
delete from JOBS;
commit;
prompt Deleting COMPANY...
delete from COMPANY;
commit;
prompt Loading COMPANY...
insert into COMPANY (ID, COP_NAME, COP_MANN, COP_CONT, COP_TEL, COP_MAIL, COP_TEX, COP_ADDR, COP_ZIP, COP_WWW, COP_DESC, USER_ID)
values (1, '浙江XX计算机公司', 3, 2, '12345678', '[e-mail]', '87654321', '浙江杭州舟山东路', '312000', 'www.xxcompany.com.cn', '民营企业，注册资本1000万元<br>', 3);
commit;
prompt 1 records loaded
prompt Loading JOBS...
insert into JOBS (ID, JOB_NAME, JOP_MANN, JOB_ADDR, JOB_NUM, JOB_GET, JOB_STA, JOB_END, JOB_GRAD, JOB_AGE1, JOB_AGE2, JOB_EXPE, JOB_LANG, JOB_ODEM, JOB_OGET, COP_ID)
values (2, '软件工程师', 1, '杭州', 10, '2000', 2006, 2007, 2, 20, 25, 2, 1, '无', '无', 1);
insert into JOBS (ID, JOB_NAME, JOP_MANN, JOB_ADDR, JOB_NUM, JOB_GET, JOB_STA, JOB_END, JOB_GRAD, JOB_AGE1, JOB_AGE2, JOB_EXPE, JOB_LANG, JOB_ODEM, JOB_OGET, COP_ID)
values (1, '测试工程师', 0, '杭州', 2, '3000', 2006, 2006, 2, 25, 30, 2, 2, '会法语优先', '没有', 1);
commit;
prompt 2 records loaded
prompt Loading REPLY...
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (1, 2, '简历已进入公司人才库', 2, 1);
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (2, 2, '谢谢', 2, 1);
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (3, 1, '谢谢您的应聘', 1, 1);
insert into REPLY (ID, USER_ID, INTRO, RESUME_ID, JOB_ID)
values (4, 2, '好的，welcome', 3, 2);
commit;
prompt 4 records loaded
prompt Loading RESUME...
insert into RESUME (ID, JOB_ID, INTRO, USER_ID, JOB_NAME, COP_NAME)
values (1, 1, '熟悉JUnit的开发', 1, '测试工程师', '浙江哈哈');
insert into RESUME (ID, JOB_ID, INTRO, USER_ID, JOB_NAME, COP_NAME)
values (2, 1, '熟悉常用的测试工具', 2, '测试工程师', '浙江哈哈');
insert into RESUME (ID, JOB_ID, INTRO, USER_ID, JOB_NAME, COP_NAME)
values (3, 2, '具备J2EE项目开发经验', 2, '软件工程师', '浙江哈哈');
commit;
prompt 3 records loaded
prompt Loading USERS...
insert into USERS (USERNAME, PASSWORD, ID, NAME, AGE, TELPHONE, ROLE, ADDRESS, EMAIL)
values ('test', '123456', 1, '嘿嘿', null, null, '0', null, null);
insert into USERS (USERNAME, PASSWORD, ID, NAME, AGE, TELPHONE, ROLE, ADDRESS, EMAIL)
values ('admin', 'admin', 3, '呵呵', null, null, '1', null, null);
insert into USERS (USERNAME, PASSWORD, ID, NAME, AGE, TELPHONE, ROLE, ADDRESS, EMAIL)
values ('jerry', '123456', 2, '陈好好', '20', '87654321', '0', '浙江省杭州', '[e-mail]');
commit;
prompt 3 records loaded
prompt Enabling triggers for COMPANY...
alter table COMPANY enable all triggers;
prompt Enabling triggers for JOBS...
alter table JOBS enable all triggers;
prompt Enabling triggers for REPLY...
alter table REPLY enable all triggers;
prompt Enabling triggers for RESUME...
alter table RESUME enable all triggers;
prompt Enabling triggers for USERS...
alter table USERS enable all triggers;
set feedback on
set define on
prompt Done.