/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名：eo顧客基幹システム * モジュール名：JSYejbETU0081B012TPDA * ソースファイル名：JSYejbETU0081B012TPDA.java * 作成者：EK909306 * 日付：2011年06月29日 *＜機能概要＞ * 電話帳申込依頼帳票情報取得テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン修正日修正者修正内容 * v3.00.00 2012/03/17 FJ)楠神新規作成 * v3.00.00 2012/03/17 FJ)楠神 ANK-0024-00-00 * v4.00.00 2012/05/31 FJ)宮本 ANK-0398-00-00 * v4.00.01 2012/06/29 FJ)宮本 IT1-2012-0000872 * v4.00.02 2012/08/22 FJ)宮本 TAI-2012-0000093 * v4.00.03 2012/11/28 FJ)楠神 ST4-2012-0000113 * ********************************************************************************/ 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.ejb.cbs.cbsmsg.ETU0081B012CBSMsg; import eo.ejb.cbs.cbsmsg.ETU0081B012CBSMsg1List; import eo.ejb.cbm.entity.TU0081ETMsg; /** * * テンプレートDBアクセス部品　ETU0081B012_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
* @author FJ */ public class JSYejbETU0081B012TPDA extends CAANSQLFacility implements TemplateDBAccessHandler { /** * コンストラクタ */ public JSYejbETU0081B012TPDA() { } /** * ETU0081B012_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @param inContext * @return void */ public void invoke(CAANMsg inMsg, AgentDispatchContext inContext) { // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt = null; // リザルトセット ResultSet rsltQuery = null; /******************** * SQL文の作成 ********************/ try { //コネクション取得 con1 = JSYejbConnection.getConnection(TU0081ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" MAIN.* ") .append(" FROM ") .append(" ( ") .append(" SELECT ") .append(" DNW.DNWACHO_MSKM_NO, ") .append(" DNW.GENE_ADD_DTM, ") .append(" DNW.ADD_SEIRI_NO, ") .append(" DNW.ADD_SEQ, ") .append(" DNW.DNWACHOMSK_IDO_NAIYO_CD, ") .append(" DNW.DNWACHOMSK_IDO_YMD, ") .append(" DNW.TDIS_SEND_CNT, ") .append(" DNW.UPD_DTM, ") .append(" DNWN_NEW.NTT_TELNO AS NTT_TELNO_NEW, ") .append(" DNWN_NEW.KEI_TELNO AS KEI_TELNO_NEW, ") .append(" DNWN_NEW.COMP_KOBET_FLG AS COMP_KOBET_FLG_NEW, ") .append(" DNWN_NEW.JIJUBETS_FLG AS JIJUBETS_FLG_NEW, ") .append(" DNWN_NEW.DBLE_KEISAI_FLG AS DBLE_KEISAI_FLG_NEW, ") .append(" DNWN_NEW.KEISAI_GUIDE_USE_CD AS KEISAI_GUIDE_USE_CD_NEW, ") .append(" DNWN_NEW.TEKKYO_DSP_CD AS TEKKYO_DSP_CD_NEW, ") .append(" DNWN_NEW.KEISAI_AD_DIV AS KEISAI_AD_DIV_NEW, ") .append(" DNWN_NEW.KEISAI_INFO_GIJ_DSP_YH AS KEISAI_INFO_GIJ_DSP_YH_NEW, ") .append(" DNWN_NEW.KEISAI_AD_CD AS KEISAI_AD_CD_NEW, ") .append(" DNWN_NEW.KEISAI_PCD AS KEISAI_PCD_NEW, ") .append(" DNWN_NEW.KEISAI_STATE_NM AS KEISAI_STATE_NM_NEW, ") .append(" DNWN_NEW.KEISAI_CITY_NM AS KEISAI_CITY_NM_NEW, ") .append(" DNWN_NEW.KEISAI_OAZTSU_NM AS KEISAI_OAZTSU_NM_NEW, ") .append(" DNWN_NEW.KEISAI_AZCHO_NM AS KEISAI_AZCHO_NM_NEW, ") .append(" DNWN_NEW.KEISAI_AD_BNCHIGO AS KEISAI_AD_BNCHIGO_NEW, ") .append(" DNWN_NEW.KEISAI_ADRTTM AS KEISAI_ADRTTM_NEW, ") .append(" DNWN_NEW.KEISAI_ADRRM AS KEISAI_ADRRM_NEW, ") .append(" DNWN_NEW.SETPLACE_AD_CD AS SETPLACE_AD_CD_NEW, ") .append(" DNWN_NEW.SETPLACE_PCD AS SETPLACE_PCD_NEW, ") .append(" DNWN_NEW.SETPLACE_STATE_NM AS SETPLACE_STATE_NM_NEW, ") .append(" DNWN_NEW.SETPLACE_CITY_NM AS SETPLACE_CITY_NM_NEW, ") .append(" DNWN_NEW.SETPLACE_OAZTSU_NM AS SETPLACE_OAZTSU_NM_NEW, ") .append(" DNWN_NEW.SETPLACE_AZCHO_NM AS SETPLACE_AZCHO_NM_NEW, ") .append(" DNWN_NEW.SETPLACE_BNCHIGO AS SETPLACE_BNCHIGO_NEW, ") .append(" DNWN_NEW.SETPLACE_ADRTTM AS SETPLACE_ADRTTM_NEW, ") .append(" DNWN_NEW.SETPLACE_ADRRM AS SETPLACE_ADRRM_NEW, ") .append(" DNWN_NEW.KEISAI_NM AS KEISAI_NM_NEW, ") .append(" DNWN_NEW.KEISAI_KANA_NM AS KEISAI_KANA_NM_NEW, ") .append(" DNWN_NEW.KEISAI_NM_APPDX AS KEISAI_NM_APPDX_NEW, ") .append(" DNWN_NEW.DNWACHO_DSP_KISN_SKBT_CD AS DNWACHO_DSP_KISN_SKBT_CD_NEW, ") .append(" DNWN_NEW.FREE_TEIGI_KMK AS FREE_TEIGI_KMK_NEW, ") .append(" DNWN_OLD.NTT_TELNO AS NTT_TELNO_OLD, ") .append(" DNWN_OLD.KEI_TELNO AS KEI_TELNO_OLD, ") .append(" DNWN_OLD.COMP_KOBET_FLG AS COMP_KOBET_FLG_OLD, ") .append(" DNWN_OLD.JIJUBETS_FLG AS JIJUBETS_FLG_OLD, ") .append(" DNWN_OLD.DBLE_KEISAI_FLG AS DBLE_KEISAI_FLG_OLD, ") .append(" DNWN_OLD.KEISAI_GUIDE_USE_CD AS KEISAI_GUIDE_USE_CD_OLD, ") .append(" DNWN_OLD.TEKKYO_DSP_CD AS TEKKYO_DSP_CD_OLD, ") .append(" DNWN_OLD.KEISAI_AD_DIV AS KEISAI_AD_DIV_OLD, ") .append(" DNWN_OLD.KEISAI_INFO_GIJ_DSP_YH AS KEISAI_INFO_GIJ_DSP_YH_OLD, ") .append(" DNWN_OLD.KEISAI_AD_CD AS KEISAI_AD_CD_OLD, ") .append(" DNWN_OLD.KEISAI_PCD AS KEISAI_PCD_OLD, ") .append(" DNWN_OLD.KEISAI_STATE_NM AS KEISAI_STATE_NM_OLD, ") .append(" DNWN_OLD.KEISAI_CITY_NM AS KEISAI_CITY_NM_OLD, ") .append(" DNWN_OLD.KEISAI_OAZTSU_NM AS KEISAI_OAZTSU_NM_OLD, ") .append(" DNWN_OLD.KEISAI_AZCHO_NM AS KEISAI_AZCHO_NM_OLD, ") .append(" DNWN_OLD.KEISAI_AD_BNCHIGO AS KEISAI_AD_BNCHIGO_OLD, ") .append(" DNWN_OLD.KEISAI_ADRTTM AS KEISAI_ADRTTM_OLD, ") .append(" DNWN_OLD.KEISAI_ADRRM AS KEISAI_ADRRM_OLD, ") .append(" DNWN_OLD.SETPLACE_AD_CD AS SETPLACE_AD_CD_OLD, ") .append(" DNWN_OLD.SETPLACE_PCD AS SETPLACE_PCD_OLD, ") .append(" DNWN_OLD.SETPLACE_STATE_NM AS SETPLACE_STATE_NM_OLD, ") .append(" DNWN_OLD.SETPLACE_CITY_NM AS SETPLACE_CITY_NM_OLD, ") .append(" DNWN_OLD.SETPLACE_OAZTSU_NM AS SETPLACE_OAZTSU_NM_OLD, ") .append(" DNWN_OLD.SETPLACE_AZCHO_NM AS SETPLACE_AZCHO_NM_OLD, ") .append(" DNWN_OLD.SETPLACE_BNCHIGO AS SETPLACE_BNCHIGO_OLD, ") .append(" DNWN_OLD.SETPLACE_ADRTTM AS SETPLACE_ADRTTM_OLD, ") .append(" DNWN_OLD.SETPLACE_ADRRM AS SETPLACE_ADRRM_OLD, ") .append(" DNWN_OLD.KEISAI_NM AS KEISAI_NM_OLD, ") .append(" DNWN_OLD.KEISAI_KANA_NM AS KEISAI_KANA_NM_OLD, ") .append(" DNWN_OLD.KEISAI_NM_APPDX AS KEISAI_NM_APPDX_OLD, ") .append(" DNWN_OLD.DNWACHO_DSP_KISN_SKBT_CD AS DNWACHO_DSP_KISN_SKBT_CD_OLD, ") .append(" DNWN_OLD.FREE_TEIGI_KMK AS FREE_TEIGI_KMK_OLD ") .append(" FROM ") .append(" ( ") .append(" SELECT ") .append(" DNW_IN.DNWACHO_MSKM_NO, ") .append(" DNW_IN.GENE_ADD_DTM, ") .append(" DNW_IN.HOJIN_KOJIN_CD, ") .append(" DNW_IN.SVC_KEI_UCWK_NO, ") .append(" DNW_IN.HJIN_EO_YKAE_SVKEI_NO, ") .append(" DNW_IN.DNWACHOMSK_IDO_NAIYO_CD, ") .append(" DNW_IN.KEISAI_SVC_STAYMD, ") .append(" DNW_IN.BMP_UM, ") .append(" DNW_IN.UPD_DTM, ") .append(" DNW_IN.ADD_SEIRI_NO, ") .append(" DNW_IN.ADD_SEQ, ") .append(" DNW_IN.DNWACHOMSK_IDO_YMD, ") .append(" DNW_IN.TDIS_SEND_CNT, ") .append(" DNW_IN.REQ_UK_YMD ") .append(" FROM ") .append(" TU_T_DNWACHOMSK DNW_IN ") .append(" WHERE ") .append(" DNW_IN.DNWACHO_MSKM_STAT = '021' ") .append(" AND DNW_IN.TDIS_INFO_CHK_FLG = '1' ") .append(" AND DNW_IN.AD_CHK_RSLT_CD = '0' ") .append(" AND (DNW_IN.DNWACHO_MSKM_NO, DNW_IN.GENE_ADD_DTM) = ( ") .append(" SELECT ") .append(" DNW_GENE.DNWACHO_MSKM_NO, MAX(DNW_GENE.GENE_ADD_DTM) ") .append(" FROM ") .append(" TU_T_DNWACHOMSK DNW_GENE ") .append(" WHERE ") .append(" DNW_GENE.DNWACHO_MSKM_NO = DNW_IN.DNWACHO_MSKM_NO ") .append(" AND DNW_GENE.MK_FLG = '0' ") .append(" GROUP BY ") .append(" DNW_GENE.DNWACHO_MSKM_NO ") .append(" ) ") .append(" ) DNW ") .append(" LEFT OUTER JOIN ") .append(" KK_T_SVC_KEI_UCWK SKU ") .append(" ON ") .append(" DNW.SVC_KEI_UCWK_NO = SKU.SVC_KEI_UCWK_NO ") .append(" AND SKU.RSV_APLY_YMD || SKU.GENE_ADD_DTM IN ( ") .append(" SELECT ") .append(" MAX(UCWK_GENE.RSV_APLY_YMD || UCWK_GENE.GENE_ADD_DTM) ") .append(" FROM ") .append(" KK_T_SVC_KEI_UCWK UCWK_GENE ") .append(" WHERE ") .append(" UCWK_GENE.SVC_KEI_UCWK_NO = SKU.SVC_KEI_UCWK_NO ") .append(" AND UCWK_GENE.RSV_APLY_YMD <= ? ") .append(" AND UCWK_GENE.RSV_APLY_CD = '2' ") .append(" AND UCWK_GENE.MK_FLG = '0' ") .append(" GROUP BY ") .append(" SKU.SVC_KEI_UCWK_NO ") .append(" ) ") .append(" INNER JOIN ") .append(" TU_T_DNWACHOMSK_NYO DNWN_NEW ") .append(" ON ") .append(" DNW.DNWACHO_MSKM_NO = DNWN_NEW.DNWACHO_MSKM_NO ") .append(" AND DNW.GENE_ADD_DTM = DNWN_NEW.GENE_ADD_DTM ") .append(" AND DNWN_NEW.DNWACHOMSK_NEW_OLD_FLG = '0' ") .append(" AND DNWN_NEW.MK_FLG = '0' ") .append(" INNER JOIN ") .append(" TU_T_DNWACHOMSK_NYO DNWN_OLD ") .append(" ON ") .append(" DNW.DNWACHO_MSKM_NO = DNWN_OLD.DNWACHO_MSKM_NO ") .append(" AND DNW.GENE_ADD_DTM = DNWN_OLD.GENE_ADD_DTM ") .append(" AND DNWN_OLD.DNWACHOMSK_NEW_OLD_FLG = '1' ") .append(" AND DNWN_OLD.MK_FLG = '0' ") .append(" LEFT OUTER JOIN ") .append(" TU_T_BMP_KOJI BMP ") .append(" ON ") .append(" NVL(DNW.SVC_KEI_UCWK_NO, 'DUMMY') = NVL(BMP.SVC_KEI_UCWK_NO, 'DUMMY') ") .append(" AND NVL(DNW.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') = NVL(BMP.HJIN_EO_YKAE_SVKEI_NO, 'DUMMY') ") .append(" AND DECODE(DNW.DNWACHOMSK_IDO_NAIYO_CD, 3, DNWN_OLD.NTT_TELNO, DNWN_NEW.NTT_TELNO) = BMP.NTT_KEI_TEL_KAISEN_NO ") .append(" AND DNW.BMP_UM = '1' ") .append(" WHERE ") .append(" ( ") .append(" ( ") .append(" DNW.BMP_UM = '1' ") .append(" AND BMP.GENE_ADD_DTM = ( ") .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 = BMP.BMP_KOJI_NO ") .append(" AND BMP_GENE.MK_FLG = '0' ") .append(" ) ") .append(" AND BMP.BMP_KOJI_STAT IN('031', '032', '040', '050') ") .append(" AND ( ") .append(" ? >= SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ") .append(" OR ? >= ( ") .append(" SELECT ") .append(" MAX(BUSDAY.TRGT_YMD) ") .append(" FROM ") .append(" ZM_M_BUSIDAY_KANRI BUSDAY ") .append(" WHERE ") .append(" BUSDAY.TRGT_YMD < SUBSTR(BMP.BMP_KOJI_FIX_YMDH,1,8) ") .append(" AND BUSDAY.BUSIDAY_FLG = '1' ") .append(" AND BUSDAY.MK_FLG = '0' ") .append(" ) ") .append(" ) ") .append(" ) ") .append(" OR ( ") .append(" DNW.BMP_UM = '0' ") .append(" AND ? >= DNW.KEISAI_SVC_STAYMD ") .append(" ) ") .append(" ) ") .append(" ORDER BY ") .append(" DNW.REQ_UK_YMD ASC, ") .append(" DECODE(DNW.HOJIN_KOJIN_CD, '1', SKU.SVC_KEI_NO, DNW.HJIN_EO_YKAE_SVKEI_NO) ASC, ") .append(" DECODE(DNW.DNWACHOMSK_IDO_NAIYO_CD, '3', DNWN_OLD.NTT_TELNO, DNWN_NEW.NTT_TELNO) ASC, ") .append(" CASE WHEN (DNW.DNWACHOMSK_IDO_NAIYO_CD IN ('1', '2') AND DNWN_NEW.DBLE_KEISAI_FLG = '0') ") .append(" OR (DNW.DNWACHOMSK_IDO_NAIYO_CD = '3' AND DNWN_OLD.DBLE_KEISAI_FLG = '1') THEN 0 ELSE 1 END ASC ") .append(" ) MAIN "); // SQL文_個別部1 if ("1".equals(inMsg.getObject(ETU0081B012CBSMsg.FUNC_CODE).toString())) { sql_Buff.append(" WHERE ") .append(" ROWNUM <= ( ") .append(" SELECT ") .append(" MSKM.SEND_UPPLNO ") .append(" FROM ") .append(" TU_M_MSKM_JIGSHO MSKM ") .append(" WHERE ") .append(" MSKM.MSKM_JIGSHO_NO = ? ") .append(" AND MSKM.MSKM_JIGSHO_SBT_CD = '3' ") .append(" AND MSKM.MK_FLG = '0' ") .append(" ) "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); //パラメータ設定用Index 初期化 int iIndex = 1; // PreparedStatementの指定されたパラメータカラムに指定された値を設定 if ("1".equals(inMsg.getString(ETU0081B012CBSMsg.FUNC_CODE))) { // パラメータの設定(ＫＥＹ＿基準日を指定) CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B012CBSMsg.KEY_STDARDYMD)); CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B012CBSMsg.KEY_STDARDYMD)); CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B012CBSMsg.KEY_STDARDYMD)); CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B012CBSMsg.KEY_STDARDYMD)); // パラメータの設定(ＫＥＹ＿申込事業所番号を指定) CAANJDBCUtil.setParam(pstmt, iIndex++, inMsg.getObject(ETU0081B012CBSMsg.KEY_MSKM_JIGSHO_NO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // ETU0081B012CBSMsgの明細にセットする項目 String[] msgKeyList1 = { ETU0081B012CBSMsg1List.DNWACHO_MSKM_NO , ETU0081B012CBSMsg1List.GENE_ADD_DTM , ETU0081B012CBSMsg1List.ADD_SEIRI_NO , ETU0081B012CBSMsg1List.ADD_SEQ , ETU0081B012CBSMsg1List.DNWACHOMSK_IDO_NAIYO_CD , ETU0081B012CBSMsg1List.DNWACHOMSK_IDO_YMD , ETU0081B012CBSMsg1List.TDIS_SEND_CNT , ETU0081B012CBSMsg1List.UPD_DTM , ETU0081B012CBSMsg1List.NTT_TELNO_NEW , ETU0081B012CBSMsg1List.KEI_TELNO_NEW , ETU0081B012CBSMsg1List.COMP_KOBET_FLG_NEW , ETU0081B012CBSMsg1List.JIJUBETS_FLG_NEW , ETU0081B012CBSMsg1List.DBLE_KEISAI_FLG_NEW , ETU0081B012CBSMsg1List.KEISAI_GUIDE_USE_CD_NEW , ETU0081B012CBSMsg1List.TEKKYO_DSP_CD_NEW , ETU0081B012CBSMsg1List.KEISAI_AD_DIV_NEW , ETU0081B012CBSMsg1List.KEISAI_INFO_GIJ_DSP_YH_NEW , ETU0081B012CBSMsg1List.KEISAI_AD_CD_NEW , ETU0081B012CBSMsg1List.KEISAI_PCD_NEW , ETU0081B012CBSMsg1List.KEISAI_STATE_NM_NEW , ETU0081B012CBSMsg1List.KEISAI_CITY_NM_NEW , ETU0081B012CBSMsg1List.KEISAI_OAZTSU_NM_NEW , ETU0081B012CBSMsg1List.KEISAI_AZCHO_NM_NEW , ETU0081B012CBSMsg1List.KEISAI_AD_BNCHIGO_NEW , ETU0081B012CBSMsg1List.KEISAI_ADRTTM_NEW , ETU0081B012CBSMsg1List.KEISAI_ADRRM_NEW , ETU0081B012CBSMsg1List.SETPLACE_AD_CD_NEW , ETU0081B012CBSMsg1List.SETPLACE_PCD_NEW , ETU0081B012CBSMsg1List.SETPLACE_STATE_NM_NEW , ETU0081B012CBSMsg1List.SETPLACE_CITY_NM_NEW , ETU0081B012CBSMsg1List.SETPLACE_OAZTSU_NM_NEW , ETU0081B012CBSMsg1List.SETPLACE_AZCHO_NM_NEW , ETU0081B012CBSMsg1List.SETPLACE_BNCHIGO_NEW , ETU0081B012CBSMsg1List.SETPLACE_ADRTTM_NEW , ETU0081B012CBSMsg1List.SETPLACE_ADRRM_NEW , ETU0081B012CBSMsg1List.KEISAI_NM_NEW , ETU0081B012CBSMsg1List.KEISAI_KANA_NM_NEW , ETU0081B012CBSMsg1List.KEISAI_NM_APPDX_NEW , ETU0081B012CBSMsg1List.DNWACHO_DSP_KISN_SKBT_CD_NEW , ETU0081B012CBSMsg1List.FREE_TEIGI_KMK_NEW , ETU0081B012CBSMsg1List.NTT_TELNO_OLD , ETU0081B012CBSMsg1List.KEI_TELNO_OLD , ETU0081B012CBSMsg1List.COMP_KOBET_FLG_OLD , ETU0081B012CBSMsg1List.JIJUBETS_FLG_OLD , ETU0081B012CBSMsg1List.DBLE_KEISAI_FLG_OLD , ETU0081B012CBSMsg1List.KEISAI_GUIDE_USE_CD_OLD , ETU0081B012CBSMsg1List.TEKKYO_DSP_CD_OLD , ETU0081B012CBSMsg1List.KEISAI_AD_DIV_OLD , ETU0081B012CBSMsg1List.KEISAI_INFO_GIJ_DSP_YH_OLD , ETU0081B012CBSMsg1List.KEISAI_AD_CD_OLD , ETU0081B012CBSMsg1List.KEISAI_PCD_OLD , ETU0081B012CBSMsg1List.KEISAI_STATE_NM_OLD , ETU0081B012CBSMsg1List.KEISAI_CITY_NM_OLD , ETU0081B012CBSMsg1List.KEISAI_OAZTSU_NM_OLD , ETU0081B012CBSMsg1List.KEISAI_AZCHO_NM_OLD , ETU0081B012CBSMsg1List.KEISAI_AD_BNCHIGO_OLD , ETU0081B012CBSMsg1List.KEISAI_ADRTTM_OLD , ETU0081B012CBSMsg1List.KEISAI_ADRRM_OLD , ETU0081B012CBSMsg1List.SETPLACE_AD_CD_OLD , ETU0081B012CBSMsg1List.SETPLACE_PCD_OLD , ETU0081B012CBSMsg1List.SETPLACE_STATE_NM_OLD , ETU0081B012CBSMsg1List.SETPLACE_CITY_NM_OLD , ETU0081B012CBSMsg1List.SETPLACE_OAZTSU_NM_OLD , ETU0081B012CBSMsg1List.SETPLACE_AZCHO_NM_OLD , ETU0081B012CBSMsg1List.SETPLACE_BNCHIGO_OLD , ETU0081B012CBSMsg1List.SETPLACE_ADRTTM_OLD , ETU0081B012CBSMsg1List.SETPLACE_ADRRM_OLD , ETU0081B012CBSMsg1List.KEISAI_NM_OLD , ETU0081B012CBSMsg1List.KEISAI_KANA_NM_OLD , ETU0081B012CBSMsg1List.KEISAI_NM_APPDX_OLD , ETU0081B012CBSMsg1List.DNWACHO_DSP_KISN_SKBT_CD_OLD , ETU0081B012CBSMsg1List.FREE_TEIGI_KMK_OLD }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery, msgKeyList1, "eo.ejb.cbs.cbsmsg.ETU0081B012CBSMsg1List", 0); /** * 検索エラーフラグの設定 */ // 一括検索の場合 // 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了 if (0 == outMsg1.length) { inMsg.set(ETU0081B012CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO); inMsg.set(ETU0081B012CBSMsg.TOTAL_SEARCH_NUM, "0"); return; } //総検索件数を再設定 inMsg.set(ETU0081B012CBSMsg.TOTAL_SEARCH_NUM, Integer.toString(outMsg1.length)); // inMsg(CBSMsg)に明細をセット inMsg.set("ETU0081B012CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(ETU0081B012CBSMsg.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(ETU0081B012CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }