应用系统模拟期末测试(影碟管理).doc

prompt PL/SQL Developer import file
prompt Created on 2014年6月13日 by Administrator
set feedback off
set define off
prompt Creating T_KHML0422...
create table T_KHML0422
(
khid0422 CHAR(6) not null,
khmc0422 VARCHAR2(20) not null,
khxb0422 CHAR(2),
rqlb0422 VARCHAR2(10),
jtdz0422 VARCHAR2(40) not null,
lxdh0422 NUMBER(14) not null,
xhjq0422 VARCHAR2(20),
dlrq0422 CHAR(8) not null,
zybz0422 VARCHAR2(30)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table T_KHML0422
add primary key (KHID0422)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

prompt Creating T_YDML0422...
create table T_YDML0422
(
ydid0422 CHAR(8) not null,
ydmc0422 VARCHAR2(30) not null,
gjrq0422 CHAR(8) not null,
gjjg0422 NUMBER(6) not null,
jqlb0422 CHAR(6) not null,
yzdm0422 CHAR(2) not null,
shrq0422 VARCHAR2(10) not null,
xjbs0422 CHAR(3) not null,
ydzt0422 CHAR(1) not null,
zybz0422 VARCHAR2(30)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 8K
minextents 1
maxextents unlimited
);
alter table T_YDML0422
add constraint I_YDML_YDID0422 primary key (YDID0422)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

prompt Creating T_ZJJG0422...
create table T_ZJJG0422
(
jgid0422 NUMBER(1) not null,
jgmc0422 VARCHAR2(20),
zjjg0422 NUMBER(6,1) not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table T_ZJJG0422
add primary key (JGID0422)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

prompt Creating T_ZJRB0422...
create table T_ZJRB0422
(
jhbh0422 NUMBER(8) not null,
zjrq0422 CHAR(8) not null,
khid0422 CHAR(6) not null,
ydid0422 CHAR(8) not null,
jgid0422 CHAR(1) not null,
yhrq0422 CHAR(8) not null,

zjyj0422 NUMBER(6) not null,
clbz0422 CHAR(1)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

prompt Disabling triggers for T_KHML0422...
alter table T_KHML0422 disable all triggers;
prompt Disabling triggers for T_YDML0422...
alter table T_YDML0422 disable all triggers;
prompt Disabling triggers for T_ZJJG0422...
alter table T_ZJJG0422 disable all triggers;
prompt Disabling triggers for T_ZJRB0422...
alter table T_ZJRB0422 disable all triggers;
prompt Deleting T_ZJRB0422...
delete from T_ZJRB0422;
commit;
prompt Deleting T_ZJJG0422...
delete from T_ZJJG0422;
commit;
prompt Deleting T_YDML0422...
delete from T_YDML0422;
commit;
prompt Deleting T_KHML0422...
delete from T_KHML0422;
commit;
prompt Loading T_KHML0422...
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100020', '李丽', '女', '职员', '河松街23号', 13103657885, '言情片', '20140522', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100021', '王秀珠', '女', '学生', '河广街255号', 18846451267, '喜剧', '20140222', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100001', '沈华', '女', '职员', '前进路4号', 13645221597, '恐怖片', '20140311', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100002', '王钊', '男', '教师', '七政街6号', 13648958554, '言情片', '20140503', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100003' '李明', '男', '售货员', '上海路133号', 18946152565, '喜剧', '20130811', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100004', '张雪', '女', '学生', '和兴路7号', 18642265845, '科幻', '20130808', null);
insert into T_KHML0422 (khid0422 khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100005', '李雪', '女', '教师', '汉广街4号', 18813564855, '记录片', '20140512', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100006', '朱岩', '男', '司机', '赣水路4号', 18103655844, '喜剧', '20131223', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100007', '沈浪', '男', '职员', '中央大街4号', 13515256884, '体育', '20140102', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100008', '金宏', '男', '学生', '红旗大街256号', 13878675669, '纪录片', '20140404', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100009', '王琳', '女', '售货员', '尚志大街4号', 13877675663, '言情片', '20140601', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100010', '黄晓明', '男', '学生', '经纬街4号', 18214853654, '喜剧', '20131130', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100011', '尚明玉', '女', '售货员', '石头道街4号', 18145622654, '纪录片', '20131225', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100012', '张翰', '男', '演员', '上海路124号', 18345625854, '恐怖片', '20140302', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100013', '王海峰', '男', '司机', '地段街78号', 18365842564, '恐怖片', '20140605', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100014', '江清', '男', '教师', '果戈里大街4号', 13878675263, '科幻片', '20130831', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100015', '吴翰', '男', '司机', '公滨路66号', 13845515462, '喜剧', '20130802', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100016', '杨过', '男', '学生', '红军街156号', 13278675663, '儿童片', '20140502', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100017', '常丽丽', '女', '职员', '一曼街4号', 13645251245, '言情片', '20130811', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100018', '李冰', '女', '学生', '中山路89号', 13345685424, '儿童片', '20140427', null);
insert into T_KHML0422 (khid0422, khmc0422, khxb0422, rqlb0422, jtdz0422, lxdh0422, xhjq0422, dlrq0422, zybz0422)
values ('100019', '白飞飞', '女', '学生', '新阳路130号', 13878675641, '儿童片', '20140409', null);
commit;
prompt 21 records loaded
prompt Loading T_YDML0422...
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('12001201', '前任攻略', '20140601', 80, '言情片', 'CN', '成年人', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('20000101', '舌尖上的中国', '20140525', 100, '记录片', 'CN', '成年人', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('11006701', '暮光之城1-破晓上', '20121225', 60, '言情片', 'EN', '少年', 'OLD', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('11006702', '暮光之城2-破晓上', '20130105', 60, '言情片', 'EN', '少年', 'OLD', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('11006703', '整容日记', '20140601', 98, '言情片', 'CN', '成年人', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('31004803', '变形金刚3', '20121230', 70, '科幻片', 'EN', '成年人', 'OLD', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('22003401', '消失的子弹', '20130809', 50, '记录片', 'CN', '成年人', 'OLD', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('41002401', '喜剧之王', '20140511', 80, '喜剧片', 'CN', '少年', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('40001401', '让子弹飞', '20121215', 44, '喜剧片', 'CN', '成年人', 'OLD', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('48004601', '澳门风云', '20140301', 100, '喜剧片', 'CN', '成人片', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('52003301', '惊魂游戏', '20140103', 90, '恐怖片', 'CN', '成年人', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('59004301', '鬼影实录', '20140610', 85, '恐怖片', 'EL', '成年人', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('29002901', '刺陵', '20120908', 30, '记录片', 'CN', '成年人', 'OLD', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('22004101', '二次曝光', '20140301', 50, '记录片', 'CN', '成年人', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('68004201', '叶问', '20130812', 54, '历史片', 'CN', '少年', 'OLD', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('62004701', '新三国', '20140112', 46, '历史片', 'CN', '成年人', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('72003501', '喜洋洋之开心闯龙年', '20120423', 70, '儿童片', 'CN', '儿童', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('78005601', '小鬼精灵', '20140522', 70, '儿童片', 'EL', '儿童', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('38003901', '冰雪奇缘', '20140305', 100, '科幻片', 'EL', '儿童', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('31004801', '变形金刚1', '20130621', 50, '科幻片', 'CN' '少年', 'OLD', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('12004801', '同桌的你', '20140601', 100, '言情片', 'JP', '成年人', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422 jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('82006901', '无限极之极限速递', '20140122', 57, '体育片', 'CN', '成年人', 'NEW', 'J', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('89006801', '十月围城', '20140409', 40, '体育片', 'CN', '成年人', 'NEW', 'Z', null);
insert into T_YDML0422 (ydid0422, ydmc0422, gjrq0422, gjjg0422, jqlb0422, yzdm0422, shrq0422, xjbs0422, ydzt0422, zybz0422)
values ('31004802', '变形金刚2', '20130621', 50, '科幻片', 'CN', '少年', 'OLD', 'Z', null);
commit;
prompt 24 records loaded
prompt Loading T_ZJJG0422...
insert into T_ZJJG0422 (jgid0422, jgmc0422, zjjg0422)
values (1, '租借一天', 6.6);
insert into T_ZJJG0422 (jgid0422, jgmc0422, zjjg0422)
values (3, '租借三天', 7.5);
insert into T_ZJJG0422 (jgid0422, jgmc0422, zjjg0422)
values (7, '租借一周', 3.3);
commit;
prompt 3 records loaded
prompt Loading T_ZJRB0422...
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (5, '20140212', '100010', '40001401', '3', '20140215', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (6, '20131121', '100005', '20000101', '1', '20131122', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (7, '20140606', '100020', '48004601', '7', '20140613', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (8, '20140101', '100003', '29002901', '7', '20140108', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (9, '20131225', '100011', '11006703', '1', '20131226', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (10, '20140306', '100008', '59004301', '1', '20140307', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (11, '20140606', '100016', '11006701', '1', '20140607', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (12, '20140301', '100010', '41002401', '3', '20140304', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (13, '20131231', '100017', '12004801', '7', '20140107', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (14, '20140404', '100003', '89006801', '3', '20140407', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422, zjyj0422, clbz0422)
values (15, '20131229', '100004', '11006702', '3', '20140101', 100, 'C');
insert into T_ZJRB0422 (jhbh0422, zjrq0422, khid0422, ydid0422, jgid0422, yhrq0422,