insert into prplcompensate(compensateno,lflag,caseno,times,
classcode,riskcode,claimno,policyno,deductcond,preservedate,currency,
sumloss,sumrest,sumdutypaid,sumnodutyfee,sumpaid,
sumprepaid,sumthispaid,bank,makecom,comcode,handlercode,handler1code,
approvercode,underwritecode,underwritename,statisticsym,operatorcode,inputdate,
underwriteenddate,underwriteflag,flag,casetype,indemnitydutyrate,indemnityduty,
finallyflag,damageaddress,handleunit)
select c.minuscompensateno compensateno, co.lflag, co.caseno, co.times,
co.classcode, co.riskcode, co.claimno, co.policyno, co.deductcond,
co.preservedate, co.currency, -co.sumloss sumloss, -co.sumrest sumrest,
-co.sumdutypaid sumdutypaid, -co.sumnodutyfee sumnodutyfee, -co.sumpaid sumpaid,
0 sumprepaid, -co.sumthispaid sumthispaid, co.bank, co.makecom, co.comcode,
co.handlercode, co.handler1code, co.approvercode,
'0000000000' underwritecode, 'admin' underwritename,
to_date(sysdate,'yyyy-mm-dd') statisticsym, '0000000000' operatorcode,
to_date(sysdate,'yyyy-mm-dd') inputdate, to_date(sysdate,'yyyy-mm-dd') underwriteenddate,
'3' underwriteflag, case when co.flag is null then ' p'
when length(co.flag)<6 then co.flag||substr(' ',0,5-length(co.flag))||'p'
else substr(co.flag,0,5)||'p'||substr(co.flag,7) end flag, ‘7’, co.indemnitydutyrate,
co.indemnityduty, co.finallyflag, co.damageaddress, co.handleunit
from prplcaseoutcompensatedeal c, prplcompensate co
where c.compensateno = co.compensateno
and c.operatestatus in ('0', '2');
把以上代码转成java代码。
classcode,riskcode,claimno,policyno,deductcond,preservedate,currency,
sumloss,sumrest,sumdutypaid,sumnodutyfee,sumpaid,
sumprepaid,sumthispaid,bank,makecom,comcode,handlercode,handler1code,
approvercode,underwritecode,underwritename,statisticsym,operatorcode,inputdate,
underwriteenddate,underwriteflag,flag,casetype,indemnitydutyrate,indemnityduty,
finallyflag,damageaddress,handleunit)
select c.minuscompensateno compensateno, co.lflag, co.caseno, co.times,
co.classcode, co.riskcode, co.claimno, co.policyno, co.deductcond,
co.preservedate, co.currency, -co.sumloss sumloss, -co.sumrest sumrest,
-co.sumdutypaid sumdutypaid, -co.sumnodutyfee sumnodutyfee, -co.sumpaid sumpaid,
0 sumprepaid, -co.sumthispaid sumthispaid, co.bank, co.makecom, co.comcode,
co.handlercode, co.handler1code, co.approvercode,
'0000000000' underwritecode, 'admin' underwritename,
to_date(sysdate,'yyyy-mm-dd') statisticsym, '0000000000' operatorcode,
to_date(sysdate,'yyyy-mm-dd') inputdate, to_date(sysdate,'yyyy-mm-dd') underwriteenddate,
'3' underwriteflag, case when co.flag is null then ' p'
when length(co.flag)<6 then co.flag||substr(' ',0,5-length(co.flag))||'p'
else substr(co.flag,0,5)||'p'||substr(co.flag,7) end flag, ‘7’, co.indemnitydutyrate,
co.indemnityduty, co.finallyflag, co.damageaddress, co.handleunit
from prplcaseoutcompensatedeal c, prplcompensate co
where c.compensateno = co.compensateno
and c.operatestatus in ('0', '2');
把以上代码转成java代码。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货