/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbEKU0021A010TPDA * ソースファイル名：JSYejbEKU0021A010TPDA.java * 作成者 ：EK907784 * 日付 ：2012年12月10日 *＜機能概要＞ * 工事案件一意照会テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン 修正日 修正者 修正内容 * ｖ1.00.00 * ********************************************************************************/ package eo.ejb.cbs.sqlf; import com.fujitsu.futurity.model.base.CAANMsg; import com.fujitsu.futurity.model.base.CAANSQLFacility; import com.fujitsu.futurity.model.base.CAANRuntimeException; import com.fujitsu.futurity.model.base.CAANJDBCUtil; import com.fujitsu.futurity.model.ejb.common.JSYejbConnection; import com.fujitsu.futurity.model.ejb.common.JSYejbLog; import com.fujitsu.futurity.model.ejb.common.StatusCodes; import com.fujitsu.futurity.model.ejb.common.fw.TemplateDBAccessHandler; import com.fujitsu.futurity.model.ejb.common.fw.AgentDispatchContext; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import eo.ejb.cbs.cbsmsg.EKU0021A010CBSMsg; import eo.ejb.cbs.cbsmsg.EKU0021A010CBSMsg1List; import eo.ejb.cbm.entity.KU0021ETMsg; /** * * テンプレートDBアクセス部品　EKU0021A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbEKU0021A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbEKU0021A010TPDA() { } /** * EKU0021A010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void */ public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){ // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt = null; // リザルトセット ResultSet rsltQuery = null; /******************** * SQL文の作成 ********************/ try{ //コネクション取得 con1 = JSYejbConnection.getConnection(KU0021ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT KU0021.KOJIAK_NO ") .append(" ,KU0021.KOJI_SCOPE_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00484' ") .append(" AND KU0021.KOJI_SCOPE_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )KOJI_SCOPE_NM ") .append(" ,KU0021.KYOSEI_DSL_SJI_YMD ") .append(" ,KU0021.PC_SETUP_UM ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.PC_SETUP_UM = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )PC_SETUP_UM_NM ") .append(" ,KU0021.EOH_TEL_TAKNIKJ_UM ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.EOH_TEL_TAKNIKJ_UM = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )EOH_TEL_TAKNIKJ_UM_NM ") .append(" ,KU0021.FAMIPA_KEI_UM ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.FAMIPA_KEI_UM = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )FAMIPA_KEI_UM_NM ") .append(" ,KU0021.CUST_SOS_USE_UM ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.CUST_SOS_USE_UM = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )CUST_SOS_USE_UM_NM ") .append(" ,KU0021.HUKKAT_ANKEN_FLG ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00777' ") .append(" AND KU0021.HUKKAT_ANKEN_FLG = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )HUKKAT_ANKEN_FLG_NM ") .append(" ,KU0021.SAME_EQUIP_RE_MSKM_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00485' ") .append(" AND KU0021.SAME_EQUIP_RE_MSKM_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )SAME_EQUIP_RE_MSKM_NM ") .append(" ,KU0021.KOJI_RSV_COUPLER_HSK_CD ") .append(" ,'' KOJI_RSV_COUPLER_HSK_NM ") .append(" ,KU0021.KOJI_RSV_OYA_PON_MAKER_CD ") .append(" ,KU0021.KOJI_RSV_OYA_PON_MAKER_NM ") .append(" ,KU0021.KOJI_RSV_VA_MAKER_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00569' ") .append(" AND KU0021.KOJI_RSV_VA_MAKER_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )KOJI_RSV_VA_MAKER_NM ") .append(" ,KU0021.KOJI_RSV_IP_KOJIAK_SBT_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00570' ") .append(" AND KU0021.KOJI_RSV_IP_KOJIAK_SBT_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )KOJI_RSV_IP_KOJIAK_SBT_NM ") .append(" ,KU0021.DSL_KIBO_YMD ") .append(" ,KU0021.EOH_TELNO_1 ") .append(" ,KU0021.BMP_UM_1 ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.BMP_UM_1 = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )BMP_UM_1_NM ") .append(" ,KU0021.BMP_RSV_YMD_1 ") .append(" ,KU0021.BMP_MOTO_TUSHIN_JGS_CD_1 ") .append(" ,(SELECT TU0051.TSJGS_NM ") .append(" FROM TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" WHERE KU0021.BMP_MOTO_TUSHIN_JGS_CD_1 = TU0051.TSJGS_CD ") .append(" AND TU0051.MK_FLG = '0' ") .append(" )BMP_MOTO_TUSHIN_JGS_NM_1 ") .append(" ,KU0021.EOH_TELNO_2 ") .append(" ,KU0021.BMP_UM_2 ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.BMP_UM_2 = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )BMP_UM_2_NM ") .append(" ,KU0021.BMP_RSV_YMD_2 ") .append(" ,KU0021.BMP_MOTO_TUSHIN_JGS_CD_2 ") .append(" ,(SELECT TU0051.TSJGS_NM ") .append(" FROM TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" WHERE KU0021.BMP_MOTO_TUSHIN_JGS_CD_2 = TU0051.TSJGS_CD ") .append(" AND TU0051.MK_FLG = '0' ") .append(" )BMP_MOTO_TUSHIN_JGS_NM_2 ") .append(" ,KU0021.EOH_TELNO_3 ") .append(" ,KU0021.BMP_UM_3 ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.BMP_UM_3 = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )BMP_UM_3_NM ") .append(" ,KU0021.BMP_RSV_YMD_3 ") .append(" ,KU0021.BMP_MOTO_TUSHIN_JGS_CD_3 ") .append(" ,(SELECT TU0051.TSJGS_NM ") .append(" FROM TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" WHERE KU0021.BMP_MOTO_TUSHIN_JGS_CD_3 = TU0051.TSJGS_CD ") .append(" AND TU0051.MK_FLG = '0' ") .append(" )BMP_MOTO_TUSHIN_JGS_NM_3 ") .append(" ,KU0021.EOH_TELNO_4 ") .append(" ,KU0021.BMP_UM_4 ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.BMP_UM_4 = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )BMP_UM_4_NM ") .append(" ,KU0021.BMP_RSV_YMD_4 ") .append(" ,KU0021.BMP_MOTO_TUSHIN_JGS_CD_4 ") .append(" ,(SELECT TU0051.TSJGS_NM ") .append(" FROM TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" WHERE KU0021.BMP_MOTO_TUSHIN_JGS_CD_4 = TU0051.TSJGS_CD ") .append(" AND TU0051.MK_FLG = '0' ") .append(" )BMP_MOTO_TUSHIN_JGS_NM_4 ") .append(" ,KU0021.EOH_TELNO_5 ") .append(" ,KU0021.BMP_UM_5 ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ") .append(" AND KU0021.BMP_UM_5 = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )BMP_UM_5_NM ") .append(" ,KU0021.BMP_RSV_YMD_5 ") .append(" ,KU0021.BMP_MOTO_TUSHIN_JGS_CD_5 ") .append(" ,(SELECT TU0051.TSJGS_NM ") .append(" FROM TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" WHERE KU0021.BMP_MOTO_TUSHIN_JGS_CD_5 = TU0051.TSJGS_CD ") .append(" AND TU0051.MK_FLG = '0' ") .append(" )BMP_MOTO_TUSHIN_JGS_NM_5 ") .append(" ,KU0021.PLC_MODEM_RENT_CNT ") .append(" ,KU0021.PLC_MODEM_KAITORI_CNT ") .append(" ,KU0021.EOH_TEL_CNT ") .append(" ,KU0021.ISETSU_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00486' ") .append(" AND KU0021.ISETSU_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )ISETSU_NM ") .append(" ,KU0021.OLD_PCRS_CD ") .append(" ,CASE ") .append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ") .append(" THEN (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ") .append(" WHERE ") .append(" KU0021.OLD_PCRS_CD = KK0791.PCRS_CD ") .append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0791.PCRS_TSTAYMD AND KK0791.PCRS_TENDYMD ") .append(" AND KK0791.MK_FLG = '0') ") .append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ") .append(" THEN (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ") .append(" WHERE ") .append(" KU0021.OLD_PCRS_CD = KK0791.PCRS_CD ") .append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0791.PCRS_TSTAYMD AND KK0791.PCRS_TENDYMD ") .append(" AND KK0791.MK_FLG = '0') ") .append(" ELSE (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ") .append(" WHERE ") .append(" KU0021.OLD_PCRS_CD = KK0791.PCRS_CD ") .append(" AND KK0791.PCRS_TENDYMD = '20991231' ") .append(" AND KK0791.MK_FLG = '0') ") .append(" END OLD_PCRS_NM ") .append(" ,KU0021.OLD_PPLAN_CD ") .append(" ,CASE ") .append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ") .append(" THEN (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ") .append(" WHERE ") .append(" KU0021.OLD_PCRS_CD = KK0591.PCRS_CD ") .append(" AND KU0021.OLD_PPLAN_CD = KK0591.PPLAN_CD ") .append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0591.PPLAN_TSTAYMD AND KK0591.PPLAN_TENDYMD ") .append(" AND KK0591.MK_FLG = '0') ") .append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ") .append(" THEN (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ") .append(" WHERE ") .append(" KU0021.OLD_PCRS_CD = KK0591.PCRS_CD ") .append(" AND KU0021.OLD_PPLAN_CD = KK0591.PPLAN_CD ") .append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0591.PPLAN_TSTAYMD AND KK0591.PPLAN_TENDYMD ") .append(" AND KK0591.MK_FLG = '0') ") .append(" ELSE (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ") .append(" WHERE ") .append(" KU0021.OLD_PCRS_CD = KK0591.PCRS_CD ") .append(" AND KU0021.OLD_PPLAN_CD = KK0591.PPLAN_CD ") .append(" AND KK0591.PPLAN_TENDYMD = '20991231' ") .append(" AND KK0591.MK_FLG = '0') ") .append(" END OLD_PPLAN_NM ") .append(" ,KU0021.OLD_WRIB_TYPE_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00284' ") .append(" AND KU0021.OLD_WRIB_TYPE_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )OLD_WRIB_TYPE_NM ") .append(" ,KU0021.ADD_MOTO_SVC_KEI_NO ") .append(" ,KU0021.MENKAIHAT_ANKEN_NO ") .append(" ,KU0021.MNKHT_KOJI_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00487' ") .append(" AND KU0021.MNKHT_KOJI_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )MNKHT_KOJI_NM ") .append(" ,KU0021.DMPS_ANKEN_NO ") .append(" ,KU0021.DMPSANK_SBT_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00607' ") .append(" AND KU0021.DMPSANK_SBT_CD = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )DMPSANK_SBT_NM ") .append(" ,KU0021.ADD_DTM ") .append(" ,KU0021.ADD_OPEACNT ") .append(" ,(SELECT ZM0051.USER_NM ") .append(" FROM ZM_M_USER ZM0051 ") .append(" WHERE KU0021.ADD_OPEACNT = ZM0051.USER_ID ") .append(" AND ZM0051.MK_FLG = '0' ") .append(" )ADD_OPEACNT_NM ") .append(" ,KU0021.UPD_DTM ") .append(" ,KU0021.UPD_OPEACNT ") .append(" ,(SELECT ZM0051.USER_NM ") .append(" FROM ZM_M_USER ZM0051 ") .append(" WHERE KU0021.UPD_OPEACNT = ZM0051.USER_ID ") .append(" AND ZM0051.MK_FLG = '0' ") .append(" )UPD_OPEACNT_NM ") .append(" ,KU0021.DEL_DTM ") .append(" ,KU0021.DEL_OPEACNT ") .append(" ,(SELECT ZM0051.USER_NM ") .append(" FROM ZM_M_USER ZM0051 ") .append(" WHERE KU0021.DEL_OPEACNT = ZM0051.USER_ID ") .append(" AND ZM0051.MK_FLG = '0' ") .append(" )DEL_OPEACNT_NM ") .append(" ,KU0021.MK_FLG ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00016' ") .append(" AND KU0021.MK_FLG = ZM0171.CD_DIV ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" )MK_FLG_NM ") .append(" FROM ") .append(" KU_T_KJAK_EOH_NET KU0021 ") .append(" INNER JOIN ") .append(" KU_T_KOJIAK KU0011 ") .append(" ON KU0021.KOJIAK_NO = KU0011.KOJIAK_NO ") .append(" AND KU0011.MK_FLG = '0' "); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(EKU0021A010CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE ") .append(" KU0021.KOJIAK_NO = ? ") .append(" AND KU0021.MK_FLG = '0' "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 if ( "1".equals( inMsg.getString(EKU0021A010CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(ＫＥＹ＿工事案件番号を指定) CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(EKU0021A010CBSMsg.KEY_KOJIAK_NO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // EKU0021A010CBSMsgの明細にセットする項目 String[] msgKeyList1 = { EKU0021A010CBSMsg1List.KOJIAK_NO , EKU0021A010CBSMsg1List.KOJI_SCOPE_CD , EKU0021A010CBSMsg1List.KOJI_SCOPE_NM , EKU0021A010CBSMsg1List.KYOSEI_DSL_SJI_YMD , EKU0021A010CBSMsg1List.PC_SETUP_UM , EKU0021A010CBSMsg1List.PC_SETUP_UM_NM , EKU0021A010CBSMsg1List.EOH_TEL_TAKNIKJ_UM , EKU0021A010CBSMsg1List.EOH_TEL_TAKNIKJ_UM_NM , EKU0021A010CBSMsg1List.FAMIPA_KEI_UM , EKU0021A010CBSMsg1List.FAMIPA_KEI_UM_NM , EKU0021A010CBSMsg1List.CUST_SOS_USE_UM , EKU0021A010CBSMsg1List.CUST_SOS_USE_UM_NM , EKU0021A010CBSMsg1List.HUKKAT_ANKEN_FLG , EKU0021A010CBSMsg1List.HUKKAT_ANKEN_FLG_NM , EKU0021A010CBSMsg1List.SAME_EQUIP_RE_MSKM_CD , EKU0021A010CBSMsg1List.SAME_EQUIP_RE_MSKM_NM , EKU0021A010CBSMsg1List.KOJI_RSV_COUPLER_HSK_CD , EKU0021A010CBSMsg1List.KOJI_RSV_COUPLER_HSK_NM , EKU0021A010CBSMsg1List.KOJI_RSV_OYA_PON_MAKER_CD , EKU0021A010CBSMsg1List.KOJI_RSV_OYA_PON_MAKER_NM , EKU0021A010CBSMsg1List.KOJI_RSV_VA_MAKER_CD , EKU0021A010CBSMsg1List.KOJI_RSV_VA_MAKER_NM , EKU0021A010CBSMsg1List.KOJI_RSV_IP_KOJIAK_SBT_CD , EKU0021A010CBSMsg1List.KOJI_RSV_IP_KOJIAK_SBT_NM , EKU0021A010CBSMsg1List.DSL_KIBO_YMD , EKU0021A010CBSMsg1List.EOH_TELNO_1 , EKU0021A010CBSMsg1List.BMP_UM_1 , EKU0021A010CBSMsg1List.BMP_UM_1_NM , EKU0021A010CBSMsg1List.BMP_RSV_YMD_1 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_CD_1 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_NM_1 , EKU0021A010CBSMsg1List.EOH_TELNO_2 , EKU0021A010CBSMsg1List.BMP_UM_2 , EKU0021A010CBSMsg1List.BMP_UM_2_NM , EKU0021A010CBSMsg1List.BMP_RSV_YMD_2 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_CD_2 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_NM_2 , EKU0021A010CBSMsg1List.EOH_TELNO_3 , EKU0021A010CBSMsg1List.BMP_UM_3 , EKU0021A010CBSMsg1List.BMP_UM_3_NM , EKU0021A010CBSMsg1List.BMP_RSV_YMD_3 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_CD_3 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_NM_3 , EKU0021A010CBSMsg1List.EOH_TELNO_4 , EKU0021A010CBSMsg1List.BMP_UM_4 , EKU0021A010CBSMsg1List.BMP_UM_4_NM , EKU0021A010CBSMsg1List.BMP_RSV_YMD_4 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_CD_4 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_NM_4 , EKU0021A010CBSMsg1List.EOH_TELNO_5 , EKU0021A010CBSMsg1List.BMP_UM_5 , EKU0021A010CBSMsg1List.BMP_UM_5_NM , EKU0021A010CBSMsg1List.BMP_RSV_YMD_5 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_CD_5 , EKU0021A010CBSMsg1List.BMP_MOTO_TUSHIN_JGS_NM_5 , EKU0021A010CBSMsg1List.PLC_MODEM_RENT_CNT , EKU0021A010CBSMsg1List.PLC_MODEM_KAITORI_CNT , EKU0021A010CBSMsg1List.EOH_TEL_CNT , EKU0021A010CBSMsg1List.ISETSU_CD , EKU0021A010CBSMsg1List.ISETSU_NM , EKU0021A010CBSMsg1List.OLD_PCRS_CD , EKU0021A010CBSMsg1List.OLD_PCRS_NM , EKU0021A010CBSMsg1List.OLD_PPLAN_CD , EKU0021A010CBSMsg1List.OLD_PPLAN_NM , EKU0021A010CBSMsg1List.OLD_WRIB_TYPE_CD , EKU0021A010CBSMsg1List.OLD_WRIB_TYPE_NM , EKU0021A010CBSMsg1List.ADD_MOTO_SVC_KEI_NO , EKU0021A010CBSMsg1List.MENKAIHAT_ANKEN_NO , EKU0021A010CBSMsg1List.MNKHT_KOJI_CD , EKU0021A010CBSMsg1List.MNKHT_KOJI_NM , EKU0021A010CBSMsg1List.DMPS_ANKEN_NO , EKU0021A010CBSMsg1List.DMPSANK_SBT_CD , EKU0021A010CBSMsg1List.DMPSANK_SBT_NM , EKU0021A010CBSMsg1List.ADD_DTM , EKU0021A010CBSMsg1List.ADD_OPEACNT , EKU0021A010CBSMsg1List.ADD_OPEACNT_NM , EKU0021A010CBSMsg1List.UPD_DTM , EKU0021A010CBSMsg1List.UPD_OPEACNT , EKU0021A010CBSMsg1List.UPD_OPEACNT_NM , EKU0021A010CBSMsg1List.DEL_DTM , EKU0021A010CBSMsg1List.DEL_OPEACNT , EKU0021A010CBSMsg1List.DEL_OPEACNT_NM , EKU0021A010CBSMsg1List.MK_FLG , EKU0021A010CBSMsg1List.MK_FLG_NM }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKU0021A010CBSMsg1List",0); // inMsg(CBSMsg)に明細をセット inMsg.set("EKU0021A010CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(EKU0021A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } finally { // 資源の解放 try{ if(rsltQuery != null){ rsltQuery.close(); } if(pstmt != null){ pstmt.close(); } if(con1 != null){ closeConnection(con1); } }catch(SQLException e){ inMsg.set(EKU0021A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }