/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbETU0151B040TPDA * ソースファイル名：JSYejbETU0151B040TPDA.java * 作成者 ：EK967615 * 日付 ：2024年04月25日 *＜機能概要＞ * ポートアウト受付情報一覧照会（電話番号）テンプレート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.ETU0151B040CBSMsg; import eo.ejb.cbs.cbsmsg.ETU0151B040CBSMsg1List; import eo.ejb.cbm.entity.TU0151ETMsg; /** * * テンプレートDBアクセス部品　ETU0151B040_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbETU0151B040TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbETU0151B040TPDA() { } /** * ETU0151B040_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(TU0151ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" TU0151.PORT_OUT_NO ") .append(" , TU0151.GENE_ADD_DTM ") .append(" , TU0151.PORT_OUT_STAT ") .append(" , ( ") .append(" SELECT ") .append(" ZM0171_01.CD_DIV_NM ") .append(" FROM ") .append(" ZM_M_CD_NM_KANRI ZM0171_01 ") .append(" WHERE ") .append(" ZM0171_01.CD_SBT_CD = 'CD01826' ") .append(" AND ZM0171_01.CD_DIV = TU0151.PORT_OUT_STAT ") .append(" AND ZM0171_01.MK_FLG = '0' ") .append(" ) AS PORT_OUT_STAT_NM ") .append(" , TU0151.SVC_KEI_NO ") .append(" , TU0151.SVC_KEI_UCWK_NO ") .append(" , TU0151.TOGO_ODR_ID ") .append(" , TU0151.HAISHI_CHUMN_SKBT ") .append(" , TU0151.RE_BMP_MKM_SKBT ") .append(" , TU0151.AFT_TONYU_SKBT ") .append(" , TU0151.HUKUSU_NO_UM ") .append(" , TU0151.BMP_TG_KSSU_BMP_HISTG_KSSU ") .append(" , TU0151.AUTO_HAISHI_RYSHZM_NO_NUM ") .append(" , TU0151.GRP_ID ") .append(" , TU0151.CUST_MSKM_DAY ") .append(" , TU0151.ITENS_MSKM_DAY ") .append(" , TU0151.CHBF_MSKM_DAY ") .append(" , TU0151.UK_KYOTEN_NO_TRAT_SVC ") .append(" , TU0151.ITENS_JIGYOSHA_NM ") .append(" , TU0151.ITENS_JIGYOSHA_NO ") .append(" , ( ") .append(" SELECT ") .append(" TSJGS1.TSJGS_NM ") .append(" FROM ") .append(" TU_M_TUSHIN_JGYOSHA TSJGS1 ") .append(" WHERE ") .append(" TSJGS1.TSJGS_CD = TU0151.ITENS_JIGYOSHA_NO ") .append(" AND TSJGS1.MK_FLG = '0' ") .append(" ) AS ITENS_JIGYOSHA_NO_NM ") .append(" , TU0151.ITENS_JIGYOSHA_DOMAIN ") .append(" , TU0151.ITENS_JIGYOSHA_TNT_NM ") .append(" , TU0151.ITENS_JIGYOSHA_TELNO ") .append(" , TU0151.KIJIRAN_1_ITNM_JGSMK ") .append(" , TU0151.KIJIRAN_2_ITNM_JGSMK ") .append(" , TU0151.KIJIRAN_1_NOSK_JGSMK ") .append(" , TU0151.KIJIRAN_2_NOSK_JGSMK ") .append(" , TU0151.JI_SHANAI_KIJIRAN ") .append(" , TU0151.PORT_OUT_KEISHA_NM ") .append(" , TU0151.PORT_OUT_KEISHA_KANA ") .append(" , TU0151.SETPLACE_ADCHG_UM ") .append(" , TU0151.SETPLC_HTNY_SKBT_CITY_NM ") .append(" , TU0151.SETPLC_HTNY_SKBT_OAZTSU_NM ") .append(" , TU0151.SETPLC_HTNY_SKBT_AZCHO_NM ") .append(" , TU0151.SETPLACE_PCD ") .append(" , TU0151.SETPLACE_STATE_NM ") .append(" , TU0151.SETPLACE_CITY_NM ") .append(" , TU0151.SETPLACE_OAZTSU_NM ") .append(" , TU0151.SETPLACE_AZCHO_NM ") .append(" , TU0151.SETPLACE_BNCHIGO ") .append(" , TU0151.SETPLACE_ADRTTM ") .append(" , TU0151.CUST_RRKS ") .append(" , TU0151.KOJI_KIBO_YMD ") .append(" , TU0151.KOJI_JSSI_WAY ") .append(" , TU0151.SOTEI_SWITCH_TIMEZ ") .append(" , TU0151.KOJI_TIMEZ_DIV ") .append(" , TU0151.ITENM_DAIHYO_JIGYOSHA_NM ") .append(" , TU0151.ITENM_DAIHYO_JIGYOSHA_NO ") .append(" , ( ") .append(" SELECT ") .append(" TSJGS2.TSJGS_NM ") .append(" FROM ") .append(" TU_M_TUSHIN_JGYOSHA TSJGS2 ") .append(" WHERE ") .append(" TSJGS2.TSJGS_CD = TU0151.ITENM_DAIHYO_JIGYOSHA_NO ") .append(" AND TSJGS2.MK_FLG = '0' ") .append(" ) AS ITENM_DAIHYO_JIGYOSHA_NO_NM ") .append(" , TU0151.KISAI_CHGE_MSKM_CNT ") .append(" , TU0151.KISAI_CHGE_MSKM_DAY ") .append(" , TU0151.KISAI_CHGE_MSKM_RSN ") .append(" , TU0151.OLD_TOGO_ORDER_ID ") .append(" , TU0151.MSKM_CHOK_NISU ") .append(" , TU0151.CANCEL_DATE ") .append(" , TU0151.CANCEL_SKBT ") .append(" , TU0151.CANCEL_OTAI_DAY ") .append(" , TU0151.CANCEL_TONYU_TNT_NM ") .append(" , TU0151.CANCEL_TONYU_TNT_TELNO ") .append(" , TU0151.PORT_OUT_CNRE ") .append(" , TU0151.CL_DATE ") .append(" , TU0151.CL_SKBT ") .append(" , TU0151.UWY_SKBT ") .append(" , TU0151.SERVER_ARIV_DATE ") .append(" , TU0151.BMP_ORDER_NO ") .append(" , TU0151.KANREN_ORDER_CNT ") .append(" , TU0151.BMP_TG_KISN_CNT_NOSK_GT ") .append(" , TU0151.CHUMN_KIND ") .append(" , ( ") .append(" SELECT ") .append(" ZM0171_07.CD_DIV_NM ") .append(" FROM ") .append(" ZM_M_CD_NM_KANRI ZM0171_07 ") .append(" WHERE ") .append(" ZM0171_07.CD_SBT_CD = 'CD01838' ") .append(" AND ZM0171_07.CD_DIV = TU0151.CHUMN_KIND ") .append(" AND ZM0171_07.MK_FLG = '0' ") .append(" ) AS CHUMN_KIND_NM ") .append(" , TU0151.ORDER_STAT ") .append(" , TU0151.NOSK_DAIHYO_JGS_NM ") .append(" , TU0151.NOSK_DAIHYO_JGS_NO ") .append(" , ( ") .append(" SELECT ") .append(" TSJGS3.TSJGS_NM ") .append(" FROM ") .append(" TU_M_TUSHIN_JGYOSHA TSJGS3 ") .append(" WHERE ") .append(" TSJGS3.TSJGS_CD = TU0151.NOSK_DAIHYO_JGS_NO ") .append(" AND TSJGS3.MK_FLG = '0' ") .append(" ) AS NOSK_DAIHYO_JGS_NO_NM ") .append(" , TU0151.KJ_DAY_RE_ADJ_REQ_DATE ") .append(" , TU0151.KJ_DAY_RE_ADJ_REQ_TNT_NM ") .append(" , TU0151.KJ_DAY_RE_ADJ_REQ_TNT_TLN ") .append(" , TU0151.KJ_DAY_RE_ADJ_REQ_KIJIRAN ") .append(" , TU0151.TELNO ") .append(" , TU0151.SKBT_NO ") .append(" , TU0151.NAIBU_SKBT_NO ") .append(" , TU0151.PORT_OUT_CHBF_SKBT_NO ") .append(" , TU0151.PSTN_KANYKN ") .append(" , TU0151.PSTN_DRYCOPPER_USE_UM ") .append(" , TU0151.PSTN_DRYCOPPER_KISN_ID ") .append(" , TU0151.PSTN_DRYCOPPER_MSKMJIG_NO ") .append(" , TU0151.PSTN_DRYCOPPER_MKM_SKBT_NO ") .append(" , TU0151.ITNS_JGS_USE_CD ") .append(" , TU0151.PSTN_PAUSE_HYO_SHS ") .append(" , TU0151.PSTN_PAUSE_HYO_SHS_OTR_AD ") .append(" , TU0151.PSTN_ITENS_JIGYOSHA_CFM_ID ") .append(" , TU0151.PSTN_ITENS_KOJI_TYPE_SNAI ") .append(" , TU0151.PSTN_ITENS_KOJI_TYPE_SGAI ") .append(" , TU0151.KIJIRAN_ITENS_JGSMK ") .append(" , TU0151.ODKH_JUDGE_TK_KH ") .append(" , ( ") .append(" SELECT ") .append(" ZM0171_10.CD_DIV_NM ") .append(" FROM ") .append(" ZM_M_CD_NM_KANRI ZM0171_10 ") .append(" WHERE ") .append(" ZM0171_10.CD_SBT_CD = 'CD01834' ") .append(" AND ZM0171_10.CD_DIV = TU0151.ODKH_JUDGE_TK_KH ") .append(" AND ZM0171_10.MK_FLG = '0' ") .append(" ) AS ODKH_JUDGE_TK_KH_NM ") .append(" , TU0151.ODKH_JUDGE_TK_FAIL_RSN ") .append(" , TU0151.ODKH_JDGTK_FRSN_OTR_RSN ") .append(" , TU0151.UK_TNT_ID ") .append(" , TU0151.UK_TNT_TELNO ") .append(" , TU0151.KOJI_TNT_NM ") .append(" , TU0151.KOJI_TNT_TELNO ") .append(" , TU0151.TK_KH ") .append(" , ( ") .append(" SELECT ") .append(" ZM0171_11.CD_DIV_NM ") .append(" FROM ") .append(" ZM_M_CD_NM_KANRI ZM0171_11 ") .append(" WHERE ") .append(" ZM0171_11.CD_SBT_CD = 'CD01834' ") .append(" AND ZM0171_11.CD_DIV = TU0151.TK_KH ") .append(" AND ZM0171_11.MK_FLG = '0' ") .append(" ) AS TK_KH_NM ") .append(" , TU0151.TK_FAIL_RSN ") .append(" , TU0151.TK_FAIL_RSN_OTR_RSN ") .append(" , TU0151.HOJIN_KOJIN_CD ") .append(" , TU0151.PORT_OUT_UK_TRKM_YMD ") .append(" , TU0151.SWITCH_SOD_HAKKO_DTM ") .append(" , TU0151.ADD_DTM ") .append(" , TU0151.ADD_OPEACNT ") .append(" , ( ") .append(" SELECT ") .append(" ZM0051.USER_NM ") .append(" FROM ") .append(" ZM_M_USER ZM0051 ") .append(" WHERE ") .append(" ZM0051.USER_ID = TU0151.ADD_OPEACNT ") .append(" AND ZM0051.MK_FLG = '0' ") .append(" ) AS ADD_OPEACNT_NM ") .append(" , TU0151.UPD_DTM ") .append(" , TU0151.UPD_OPEACNT ") .append(" , ( ") .append(" SELECT ") .append(" ZM0051.USER_NM ") .append(" FROM ") .append(" ZM_M_USER ZM0051 ") .append(" WHERE ") .append(" ZM0051.USER_ID = TU0151.UPD_OPEACNT ") .append(" AND ZM0051.MK_FLG = '0' ") .append(" ) AS UPD_OPEACNT_NM ") .append(" , TU0151.DEL_DTM ") .append(" , TU0151.DEL_OPEACNT ") .append(" , ( ") .append(" SELECT ") .append(" ZM0051.USER_NM ") .append(" FROM ") .append(" ZM_M_USER ZM0051 ") .append(" WHERE ") .append(" ZM0051.USER_ID = TU0151.DEL_OPEACNT ") .append(" AND ZM0051.MK_FLG = '0' ") .append(" ) AS DEL_OPEACNT_NM ") .append(" , TU0151.MK_FLG ") .append(" , ( ") .append(" SELECT ") .append(" ZM0171_13.CD_DIV_NM ") .append(" FROM ") .append(" ZM_M_CD_NM_KANRI ZM0171_13 ") .append(" WHERE ") .append(" ZM0171_13.CD_SBT_CD = 'CD00016' ") .append(" AND ZM0171_13.CD_DIV = TU0151.MK_FLG ") .append(" AND ZM0171_13.MK_FLG = '0' ") .append(" ) AS HOJIN_KOJIN_CD_NM ") .append(" , TU0151.ADD_UNYO_YMD ") .append(" , TU0151.ADD_TRN_ID ") .append(" , TU0151.UPD_UNYO_YMD ") .append(" , TU0151.UPD_TRN_ID ") .append(" , TU0151.DEL_UNYO_YMD ") .append(" , TU0151.DEL_TRN_ID ") .append(" FROM ") .append(" TU_T_PORT_OUT_UK_IF TU0151 "); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(ETU0151B040CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE ") .append(" TU0151.TELNO = ? ") .append(" AND (TU0151.PORT_OUT_NO, TU0151.GENE_ADD_DTM) = ( ") .append(" SELECT ") .append(" TU0151_GENE.PORT_OUT_NO ") .append(" , MAX(TU0151_GENE.GENE_ADD_DTM) AS TU0151_MAX ") .append(" FROM ") .append(" TU_T_PORT_OUT_UK_IF TU0151_GENE ") .append(" WHERE ") .append(" TU0151_GENE.PORT_OUT_NO = TU0151.PORT_OUT_NO ") .append(" AND TU0151_GENE.MK_FLG = '0' ") .append(" GROUP BY ") .append(" TU0151_GENE.PORT_OUT_NO ") .append(" ) ") .append(" ORDER BY ") .append(" TU0151.PORT_OUT_UK_TRKM_YMD DESC ") .append(" , TU0151.PORT_OUT_NO DESC "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 if ( "1".equals( inMsg.getString(ETU0151B040CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(ＫＥＹ＿電話番号を指定) CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(ETU0151B040CBSMsg.KEY_TELNO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // ETU0151B040CBSMsgの明細にセットする項目 String[] msgKeyList1 = { ETU0151B040CBSMsg1List.PORT_OUT_NO , ETU0151B040CBSMsg1List.GENE_ADD_DTM , ETU0151B040CBSMsg1List.PORT_OUT_STAT , ETU0151B040CBSMsg1List.PORT_OUT_STAT_NM , ETU0151B040CBSMsg1List.SVC_KEI_NO , ETU0151B040CBSMsg1List.SVC_KEI_UCWK_NO , ETU0151B040CBSMsg1List.TOGO_ODR_ID , ETU0151B040CBSMsg1List.HAISHI_CHUMN_SKBT , ETU0151B040CBSMsg1List.RE_BMP_MKM_SKBT , ETU0151B040CBSMsg1List.AFT_TONYU_SKBT , ETU0151B040CBSMsg1List.HUKUSU_NO_UM , ETU0151B040CBSMsg1List.BMP_TG_KSSU_BMP_HISTG_KSSU , ETU0151B040CBSMsg1List.AUTO_HAISHI_RYSHZM_NO_NUM , ETU0151B040CBSMsg1List.GRP_ID , ETU0151B040CBSMsg1List.CUST_MSKM_DAY , ETU0151B040CBSMsg1List.ITENS_MSKM_DAY , ETU0151B040CBSMsg1List.CHBF_MSKM_DAY , ETU0151B040CBSMsg1List.UK_KYOTEN_NO_TRAT_SVC , ETU0151B040CBSMsg1List.ITENS_JIGYOSHA_NM , ETU0151B040CBSMsg1List.ITENS_JIGYOSHA_NO , ETU0151B040CBSMsg1List.ITENS_JIGYOSHA_NO_NM , ETU0151B040CBSMsg1List.ITENS_JIGYOSHA_DOMAIN , ETU0151B040CBSMsg1List.ITENS_JIGYOSHA_TNT_NM , ETU0151B040CBSMsg1List.ITENS_JIGYOSHA_TELNO , ETU0151B040CBSMsg1List.KIJIRAN_1_ITNM_JGSMK , ETU0151B040CBSMsg1List.KIJIRAN_2_ITNM_JGSMK , ETU0151B040CBSMsg1List.KIJIRAN_1_NOSK_JGSMK , ETU0151B040CBSMsg1List.KIJIRAN_2_NOSK_JGSMK , ETU0151B040CBSMsg1List.JI_SHANAI_KIJIRAN , ETU0151B040CBSMsg1List.PORT_OUT_KEISHA_NM , ETU0151B040CBSMsg1List.PORT_OUT_KEISHA_KANA , ETU0151B040CBSMsg1List.SETPLACE_ADCHG_UM , ETU0151B040CBSMsg1List.SETPLC_HTNY_SKBT_CITY_NM , ETU0151B040CBSMsg1List.SETPLC_HTNY_SKBT_OAZTSU_NM , ETU0151B040CBSMsg1List.SETPLC_HTNY_SKBT_AZCHO_NM , ETU0151B040CBSMsg1List.SETPLACE_PCD , ETU0151B040CBSMsg1List.SETPLACE_STATE_NM , ETU0151B040CBSMsg1List.SETPLACE_CITY_NM , ETU0151B040CBSMsg1List.SETPLACE_OAZTSU_NM , ETU0151B040CBSMsg1List.SETPLACE_AZCHO_NM , ETU0151B040CBSMsg1List.SETPLACE_BNCHIGO , ETU0151B040CBSMsg1List.SETPLACE_ADRTTM , ETU0151B040CBSMsg1List.CUST_RRKS , ETU0151B040CBSMsg1List.KOJI_KIBO_YMD , ETU0151B040CBSMsg1List.KOJI_JSSI_WAY , ETU0151B040CBSMsg1List.SOTEI_SWITCH_TIMEZ , ETU0151B040CBSMsg1List.KOJI_TIMEZ_DIV , ETU0151B040CBSMsg1List.ITENM_DAIHYO_JIGYOSHA_NM , ETU0151B040CBSMsg1List.ITENM_DAIHYO_JIGYOSHA_NO , ETU0151B040CBSMsg1List.ITENM_DAIHYO_JIGYOSHA_NO_NM , ETU0151B040CBSMsg1List.KISAI_CHGE_MSKM_CNT , ETU0151B040CBSMsg1List.KISAI_CHGE_MSKM_DAY , ETU0151B040CBSMsg1List.KISAI_CHGE_MSKM_RSN , ETU0151B040CBSMsg1List.OLD_TOGO_ORDER_ID , ETU0151B040CBSMsg1List.MSKM_CHOK_NISU , ETU0151B040CBSMsg1List.CANCEL_DATE , ETU0151B040CBSMsg1List.CANCEL_SKBT , ETU0151B040CBSMsg1List.CANCEL_OTAI_DAY , ETU0151B040CBSMsg1List.CANCEL_TONYU_TNT_NM , ETU0151B040CBSMsg1List.CANCEL_TONYU_TNT_TELNO , ETU0151B040CBSMsg1List.PORT_OUT_CNRE , ETU0151B040CBSMsg1List.CL_DATE , ETU0151B040CBSMsg1List.CL_SKBT , ETU0151B040CBSMsg1List.UWY_SKBT , ETU0151B040CBSMsg1List.SERVER_ARIV_DATE , ETU0151B040CBSMsg1List.BMP_ORDER_NO , ETU0151B040CBSMsg1List.KANREN_ORDER_CNT , ETU0151B040CBSMsg1List.BMP_TG_KISN_CNT_NOSK_GT , ETU0151B040CBSMsg1List.CHUMN_KIND , ETU0151B040CBSMsg1List.CHUMN_KIND_NM , ETU0151B040CBSMsg1List.ORDER_STAT , ETU0151B040CBSMsg1List.NOSK_DAIHYO_JGS_NM , ETU0151B040CBSMsg1List.NOSK_DAIHYO_JGS_NO , ETU0151B040CBSMsg1List.NOSK_DAIHYO_JGS_NO_NM , ETU0151B040CBSMsg1List.KJ_DAY_RE_ADJ_REQ_DATE , ETU0151B040CBSMsg1List.KJ_DAY_RE_ADJ_REQ_TNT_NM , ETU0151B040CBSMsg1List.KJ_DAY_RE_ADJ_REQ_TNT_TLN , ETU0151B040CBSMsg1List.KJ_DAY_RE_ADJ_REQ_KIJIRAN , ETU0151B040CBSMsg1List.TELNO , ETU0151B040CBSMsg1List.SKBT_NO , ETU0151B040CBSMsg1List.NAIBU_SKBT_NO , ETU0151B040CBSMsg1List.PORT_OUT_CHBF_SKBT_NO , ETU0151B040CBSMsg1List.PSTN_KANYKN , ETU0151B040CBSMsg1List.PSTN_DRYCOPPER_USE_UM , ETU0151B040CBSMsg1List.PSTN_DRYCOPPER_KISN_ID , ETU0151B040CBSMsg1List.PSTN_DRYCOPPER_MSKMJIG_NO , ETU0151B040CBSMsg1List.PSTN_DRYCOPPER_MKM_SKBT_NO , ETU0151B040CBSMsg1List.ITNS_JGS_USE_CD , ETU0151B040CBSMsg1List.PSTN_PAUSE_HYO_SHS , ETU0151B040CBSMsg1List.PSTN_PAUSE_HYO_SHS_OTR_AD , ETU0151B040CBSMsg1List.PSTN_ITENS_JIGYOSHA_CFM_ID , ETU0151B040CBSMsg1List.PSTN_ITENS_KOJI_TYPE_SNAI , ETU0151B040CBSMsg1List.PSTN_ITENS_KOJI_TYPE_SGAI , ETU0151B040CBSMsg1List.KIJIRAN_ITENS_JGSMK , ETU0151B040CBSMsg1List.ODKH_JUDGE_TK_KH , ETU0151B040CBSMsg1List.ODKH_JUDGE_TK_KH_NM , ETU0151B040CBSMsg1List.ODKH_JUDGE_TK_FAIL_RSN , ETU0151B040CBSMsg1List.ODKH_JDGTK_FRSN_OTR_RSN , ETU0151B040CBSMsg1List.UK_TNT_ID , ETU0151B040CBSMsg1List.UK_TNT_TELNO , ETU0151B040CBSMsg1List.KOJI_TNT_NM , ETU0151B040CBSMsg1List.KOJI_TNT_TELNO , ETU0151B040CBSMsg1List.TK_KH , ETU0151B040CBSMsg1List.TK_KH_NM , ETU0151B040CBSMsg1List.TK_FAIL_RSN , ETU0151B040CBSMsg1List.TK_FAIL_RSN_OTR_RSN , ETU0151B040CBSMsg1List.HOJIN_KOJIN_CD , ETU0151B040CBSMsg1List.PORT_OUT_UK_TRKM_YMD , ETU0151B040CBSMsg1List.SWITCH_SOD_HAKKO_DTM , ETU0151B040CBSMsg1List.ADD_DTM , ETU0151B040CBSMsg1List.ADD_OPEACNT , ETU0151B040CBSMsg1List.ADD_OPEACNT_NM , ETU0151B040CBSMsg1List.UPD_DTM , ETU0151B040CBSMsg1List.UPD_OPEACNT , ETU0151B040CBSMsg1List.UPD_OPEACNT_NM , ETU0151B040CBSMsg1List.DEL_DTM , ETU0151B040CBSMsg1List.DEL_OPEACNT , ETU0151B040CBSMsg1List.DEL_OPEACNT_NM , ETU0151B040CBSMsg1List.MK_FLG , ETU0151B040CBSMsg1List.MK_FLG_NM , ETU0151B040CBSMsg1List.ADD_UNYO_YMD , ETU0151B040CBSMsg1List.ADD_TRN_ID , ETU0151B040CBSMsg1List.UPD_UNYO_YMD , ETU0151B040CBSMsg1List.UPD_TRN_ID , ETU0151B040CBSMsg1List.DEL_UNYO_YMD , ETU0151B040CBSMsg1List.DEL_TRN_ID }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.ETU0151B040CBSMsg1List",0); // inMsg(CBSMsg)に明細をセット inMsg.set("ETU0151B040CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(ETU0151B040CBSMsg.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(ETU0151B040CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }