/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbECK0011B514TPDA * ソースファイル名：JSYejbECK0011B514TPDA.java * 作成者 ： * 日付 ：2022年01月25 *＜機能概要＞ * お客様一覧照会（営業支援）（解約時契約状態）テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン 修正日 修正者 修正内容 * v57.00.00 2022/01/18 GDC） Melvin Gungog ANK-4173-00-00_【eo顧客】解約後の契約情報表示、再申込対応 * ********************************************************************************/ package eo.ejb.cbs.sqlf; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.fujitsu.futurity.model.base.CAANJDBCUtil; import com.fujitsu.futurity.model.base.CAANMsg; import com.fujitsu.futurity.model.base.CAANRuntimeException; import com.fujitsu.futurity.model.base.CAANSQLFacility; 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.AgentDispatchContext; import com.fujitsu.futurity.model.ejb.common.fw.TemplateDBAccessHandler; import eo.ejb.cbm.entity.CK0011ETMsg; import eo.ejb.cbs.cbsmsg.ECK0011B514CBSMsg; import eo.ejb.cbs.cbsmsg.ECK0011B514CBSMsg1List; import eo.ejb.common.JCKModelCommon; public class JSYejbECK0011B514TPDA extends CAANSQLFacility implements TemplateDBAccessHandler { public JSYejbECK0011B514TPDA() { } @Override public void invoke(CAANMsg inMsg,AgentDispatchContext inContext) { // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt = null; // リザルトセット ResultSet rsltQuery = null; /******************** * SQL文の作成 ********************/ try{ //コネクション取得 con1 = JSYejbConnection.getConnection(CK0011ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" DISTINCT") .append(" CK0011.SYSID, ") .append(" NVL(CK0011.CUST_NM, CK0011.CONT_CUST_NM) AS CUST_NM, ") .append(" NVL(CK0011.CUST_KANA, CK0011.CONT_CUST_KANA) AS CUST_KANA,") .append(" NVL(CK0011.CUST_BIRTHD, CK0011.CONT_CUST_BIRTHD) AS CUST_BIRTHD, ") .append(" CK0011.KEISHA_TELNO,") .append(" NVL(CK0011.KEISHA_PCD, CK0011.CONT_PCD) AS KEISHA_PCD, ") .append(" NVL(") .append(" CK0011.KEISHA_STATE_NM || CK0011.KEISHA_CITY_NM || CK0011.KEISHA_OAZTSU_NM || CK0011.KEISHA_AZCHO_NM || CK0011.KEISHA_BNCHIGO || CK0011.KEISHA_ADRTTM || CK0011.KEISHA_ADRRM,") .append(" CK0011.CONT_STATE_NM || CK0011.CONT_CITY_NM || CK0011.CONT_OAZTSU_NM || CK0011.CONT_AZCHO_NM || CK0011.CONT_BNCHIGO || CK0011.CONT_ADRTTM || CK0011.CONT_ADRRM") .append(" ) AS KEISHA_AD, ") // ANK-4173-00-00 MOD START // .append(" CASE ") // .append(" WHEN KK0081.SVC_CD in ('05', '51') ") // .append(" THEN KK0081.SVC_KEI_NO ") // .append(" ELSE NULL ") // .append(" END AS SVC_KEI_NO, ") // .append(" CASE ") // .append(" WHEN KK0081.SVC_CD in ('05', '51') ") // .append(" THEN KK0081.SVC_CD ") // .append(" ELSE NULL ") // .append(" END AS SVC_CD, ") .append(" NULL AS SVC_KEI_NO, ") .append(" NULL AS SVC_CD, ") // ANK-4173-00-00 MOD END .append(" KK0251.KAISEN_PLACE_PCD, ") .append(" KK0251.KAISEN_PLACE_STATE_NM || KK0251.KAISEN_PLACE_CITY_NM || KK0251.KAISEN_PLACE_OAZTSU_NM || KK0251.KAISEN_PLACE_AZCHO_NM || KK0251.KAISEN_PLACE_BNCHIGO || KK0251.KAISEN_PLACE_ADRTTM || KK0251.KAISEN_PLACE_ADRRM AS KAISEN_PLACE_AD, ") // ANK-4173-00-00 ADD START .append(" KK0251.SVC_KEI_KAISEN_UCWK_NO, ") .append(" KK0081.SVC_ENDYMD ") // ANK-4173-00-00 ADD END .append(" FROM CK_T_CUST CK0011 ") .append("INNER JOIN KK_T_SVC_KEI KK0081 ") .append(" ON KK0081.SYSID = CK0011.SYSID") // ANK-4173-00-00 MOD START // // ANK-4110-00-00 MOD START //// .append(" AND KK0081.PRC_GRP_CD <> '14'") // .append(" AND KK0081.PRC_GRP_CD IN ('02', '03', '04', '10', '11', '13', '17', '51') ") // // ANK-4110-00-00 MOD END .append(" AND KK0081.PRC_GRP_CD IN ('02', '03', '04', '10', '11', '13') ") // ANK-4173-00-00 MOD END // ANK-4173-00-00 MOD START // .append(" AND KK0081.SVC_KEI_STAT NOT IN ('910', '920')") .append(" AND KK0081.SVC_KEI_STAT = '910' ") // ANK-4173-00-00 MOD END // ANK-4110-00-00 ADD START .append(" AND (KK0081.SHOSA_DSL_FIN_CD IS NULL ") .append(" OR KK0081.SHOSA_DSL_FIN_CD = '1') ") // ANK-4110-00-00 ADD END .append(" AND (KK0081.SVC_KEI_NO, KK0081.RSV_APLY_YMD || KK0081.GENE_ADD_DTM) = ( ") .append(" SELECT KK0081_GENE.SVC_KEI_NO, MAX(KK0081_GENE.RSV_APLY_YMD || KK0081_GENE.GENE_ADD_DTM) ") .append(" FROM KK_T_SVC_KEI KK0081_GENE ") .append(" WHERE") .append(" KK0081_GENE.SVC_KEI_NO = KK0081.SVC_KEI_NO ") .append(" AND KK0081_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0081_GENE.RSV_APLY_CD = '2' ") .append(" AND KK0081_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0081_GENE.SVC_KEI_NO") .append(" ) ") // ANK-4173-00-00 MOD START // .append("LEFT OUTER JOIN KK_T_KAISEN_TG_SVKEI KK0241 ") .append("INNER JOIN KK_T_KAISEN_TG_SVKEI KK0241 ") // ANK-4173-00-00 MOD END .append(" ON KK0241.SVC_KEI_NO = KK0081.SVC_KEI_NO ") .append(" AND KK0241.KAISEN_UCWK_USE_STAYMD <= ? ") // ANK-4173-00-00 DEL START // .append(" AND KK0241.KAISEN_UCWK_USE_ENDYMD = '20991231'") // ANK-4173-00-00 DEL END // ANK-4173-00-00 ADD START .append(" AND KK0241.KAISEN_UCWK_USE_ENDYMD = ( ") .append(" SELECT MAX( KK0241_GENE.KAISEN_UCWK_USE_ENDYMD ) ") .append(" FROM KK_T_KAISEN_TG_SVKEI KK0241_GENE ") .append(" WHERE KK0241_GENE.SVC_KEI_NO = KK0241.SVC_KEI_NO ") .append(" AND KK0241_GENE.KAISEN_UCWK_USE_STAYMD <= ? ") .append(" AND KK0241_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0241_GENE.SVC_KEI_NO ") .append(" ) ") // ANK-4173-00-00 ADD END .append(" AND KK0241.MK_FLG = '0' ") // ANK-4173-00-00 MOD START // .append("LEFT OUTER JOIN KK_T_SVKEI_KAISEN_UW KK0251 ") .append("INNER JOIN KK_T_SVKEI_KAISEN_UW KK0251 ") // ANK-4173-00-00 MOD END .append(" ON KK0251.SVC_KEI_KAISEN_UCWK_NO = KK0241.SVC_KEI_KAISEN_UCWK_NO ") // ANK-4173-00-00 ADD START .append(" AND (KK0251.SVC_KEI_KAISEN_UCWK_NO, KK0251.GENE_ADD_DTM) = ( ") .append(" SELECT KK0251_GENE.SVC_KEI_KAISEN_UCWK_NO, MAX(KK0251_GENE.GENE_ADD_DTM) ") .append(" FROM KK_T_SVKEI_KAISEN_UW KK0251_GENE ") .append(" WHERE ") .append(" KK0251_GENE.SVC_KEI_KAISEN_UCWK_NO = KK0251.SVC_KEI_KAISEN_UCWK_NO ") .append(" AND KK0251_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0251_GENE.SVC_KEI_KAISEN_UCWK_NO ") .append(" ) ") // ANK-4173-00-00 ADD END .append("WHERE") .append(" (CK0011.SYSID, CK0011.RSV_APLY_YMD || CK0011.GENE_ADD_DTM) = ( ") .append(" SELECT CK0011_GENE.SYSID, MAX(RSV_APLY_YMD || GENE_ADD_DTM) ") .append(" FROM CK_T_CUST CK0011_GENE ") .append(" WHERE") .append(" CK0011_GENE.SYSID = CK0011.SYSID ") .append(" AND CK0011_GENE.RSV_APLY_YMD <= ? ") .append(" AND CK0011_GENE.RSV_APLY_CD = '2' ") .append(" AND CK0011_GENE.MK_FLG = '0' ") .append(" GROUP BY CK0011_GENE.SYSID") .append(" )") // ANK-4173-00-00 DEL START // .append(" AND (") // .append(" KK0251.SVC_KEI_KAISEN_UCWK_NO IS NULL") // .append(" OR (KK0251.SVC_KEI_KAISEN_UCWK_NO, KK0251.GENE_ADD_DTM) = ( ") // .append(" SELECT KK0251_GENE.SVC_KEI_KAISEN_UCWK_NO, MAX(KK0251_GENE.GENE_ADD_DTM) ") // .append(" FROM KK_T_SVKEI_KAISEN_UW KK0251_GENE ") // .append(" WHERE") // .append(" KK0251_GENE.SVC_KEI_KAISEN_UCWK_NO = KK0251.SVC_KEI_KAISEN_UCWK_NO ") // .append(" AND KK0251_GENE.MK_FLG = '0' ") // .append(" GROUP BY KK0251_GENE.SVC_KEI_KAISEN_UCWK_NO") // .append(" )") // .append(" )") // ANK-4173-00-00 DEL END // IT1-2022-0000001 ADD START .append(" AND NOT EXISTS (") .append(" SELECT 1 FROM KK_T_MSKM KK0011 WHERE ") .append(" KK0011.MSKM_NO IN ( SELECT KK0021.MSKM_NO FROM KK_T_MSKM_DTL KK0021 WHERE KK0021.MSKM_DTL_NO = KK0081.MSKM_DTL_NO )") .append(" AND KK0011.GENE_ADD_DTM = ") .append(" (SELECT MAX(KK0011_GENE.GENE_ADD_DTM) AS KK0011_MAX") .append(" FROM KK_T_MSKM KK0011_GENE ") .append(" WHERE KK0011_GENE.MSKM_NO = KK0011.MSKM_NO") .append(" AND KK0011_GENE .MK_FLG = '0')") .append(" AND KK0011.KARI_MSKM_FLG = '1' )") // IT1-2022-0000001 ADD END // ANK-4110-00-00 ADD START .append(" AND NOT EXISTS( ") .append(" SELECT 1 ") .append(" FROM KK_T_SVC_KEI KK0081_OTHER ") .append(" WHERE KK0081_OTHER.SYSID = KK0081.SYSID ") .append(" AND ( KK0081_OTHER.SVC_KEI_STAT NOT IN ('910', '920') OR KK0081_OTHER.SVC_ENDYMD > KK0081.SVC_ENDYMD ) ") .append(" AND KK0081_OTHER.PRC_GRP_CD <> '14' ") .append(" AND (KK0081_OTHER.SVC_KEI_NO, KK0081_OTHER.RSV_APLY_YMD || KK0081_OTHER.GENE_ADD_DTM) = ( ") .append(" SELECT KK0081_OTHER_GENE.SVC_KEI_NO, MAX(KK0081_OTHER_GENE.RSV_APLY_YMD || KK0081_OTHER_GENE.GENE_ADD_DTM) ") .append(" FROM KK_T_SVC_KEI KK0081_OTHER_GENE ") .append(" WHERE ") .append(" KK0081_OTHER_GENE.SVC_KEI_NO = KK0081_OTHER.SVC_KEI_NO ") .append(" AND KK0081_OTHER_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0081_OTHER_GENE.RSV_APLY_CD = '2' ") .append(" AND KK0081_OTHER_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0081_OTHER_GENE.SVC_KEI_NO ") .append(" ) ") .append(" ) ") // ANK-4110-00-00 ADD END .append(""); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(ECK0011B514CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" AND CK0011.EOID = ? ") .append(""); } if ( "2".equals( inMsg.getObject(ECK0011B514CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" AND ( ") // ▽▽▽ ANK-3795-05-00 Modify START // .append(" CK0011.CUST_KANA LIKE ? ") // .append(" OR CK0011.CONT_CUST_KANA LIKE ? ") .append(" CK0011.CUST_KANA = ? ") .append(" OR CK0011.CONT_CUST_KANA = ? ") // ▲▲▲ ANK-3795-05-00 Modify END .append(" )") .append(" AND ( ") .append(" CK0011.CUST_BIRTHD = ? ") .append(" OR CK0011.CONT_CUST_BIRTHD = ?") .append(" ) ") .append(" AND ( ") .append(" CK0011.KEISHA_TELNO = ? ") .append(" OR EXISTS ( ") .append(" SELECT 1 ") .append(" FROM CK_T_RRKS CK0201_03 ") .append(" WHERE") .append(" CK0201_03.SYSID = CK0011.SYSID ") .append(" AND CK0201_03.TELNO = ?") .append(" AND (CK0201_03.RRKS_NO, CK0201_03.RSV_APLY_YMD || CK0201_03.GENE_ADD_DTM) = ( ") .append(" SELECT CK0201_04_GENE.RRKS_NO, MAX(CK0201_04_GENE.RSV_APLY_YMD || CK0201_04_GENE.GENE_ADD_DTM) ") .append(" FROM CK_T_RRKS CK0201_04_GENE ") .append(" WHERE") .append(" CK0201_04_GENE.RRKS_NO = CK0201_03.RRKS_NO ") .append(" AND CK0201_04_GENE.RSV_APLY_YMD <= ? ") .append(" AND CK0201_04_GENE.RSV_APLY_CD = '2' ") .append(" AND CK0201_04_GENE.MK_FLG = '0' ") .append(" GROUP BY CK0201_04_GENE.RRKS_NO") .append(" ) ") .append(" ) ") .append(" OR EXISTS ( ") // ANK-4173-00-00 DEL START // .append(" SELECT 1 ") // .append(" FROM KK_T_SVC_KEI_UCWK KK0161_06 ") // .append(" WHERE") // .append(" KK0161_06.SVC_KEI_NO = KK0081.SVC_KEI_NO ") // .append(" AND KK0161_06.SVC_KEI_UCWK_STAT NOT IN ('910', '920') ") // .append(" AND (KK0161_06.SVC_KEI_UCWK_NO, KK0161_06.RSV_APLY_YMD || KK0161_06.GENE_ADD_DTM) = ( ") // .append(" SELECT KK0161_06_GENE.SVC_KEI_UCWK_NO, MAX(KK0161_06_GENE.RSV_APLY_YMD || KK0161_06_GENE.GENE_ADD_DTM) ") // .append(" FROM KK_T_SVC_KEI_UCWK KK0161_06_GENE ") // .append(" WHERE") // .append(" KK0161_06_GENE.SVC_KEI_UCWK_NO = KK0161_06.SVC_KEI_UCWK_NO ") // .append(" AND KK0161_06_GENE.RSV_APLY_YMD <= ? ") // .append(" AND KK0161_06_GENE.RSV_APLY_CD = '2' ") // .append(" AND KK0161_06_GENE.MK_FLG = '0' ") // .append(" GROUP BY KK0161_06_GENE.SVC_KEI_UCWK_NO") // .append(" ) ") // .append(" AND EXISTS ( ") // .append(" SELECT 1 ") // .append(" FROM KK_T_SVKEIUW_EOH_TEL KK0191_02 ") // .append(" WHERE") // .append(" KK0191_02.SVC_KEI_UCWK_NO = KK0161_06.SVC_KEI_UCWK_NO ") // .append(" AND KK0191_02.GENE_ADD_DTM = KK0161_06.GENE_ADD_DTM ") // .append(" AND KK0191_02.TELNO = ? ") // .append(" AND KK0191_02.MK_FLG = '0'") // .append(" )") // ANK-4173-00-00 DEL END // ANK-4173-00-00 ADD START .append(" SELECT 1 ") .append(" FROM KK_T_KAISEN_TG_SVKEI KK0241_TEL ") .append(" INNER JOIN KK_T_SVC_KEI KK0081_TEL ") .append(" ON KK0081_TEL.SVC_KEI_NO = KK0241_TEL.SVC_KEI_NO ") .append(" INNER JOIN KK_T_SVC_KEI_UCWK KK0161_TEL ") .append(" ON KK0161_TEL.SVC_KEI_NO = KK0081_TEL.SVC_KEI_NO ") .append(" AND KK0161_TEL.MSKM_DTL_NO = KK0081_TEL.MSKM_DTL_NO ") .append(" INNER JOIN KK_T_SVKEIUW_EOH_TEL KK0191_TEL ") .append(" ON KK0191_TEL.SVC_KEI_UCWK_NO = KK0161_TEL.SVC_KEI_UCWK_NO ") .append(" AND KK0191_TEL.GENE_ADD_DTM = KK0161_TEL.GENE_ADD_DTM ") .append(" AND KK0191_TEL.MK_FLG = '0' ") .append(" WHERE ") .append(" KK0241_TEL.SVC_KEI_KAISEN_UCWK_NO = KK0241.SVC_KEI_KAISEN_UCWK_NO ") .append(" AND KK0241_TEL.KAISEN_UCWK_USE_STAYMD <= ? ") .append(" AND KK0241_TEL.KAISEN_UCWK_USE_ENDYMD = ( ") .append(" SELECT MAX( KK0241_TEL_GENE.KAISEN_UCWK_USE_ENDYMD ) ") .append(" FROM KK_T_KAISEN_TG_SVKEI KK0241_TEL_GENE ") .append(" WHERE KK0241_TEL_GENE.SVC_KEI_NO = KK0241_TEL.SVC_KEI_NO ") .append(" AND KK0241_TEL_GENE.KAISEN_UCWK_USE_STAYMD <= ? ") .append(" AND KK0241_TEL_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0241_TEL_GENE.SVC_KEI_NO ") .append(" ) ") .append(" AND (KK0081_TEL.SVC_KEI_NO, KK0081_TEL.RSV_APLY_YMD || KK0081_TEL.GENE_ADD_DTM) = ( ") .append(" SELECT KK0081_TEL_GENE.SVC_KEI_NO, MAX(KK0081_TEL_GENE.RSV_APLY_YMD || KK0081_TEL_GENE.GENE_ADD_DTM) ") .append(" FROM KK_T_SVC_KEI KK0081_TEL_GENE ") .append(" WHERE ") .append(" KK0081_TEL_GENE.SVC_KEI_NO = KK0081_TEL.SVC_KEI_NO ") .append(" AND KK0081_TEL_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0081_TEL_GENE.RSV_APLY_CD = '2' ") .append(" AND KK0081_TEL_GENE.MK_FLG = '0' ") .append(" AND KK0081_TEL_GENE.SVC_KEI_STAT = '910' ") .append(" AND KK0081_TEL_GENE.IDO_DIV IN ('00005', '00006', '00064') ") .append(" GROUP BY KK0081_TEL_GENE.SVC_KEI_NO ") .append(" ) ") .append(" AND (KK0161_TEL.SVC_KEI_UCWK_NO, KK0161_TEL.RSV_APLY_YMD || KK0161_TEL.GENE_ADD_DTM) = ( ") .append(" SELECT KK0161_TEL_GENE.SVC_KEI_UCWK_NO, MAX(KK0161_TEL_GENE.RSV_APLY_YMD || KK0161_TEL_GENE.GENE_ADD_DTM) ") .append(" FROM KK_T_SVC_KEI_UCWK KK0161_TEL_GENE ") .append(" WHERE ") .append(" KK0161_TEL_GENE.SVC_KEI_UCWK_NO = KK0161_TEL.SVC_KEI_UCWK_NO ") .append(" AND KK0161_TEL_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0161_TEL_GENE.RSV_APLY_CD = '2' ") .append(" AND KK0161_TEL_GENE.MK_FLG = '0' ") .append(" AND KK0161_TEL_GENE.SVC_KEI_UCWK_STAT = '910' ") .append(" AND KK0161_TEL_GENE.IDO_DIV IN ('00005', '00006', '00064') ") .append(" GROUP BY KK0161_TEL_GENE.SVC_KEI_UCWK_NO ") .append(" ) ") // ANK-4173-00-00 ADD END .append(" ) ") .append(" OR KK0251.KAISEN_PLACE_TELNO = ?") .append(" )") // ANK-4173-00-00 MOD START // .append(" AND ( ") // .append(" ( ") // .append(" KK0081.SVC_CD = '51' ") // .append(" AND ( ") // .append(" CK0011.KEISHA_PCD = ? ") // .append(" OR CK0011.CONT_PCD = ?") // .append(" )") // .append(" ) ") // .append(" OR ( ") // .append(" KK0081.SVC_CD <> '51' ") // .append(" AND KK0251.KAISEN_PLACE_PCD = ?") // .append(" )") // .append(" OR KK0081.SVC_CD = '05' ") // .append(" )") .append(" AND KK0251.KAISEN_PLACE_PCD = ?") // ANK-4173-00-00 MOD END // ANK-4173-00-00 MOD START // .append("ORDER BY CK0011.SYSID, SVC_KEI_NO, KK0251.SVC_KEI_KAISEN_UCWK_NO"); .append("ORDER BY CK0011.SYSID, KK0251.SVC_KEI_KAISEN_UCWK_NO"); // ANK-4173-00-00 MOD END } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); // 運用日の取得 String opeDate = JCKModelCommon.getOpeDate(inMsg); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 if ( "1".equals( inMsg.getString(ECK0011B514CBSMsg.FUNC_CODE) ) ) { CAANJDBCUtil.setParam(pstmt, 1, opeDate); CAANJDBCUtil.setParam(pstmt, 2, opeDate); CAANJDBCUtil.setParam(pstmt, 3, opeDate); CAANJDBCUtil.setParam(pstmt, 4, opeDate); CAANJDBCUtil.setParam(pstmt, 5, opeDate); CAANJDBCUtil.setParam(pstmt, 6, inMsg.getObject(ECK0011B514CBSMsg.KEY_EOID)); } // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 if ( "2".equals( inMsg.getString(ECK0011B514CBSMsg.FUNC_CODE) ) ) { CAANJDBCUtil.setParam(pstmt, 1, opeDate); CAANJDBCUtil.setParam(pstmt, 2, opeDate); CAANJDBCUtil.setParam(pstmt, 3, opeDate); CAANJDBCUtil.setParam(pstmt, 4, opeDate); CAANJDBCUtil.setParam(pstmt, 5, opeDate); CAANJDBCUtil.setParam(pstmt, 6, inMsg.getObject(ECK0011B514CBSMsg.KEY_CUST_KANA)); CAANJDBCUtil.setParam(pstmt, 7, inMsg.getObject(ECK0011B514CBSMsg.KEY_CUST_KANA)); CAANJDBCUtil.setParam(pstmt, 8, inMsg.getObject(ECK0011B514CBSMsg.KEY_CUST_BIRTHD)); CAANJDBCUtil.setParam(pstmt, 9, inMsg.getObject(ECK0011B514CBSMsg.KEY_CUST_BIRTHD)); CAANJDBCUtil.setParam(pstmt, 10, inMsg.getObject(ECK0011B514CBSMsg.KEY_TELNO)); CAANJDBCUtil.setParam(pstmt, 11, inMsg.getObject(ECK0011B514CBSMsg.KEY_TELNO)); CAANJDBCUtil.setParam(pstmt, 12, opeDate); CAANJDBCUtil.setParam(pstmt, 13, opeDate); CAANJDBCUtil.setParam(pstmt, 14, opeDate); CAANJDBCUtil.setParam(pstmt, 15, opeDate); CAANJDBCUtil.setParam(pstmt, 16, opeDate); CAANJDBCUtil.setParam(pstmt, 17, inMsg.getObject(ECK0011B514CBSMsg.KEY_TELNO)); CAANJDBCUtil.setParam(pstmt, 18, inMsg.getObject(ECK0011B514CBSMsg.KEY_PCD)); } //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // ResultSetの取得 rsltQuery = pstmt.executeQuery(); String[] msgKeyList1 = { ECK0011B514CBSMsg1List.SYSID , ECK0011B514CBSMsg1List.NM , ECK0011B514CBSMsg1List.NM_KANA , ECK0011B514CBSMsg1List.CUST_BIRTHD , ECK0011B514CBSMsg1List.KEISHA_TELNO , ECK0011B514CBSMsg1List.KEISHA_PCD , ECK0011B514CBSMsg1List.KEISHA_AD , ECK0011B514CBSMsg1List.SVC_KEI_NO , ECK0011B514CBSMsg1List.SVC_CD , ECK0011B514CBSMsg1List.KAISEN_PLACE_PCD , ECK0011B514CBSMsg1List.KAISEN_PLACE_AD // ANK-4173-00-00 ADD START , ECK0011B514CBSMsg1List.SVC_KEI_KAISEN_UCWK_NO , ECK0011B514CBSMsg1List.SVC_ENDYMD // ANK-4173-00-00 ADD START }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.ECK0011B514CBSMsg1List",0); // inMsg(CBSMsg)に明細をセット inMsg.set("ECK0011B514CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(ECK0011B514CBSMsg.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(ECK0011B514CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }