package DB2ORACLE.transfer;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import DB2ORACLE.conn.CloseFunction;
import DB2ORACLE.conn.ConnectionDB2;
import DB2ORACLE.conn.ConnectionORACLE;
import DB2ORACLE.utils.LangUtils;
public class TBL_BKE_FRN_DMS_LOG2 {
// public static void main(String args[]) {
// System.getProperties().list(System.out);
// }
public void TBL_BKE_FRN_DMS_LOG2() {
long startTime=System.currentTimeMillis(); //记录开始时间
Connection connDB2=null; //链接DB2数据库
Connection connOracle=null; //链接oracle数据库
Statement statement=null;
ResultSet resultSet=null;
Statement statementOR=null;
ResultSet resultSetOR=null;
PreparedStatement preparedStatement=null;
String ic_flds="";
try {
ConnectionORACLE connectionOracle=new ConnectionORACLE();
System.out.println(connectionOracle+"链接oracle成功!");
ConnectionDB2 connectionDB2=new ConnectionDB2();
System.out.println(connectionDB2+"-->>>链接DB2数据库成功!");
connDB2=connectionDB2.getConnection();
//执行DB2数据库sql语句
String db2SQL="SELECT pri_key, log_cd,orig_key,alt_key,related_key,mc_file_cd, mc_msg_id,trans_fwd_st,trans_rcv_st,sms_dms_conv_in," +
"fee_in, pre_proc_st,pre_proc_in,orig_acq_sdms_in,cups_card_in,cups_sig_card_in,card_class,card_attr,sti_in,acq_ins_id_cd," +
"acq_ins_id_cd_conv,acq_ins_tp,fwd_ins_id_cd,fwd_ins_id_cd_conv,fwd_ins_tp,rcv_ins_id_cd,rcv_ins_id_cd_conv,rcv_ins_tp,iss_ins_id_cd,iss_ins_tp," +
"related_ins_id_cd,related_ins_tp,pri_acct_no,pri_acct_no_conv,sys_tra_no,sys_tra_no_conv,sw_sys_tra_no,auth_dt,auth_id_resp_cd,resp_cd1," +
"resp_cd2,resp_cd3,resp_cd4,trans_st,sti_takeout_in,to_ts,resnd_num,trans_id,trans_tp,trans_chnl," +
"card_media,card_brand,interval_seg,trans_id_conv,frn_settle_dt,settle_dt,settle_mon,settle_d,orig_settle_dt,frn_bat_no," +
"corr_frn_bat_no,settle_fwd_ins_id_cd,settle_rcv_ins_id_cd,trans_at,orig_trans_at,fwd_settle_at,fwd_orig_settle_at,trans_conv_rt,fwd_settle_conv_rt,trans_curr_cd," +
"fwd_settle_curr_cd,rcv_settle_atm,rcv_orig_settle_at,rcv_settle_conv_rt,rcv_settle_curr_cd,cdhd_at,cdhd_conv_rt,cdhd_curr_cd,repl_at,conv_rt," +
"conv_expt,cup_branch_cny_conv_rt,cup_branch_usd_conv_rt,fwd_cny_conv_rt,rcv_cny_conv_rt,cup_branch_settle_atm,mchnt_disc_at,cup_branch_disc_at,mchnt_disc_at_cny,cup_branch_disc_at_cny," +
"mchnt_disc_cd,cup_branch_disc_cd,mchnt_disc_debt_cret_in,cup_branch_disc_debt_cret_in,fwd_disc_cd,rcv_disc_cd,orig_fwd_disc_cd,orig_fwd_disc_at,orig_fwd_disc_debt_cret_in,orig_rcv_disc_cd," +
"orig_rcv_disc_at,orig_rcv_disc_debt_cret_in,fwd_fee_cd,rcv_fee_cd,fwd_disc_debt_cret_in,fwd_disc_at,fwd_disc_at_cny,rcv_disc_debt_cret_in,rcv_disc_at,rcv_disc_at_cny," +
"sw_disc_debt_cret_in,sw_disc_at,fwd_fee_at,rcv_fee_at,vfy_rslt,vfy_fee_cd,vfy_fee_at,exp_snd_chnl,confirm_exp_chnl,msg_tp," +
"msg_tp_conv,bin,proc_cd,proc_cd_conv,transmsn_dt_tm,transmsn_dt_tm_conv,loc_trans_tm,loc_trans_tm_conv,loc_trans_dt,conv_dt" +
",mchnt_tp," +
"mchnt_tp_conv,pos_entry_md_cd,pos_entry_md_cd_conv,card_seq_id,pos_cond_cd,pos_cond_cd_conv,trans_fee_at,settle_fee_at,settle_pro_fee,arn," +
"rrn,trans_cycle,source_ins_id_cd,dest_ins_id_cd,ext_info,retri_ref_no,retri_ref_no_conv,term_id,term_id_conv,mchnt_cd," +
"mchnt_cd_conv,card_accptr_nm_loc,card_accptr_nm_loc_conv,ic_res_dat,rsn_cd,rsn_cd_conv,addn_pos_inf,orig_msg_tp,orig_msg_tp_conv,orig_sys_tra_no," +
"orig_sys_tra_no_conv,orig_transmsn_dt_tm,orig_transmsn_dt_tm_conv,orig_trans_id,orig_trans_id_conv,orig_trans_chnl,orig_card_media,cups_res,ic_flds,msg_buffer," +
"exp_ext_info,exp_vou_req_tp,exp_vou_file_tp,rec_upd_ts,rec_crt_ts from FPDB_BKE.TBL_BKE_FRN_DMS_LOG2";
String oracleSQLT="SELECT pri_key, log_cd,orig_key,alt_key,related_key,mc_file_cd, mc_msg_id,trans_fwd_st,trans_rcv_st,sms_dms_conv_in," +
"fee_in, pre_proc_st,pre_proc_in,orig_acq_sdms_in,cups_card_in,cups_sig_card_in,card_class,card_attr,sti_in,acq_ins_id_cd," +
"acq_ins_id_cd_conv,acq_ins_tp,fwd_ins_id_cd,fwd_ins_id_cd_conv,fwd_ins_tp,rcv_ins_id_cd,rcv_ins_id_cd_conv,rcv_ins_tp,iss_ins_id_cd,iss_ins_tp," +
"related_ins_id_cd,related_ins_tp,pri_acct_no,pri_acct_no_conv,sys_tra_no,sys_tra_no_conv,sw_sys_tra_no,auth_dt,auth_id_resp_cd,resp_cd1," +
"resp_cd2,resp_cd3,resp_cd4,trans_st,sti_takeout_in,to_ts,resnd_num,trans_id,trans_tp,trans_chnl," +
"card_media,card_brand,interval_seg,trans_id_conv,frn_settle_dt,settle_dt,settle_mon,settle_d,orig_settle_dt,frn_bat_no," +
"corr_frn_bat_no,settle_fwd_ins_id_cd,settle_rcv_ins_id_cd,trans_at,orig_trans_at,fwd_settle_at,fwd_orig_settle_at,trans_conv_rt,fwd_settle_conv_rt,trans_curr_cd," +
"fwd_settle_curr_cd,rcv_settle_atm,rcv_orig_settle_at,rcv_settle_conv_rt,rcv_settle_curr_cd,cdhd_at,cdhd_conv_rt,cdhd_curr_cd,repl_at,conv_rt," +
"conv_expt,cup_branch_cny_conv_rt,cup_branch_usd_conv_rt,fwd_cny_conv_rt,rcv_cny_conv_rt,cup_branch_settle_atm,mchnt_disc_at,cup_branch_disc_at,mchnt_disc_at_cny,cup_branch_disc_at_cny," +
"mchnt_disc_cd,cup_branch_disc_cd,mchnt_disc_debt_cret_in,cup_branch_disc_debt_cret_in,fwd_disc_cd,rcv_disc_cd,orig_fwd_disc_cd,orig_fwd_disc_at,orig_fwd_disc_debt_cret_in,orig_rcv_disc_cd," +
"orig_rcv_disc_at,orig_rcv_disc_debt_cret_in,fwd_fee_cd,rcv_fee_cd,fwd_disc_debt_cret_in,fwd_disc_at,fwd_disc_at_cny,rcv_disc_debt_cret_in,rcv_disc_at,rcv_disc_at_cny," +
"sw_disc_debt_cret_in,sw_disc_at,fwd_fee_at,rcv_fee_at,vfy_rslt,vfy_fee_cd,vfy_fee_at,exp_snd_chnl,confirm_exp_chnl,msg_tp," +
"msg_tp_conv,bin,proc_cd,proc_cd_conv,transmsn_dt_tm,transmsn_dt_tm_conv,loc_trans_tm,loc_trans_tm_conv,loc_trans_dt,conv_dt" +
",mchnt_tp," +
"mchnt_tp_conv,pos_entry_md_cd,pos_entry_md_cd_conv,card_seq_id,pos_cond_cd,pos_cond_cd_conv,trans_fee_at,settle_fee_at,settle_pro_fee,arn," +
"rrn,trans_cycle,source_ins_id_cd,dest_ins_id_cd,ext_info,retri_ref_no,retri_ref_no_conv,term_id,term_id_conv,mchnt_cd," +
"mchnt_cd_conv,card_accptr_nm_loc,card_accptr_nm_loc_conv,ic_res_dat,rsn_cd,rsn_cd_conv,addn_pos_inf,orig_msg_tp,orig_msg_tp_conv,orig_sys_tra_no," +
"orig_sys_tra_no_conv,orig_transmsn_dt_tm,orig_transmsn_dt_tm_conv,orig_trans_id,orig_trans_id_conv,orig_trans_chnl,orig_card_media,cups_res,ic_flds,msg_buffer," +
"exp_ext_info,exp_vou_req_tp,exp_vou_file_tp,rec_upd_ts,rec_crt_ts from TBL_BKE_FRN_DMS_LOG2";
System.out.println(db2SQL);
//执行oracle数据库sql语句
String oracleSQL="INSERT INTO TBL_BKE_FRN_DMS_LOG2(pri_key, log_cd,orig_key,alt_key,related_key,mc_file_cd, mc_msg_id,trans_fwd_st,trans_rcv_st,sms_dms_conv_in," +
"fee_in, pre_proc_st,pre_proc_in,orig_acq_sdms_in,cups_card_in,cups_sig_card_in,card_class,card_attr,sti_in,acq_ins_id_cd," +
"acq_ins_id_cd_conv,acq_ins_tp,fwd_ins_id_cd,fwd_ins_id_cd_conv,fwd_ins_tp,rcv_ins_id_cd,rcv_ins_id_cd_conv,rcv_ins_tp,iss_ins_id_cd,iss_ins_tp," +
"related_ins_id_cd,related_ins_tp,pri_acct_no,pri_acct_no_conv,sys_tra_no,sys_tra_no_conv,sw_sys_tra_no,auth_dt,auth_id_resp_cd,resp_cd1," +
"resp_cd2,resp_cd3,resp_cd4,trans_st,sti_takeout_in,to_ts,resnd_num,trans_id,trans_tp,trans_chnl," +
"card_media,card_brand,interval_seg,trans_id_conv,frn_settle_dt,settle_dt,settle_mon,settle_d,orig_settle_dt,frn_bat_no," +
"corr_frn_bat_no,settle_fwd_ins_id_cd,settle_rcv_ins_id_cd,trans_at,orig_trans_at,fwd_settle_at,fwd_orig_settle_at,trans_conv_rt,fwd_settle_conv_rt,trans_curr_cd," +
"fwd_settle_curr_cd,rcv_settle_atm,rcv_orig_settle_at,rcv_settle_conv_rt,rcv_settle_curr_cd,cdhd_at,cdhd_conv_rt,cdhd_curr_cd,repl_at,conv_rt," +
"conv_expt,cup_branch_cny_conv_rt,cup_branch_usd_conv_rt,fwd_cny_conv_rt,rcv_cny_conv_rt,cup_branch_settle_atm,mchnt_disc_at,cup_branch_disc_at,mchnt_disc_at_cny,cup_branch_disc_at_cny," +
"mchnt_disc_cd,cup_branch_disc_cd,mchnt_disc_debt_cret_in,cup_branch_disc_d
评论0
最新资源