Here are async Export code experience .

Here are async Export code demo .

1. Async Export
2. Export 使用
   1. 1、Tables
   2. 2、编写配置

Async Export

Export 使用

1、Tables

控制导出报表类型

CREATE TABLE AMS.AMS_QUERYCONTROL_TD (
TASKCODE VARCHAR2(20) NOT NULLTASKNAME VARCHAR2 (200),
INPORTPARAM VARCHAR2 (4000) ,
LASTOPDATE DATE DEFAULT SySdate NOT NULL, 
CREATETIMEDATE DEFAULT SySdate NOT NULL,
MODIFYDESC VARCHAR2(200),
HIBERNATEVERSION NUMBER(5)DEFAULT 1 NOT NULL,
CONSTRAINTPK_Q_CONTROL_OO1PRIMARY KEY(TASKCODE)
);
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.TASKCODE IS'任务类型';
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.TASKNAME IS'任务名称';
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.INPORTPARAM IS 'excel字段中文名称';
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.LASTOPDATE IS '最后操作日期！';
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.CREATETIME IS '数据库系统时间';
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.MODIFYDESC IS '手工修改记录';
COMMENT ON COLUMN AMS.AMS_QUERYCONTROL_TD.HIBERNATEVERSION IS '版本号';

示例数据

INSERT INTO AMS.AMS_QUERYCONTROL_TD (TASKCODE, TASKNAME, INPORTPARAM, LASTOPDATE, CREATETIME, MODIFYDESC,HIBERNATEVERSION)
VALUES（'1001','银行数据导出明细','com.small.pojo.AmsAccountImpDataDetailTdExport=tradedate:交易日期,paymentbank:付款开户行,paymentname:付款户名paymentno:付款账号，summaryinfo:摘要,realstatus:核销状态，amount:金额,realamount:已核销金额,unrealamount:未核销金领状态，importtype：接入方式，accountname：收款户名，accountno：收款账号，tounitcode：入账机构，opdate：操作日期，useableno额,currencycode:币种,unitnameofopcode:认领人财务机构,departmentnameofopcode:认领人部门,processor:认领人,ifuse:认:预收款流水号businesstype:类型', SYSDATE, SYSDATE, null,1);

INSERT INTO AMS.AMS_QUERYCONTROL_TD (TASKCODE， TASKNAME， INPORTPARAM, LASTOPDATE， CREATETIME， MODIFYDESC,HIBERNATEVERSION)
VALUES（'1002','审核状态查询导出','com.small,pojo.AmsFinancecheckTd=applyno:申请号,applytype:申请类型,applytypedetail:申请类型子类,detailopstatus:处理状态,checklevel:当前层级,resultreason:审核结果,ifattachment:后补附件,currentcheckcode:处理人,applycode:提交人,checkamount:金额,applyreason:提交原因,checktime:审核时间,applydate:提交时间,unitname:机构,attachmentreason：无附件原因,modifydesc:备注'，SYSDATE, SYSDATE, null, 1);

INSERT INTO AMS.AMS_QUERYCONTROL_TD (TASKCODE, TASKNAME, INPORTPARAM, LASTOPDATE, CREATETIME, MODIFYDESC,HIBERNATEVERSION)
VALUES （'1003','保费核销非见费出单','com.small.pojo.AmsPolicyReceiveableTd=policyno:保单号,endorseno:批单号,customername:投保人,amount:保费金额,remains:未核销金额,realamount:已核销金额,transactorcode:经办人,classeskind:险种大类,agentcode:代理点,currencycode:币种,busineSsattrname:保单属性'，SYSDATE, SYSDATE, null, 1);

INSERT INTO AMS.AMS_QUERYCONTROL_TD (TASKCODE, TASKNAME, INPORTPARAM, LASTOPDATE, CREATETIME, MODIFYDESC,HIBERNATEVERSION)
VALUES ('1004','保费核销见费出单！','com.small.pojo.AmsPaymentAccountTd=inpaymentno:支付号,policyno:保单号,endorseno:批单号,insurance_name:投保人amount:保费金额,remains:未核销金额,realamount:已核销金额,transactorcode:经办人,classtype:险种大类,agentcode:代理点', SYSDATE, SYSDATE, null, 1);

控制导出报表读取任务

CREATE TABLE AMS.AMS_QUERYAPPLY_TD(
APPLYNO VARCHAR2（20）NOT NULL,
TASKCODE VARCHAR2(20)NOT NULL,
SUBCOMPANY VARCHAR2(10) NOT NULL,
OPCODE VARCHAR2(20),
STATUS VARCHAR2(2),APPLYTIME DATE,
FINISHEDTIME DATE,
PATH VARCHAR2(2000),
SQLSTR CLOB,
RESULTCON VARCHAR2(2000),
LASTOPDATE DATE DEFAULT SYSDATE NOT NULL,
CREATETIME DATE DEFAULT SYSDATE NOT NULL,
MODIFYDESC VARCHAR2(200),
HIBERNATEVERSION NUMBER(5)DEFAULT 1 NOT NULL,
DOWNLOADURL VARCHAR2(100),
TOTALDATAA VARCHAR2(100),
EXECUTIONTIME VARCHAR2(100),
RUNNINGFLAGVARCHAR2(2) DEFAULT '0',
TYPE VARCHAR2(20) DEFAULT '0' ,
EXT1 VARCHAR2(500),
EXT2 VARCHAR2(500),
EXT3 VARCHAR2(500),
EXT4 VARCHAR2(500),
EXT5 VARCHAR2(500),
CONSTRAINT PK AMS QUERYAPPLY TD OO1 PRIMARY KEY (APPLYNO)
);
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.APPLYNO IS '物理主键，取SEQ_APPLYNO这个SEQUENCE';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.TASKCODE IS '任务类型';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.SUBCOMPANY IS '分公司';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.OPCODE IS '操作员代码';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.STATUS IS '状态：0初始化,1处理中,2处理成功,3处理失败';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.APPLYTIME IS '申请日期到时分秒 ';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.FINISHEDTIME IS'结束时间';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.PATH IS '下载路径';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.SQLSTR IS '执行SQL';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.RESULTCON IS'结果内容';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.LASTOPDATE IS'最后操作日期 ';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.CREATETIME IS'数据库系统时间';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.MODIFYDESC IS'手工修改记录';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.HIBERNATEVERSION IS '片版本号';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.TOTALDATA IS'数据总量';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.EXECUTIONTIME IS'执行时间';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.RUNNINGFLAG IS '任务状态O:允许1:终I止';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.TYPEIS '任务类型O:非绑参任务1:绑参任务 ';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.EXT1 IS '扩展参数字段1';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.EXT2 IS '扩展参数字段2 ';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.EXT3 IS '扩展参数字段3 ';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.EXT4 IS '扩展参数字段4 ';
COMMENT ON COLUMN AMS.AMS_QUERYAPPLY_TD.EXT5 IS'扩展参数字段5 ';

2、编写配置