/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名：eo顧客基幹システム * モジュール名：JSYejbETU0081B013TPDA * ソースファイル名：JSYejbETU0081B013TPDA.java * 作成者：EK908590 * 日付：2012年01月24日 *＜機能概要＞ * TDIS番号情報申込書番ポ有情報取得テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン修正日修正者修正内容 * v3.00.00 2012/03/17 FJ)楠神新規作成 * v3.00.01 2012/08/23 FJ)宮本 IT1-2012-0000963 * v5.00.02 2013/05/24 FJ)高橋 ANK-1529-00-00 * v48.00.00 2020/01/21 FJ)西窪 ANK-3507-00-00 TDIS連携の自動化対応 * ********************************************************************************/ 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.common.constant.JPCModelConstant; import eo.common.constant.JTUStrConst; import eo.ejb.cbs.cbsmsg.ETU0081B013CBSMsg; import eo.ejb.cbs.cbsmsg.ETU0081B013CBSMsg1List; import eo.ejb.cbm.entity.TU0081ETMsg; /** * * テンプレートDBアクセス部品　ETU0081B013_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
* @author FJ */ public class JSYejbETU0081B013TPDA extends CAANSQLFacility implements TemplateDBAccessHandler { /** * コンストラクタ */ public JSYejbETU0081B013TPDA() { } /** * ETU0081B013_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @param inContext * @return void */ public void invoke(CAANMsg inMsg, AgentDispatchContext inContext) { // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt = null; // リザルトセット ResultSet rsltQuery = null; /** * パラメータセット用 */ int iIndex = 1; // 検索処理パターン String searchType = inMsg.getString(ETU0081B013CBSMsg.SEARCH_TYPE); //共通部必須チェック if(JPCModelConstant.SAERCH_TYPE_IKT.equals(searchType)) { /** * 最大検索件数が未設定の場合 */ if (inMsg.isNull(ETU0081B013CBSMsg.MAX_SEARCH_NUM)) { throw new IllegalArgumentException(JTUStrConst.ICRN_ERR_MSG_IKT); } } else { throw new IllegalArgumentException(JTUStrConst.ICRN_ERR_MSG_FUSEI_PTN); } /******************** * SQL文の作成 ********************/ try { //コネクション取得 con1 = JSYejbConnection.getConnection(TU0081ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); StringBuffer sql_Select = new StringBuffer(); StringBuffer sql_From = new StringBuffer(); StringBuffer sql_Where = new StringBuffer(); StringBuffer sql_Order = new StringBuffer(); sql_Select.append(" SELECT ") .append(" TU0041.KOPT_RRK_MDGC_TELNO, ") .append(" TU0041.KOPT_RRK_MDGC_FAX_NO, ") .append(" TU0081.ORDER_NO, ") .append(" TU0081.DNWACHOMSK_IDO_YMD, ") .append(" TU0081.DNWACHOMSK_IDO_NAIYO_CD, ") .append(" TU0081.DNWACHOMSK_IDO_NAIYO_OTHER, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.NTT_TELNO,TU0091_NEW.NTT_TELNO) AS NTT_TELNO, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEI_TELNO,TU0091_NEW.KEI_TELNO) AS KEI_TELNO, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.TEKKYO_DSP_CD,TU0091_NEW.TEKKYO_DSP_CD) AS TEKKYO_DSP_CD, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_GUIDE_USE_CD,TU0091_NEW.KEISAI_GUIDE_USE_CD) AS KEISAI_GUIDE_USE_CD, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.JIJUBETS_FLG,TU0091_NEW.JIJUBETS_FLG) AS JIJUBETS_FLG, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.FREE_TEIGI_KMK,TU0091_NEW.FREE_TEIGI_KMK) AS FREE_TEIGI_KMK, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_STATE_NM,TU0091_NEW.SETPLACE_STATE_NM) AS SETPLACE_STATE_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_CITY_NM,TU0091_NEW.SETPLACE_CITY_NM) AS SETPLACE_CITY_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_OAZTSU_NM,TU0091_NEW.SETPLACE_OAZTSU_NM) AS SETPLACE_OAZTSU_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_AZCHO_NM,TU0091_NEW.SETPLACE_AZCHO_NM) AS SETPLACE_AZCHO_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_BNCHIGO,TU0091_NEW.SETPLACE_BNCHIGO) AS SETPLACE_BNCHIGO, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_ADRTTM,TU0091_NEW.SETPLACE_ADRTTM) AS SETPLACE_ADRTTM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_ADRRM,TU0091_NEW.SETPLACE_ADRRM) AS SETPLACE_ADRRM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.SETPLACE_AD_CD,TU0091_NEW.SETPLACE_AD_CD) AS SETPLACE_AD_CD, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_AD_DIV,TU0091_NEW.KEISAI_AD_DIV) AS KEISAI_AD_DIV, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_STATE_NM,TU0091_NEW.KEISAI_STATE_NM) AS KEISAI_STATE_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_CITY_NM,TU0091_NEW.KEISAI_CITY_NM) AS KEISAI_CITY_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_OAZTSU_NM,TU0091_NEW.KEISAI_OAZTSU_NM) AS KEISAI_OAZTSU_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_AZCHO_NM,TU0091_NEW.KEISAI_AZCHO_NM) AS KEISAI_AZCHO_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_AD_BNCHIGO,TU0091_NEW.KEISAI_AD_BNCHIGO) AS KEISAI_AD_BNCHIGO, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_ADRTTM,TU0091_NEW.KEISAI_ADRTTM) AS KEISAI_ADRTTM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_ADRRM,TU0091_NEW.KEISAI_ADRRM) AS KEISAI_ADRRM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_AD_CD,TU0091_NEW.KEISAI_AD_CD) AS KEISAI_AD_CD, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.COMP_KOBET_FLG,TU0091_NEW.COMP_KOBET_FLG) AS COMP_KOBET_FLG, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.DBLE_KEISAI_FLG,TU0091_NEW.DBLE_KEISAI_FLG) AS DBLE_KEISAI_FLG, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_KANA_NM,TU0091_NEW.KEISAI_KANA_NM) AS KEISAI_KANA_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_NM,TU0091_NEW.KEISAI_NM) AS KEISAI_NM, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.DNRYAK_SYMBOL,TU0091_NEW.DNRYAK_SYMBOL) AS DNRYAK_SYMBOL, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KEISAI_NM_APPDX,TU0091_NEW.KEISAI_NM_APPDX) AS KEISAI_NM_APPDX, ") .append(" DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.KIJIRAN,TU0091_NEW.KIJIRAN) AS KIJIRAN, ") .append(" TU0081.DNWACHOMSK_BIKO, ") .append(" TU0051.NTT_YO_TSJGS_NM AS BMP_ITENM_JIGYOSHA_NM, ") .append(" DECODE(TU0081.HOJIN_KOJIN_CD,1,TU0011.BMP_KOJI_FIX_YMDH,TU0081.DNWACHOMSK_IDO_YMD || '00') AS BMP_KOJI_FIX_YMD, ") .append(" TU0081.UPD_DTM, ") .append(" TU0081.TDIS_SEND_CNT, ") .append(" TU0081.DNWACHO_MSKM_STAT, ") .append(" TU0081.TDIS_INFO_CHK_FLG, ") .append(" TU0081.AD_CHK_RSLT_CD, ") .append(" ( ") .append(" SELECT ") .append(" MAX(BUSDAY.TRGT_YMD) ") .append(" FROM ") .append(" ZM_M_BUSIDAY_KANRI BUSDAY ") .append(" WHERE ") .append(" BUSDAY.TRGT_YMD < SUBSTR(TU0011.BMP_KOJI_FIX_YMDH,1,8) ") .append(" AND BUSDAY.BUSIDAY_FLG = '1' ") .append(" AND BUSDAY.MK_FLG = '0' ") // ANK 3507-00-00 MOD START // .append(" ) AS TRGT_YMD "); .append(" ) AS TRGT_YMD, ") // ANK 3507-00-00 MOD END // ANK-3507-00-00 ADD START .append(" TU0081.TDIS_FST_RENKEI_DTM "); // ANK-3507-00-00 ADD END sql_From.append(" FROM ") .append(" TU_T_DNWACHOMSK TU0081 ") .append(" INNER JOIN TU_T_DNWACHOMSK_NYO TU0091_NEW ") .append(" ON TU0081.DNWACHO_MSKM_NO = TU0091_NEW.DNWACHO_MSKM_NO ") .append(" AND TU0081.GENE_ADD_DTM = TU0091_NEW.GENE_ADD_DTM ") .append(" AND TU0091_NEW.DNWACHOMSK_NEW_OLD_FLG = '0' ") .append(" AND TU0091_NEW.MK_FLG = '0' ") .append(" INNER JOIN TU_T_DNWACHOMSK_NYO TU0091_OLD ") .append(" ON TU0081.DNWACHO_MSKM_NO = TU0091_OLD.DNWACHO_MSKM_NO ") .append(" AND TU0081.GENE_ADD_DTM = TU0091_OLD.GENE_ADD_DTM ") .append(" AND TU0091_OLD.DNWACHOMSK_NEW_OLD_FLG = '1' ") .append(" AND TU0091_OLD.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_T_BMP_KOJI TU0011 ") .append(" ON ") .append(" TU0011.GENE_ADD_DTM IN ( ") .append(" SELECT ") .append(" MAX(BMP_GENE.GENE_ADD_DTM) ") .append(" FROM ") .append(" TU_T_BMP_KOJI BMP_GENE ") .append(" WHERE ") .append(" BMP_GENE.BMP_KOJI_NO = TU0011.BMP_KOJI_NO ") .append(" AND BMP_GENE.MK_FLG= '0' ") .append(" GROUP BY BMP_GENE.BMP_KOJI_NO ") .append(" ) ") .append(" AND TU0011.MK_FLG = '0' ") .append(" AND NVL(TU0081.SVC_KEI_UCWK_NO, 'DUMMY') = NVL(TU0011.SVC_KEI_UCWK_NO, 'DUMMY') ") .append(" AND NVL(TU0081.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') = NVL(TU0011.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') ") .append(" AND TU0011.NTT_KEI_TEL_KAISEN_NO = DECODE(TU0081.DNWACHOMSK_IDO_NAIYO_CD,3,TU0091_OLD.NTT_TELNO,TU0091_NEW.NTT_TELNO) ") .append(" AND TU0011.BMP_KOJI_STAT IN('000','010','011','012','013','021','022','023','031','032','040','041','050') ") .append(" LEFT OUTER JOIN TU_M_MSKM_JIGSHO TU0041 ") .append(" ON TU0081.MSKM_JIGSHO_NO = TU0041.MSKM_JIGSHO_NO ") .append(" AND TU0041.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" ON TU0011.ITNM_TSJGS_CD = TU0051.TSJGS_CD ") .append(" AND TU0051.MK_FLG = '0' "); // SQL文_個別部1 if ("1".equals(inMsg.getObject(ETU0081B013CBSMsg.FUNC_CODE).toString())) { sql_Where.append(" WHERE ") .append(" TU0081.DNWACHO_MSKM_NO = ? ") .append(" AND TU0081.GENE_ADD_DTM = ? ") .append(" AND TU0081.MK_FLG = '0' "); } //件数取得SQL StringBuffer sql_cnt = new StringBuffer(); sql_cnt.append(" SELECT ") .append(" COUNT(*) AS CNT ") .append(sql_From) .append(sql_Where); //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_cnt.toString()); // PreparedStatementの指定されたパラメータカラムに指定された値を設定 if ("1".equals(inMsg.getString(ETU0081B013CBSMsg.FUNC_CODE))) { //パラメータ設定用Index 初期化 iIndex = 1; // パラメータの設定(ＫＥＹ＿電話帳申込番号を指定) CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B013CBSMsg.KEY_DNWACHO_MSKM_NO)); // パラメータの設定(ＫＥＹ＿世代登録年月日時分秒を指定) CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B013CBSMsg.KEY_GENE_ADD_DTM)); } //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_cnt); /** * SQL文実行 */ // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // ETU0081B015CBSMsgの明細にセットする項目 String[] msgKeyListCnt = { ETU0081B013CBSMsg.TOTAL_SEARCH_NUM }; /** * 結果取得 */ rsltQuery.next(); mapMessage(rsltQuery, msgKeyListCnt, inMsg); // 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了 if (0 == (Integer.parseInt(inMsg.getString(ETU0081B013CBSMsg.TOTAL_SEARCH_NUM)))) { inMsg.set(ETU0081B013CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO); return; } // 検索件数が最大検索件数を超えた場合、エラーフラグに"2"を設定して処理終了 if (Integer.parseInt(inMsg.getString(ETU0081B013CBSMsg.MAX_SEARCH_NUM)) < (Integer.parseInt(inMsg.getString(ETU0081B013CBSMsg.TOTAL_SEARCH_NUM)))) { inMsg.set(ETU0081B013CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_OVERMAX); return; } if(rsltQuery != null) { rsltQuery.close(); } if(pstmt != null) { pstmt.close(); } /*********************************************************************************************** * データ取得 */ sql_Buff.append(" SELECT ") .append(" * ") .append(" FROM ") .append(" ( ") .append(sql_Select) .append(sql_From) .append(sql_Where) .append(sql_Order) .append(" ) TBL "); //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに指定された値を設定 if ("1".equals(inMsg.getString(ETU0081B013CBSMsg.FUNC_CODE))) { //パラメータ設定用Index 初期化 iIndex = 1; // パラメータの設定(ＫＥＹ＿電話帳申込番号を指定) CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B013CBSMsg.KEY_DNWACHO_MSKM_NO)); // パラメータの設定(ＫＥＹ＿世代登録年月日時分秒を指定) CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B013CBSMsg.KEY_GENE_ADD_DTM)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // ETU0081B013CBSMsgの明細にセットする項目 String[] msgKeyList1 = { ETU0081B013CBSMsg1List.KOPT_RRK_MDGC_TELNO , ETU0081B013CBSMsg1List.KOPT_RRK_MDGC_FAX_NO , ETU0081B013CBSMsg1List.ORDER_NO , ETU0081B013CBSMsg1List.DNWACHOMSK_IDO_YMD , ETU0081B013CBSMsg1List.DNWACHOMSK_IDO_NAIYO_CD , ETU0081B013CBSMsg1List.DNWACHOMSK_IDO_NAIYO_OTHER , ETU0081B013CBSMsg1List.NTT_TELNO , ETU0081B013CBSMsg1List.KEI_TELNO , ETU0081B013CBSMsg1List.TEKKYO_DSP_CD , ETU0081B013CBSMsg1List.KEISAI_GUIDE_USE_CD , ETU0081B013CBSMsg1List.JIJUBETS_FLG , ETU0081B013CBSMsg1List.FREE_TEIGI_KMK , ETU0081B013CBSMsg1List.SETPLACE_STATE_NM , ETU0081B013CBSMsg1List.SETPLACE_CITY_NM , ETU0081B013CBSMsg1List.SETPLACE_OAZTSU_NM , ETU0081B013CBSMsg1List.SETPLACE_AZCHO_NM , ETU0081B013CBSMsg1List.SETPLACE_BNCHIGO , ETU0081B013CBSMsg1List.SETPLACE_ADRTTM , ETU0081B013CBSMsg1List.SETPLACE_ADRRM , ETU0081B013CBSMsg1List.SETPLACE_AD_CD , ETU0081B013CBSMsg1List.KEISAI_AD_DIV , ETU0081B013CBSMsg1List.KEISAI_STATE_NM , ETU0081B013CBSMsg1List.KEISAI_CITY_NM , ETU0081B013CBSMsg1List.KEISAI_OAZTSU_NM , ETU0081B013CBSMsg1List.KEISAI_AZCHO_NM , ETU0081B013CBSMsg1List.KEISAI_AD_BNCHIGO , ETU0081B013CBSMsg1List.KEISAI_ADRTTM , ETU0081B013CBSMsg1List.KEISAI_ADRRM , ETU0081B013CBSMsg1List.KEISAI_AD_CD , ETU0081B013CBSMsg1List.COMP_KOBET_FLG , ETU0081B013CBSMsg1List.DBLE_KEISAI_FLG , ETU0081B013CBSMsg1List.KEISAI_KANA_NM , ETU0081B013CBSMsg1List.KEISAI_NM , ETU0081B013CBSMsg1List.DNRYAK_SYMBOL , ETU0081B013CBSMsg1List.KEISAI_NM_APPDX , ETU0081B013CBSMsg1List.KIJIRAN , ETU0081B013CBSMsg1List.DNWACHOMSK_BIKO , ETU0081B013CBSMsg1List.BMP_ITENM_JIGYOSHA_NM , ETU0081B013CBSMsg1List.BMP_KOJI_FIX_YMD , ETU0081B013CBSMsg1List.UPD_DTM , ETU0081B013CBSMsg1List.TDIS_SEND_CNT , ETU0081B013CBSMsg1List.DNWACHO_MSKM_STAT , ETU0081B013CBSMsg1List.TDIS_INFO_CHK_FLG , ETU0081B013CBSMsg1List.AD_CHK_RSLT_CD , ETU0081B013CBSMsg1List.TRGT_YMD // ANK 3507-00-00 ADD START , ETU0081B013CBSMsg1List.TDIS_FST_RENKEI_DTM // ANK 3507-00-00 ADD END }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery, msgKeyList1, "eo.ejb.cbs.cbsmsg.ETU0081B013CBSMsg1List", 0); // 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了 if (0 == outMsg1.length) { inMsg.set(ETU0081B013CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO); return; } // 検索件数が最大検索件数を超えた場合、エラーフラグに"2"を設定して処理終了 if (Integer.parseInt(inMsg.getString(ETU0081B013CBSMsg.MAX_SEARCH_NUM)) < (outMsg1.length)) { inMsg.set(ETU0081B013CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_OVERMAX); return; } //総検索件数を再設定 inMsg.set(ETU0081B013CBSMsg.TOTAL_SEARCH_NUM, Integer.toString(outMsg1.length)); // inMsg(CBSMsg)に明細をセット inMsg.set("ETU0081B013CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(ETU0081B013CBSMsg.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(ETU0081B013CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }