/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名：eo顧客基幹システム * モジュール名：JSYejbEKK0361A010TPDA * ソースファイル名：JSYejbEKK0361A010TPDA.java * 作成者：EK911014 * 日付：2012年02月27日 *＜機能概要＞ * オプションサービス契約一意照会テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン修正日修正者修正内容 * ｖ1.00.00 * v6.00.00 2013/10/08 FJ)沖田 ANK-1577-00-00 * v32.00.00 2017/03/28 FJ)三宅(隆) ANK-3149-00-00 * v39.00.00 2018/09/25 FJ)周藤【ANK-3484-00-00】端末補償サービス導入対応 * v73.00.00 2024/08/23 FJ)中川【ANK-4427-00-00】NTT卸対応 * v75.00.00 2025/02/19 FJ)寺田【ANK-4640-00-00】typeN：追加要件対応 ********************************************************************************/ 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.EKK0361A010CBSMsg; import eo.ejb.cbs.cbsmsg.EKK0361A010CBSMsg1List; import eo.ejb.cbm.entity.KK0361ETMsg; import eo.ejb.common.JKKModelCommon; import eo.ejb.common.db.JKKejbExclusiveProcKK0351; /** * * テンプレートDBアクセス部品　EKK0361A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbEKK0361A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbEKK0361A010TPDA() { } /** * EKK0361A010_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(KK0361ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT KK0361.OP_SVC_KEI_NO ") .append(" ,KK0361.GENE_ADD_DTM ") .append(" ,KK0361.KIBO_ML_ACCOUNT_1 ") .append(" ,KK0361.KIBO_ML_ACCOUNT_2 ") .append(" ,KK0361.KIBO_ML_ACCOUNT_3 ") .append(" ,KK0361.MLTISE_SHK_NINSHO_ID_PWD ") .append(" ,KK0361.MLTISE_NINSHO_ID ") .append(" ,KK0361.MLTISE_NINSHO_ID_PWD ") .append(" ,KK0361.KOTEI_IP_AD ") .append(" ,KK0361.NETMASK ") .append(" ,KK0361.POP_ID ") .append(" ,KK0361.MLAD ") .append(" ,KK0361.MLAD_CHGE_YMD ") .append(" ,KK0361.CAPA ") .append(" ,KK0361.SHK_WEB_ID_PWD ") .append(" ,KK0361.WEB_ID ") .append(" ,KK0361.URL_DOMAIN ") .append(" ,KK0361.URL_ACCOUNT ") .append(" ,KK0361.MLLIST_NM ") .append(" ,KK0361.MLLIST_KOSHO ") .append(" ,KK0361.MLLIST_KOKAI_YH ") .append(" ,(SELECT ZM0171_01.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_01 ") .append(" WHERE ZM0171_01.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_01.CD_DIV = KK0361.MLLIST_KOKAI_YH ") .append(" AND ZM0171_01.MK_FLG = '0') AS MLLIST_KOKAI_YH_NM ") .append(" ,KK0361.MLLIST_MAX_USER_CNT ") .append(" ,KK0361.MLLIST_KRISHA_MLAD ") .append(" ,KK0361.DOKUJI_DOMAIN_NM ") .append(" ,KK0361.HOSML_ACCOUNT_CNT ") .append(" ,KK0361.HOSML_BOX_CAPA ") .append(" ,KK0361.HOSML_KRISHA_ID ") .append(" ,KK0361.HOSTING_SHKM_KRISHA_ID_PWD ") .append(" ,KK0361.HOSML_KRISHA_POP_ID ") .append(" ,KK0361.HOS_SHKM_KRISHA_POP_ID_PWD ") .append(" ,KK0361.HOSML_KRISHA_MLAD ") .append(" ,KK0361.HOSML_KRISHA_MAIL_BOX_CAPA ") .append(" ,KK0361.DPAD_ID ") .append(" ,KK0361.DPAD_ISP_ID ") .append(" ,KK0361.DPAD_MAPID ") .append(" ,KK0361.DPAD_PIN ") .append(" ,KK0361.DPAD_MLAD ") .append(" ,KK0361.DPAD_ID_KOKAI_YH ") .append(" ,(SELECT ZM0171_02.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_02 ") .append(" WHERE ZM0171_02.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_02.CD_DIV = KK0361.DPAD_ID_KOKAI_YH ") .append(" AND ZM0171_02.MK_FLG = '0') AS DPAD_ID_KOKAI_YH_NM ") .append(" ,KK0361.VOIP_USER_ID ") .append(" ,KK0361.VOIP_TELNO ") .append(" ,KK0361.DNS_SETTE_CD ") .append(" ,KK0361.MAIL_GW_KRISHA_ID ") .append(" ,KK0361.MAIL_GW_KRISHA_ID_PWD ") .append(" ,KK0361.MAIL_GW_KRISHA_MLAD ") .append(" ,KK0361.MAIL_GW_RCV_MSERVER_IP_AD ") .append(" ,KK0361.MAIL_GW_SEND_MSERVER_IP_AD ") .append(" ,KK0361.ML_GW_ACCOUNT_CNT ") .append(" ,KK0361.KOSHUMO_TELNO ") .append(" ,KK0361.SPOT_YGSITEBLCK_TRGT_SYSID ") .append(" ,(SELECT CK001.CUST_NM ") .append(" FROM CK_T_CUST CK001 ") .append(" WHERE CK001.SYSID = KK0361.SPOT_YGSITEBLCK_TRGT_SYSID ") .append(" AND (CK001.SYSID, CK001.RSV_APLY_YMD || CK001.GENE_ADD_DTM) = ") .append(" (SELECT CK001_GENE.SYSID, MAX(CK001_GENE.RSV_APLY_YMD || CK001_GENE.GENE_ADD_DTM) AS CK001_MAX ") .append(" FROM CK_T_CUST CK001_GENE ") .append(" WHERE CK001_GENE.SYSID = CK001.SYSID ") .append(" AND CK001_GENE.RSV_APLY_YMD <= ? ") .append(" AND CK001_GENE.RSV_APLY_CD = '2' ") .append(" AND CK001_GENE.MK_FLG= '0' ") .append(" GROUP BY CK001_GENE.SYSID )) AS SPOT_YGSITEBLCK_TRGT_SYSID_NM ") .append(" ,KK0361.SIP_ADD_STAT_CD ") .append(" ,(SELECT ZM0171_03.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_03 ") .append(" WHERE ZM0171_03.CD_SBT_CD = 'CD00681' ") .append(" AND ZM0171_03.CD_DIV = KK0361.SIP_ADD_STAT_CD ") .append(" AND ZM0171_03.MK_FLG = '0') AS SIP_ADD_STAT_CD_NM ") .append(" ,KK0361.SVC_KBT_SET_RRKS_MLAD ") .append(" ,KK0361.TUWA_DTL_KOKAI_YH ") .append(" ,(SELECT ZM0171_04.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_04 ") .append(" WHERE ZM0171_04.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_04.CD_DIV = KK0361.TUWA_DTL_KOKAI_YH ") .append(" AND ZM0171_04.MK_FLG = '0') AS TUWA_DTL_KOKAI_YH_NM ") .append(" ,KK0361.RSV_APLY_CD ") .append(" ,(SELECT ZM0171_05.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_05 ") .append(" WHERE ZM0171_05.CD_SBT_CD = 'CD00343' ") .append(" AND ZM0171_05.CD_DIV = KK0361.RSV_APLY_CD ") .append(" AND ZM0171_05.MK_FLG = '0') AS RSV_APLY_CD_NM ") .append(" ,KK0361.ADD_DTM ") .append(" ,KK0361.ADD_OPEACNT ") .append(" ,KK0361.UPD_DTM ") .append(" ,KK0361.UPD_OPEACNT ") .append(" ,KK0361.DEL_DTM ") .append(" ,KK0361.DEL_OPEACNT ") .append(" ,KK0361.MK_FLG ") .append(" ,(SELECT ZM0171_06.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_06 ") .append(" WHERE ZM0171_06.CD_SBT_CD = 'CD00016' ") .append(" AND ZM0171_06.CD_DIV = KK0361.MK_FLG ") .append(" AND ZM0171_06.MK_FLG = '0') AS MK_FLG_NM ") .append(" ,NULL AS LAST_UPD_DTM ") .append(" ,KK0361.SHK_POP_ID_PWD ") .append(" ,KK0361.DUPCON_NINSHO_ID ") .append(" ,KK0361.TSYRN_SVKEI_CD_SEQ ") .append(" ,KK0361.MLTISE_SESSION_CNT ") .append(" ,KK0361.DOMAIN_DAIKO_SHINSEI_UM ") .append(" ,(SELECT ZM0171_07.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_07 ") .append(" WHERE ZM0171_07.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_07.CD_DIV = KK0361.DOMAIN_DAIKO_SHINSEI_UM ") .append(" AND ZM0171_07.MK_FLG = '0') AS DOMAIN_DAIKO_SHINSEI_UM_NM ") .append(" ,KK0361.EOHNT_DAIKO_SHINSEI_UM ") .append(" ,(SELECT ZM0171_08.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_08 ") .append(" WHERE ZM0171_08.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_08.CD_DIV = KK0361.EOHNT_DAIKO_SHINSEI_UM ") .append(" AND ZM0171_08.MK_FLG = '0') AS EOHNT_DAIKO_SHINSEI_UM_NM ") .append(" ,KK0361.WISH_OWNR_ID ") .append(" ,KK0361.IPV6_AD_IFID ") .append(" ,KK0361.FMTCEL_JGS_CD ") .append(" ,(SELECT ZM0171_09.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_09 ") .append(" WHERE ZM0171_09.CD_SBT_CD = 'CD00255' ") .append(" AND ZM0171_09.CD_DIV = KK0361.FMTCEL_JGS_CD ") .append(" AND ZM0171_09.MK_FLG = '0') AS FMTCEL_JGS_CD_NM ") .append(" ,KK0361.FMTCEL_JGS_USE_CD ") .append(" ,KK0361.FMTCEL_NINSHO_ID ") .append(" ,KK0361.FMTCEL_NINSHO_ID_PWD ") .append(" ,KK0361.ML_VRSETTE_HKTGI_FLG ") .append(" ,KK0361.MLAD_CHGJ_ML_TNS_FLG ") // ANK-3149-00-00 START .append(" ,KK0361.MCAFEE_MEMBER_ID ") .append(" ,KK0361.MCAFEE_NINSHO_MLAD ") .append(" ,KK0361.MCAFEE_NINSHO_PWD ") .append(" ,KK0361.MCAFEE_SEHN_DL_URL ") .append(" ,KK0361.MCAFEE_BUY_ID ") .append(" ,KK0361.BBSS_MEMBER_ID ") .append(" ,KK0361.USER_SBSCPT_PIN ") .append(" ,KK0361.SBSCPT_ID ") // ANK-3149-00-00 END // ANK-3484-00-00 ADD START .append(" ,KK0361.TMCP_KEI_NO ") .append(" ,KK0361.KIKI_COMPS_ZAN_USE_CNT ") .append(" ,KK0361.DATA_FUKKYU_ZAN_USE_CNT ") .append(" ,KK0361.TMCP_MSKM_YMD ") .append(" ,KK0361.TMCP_MSKM_RNKI_YMD ") .append(" ,KK0361.TMCP_CNCL_RNKI_YMD ") .append(" ,KK0361.TMCP_DSL_RNKI_YMD ") .append(" ,KK0361.TMCP_ADCHG_HKTGI_UM ") .append(" ,(SELECT ZM0171_10.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_10 ") .append(" WHERE ZM0171_10.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_10.CD_DIV = KK0361.TMCP_ADCHG_HKTGI_UM ") .append(" AND ZM0171_10.MK_FLG = '0') AS TMCP_ADCHG_HKTGI_UM_NM ") // ANK-3484-00-00 ADD END // ANK-4427-00-00 ADD START .append(" ,KK0361.TYPEN_TELNO ") .append(" ,KK0361.TYPEN_BMP_SBT ") .append(" ,(SELECT ZM0171_11.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_11 ") .append(" WHERE ZM0171_11.CD_SBT_CD = 'CD01846' ") .append(" AND ZM0171_11.CD_DIV = KK0361.TYPEN_BMP_SBT ") .append(" AND ZM0171_11.MK_FLG = '0') AS TYPEN_BMP_SBT_NM ") .append(" ,KK0361.TYPEN_KEISHA_NM ") .append(" ,KK0361.TYPEN_AD_CD ") .append(" ,KK0361.TYPEN_PCD ") .append(" ,KK0361.TYPEN_STATE_NM ") .append(" ,KK0361.TYPEN_CITY_NM ") .append(" ,KK0361.TYPEN_OAZTSU_NM ") .append(" ,KK0361.TYPEN_AZCHO_NM ") .append(" ,KK0361.TYPEN_BNCHIGO ") .append(" ,KK0361.TYPEN_ADRTTM ") .append(" ,KK0361.TYPEN_ADRRM ") .append(" ,KK0361.TYPEN_AD_MAN_INPUT_FLG ") .append(" ,KK0361.TYPEN_TEL_KNKN_TRAT_CD ") .append(" ,(SELECT ZM0171_12.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_12 ") .append(" WHERE ZM0171_12.CD_SBT_CD = 'CD01847' ") .append(" AND ZM0171_12.CD_DIV = KK0361.TYPEN_TEL_KNKN_TRAT_CD ") .append(" AND ZM0171_12.MK_FLG = '0') AS TYPEN_TEL_KNKN_TRAT_CD_NM ") .append(" ,KK0361.TYPEN_TELNO_SBT_CD ") .append(" ,(SELECT ZM0171_13.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_13 ") .append(" WHERE ZM0171_13.CD_SBT_CD = 'CD01854' ") .append(" AND ZM0171_13.CD_DIV = KK0361.TYPEN_TELNO_SBT_CD ") .append(" AND ZM0171_13.MK_FLG = '0') AS TYPEN_TELNO_SBT_CD_NM ") // ANK-4427-00-00 ADD END // ANK-4640-00-00 ADD START .append(" ,KK0361.TYPEN_TSJGS_CD ") .append(" ,(SELECT TU0051.TSJGS_NM ") .append(" FROM TU_M_TUSHIN_JGYOSHA TU0051 ") .append(" WHERE TU0051.TSJGS_CD = KK0361.TYPEN_TSJGS_CD ") .append(" AND TU0051.MK_FLG= '0') AS TYPEN_TSJGS_CD_NM ") // ANK-4640-00-00 ADD END .append(" FROM KK_T_OPSVKEI_ISP KK0361 "); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(EKK0361A010CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE KK0361.OP_SVC_KEI_NO = ? ") .append(" AND KK0361.GENE_ADD_DTM = ? ") .append(" AND KK0361.MK_FLG = '0' "); } if ( "2".equals( inMsg.getObject(EKK0361A010CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE KK0361.OP_SVC_KEI_NO = ? ") .append(" AND (KK0361.OP_SVC_KEI_NO, KK0361.GENE_ADD_DTM) = ") .append(" (SELECT KK0361_GENE.OP_SVC_KEI_NO, MAX(KK0361_GENE.GENE_ADD_DTM) AS KK0361_MAX ") .append(" FROM KK_T_OPSVKEI_ISP KK0361_GENE ") .append(" WHERE KK0361_GENE.OP_SVC_KEI_NO = KK0361.OP_SVC_KEI_NO ") .append(" AND KK0361_GENE.RSV_APLY_CD = '2' ") .append(" AND KK0361_GENE.MK_FLG = '0' ") .append(" GROUP BY KK0361_GENE.OP_SVC_KEI_NO) "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに指定された値を設定 if ( "1".equals( inMsg.getString(EKK0361A010CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(運用日付を指定) CAANJDBCUtil.setParam(pstmt, 1, JKKModelCommon.getOpeDate(inMsg)); // パラメータの設定(ＫＥＹ＿オプションサービス契約番号を指定) CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(EKK0361A010CBSMsg.KEY_OP_SVC_KEI_NO)); // パラメータの設定(ＫＥＹ＿世代登録年月日時分秒を指定) CAANJDBCUtil.setParam(pstmt, 3, inMsg.getObject(EKK0361A010CBSMsg.KEY_GENE_ADD_DTM)); } if ( "2".equals( inMsg.getString(EKK0361A010CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(運用日付を指定) CAANJDBCUtil.setParam(pstmt, 1, JKKModelCommon.getOpeDate(inMsg)); // パラメータの設定(ＫＥＹ＿オプションサービス契約番号を指定) CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(EKK0361A010CBSMsg.KEY_OP_SVC_KEI_NO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // EKK0361A010CBSMsgの明細にセットする項目 String[] msgKeyList1 = { EKK0361A010CBSMsg1List.OP_SVC_KEI_NO , EKK0361A010CBSMsg1List.GENE_ADD_DTM , EKK0361A010CBSMsg1List.KIBO_ML_ACCOUNT_1 , EKK0361A010CBSMsg1List.KIBO_ML_ACCOUNT_2 , EKK0361A010CBSMsg1List.KIBO_ML_ACCOUNT_3 , EKK0361A010CBSMsg1List.MLTISE_SHK_NINSHO_ID_PWD , EKK0361A010CBSMsg1List.MLTISE_NINSHO_ID , EKK0361A010CBSMsg1List.MLTISE_NINSHO_ID_PWD , EKK0361A010CBSMsg1List.KOTEI_IP_AD , EKK0361A010CBSMsg1List.NETMASK , EKK0361A010CBSMsg1List.POP_ID , EKK0361A010CBSMsg1List.MLAD , EKK0361A010CBSMsg1List.MLAD_CHGE_YMD , EKK0361A010CBSMsg1List.CAPA , EKK0361A010CBSMsg1List.SHK_WEB_ID_PWD , EKK0361A010CBSMsg1List.WEB_ID , EKK0361A010CBSMsg1List.URL_DOMAIN , EKK0361A010CBSMsg1List.URL_ACCOUNT , EKK0361A010CBSMsg1List.MLLIST_NM , EKK0361A010CBSMsg1List.MLLIST_KOSHO , EKK0361A010CBSMsg1List.MLLIST_KOKAI_YH , EKK0361A010CBSMsg1List.MLLIST_KOKAI_YH_NM , EKK0361A010CBSMsg1List.MLLIST_MAX_USER_CNT , EKK0361A010CBSMsg1List.MLLIST_KRISHA_MLAD , EKK0361A010CBSMsg1List.DOKUJI_DOMAIN_NM , EKK0361A010CBSMsg1List.HOSML_ACCOUNT_CNT , EKK0361A010CBSMsg1List.HOSML_BOX_CAPA , EKK0361A010CBSMsg1List.HOSML_KRISHA_ID , EKK0361A010CBSMsg1List.HOSTING_SHKM_KRISHA_ID_PWD , EKK0361A010CBSMsg1List.HOSML_KRISHA_POP_ID , EKK0361A010CBSMsg1List.HOS_SHKM_KRISHA_POP_ID_PWD , EKK0361A010CBSMsg1List.HOSML_KRISHA_MLAD , EKK0361A010CBSMsg1List.HOSML_KRISHA_MAIL_BOX_CAPA , EKK0361A010CBSMsg1List.DPAD_ID , EKK0361A010CBSMsg1List.DPAD_ISP_ID , EKK0361A010CBSMsg1List.DPAD_MAPID , EKK0361A010CBSMsg1List.DPAD_PIN , EKK0361A010CBSMsg1List.DPAD_MLAD , EKK0361A010CBSMsg1List.DPAD_ID_KOKAI_YH , EKK0361A010CBSMsg1List.DPAD_ID_KOKAI_YH_NM , EKK0361A010CBSMsg1List.VOIP_USER_ID , EKK0361A010CBSMsg1List.VOIP_TELNO , EKK0361A010CBSMsg1List.DNS_SETTE_CD , EKK0361A010CBSMsg1List.MAIL_GW_KRISHA_ID , EKK0361A010CBSMsg1List.MAIL_GW_KRISHA_ID_PWD , EKK0361A010CBSMsg1List.MAIL_GW_KRISHA_MLAD , EKK0361A010CBSMsg1List.MAIL_GW_RCV_MSERVER_IP_AD , EKK0361A010CBSMsg1List.MAIL_GW_SEND_MSERVER_IP_AD , EKK0361A010CBSMsg1List.ML_GW_ACCOUNT_CNT , EKK0361A010CBSMsg1List.KOSHUMO_TELNO , EKK0361A010CBSMsg1List.SPOT_YGSITEBLCK_TRGT_SYSID , EKK0361A010CBSMsg1List.SPOT_YGSITEBLCK_TRGT_SYSID_NM , EKK0361A010CBSMsg1List.SIP_ADD_STAT_CD , EKK0361A010CBSMsg1List.SIP_ADD_STAT_CD_NM , EKK0361A010CBSMsg1List.SVC_KBT_SET_RRKS_MLAD , EKK0361A010CBSMsg1List.TUWA_DTL_KOKAI_YH , EKK0361A010CBSMsg1List.TUWA_DTL_KOKAI_YH_NM , EKK0361A010CBSMsg1List.RSV_APLY_CD , EKK0361A010CBSMsg1List.RSV_APLY_CD_NM , EKK0361A010CBSMsg1List.ADD_DTM , EKK0361A010CBSMsg1List.ADD_OPEACNT , EKK0361A010CBSMsg1List.UPD_DTM , EKK0361A010CBSMsg1List.UPD_OPEACNT , EKK0361A010CBSMsg1List.DEL_DTM , EKK0361A010CBSMsg1List.DEL_OPEACNT , EKK0361A010CBSMsg1List.MK_FLG , EKK0361A010CBSMsg1List.MK_FLG_NM , EKK0361A010CBSMsg1List.LAST_UPD_DTM , EKK0361A010CBSMsg1List.SHK_POP_ID_PWD , EKK0361A010CBSMsg1List.DUPCON_NINSHO_ID , EKK0361A010CBSMsg1List.TSYRN_SVKEI_CD_SEQ , EKK0361A010CBSMsg1List.MLTISE_SESSION_CNT , EKK0361A010CBSMsg1List.DOMAIN_DAIKO_SHINSEI_UM , EKK0361A010CBSMsg1List.DOMAIN_DAIKO_SHINSEI_UM_NM , EKK0361A010CBSMsg1List.EOHNT_DAIKO_SHINSEI_UM , EKK0361A010CBSMsg1List.EOHNT_DAIKO_SHINSEI_UM_NM , EKK0361A010CBSMsg1List.WISH_OWNR_ID , EKK0361A010CBSMsg1List.IPV6_AD_IFID , EKK0361A010CBSMsg1List.FMTCEL_JGS_CD , EKK0361A010CBSMsg1List.FMTCEL_JGS_CD_NM , EKK0361A010CBSMsg1List.FMTCEL_JGS_USE_CD , EKK0361A010CBSMsg1List.FMTCEL_NINSHO_ID , EKK0361A010CBSMsg1List.FMTCEL_NINSHO_ID_PWD , EKK0361A010CBSMsg1List.ML_VRSETTE_HKTGI_FLG , EKK0361A010CBSMsg1List.MLAD_CHGJ_ML_TNS_FLG , EKK0361A010CBSMsg1List.MCAFEE_MEMBER_ID , EKK0361A010CBSMsg1List.MCAFEE_NINSHO_MLAD , EKK0361A010CBSMsg1List.MCAFEE_NINSHO_PWD , EKK0361A010CBSMsg1List.MCAFEE_SEHN_DL_URL , EKK0361A010CBSMsg1List.MCAFEE_BUY_ID , EKK0361A010CBSMsg1List.BBSS_MEMBER_ID , EKK0361A010CBSMsg1List.USER_SBSCPT_PIN , EKK0361A010CBSMsg1List.SBSCPT_ID // ANK-3484-00-00 ADD START , EKK0361A010CBSMsg1List.TMCP_KEI_NO , EKK0361A010CBSMsg1List.KIKI_COMPS_ZAN_USE_CNT , EKK0361A010CBSMsg1List.DATA_FUKKYU_ZAN_USE_CNT , EKK0361A010CBSMsg1List.TMCP_MSKM_YMD , EKK0361A010CBSMsg1List.TMCP_MSKM_RNKI_YMD , EKK0361A010CBSMsg1List.TMCP_CNCL_RNKI_YMD , EKK0361A010CBSMsg1List.TMCP_DSL_RNKI_YMD , EKK0361A010CBSMsg1List.TMCP_ADCHG_HKTGI_UM , EKK0361A010CBSMsg1List.TMCP_ADCHG_HKTGI_UM_NM // ANK-3484-00-00 ADD END // ANK-4427-00-00 ADD START , EKK0361A010CBSMsg1List.TYPEN_TELNO , EKK0361A010CBSMsg1List.TYPEN_BMP_SBT , EKK0361A010CBSMsg1List.TYPEN_BMP_SBT_NM , EKK0361A010CBSMsg1List.TYPEN_KEISHA_NM , EKK0361A010CBSMsg1List.TYPEN_AD_CD , EKK0361A010CBSMsg1List.TYPEN_PCD , EKK0361A010CBSMsg1List.TYPEN_STATE_NM , EKK0361A010CBSMsg1List.TYPEN_CITY_NM , EKK0361A010CBSMsg1List.TYPEN_OAZTSU_NM , EKK0361A010CBSMsg1List.TYPEN_AZCHO_NM , EKK0361A010CBSMsg1List.TYPEN_BNCHIGO , EKK0361A010CBSMsg1List.TYPEN_ADRTTM , EKK0361A010CBSMsg1List.TYPEN_ADRRM , EKK0361A010CBSMsg1List.TYPEN_AD_MAN_INPUT_FLG , EKK0361A010CBSMsg1List.TYPEN_TEL_KNKN_TRAT_CD , EKK0361A010CBSMsg1List.TYPEN_TEL_KNKN_TRAT_CD_NM , EKK0361A010CBSMsg1List.TYPEN_TELNO_SBT_CD , EKK0361A010CBSMsg1List.TYPEN_TELNO_SBT_CD_NM // ANK-4427-00-00 ADD END // ANK-4640-00-00 ADD START , EKK0361A010CBSMsg1List.TYPEN_TSJGS_CD , EKK0361A010CBSMsg1List.TYPEN_TSJGS_CD_NM // ANK-4640-00-00 ADD END }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK0361A010CBSMsg1List",0); if(outMsg1.length > 0) { String lastUpdDtm = null; // 「オプションサービス契約排他処理部品」の「最終更新年月日時分秒(オプションサービス契約番号)取得処理」を呼出す。 lastUpdDtm = new JKKejbExclusiveProcKK0351().getLastUpdDtmOpSvcKeiNo(inMsg, inMsg.getObject(EKK0361A010CBSMsg.KEY_OP_SVC_KEI_NO).toString()); // 取得した最大最終更新年月日時分秒を設定 outMsg1[0].set(EKK0361A010CBSMsg1List.LAST_UPD_DTM, lastUpdDtm); } // inMsg(CBSMsg)に明細をセット inMsg.set("EKK0361A010CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(EKK0361A010CBSMsg.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(EKK0361A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }