qyxx_table.sql

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

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

prompt Creating QYXX_GOODS...
create table QYXX_GOODS
(
  ID         NUMBER,
  GOOD_NAME  VARCHAR2(100),
  GOOD_PRICE VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating QYXX_MONEY...
create table QYXX_MONEY
(
  ID             NUMBER,
  MOUNT          VARCHAR2(100),
  JIEDAI         VARCHAR2(100),
  DEPART_ID      NUMBER,
  MONEY_MEN      VARCHAR2(100),
  MONEY_PRIORITY VARCHAR2(100),
  MONEY_TIME     VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating QYXX_PRODUCE...
create table QYXX_PRODUCE
(
  ID            NUMBER,
  GOOD_ID       NUMBER,
  PRODUCE_MOUNT NUMBER,
  PRODUCE_TIME  VARCHAR2(100),
  PRODUCE_MEN   VARCHAR2(100),
  PRIORITY      VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating QYXX_SALES...
create table QYXX_SALES
(
  ID          NUMBER,
  GOOD_ID     NUMBER,
  SALES_MOUNT VARCHAR2(100),
  SALES_PRICE VARCHAR2(100),
  SALES_TIME  VARCHAR2(100),
  SALES_MEN   VARCHAR2(100),
  PRIORITY    VARCHAR2(100),
  MONEY_ID    NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating QYXX_USER...
create table QYXX_USER
(
  USERNAME  VARCHAR2(100),
  PASSWORD  VARCHAR2(100),
  PRIORITY  VARCHAR2(100),
  NAME      VARCHAR2(100),
  AGE       VARCHAR2(100),
  SEX       VARCHAR2(100),
  SALARY    VARCHAR2(100),
  DEPART_ID NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for QYXX_DEPARTMENT...
alter table QYXX_DEPARTMENT disable all triggers;
prompt Disabling triggers for QYXX_GOODS...
alter table QYXX_GOODS disable all triggers;
prompt Disabling triggers for QYXX_MONEY...
alter table QYXX_MONEY disable all triggers;
prompt Disabling triggers for QYXX_PRODUCE...
alter table QYXX_PRODUCE disable all triggers;
prompt Disabling triggers for QYXX_SALES...
alter table QYXX_SALES disable all triggers;
prompt Disabling triggers for QYXX_USER...
alter table QYXX_USER disable all triggers;
prompt Deleting QYXX_USER...
delete from QYXX_USER;
commit;
prompt Deleting QYXX_SALES...
delete from QYXX_SALES;
commit;
prompt Deleting QYXX_PRODUCE...
delete from QYXX_PRODUCE;
commit;
prompt Deleting QYXX_MONEY...
delete from QYXX_MONEY;
commit;
prompt Deleting QYXX_GOODS...
delete from QYXX_GOODS;
commit;
prompt Deleting QYXX_DEPARTMENT...
delete from QYXX_DEPARTMENT;
commit;
prompt Loading QYXX_DEPARTMENT...
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (1, '董事会');
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (2, '生产部');
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (3, '销售部');
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (4, '财务部');
commit;
prompt 4 records loaded
prompt Loading QYXX_GOODS...
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (1, '木材', '100');
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (2, '橡胶', '120');
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (3, '石油', '150');
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (4, '钢铁', '180');
commit;
prompt 4 records loaded
prompt Loading QYXX_MONEY...
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (6, '2214', '1', 1, 'admin', '3', '2006-3-3 2:44:45');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (2, '1000', '2', 2, 'b', '1', '2006-3-3 1:20:47');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (7, '14300', '1', 3, 'c', '1', '2006-3-3 15:26:25');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (4, '100', '2', 1, 'admin', '3', '2006-3-3 2:10:30');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (5, '10000', '1', 4, 'b', '2', '2006-3-3 2:38:35');
commit;
prompt 5 records loaded
prompt Loading QYXX_PRODUCE...
insert into QYXX_PRODUCE (ID, GOOD_ID, PRODUCE_MOUNT, PRODUCE_TIME, PRODUCE_MEN, PRIORITY)
values (4, 2, 21213, '2006-3-3 14:12:14', 'a', '2');
insert into QYXX_PRODUCE (ID, GOOD_ID, PRODUCE_MOUNT, PRODUCE_TIME, PRODUCE_MEN, PRIORITY)
values (2, 2, 100, '2006-3-3 11:01:53', 'a', '1');
insert into QYXX_PRODUCE (ID, GOOD_ID, PRODUCE_MOUNT, PRODUCE_TIME, PRODUCE_MEN, PRIORITY)
values (3, 4, 123, '2006-3-3 14:05:53', 'admin', '3');
commit;
prompt 3 records loaded
prompt Loading QYXX_SALES...
insert into QYXX_SALES (ID, GOOD_ID, SALES_MOUNT, SALES_PRICE, SALES_TIME, SALES_MEN, PRIORITY, MONEY_ID)
values (1, 4, '10', '120', '2006-3-3 14:38:13', 'c', '1', 7);
insert into QYXX_SALES (ID, GOOD_ID, SALES_MOUNT, SALES_PRICE, SALES_TIME, SALES_MEN, PRIORITY, MONEY_ID)
values (2, 2, '11', '120', '2006-3-3 14:39:59', 'c', '1', 7);
insert into QYXX_SALES (ID, GOOD_ID, SALES_MOUNT, SALES_PRICE, SALES_TIME, SALES_MEN, PRIORITY, MONEY_ID)
values (3, 4, '10', '120', '2006-3-3 14:41:12', 'c', '1', 7);
insert into QYXX_SALES (ID, GOOD_ID, SALES_MOUNT, SALES_PRICE, SALES_TIME, SALES_MEN, PRIORITY, MONEY_ID)
values (4, 4, '12', '110', '2006-3-3 14:42:48', 'c', '1', 7);
insert into QYXX_SALES (ID, GOOD_ID, SALES_MOUNT, SALES_PRICE, SALES_TIME, SALES_MEN, PRIORITY, MONEY_ID)
values (5, 1, '100', '120', '2006-3-3 14:43:29', 'c', '1', 7);
insert into QYXX_SALES (ID, GOOD_ID, SALES_MOUNT, SALES_PRICE, SALES_TIME, SALES_MEN, PRIORITY, MONEY_ID)
values (6, 4, '110', '130', '2006-3-3 15:26:25', 'c', '1', 7);
commit;
prompt 6 records loaded
prompt Loading QYXX_USER...
insert into QYXX_USER (USERNAME, PASSWORD, PRIORITY, NAME, AGE, SEX, SALARY, DEPART_ID)
values ('admin', 'admin', '3', 'jerry', '23', '男', '1000', 1);
insert into QYXX_USER (USERNAME, PASSWORD, PRIORITY, NAME, AGE, SEX, SALARY, DEPART_ID)
values ('jerry', '123', '3', '哈哈', '23', '男', null, 3);
insert into QYXX_USER (USERNAME, PASSWORD, PRIORITY, NAME, AGE, SEX, SALARY, DEPART_ID)
values ('a', 'a', '2', '生产测试', 'a', 'a', null, 2);
insert into QYXX_USER (USERNAME, PASSWORD, PRIORITY, NAME, AGE, SEX, SALARY, DEPART_ID)
values ('b', 'b', '2', '财务测试', 'b', 'b', null, 4);
insert into QYXX_USER (USERNAME, PASSWORD, PRIORITY, NAME, AGE, SEX, SALARY, DEPART_ID)
values ('c', 'c', '1', 'c', 'c', 'c', null, 3);
commit;
prompt 5 records loaded
prompt Enabling triggers for QYXX_DEPARTMENT...
alter table QYXX_DEPARTMENT enable all triggers;
prompt Enabling triggers for QYXX_GOODS...
alter table QYXX_GOODS enable all triggers;
prompt Enabling triggers for QYXX_MONEY...
alter table QYXX_MONEY enable all triggers;
prompt Enabling triggers for QYXX_PRODUCE...
alter table QYXX_PRODUCE enable all triggers;
prompt Enabling triggers for QYXX_SALES...
alter table QYXX_SALES enable all triggers;
prompt Enabling triggers for QYXX_USER...
alter table QYXX_USER enable all triggers;
set feedback on
set define on
prompt Done.