/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbEKK0401B003TPDA * ソースファイル名：JSYejbEKK0401B003TPDA.java * 作成者 ：EK103127 * 日付 ：2011年10月24日 *＜機能概要＞ * SQLFacility * テンプレート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.EKK0401B003CBSMsg; import eo.ejb.cbs.cbsmsg.EKK0401B003CBSMsg1List; import eo.ejb.cbm.entity.KK0401ETMsg; /** * * テンプレートDBアクセス部品　EKK0401B003_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbEKK0401B003TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbEKK0401B003TPDA() { } /** * EKK0401B003_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(KK0401ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" KK0401.OP_SVC_KEI_NO AS KK0401_OP_SVC_KEI_NO ") .append(" ,KK0401.SBOP_SVC_KEI_NO AS KK0401_SBOP_SVC_KEI_NO ") .append(" ,KK0401.GENE_ADD_DTM AS KK0401_GENE_ADD_DTM ") .append(" ,KK0401.SBOP_SVC_KEI_STAT AS SBOP_SVC_KEI_STAT ") .append(" ,KK0401.SBOP_SVC_CD AS SBOP_SVC_CD ") .append(" ,KK0401.PCRS_CD AS PCRS_CD ") .append(" ,KK0401.PPLAN_CD AS PPLAN_CD ") .append(" ,KK0401.MSKM_DTL_NO AS MSKM_DTL_NO ") .append(" ,KK0401.FTRIAL_KANYU_YMD AS FTRIAL_KANYU_YMD ") .append(" ,KK0401.FTRIAL_PRD_ENDYMD AS FTRIAL_PRD_ENDYMD ") .append(" ,KK0401.HONKANYU_YMD AS HONKANYU_YMD ") .append(" ,KK0401.HONKANYU_IKO_KIGEN_YMD AS HONKANYU_IKO_KIGEN_YMD ") .append(" ,KK0401.SVC_USE_STA_KIBO_YMD AS SVC_USE_STA_KIBO_YMD ") .append(" ,KK0401.RSV_TSTA_KIBO_YMD AS RSV_TSTA_KIBO_YMD ") .append(" ,KK0401.SBOP_SVC_KEI_KZKWRK_REQYMD AS SBOP_SVC_KEI_KZKWRK_REQYMD ") .append(" ,KK0401.SHOSA_YMD AS SHOSA_YMD ") .append(" ,KK0401.SHOSA_CL_YMD AS SHOSA_CL_YMD ") .append(" ,KK0401.KEI_CNC_YMD AS KEI_CNC_YMD ") .append(" ,KK0401.RSV_APLY_YMD AS RSV_APLY_YMD ") .append(" ,KK0401.RSV_CL_YMD AS RSV_CL_YMD ") .append(" ,KK0401.RSV_APLY_CD AS KK0401_RSV_APLY_CD ") .append(" ,KK0401.PLAN_STAYMD AS PLAN_STAYMD ") .append(" ,KK0401.PLAN_ENDYMD AS PLAN_ENDYMD ") .append(" ,KK0401.PLAN_CHRG_STAYMD AS PLAN_CHRG_STAYMD ") .append(" ,KK0401.PLAN_CHRG_ENDYMD AS PLAN_CHRG_ENDYMD ") .append(" ,KK0401.PLAN_END_SBT_CD AS PLAN_END_SBT_CD ") .append(" ,KK0401.SVC_CANCEL_YMD AS SVC_CANCEL_YMD ") .append(" ,KK0401.SVC_CANCEL_RSN_CD AS SVC_CANCEL_RSN_CD ") .append(" ,KK0401.SVC_STAYMD AS SVC_STAYMD ") .append(" ,KK0401.SVC_CHRG_STAYMD AS SVC_CHRG_STAYMD ") .append(" ,KK0401.SVC_STP_YMD AS SVC_STP_YMD ") .append(" ,KK0401.SVC_STP_RSN_CD AS SVC_STP_RSN_CD ") .append(" ,KK0401.SVC_STP_RLS_YMD AS SVC_STP_RLS_YMD ") .append(" ,KK0401.SVC_STP_RLS_RSN_CD AS SVC_STP_RLS_RSN_CD ") .append(" ,KK0401.PAUSE_STP_CD AS PAUSE_STP_CD ") .append(" ,KK0401.SVC_PAUSE_YMD AS SVC_PAUSE_YMD ") .append(" ,KK0401.SVC_PAUSE_RSN_CD AS SVC_PAUSE_RSN_CD ") .append(" ,KK0401.SVC_PAUSE_RSN_MEMO AS SVC_PAUSE_RSN_MEMO ") .append(" ,KK0401.SVC_PAUSE_RLS_YMD AS SVC_PAUSE_RLS_YMD ") .append(" ,KK0401.SVC_PAUSE_RLS_RSN_CD AS SVC_PAUSE_RLS_RSN_CD ") .append(" ,KK0401.SVC_PAUSE_RLS_RSN_MEMO AS SVC_PAUSE_RLS_RSN_MEMO ") .append(" ,KK0401.SVC_ENDYMD AS SVC_ENDYMD ") .append(" ,KK0401.SVC_CHRG_ENDYMD AS SVC_CHRG_ENDYMD ") .append(" ,KK0401.SVC_DSL_YMD AS SVC_DSL_YMD ") .append(" ,KK0401.SVC_DLRE_CD AS SVC_DLRE_CD ") .append(" ,KK0401.SVC_DLRE_MEMO AS SVC_DLRE_MEMO ") .append(" ,KK0401.SVC_DSL_TTDKI_FIN_FLG AS SVC_DSL_TTDKI_FIN_FLG ") .append(" ,KK0401.KAIHK_YMD AS KAIHK_YMD ") .append(" ,KK0401.SVC_CANCEL_CL_YMD AS SVC_CANCEL_CL_YMD ") .append(" ,KK0401.SVC_DSL_CL_YMD AS SVC_DSL_CL_YMD ") .append(" ,KK0401.SKEKKA_SEND_CD AS SKEKKA_SEND_CD ") .append(" ,KK0401.CHRG_STA_YMD_HOSEI_UM AS CHRG_STA_YMD_HOSEI_UM ") .append(" ,KK0401.SVC_PAUSE_CHRG_STA_YMD AS SVC_PAUSE_CHRG_STA_YMD ") .append(" ,KK0401.PNLTY_HASSEI_CD AS PNLTY_HASSEI_CD ") .append(" ,KK0401.IDO_DIV AS IDO_DIV ") .append(" ,KK0401.SHOSA_DSL_FIN_CD AS SHOSA_DSL_FIN_CD ") .append(" ,KK0401.ADD_DTM AS KK0401_ADD_DTM ") .append(" ,KK0401.ADD_OPEACNT AS KK0401_ADD_OPEACNT ") .append(" ,KK0401.UPD_DTM AS KK0401_UPD_DTM ") .append(" ,KK0401.UPD_OPEACNT AS KK0401_UPD_OPEACNT ") .append(" ,KK0401.DEL_DTM AS KK0401_DEL_DTM ") .append(" ,KK0401.DEL_OPEACNT AS KK0401_DEL_OPEACNT ") .append(" ,KK0401.MK_FLG AS KK0401_MK_FLG ") .append(" ,KK0411.OP_SVC_KEI_NO AS KK0411_OP_SVC_KEI_NO ") .append(" ,KK0411.SBOP_SVC_KEI_NO AS KK0411_SBOP_SVC_KEI_NO ") .append(" ,KK0411.GENE_ADD_DTM AS KK0411_GENE_ADD_DTM ") .append(" ,KK0411.ADD_CAPA AS ADD_CAPA ") .append(" ,KK0411.ALIAS AS ALIAS ") .append(" ,KK0411.ALIAS_CHGE_YMD AS ALIAS_CHGE_YMD ") .append(" ,KK0411.RSV_APLY_CD AS KK0411_RSV_APLY_CD ") .append(" ,KK0411.ADD_DTM AS KK0411_ADD_DTM ") .append(" ,KK0411.ADD_OPEACNT AS KK0411_ADD_OPEACNT ") .append(" ,KK0411.UPD_DTM AS KK0411_UPD_DTM ") .append(" ,KK0411.UPD_OPEACNT AS KK0411_UPD_OPEACNT ") .append(" ,KK0411.DEL_DTM AS KK0411_DEL_DTM ") .append(" ,KK0411.DEL_OPEACNT AS KK0411_DEL_OPEACNT ") .append(" ,KK0411.MK_FLG AS KK0411_MK_FLG ") .append(" ,KK0421.OP_SVC_KEI_NO AS KK0421_OP_SVC_KEI_NO ") .append(" ,KK0421.SBOP_SVC_KEI_NO AS KK0421_SBOP_SVC_KEI_NO ") .append(" ,KK0421.GENE_ADD_DTM AS KK0421_GENE_ADD_DTM ") .append(" ,KK0421.RSV_APLY_CD AS KK0421_RSV_APLY_CD ") .append(" ,KK0421.ADD_DTM AS KK0421_ADD_DTM ") .append(" ,KK0421.ADD_OPEACNT AS KK0421_ADD_OPEACNT ") .append(" ,KK0421.UPD_DTM AS KK0421_UPD_DTM ") .append(" ,KK0421.UPD_OPEACNT AS KK0421_UPD_OPEACNT ") .append(" ,KK0421.DEL_DTM AS KK0421_DEL_DTM ") .append(" ,KK0421.DEL_OPEACNT AS KK0421_DEL_OPEACNT ") .append(" ,KK0421.MK_FLG AS KK0421_MK_FLG ") .append(" ,KK0431.OP_SVC_KEI_NO AS KK0431_OP_SVC_KEI_NO ") .append(" ,KK0431.SBOP_SVC_KEI_NO AS KK0431_SBOP_SVC_KEI_NO ") .append(" ,KK0431.GENE_ADD_DTM AS KK0431_GENE_ADD_DTM ") .append(" ,KK0431.RSV_APLY_CD AS KK0431_RSV_APLY_CD ") .append(" ,KK0431.ADD_DTM AS KK0431_ADD_DTM ") .append(" ,KK0431.ADD_OPEACNT AS KK0431_ADD_OPEACNT ") .append(" ,KK0431.UPD_DTM AS KK0431_UPD_DTM ") .append(" ,KK0431.UPD_OPEACNT AS KK0431_UPD_OPEACNT ") .append(" ,KK0431.DEL_DTM AS KK0431_DEL_DTM ") .append(" ,KK0431.DEL_OPEACNT AS KK0431_DEL_OPEACNT ") .append(" ,KK0431.MK_FLG AS KK0431_MK_FLG ") .append(" ,(SELECT KK0831.SBOP_SVC_NM ") .append(" FROM KK_M_SBOP_SVC KK0831 ") .append(" WHERE KK0831.SBOP_SVC_CD = KK0401.SBOP_SVC_CD ") .append(" AND (KK0831.SBOP_SVC_CD, KK0831.GENE_ADD_DTM) = ") .append(" (SELECT KK0831_GENE.SBOP_SVC_CD, MAX(KK0831_GENE.GENE_ADD_DTM) AS KK0831_MAX ") .append(" FROM KK_M_SBOP_SVC KK0831_GENE ") .append(" WHERE KK0831_GENE.SBOP_SVC_CD = KK0831.SBOP_SVC_CD ") .append(" AND KK0831_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0831_GENE.SBOP_SVC_CD )) AS SBOP_SVC_CD_NM ") .append(" ,( SELECT ZM0051_ADD.USER_NM ") .append(" FROM ZM_M_USER ZM0051_ADD ") .append(" WHERE ZM0051_ADD.USER_ID = KK0401.ADD_OPEACNT ") .append(" AND ZM0051_ADD.MK_FLG = '0' ") .append(" ) AS KK0401_ADD_OPEACNT_NM ") .append(" ,( SELECT ZM0051_UPD.USER_NM ") .append(" FROM ZM_M_USER ZM0051_UPD ") .append(" WHERE ZM0051_UPD.USER_ID = KK0401.UPD_OPEACNT ") .append(" AND ZM0051_UPD.MK_FLG = '0' ") .append(" ) AS KK0401_UPD_OPEACNT_NM ") .append(" FROM KK_T_SBOP_SVC_KEI KK0401 ") .append(" LEFT JOIN KK_T_SBOPSVKEI_ISP KK0411 ") .append(" ON KK0401.OP_SVC_KEI_NO = KK0411.OP_SVC_KEI_NO ") .append(" AND KK0401.SBOP_SVC_KEI_NO = KK0411.SBOP_SVC_KEI_NO ") .append(" AND KK0401.GENE_ADD_DTM = KK0411.GENE_ADD_DTM ") .append(" LEFT JOIN KK_T_SBOPSVKEI_TV KK0421 ") .append(" ON KK0401.OP_SVC_KEI_NO = KK0421.OP_SVC_KEI_NO ") .append(" AND KK0401.SBOP_SVC_KEI_NO = KK0421.SBOP_SVC_KEI_NO ") .append(" AND KK0401.GENE_ADD_DTM = KK0421.GENE_ADD_DTM ") .append(" LEFT JOIN KK_T_SBOPSVKEI_TEL KK0431 ") .append(" ON KK0401.OP_SVC_KEI_NO = KK0431.OP_SVC_KEI_NO ") .append(" AND KK0401.SBOP_SVC_KEI_NO = KK0431.SBOP_SVC_KEI_NO ") .append(" AND KK0401.GENE_ADD_DTM = KK0431.GENE_ADD_DTM "); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(EKK0401B003CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE KK0401.OP_SVC_KEI_NO = ? ") .append(" AND KK0401.MK_FLG = '0' ") .append(" ORDER BY KK0401.SBOP_SVC_KEI_NO ASC, KK0401.GENE_ADD_DTM 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(EKK0401B003CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(ＫＥＹ＿オプションサービス契約番号を指定) CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(EKK0401B003CBSMsg.KEY_SBOP_SVC_KEI_NO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // EKK0401B003CBSMsgの明細にセットする項目 String[] msgKeyList1 = { EKK0401B003CBSMsg1List.KK0401_OP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0401_SBOP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0401_GENE_ADD_DTM , EKK0401B003CBSMsg1List.SBOP_SVC_KEI_STAT , EKK0401B003CBSMsg1List.SBOP_SVC_CD , EKK0401B003CBSMsg1List.PCRS_CD , EKK0401B003CBSMsg1List.PPLAN_CD , EKK0401B003CBSMsg1List.MSKM_DTL_NO , EKK0401B003CBSMsg1List.FTRIAL_KANYU_YMD , EKK0401B003CBSMsg1List.FTRIAL_PRD_ENDYMD , EKK0401B003CBSMsg1List.HONKANYU_YMD , EKK0401B003CBSMsg1List.HONKANYU_IKO_KIGEN_YMD , EKK0401B003CBSMsg1List.SVC_USE_STA_KIBO_YMD , EKK0401B003CBSMsg1List.RSV_TSTA_KIBO_YMD , EKK0401B003CBSMsg1List.SBOP_SVC_KEI_KZKWRK_REQYMD , EKK0401B003CBSMsg1List.SHOSA_YMD , EKK0401B003CBSMsg1List.SHOSA_CL_YMD , EKK0401B003CBSMsg1List.KEI_CNC_YMD , EKK0401B003CBSMsg1List.RSV_APLY_YMD , EKK0401B003CBSMsg1List.RSV_CL_YMD , EKK0401B003CBSMsg1List.KK0401_RSV_APLY_CD , EKK0401B003CBSMsg1List.PLAN_STAYMD , EKK0401B003CBSMsg1List.PLAN_ENDYMD , EKK0401B003CBSMsg1List.PLAN_CHRG_STAYMD , EKK0401B003CBSMsg1List.PLAN_CHRG_ENDYMD , EKK0401B003CBSMsg1List.PLAN_END_SBT_CD , EKK0401B003CBSMsg1List.SVC_CANCEL_YMD , EKK0401B003CBSMsg1List.SVC_CANCEL_RSN_CD , EKK0401B003CBSMsg1List.SVC_STAYMD , EKK0401B003CBSMsg1List.SVC_CHRG_STAYMD , EKK0401B003CBSMsg1List.SVC_STP_YMD , EKK0401B003CBSMsg1List.SVC_STP_RSN_CD , EKK0401B003CBSMsg1List.SVC_STP_RLS_YMD , EKK0401B003CBSMsg1List.SVC_STP_RLS_RSN_CD , EKK0401B003CBSMsg1List.PAUSE_STP_CD , EKK0401B003CBSMsg1List.SVC_PAUSE_YMD , EKK0401B003CBSMsg1List.SVC_PAUSE_RSN_CD , EKK0401B003CBSMsg1List.SVC_PAUSE_RSN_MEMO , EKK0401B003CBSMsg1List.SVC_PAUSE_RLS_YMD , EKK0401B003CBSMsg1List.SVC_PAUSE_RLS_RSN_CD , EKK0401B003CBSMsg1List.SVC_PAUSE_RLS_RSN_MEMO , EKK0401B003CBSMsg1List.SVC_ENDYMD , EKK0401B003CBSMsg1List.SVC_CHRG_ENDYMD , EKK0401B003CBSMsg1List.SVC_DSL_YMD , EKK0401B003CBSMsg1List.SVC_DLRE_CD , EKK0401B003CBSMsg1List.SVC_DLRE_MEMO , EKK0401B003CBSMsg1List.SVC_DSL_TTDKI_FIN_FLG , EKK0401B003CBSMsg1List.KAIHK_YMD , EKK0401B003CBSMsg1List.SVC_CANCEL_CL_YMD , EKK0401B003CBSMsg1List.SVC_DSL_CL_YMD , EKK0401B003CBSMsg1List.SKEKKA_SEND_CD , EKK0401B003CBSMsg1List.CHRG_STA_YMD_HOSEI_UM , EKK0401B003CBSMsg1List.SVC_PAUSE_CHRG_STA_YMD , EKK0401B003CBSMsg1List.PNLTY_HASSEI_CD , EKK0401B003CBSMsg1List.IDO_DIV , EKK0401B003CBSMsg1List.SHOSA_DSL_FIN_CD , EKK0401B003CBSMsg1List.KK0401_ADD_DTM , EKK0401B003CBSMsg1List.KK0401_ADD_OPEACNT , EKK0401B003CBSMsg1List.KK0401_UPD_DTM , EKK0401B003CBSMsg1List.KK0401_UPD_OPEACNT , EKK0401B003CBSMsg1List.KK0401_DEL_DTM , EKK0401B003CBSMsg1List.KK0401_DEL_OPEACNT , EKK0401B003CBSMsg1List.KK0401_MK_FLG , EKK0401B003CBSMsg1List.KK0411_OP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0411_SBOP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0411_GENE_ADD_DTM , EKK0401B003CBSMsg1List.ADD_CAPA , EKK0401B003CBSMsg1List.ALIAS , EKK0401B003CBSMsg1List.ALIAS_CHGE_YMD , EKK0401B003CBSMsg1List.KK0411_RSV_APLY_CD , EKK0401B003CBSMsg1List.KK0411_ADD_DTM , EKK0401B003CBSMsg1List.KK0411_ADD_OPEACNT , EKK0401B003CBSMsg1List.KK0411_UPD_DTM , EKK0401B003CBSMsg1List.KK0411_UPD_OPEACNT , EKK0401B003CBSMsg1List.KK0411_DEL_DTM , EKK0401B003CBSMsg1List.KK0411_DEL_OPEACNT , EKK0401B003CBSMsg1List.KK0411_MK_FLG , EKK0401B003CBSMsg1List.KK0421_OP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0421_SBOP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0421_GENE_ADD_DTM , EKK0401B003CBSMsg1List.KK0421_RSV_APLY_CD , EKK0401B003CBSMsg1List.KK0421_ADD_DTM , EKK0401B003CBSMsg1List.KK0421_ADD_OPEACNT , EKK0401B003CBSMsg1List.KK0421_UPD_DTM , EKK0401B003CBSMsg1List.KK0421_UPD_OPEACNT , EKK0401B003CBSMsg1List.KK0421_DEL_DTM , EKK0401B003CBSMsg1List.KK0421_DEL_OPEACNT , EKK0401B003CBSMsg1List.KK0421_MK_FLG , EKK0401B003CBSMsg1List.KK0431_OP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0431_SBOP_SVC_KEI_NO , EKK0401B003CBSMsg1List.KK0431_GENE_ADD_DTM , EKK0401B003CBSMsg1List.KK0431_RSV_APLY_CD , EKK0401B003CBSMsg1List.KK0431_ADD_DTM , EKK0401B003CBSMsg1List.KK0431_ADD_OPEACNT , EKK0401B003CBSMsg1List.KK0431_UPD_DTM , EKK0401B003CBSMsg1List.KK0431_UPD_OPEACNT , EKK0401B003CBSMsg1List.KK0431_DEL_DTM , EKK0401B003CBSMsg1List.KK0431_DEL_OPEACNT , EKK0401B003CBSMsg1List.KK0431_MK_FLG , EKK0401B003CBSMsg1List.SBOP_SVC_CD_NM , EKK0401B003CBSMsg1List.KK0401_ADD_OPEACNT_NM , EKK0401B003CBSMsg1List.KK0401_UPD_OPEACNT_NM }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK0401B003CBSMsg1List",0); // inMsg(CBSMsg)に明細をセット inMsg.set("EKK0401B003CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(EKK0401B003CBSMsg.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(EKK0401B003CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }