1201707062886.sql

基于J2EE的办公自动化系统。实现流程定义流程办理等。运用了hibernate+struts+spring框架综合运用的系统。

prompt PL/SQL Developer import file
prompt Created on 2008年1月27日 by admin
set feedback off
set define off
prompt Disabling triggers for TRANSTYPE...
alter table TRANSTYPE disable all triggers;
prompt Deleting TRANSTYPE...
delete from TRANSTYPE;
commit;
prompt Loading TRANSTYPE...
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (622, '请假4', '1201223288453.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (624, '请假5', '1201223397718.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (226, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (227, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (228, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (229, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (626, '请假5', '1201223542390.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (34, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (628, '水水水', '1201223604796.xml', '2008-01-25', null, '0', 1, '2,1');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (222, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (231, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (232, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (233, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (234, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (235, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (236, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (237, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (238, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (239, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (240, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (241, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (242, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (243, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (244, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (245, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (246, '请假', '1200981368156.xml', '2008-01-22 05:56:08', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (630, '发工资', '1201224802953.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (632, '工资', '1201224848656.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (634, '淡淡的', '1201225083437.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (636, 'sssssssss', '1201225674468.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (638, 'ggg', '1201225703546.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (640, 'aaa', '1201226044718.xml', '2008-01-25', null, '0', 1, '1,2,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (642, 'fff', '1201226314593.xml', '2008-01-25', null, '0', 1, '1,2,3,10,11');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (644, 'ssff', '1201226435203.xml', '2008-01-25', null, '0', 1, '1,2,3,10,11');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (646, 'ssff', '1201226743390.xml', '2008-01-25', null, '0', 1, '1,2,3,10,11');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (648, 'hhhh', '1201226769343.xml', '2008-01-25', null, '0', 1, '1,2,3,10,11');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (650, 'test3', '1201228260781.xml', '2008-01-25', null, '0', 2, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (655, 'test10', '1201228430609.xml', '2008-01-25', null, '0', 1, '1,3');
insert into TRANSTYPE (RTID, TNAME, TXMLPATH, TTIME, UNO, TFLAG, TSTEP, TRID)
values (657, '回家', '1201230398671.xml', '2008-01-25', null, '0', 1, '1');
commit;
prompt 39 records loaded
prompt Enabling triggers for TRANSTYPE...
alter table TRANSTYPE enable all triggers;
set feedback on
set define on
prompt Done.