/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbETU0061B012TPDA * ソースファイル名：JSYejbETU0061B012TPDA.java * 作成者 ：EK909148 * 日付 ：2012年05月18日 *＜機能概要＞ * 番ポ工事希望日予約情報一覧照会テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン 修正日 修正者 修正内容 * ｖ1.00.00 * ｖ3.00 2012/05/18 FJ)南岡 参照テーブル名変更対応 * ********************************************************************************/ 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.ETU0061B012CBSMsg; import eo.ejb.cbs.cbsmsg.ETU0061B012CBSMsg1List; import eo.ejb.cbm.entity.TU0061ETMsg; /** * * テンプレートDBアクセス部品　ETU0061B012_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbETU0061B012TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbETU0061B012TPDA() { } /** * ETU0061B012_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(TU0061ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" TU0061.BMP_KOJI_YMD, ") .append(" TU0061.BUSIDAY_FLG, ") .append(" TU0061.N_0_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_1_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_2_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_3_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_4_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_5_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_6_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_7_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_8_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_9_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_10_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_11_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_12_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_13_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_14_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_15_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_16_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_17_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_18_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_19_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_20_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_21_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_22_JIDAI_RSV_PSB_CNT, ") .append(" TU0061.N_23_JIDAI_RSV_PSB_CNT, ") .append(" NVL(TU0141.N_0_JIDAI_KOJI_KIBO_CNT, 0) AS N_0_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_1_JIDAI_KOJI_KIBO_CNT, 0) AS N_1_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_2_JIDAI_KOJI_KIBO_CNT, 0) AS N_2_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_3_JIDAI_KOJI_KIBO_CNT, 0) AS N_3_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_4_JIDAI_KOJI_KIBO_CNT, 0) AS N_4_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_5_JIDAI_KOJI_KIBO_CNT, 0) AS N_5_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_6_JIDAI_KOJI_KIBO_CNT, 0) AS N_6_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_7_JIDAI_KOJI_KIBO_CNT, 0) AS N_7_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_8_JIDAI_KOJI_KIBO_CNT, 0) AS N_8_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_9_JIDAI_KOJI_KIBO_CNT, 0) AS N_9_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_10_JIDAI_KOJI_KIBO_CNT, 0) AS N_10_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_11_JIDAI_KOJI_KIBO_CNT, 0) AS N_11_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_12_JIDAI_KOJI_KIBO_CNT, 0) AS N_12_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_13_JIDAI_KOJI_KIBO_CNT, 0) AS N_13_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_14_JIDAI_KOJI_KIBO_CNT, 0) AS N_14_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_15_JIDAI_KOJI_KIBO_CNT, 0) AS N_15_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_16_JIDAI_KOJI_KIBO_CNT, 0) AS N_16_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_17_JIDAI_KOJI_KIBO_CNT, 0) AS N_17_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_18_JIDAI_KOJI_KIBO_CNT, 0) AS N_18_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_19_JIDAI_KOJI_KIBO_CNT, 0) AS N_19_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_20_JIDAI_KOJI_KIBO_CNT, 0) AS N_20_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_21_JIDAI_KOJI_KIBO_CNT, 0) AS N_21_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_22_JIDAI_KOJI_KIBO_CNT, 0) AS N_22_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_23_JIDAI_KOJI_KIBO_CNT, 0) AS N_23_JIDAI_KOJI_KIBO_CNT, ") .append(" NVL(TU0141.N_0_JIDAI_KOJI_FIX_CNT, 0) AS N_0_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_1_JIDAI_KOJI_FIX_CNT, 0) AS N_1_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_2_JIDAI_KOJI_FIX_CNT, 0) AS N_2_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_3_JIDAI_KOJI_FIX_CNT, 0) AS N_3_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_4_JIDAI_KOJI_FIX_CNT, 0) AS N_4_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_5_JIDAI_KOJI_FIX_CNT, 0) AS N_5_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_6_JIDAI_KOJI_FIX_CNT, 0) AS N_6_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_7_JIDAI_KOJI_FIX_CNT, 0) AS N_7_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_8_JIDAI_KOJI_FIX_CNT, 0) AS N_8_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_9_JIDAI_KOJI_FIX_CNT, 0) AS N_9_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_10_JIDAI_KOJI_FIX_CNT, 0) AS N_10_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_11_JIDAI_KOJI_FIX_CNT, 0) AS N_11_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_12_JIDAI_KOJI_FIX_CNT, 0) AS N_12_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_13_JIDAI_KOJI_FIX_CNT, 0) AS N_13_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_14_JIDAI_KOJI_FIX_CNT, 0) AS N_14_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_15_JIDAI_KOJI_FIX_CNT, 0) AS N_15_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_16_JIDAI_KOJI_FIX_CNT, 0) AS N_16_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_17_JIDAI_KOJI_FIX_CNT, 0) AS N_17_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_18_JIDAI_KOJI_FIX_CNT, 0) AS N_18_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_19_JIDAI_KOJI_FIX_CNT, 0) AS N_19_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_20_JIDAI_KOJI_FIX_CNT, 0) AS N_20_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_21_JIDAI_KOJI_FIX_CNT, 0) AS N_21_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_22_JIDAI_KOJI_FIX_CNT, 0) AS N_22_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_23_JIDAI_KOJI_FIX_CNT, 0) AS N_23_JIDAI_KOJI_FIX_CNT, ") .append(" NVL(TU0141.N_0_JIDAI_KOJI_GOKEI_CNT, 0) AS N_0_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_1_JIDAI_KOJI_GOKEI_CNT, 0) AS N_1_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_2_JIDAI_KOJI_GOKEI_CNT, 0) AS N_2_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_3_JIDAI_KOJI_GOKEI_CNT, 0) AS N_3_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_4_JIDAI_KOJI_GOKEI_CNT, 0) AS N_4_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_5_JIDAI_KOJI_GOKEI_CNT, 0) AS N_5_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_6_JIDAI_KOJI_GOKEI_CNT, 0) AS N_6_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_7_JIDAI_KOJI_GOKEI_CNT, 0) AS N_7_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_8_JIDAI_KOJI_GOKEI_CNT, 0) AS N_8_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_9_JIDAI_KOJI_GOKEI_CNT, 0) AS N_9_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_10_JIDAI_KOJI_GOKEI_CNT, 0) AS N_10_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_11_JIDAI_KOJI_GOKEI_CNT, 0) AS N_11_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_12_JIDAI_KOJI_GOKEI_CNT, 0) AS N_12_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_13_JIDAI_KOJI_GOKEI_CNT, 0) AS N_13_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_14_JIDAI_KOJI_GOKEI_CNT, 0) AS N_14_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_15_JIDAI_KOJI_GOKEI_CNT, 0) AS N_15_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_16_JIDAI_KOJI_GOKEI_CNT, 0) AS N_16_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_17_JIDAI_KOJI_GOKEI_CNT, 0) AS N_17_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_18_JIDAI_KOJI_GOKEI_CNT, 0) AS N_18_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_19_JIDAI_KOJI_GOKEI_CNT, 0) AS N_19_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_20_JIDAI_KOJI_GOKEI_CNT, 0) AS N_20_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_21_JIDAI_KOJI_GOKEI_CNT, 0) AS N_21_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_22_JIDAI_KOJI_GOKEI_CNT, 0) AS N_22_JIDAI_KOJI_GOKEI_CNT, ") .append(" NVL(TU0141.N_23_JIDAI_KOJI_GOKEI_CNT, 0) AS N_23_JIDAI_KOJI_GOKEI_CNT ") .append(" FROM ") .append(" (SELECT ") .append(" ROW_NUMBER() OVER(ORDER BY TU0061_ROW.BMP_KOJI_YMD) AS ROW_NUM, ") .append(" TU0061_ROW.BMP_KOJI_YMD ") .append(" FROM ") .append(" TU_M_BMPKJ_RSV_PSBSU TU0061_ROW ") .append(" WHERE ") .append(" TU0061_ROW.BMP_KOJI_YMD >= ? AND ") .append(" TU0061_ROW.MK_FLG= '0' ") .append(" ) BMP_RSV_ROW, ") .append(" TU_M_BMPKJ_RSV_PSBSU TU0061, ") .append(" TU_T_BMPKJ_RSV_SYCNT TU0141 "); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(ETU0061B012CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE ") .append(" BMP_RSV_ROW.ROW_NUM between 1 and ? AND ") .append(" BMP_RSV_ROW.BMP_KOJI_YMD = TU0061.BMP_KOJI_YMD AND ") .append(" BMP_RSV_ROW.BMP_KOJI_YMD = TU0141.BMP_KOJI_YMD(+) AND ") .append(" TU0141.MK_FLG (+)= '0' ") .append(" ORDER BY ") .append(" TU0061.BMP_KOJI_YMD "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 if ( "1".equals( inMsg.getString(ETU0061B012CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(ＫＥＹ＿開始日を指定) CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(ETU0061B012CBSMsg.KEY_STAYMD)); // パラメータの設定(ＫＥＹ＿可能期間日数を指定) CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(ETU0061B012CBSMsg.KEY_PSB_PRD_CNT)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // ETU0061B012CBSMsgの明細にセットする項目 String[] msgKeyList1 = { ETU0061B012CBSMsg1List.BMP_KOJI_YMD , ETU0061B012CBSMsg1List.BUSIDAY_FLG , ETU0061B012CBSMsg1List.N_0_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_1_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_2_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_3_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_4_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_5_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_6_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_7_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_8_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_9_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_10_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_11_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_12_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_13_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_14_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_15_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_16_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_17_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_18_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_19_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_20_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_21_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_22_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_23_JIDAI_RSV_PSB_CNT , ETU0061B012CBSMsg1List.N_0_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_1_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_2_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_3_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_4_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_5_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_6_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_7_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_8_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_9_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_10_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_11_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_12_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_13_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_14_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_15_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_16_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_17_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_18_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_19_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_20_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_21_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_22_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_23_JIDAI_KOJI_KIBO_CNT , ETU0061B012CBSMsg1List.N_0_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_1_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_2_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_3_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_4_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_5_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_6_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_7_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_8_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_9_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_10_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_11_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_12_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_13_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_14_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_15_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_16_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_17_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_18_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_19_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_20_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_21_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_22_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_23_JIDAI_KOJI_FIX_CNT , ETU0061B012CBSMsg1List.N_0_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_1_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_2_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_3_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_4_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_5_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_6_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_7_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_8_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_9_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_10_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_11_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_12_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_13_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_14_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_15_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_16_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_17_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_18_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_19_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_20_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_21_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_22_JIDAI_KOJI_GOKEI_CNT , ETU0061B012CBSMsg1List.N_23_JIDAI_KOJI_GOKEI_CNT }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.ETU0061B012CBSMsg1List",0); // inMsg(CBSMsg)に明細をセット inMsg.set("ETU0061B012CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(ETU0061B012CBSMsg.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(ETU0061B012CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }