/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEKK2081A010TPDA
* ソースファイル名：JSYejbEKK2081A010TPDA.java
* 作成者 ：EK919738
* 日付 ：2018年11月16日
*＜機能概要＞
* 申込保留内容一時保存一意照会テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* v51.00.00 2020/09/03 FJ) 西窪 【ANK-3885-00-00】光化マンションの自動設計対応
* v54.00.00 2021/08/19 FJ) 平野 【ANK-4096-00-00】宅調宅工同時実施のための聞取り強化対応
* v57.00.00 2022/01/14 FJ) 平野 【ANK-4075-00-00】マンション卸回線(WI-FIスキーム)の不備対応
* v60.00.00 2022/06/08 FJ) 平野 【ANK-4244-00-00】_【eo定期】MT既設賃貸対応
* v62.00.00 2022/10/04 FJ) 原 【ANK-4318-00-00】申込新規登録画面の成人年齢チェック条件変更対応
* v73.00.00 2024/10/18 FJ) 森下 【ANK-4427-00-00】NTT卸対応
********************************************************************************/
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.EKK2081A010CBSMsg;
import eo.ejb.cbs.cbsmsg.EKK2081A010CBSMsg1List;
import eo.ejb.cbm.entity.KK2081ETMsg;
/**
*
* テンプレートDBアクセス部品 EKK2081A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEKK2081A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEKK2081A010TPDA() {
}
/**
* EKK2081A010_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(KK2081ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" KK2081.MSKM_PNY_TPPV_NO, ")
.append(" KK2081.MSKM_UK_USER_ID, ")
.append(" KK2081.MSKM_PDING_UK_YMD, ")
.append(" KK2081.ADD_MOTO_SVC_KEI_NO, ")
.append(" KK2081.ADD_MT_SYSID, ")
.append(" KK2081.USE_KISN_CD, ")
.append(" KK2081.UK_TNTSHA_SKBT_CD, ")
.append(" KK2081.JKYO_TYPE_SKBT_CD, ")
.append(" KK2081.MSKM_ROUTE_SKBT_CD, ")
.append(" KK2081.AGNT_CD, ")
.append(" KK2081.TTL_BUSINESS_MSKM_OPT_CD, ")
.append(" KK2081.MANSION_BUKKEN_NO, ")
.append(" KK2081.MANSION_OWNR_ID, ")
.append(" KK2081.KEISHA_TYPE_CD, ")
.append(" KK2081.PAYWAY_KEIZOKU_FLG, ")
.append(" KK2081.KAISEN_PLACE_PCD_BF, ")
.append(" KK2081.KAISEN_PLACE_PCD_AF, ")
.append(" KK2081.KAISEN_PLACE_STATE_NM, ")
.append(" KK2081.KAISEN_PLACE_CITY_NM, ")
.append(" KK2081.KAISEN_PLACE_OAZTSU_NM, ")
.append(" KK2081.KAISEN_PLACE_AZCHO_NM, ")
.append(" KK2081.KAISEN_PLACE_BNCHIGO, ")
.append(" KK2081.KAISEN_PLACE_ADRTTM, ")
.append(" KK2081.KAISEN_PLACE_ADRRM, ")
.append(" KK2081.SKS_YO_KISN_PLACE_AD_RM_NO, ")
.append(" KK2081.KAISEN_PLACE_AD_CD, ")
.append(" KK2081.KAISEN_PLACE_TELNO, ")
.append(" KK2081.AD_FORM_CD, ")
.append(" KK2081.SHUGJ_NYUKYO_FLR_CNT_CD, ")
.append(" KK2081.SHUNKO_RSV_YMD_YEAR, ")
.append(" KK2081.SHUNKO_RSV_YMD_MON, ")
.append(" KK2081.NYUKYO_RSV_YMD_YEAR, ")
.append(" KK2081.NYUKYO_RSV_YMD_MON, ")
.append(" KK2081.NYUKYO_RSV_YMD_DAY, ")
.append(" KK2081.KISN_PLC_HSK_MEMO, ")
.append(" KK2081.KISN_PLC_AD_MI_FIX_FLG, ")
.append(" KK2081.KISN_PLC_KKK_SEIRI_CHU_FLG, ")
.append(" KK2081.KSHAD_CHG_UM, ")
.append(" KK2081.KSHAD_CHG_KIBO_YMD, ")
.append(" KK2081.KEPCO_CUSTINFO_JUJU_DOI_UM, ")
.append(" KK2081.XZAHYO, ")
.append(" KK2081.YZAHYO, ")
.append(" KK2081.LGTD, ")
.append(" KK2081.LTTD, ")
.append(" KK2081.KEPCO_BUSIOFFICE_CD, ")
.append(" KK2081.CUST_NM, ")
.append(" KK2081.CUST_KANA, ")
.append(" KK2081.HOJIN_ZENGO_SHITEI_CD, ")
.append(" KK2081.HOJIN_SBT_CD, ")
.append(" KK2081.COMP_NM, ")
.append(" KK2081.COMP_KANA, ")
.append(" KK2081.GSHU_CD, ")
.append(" KK2081.RRKS_KTAI_TELNO, ")
.append(" KK2081.RRKS_TELNO, ")
.append(" KK2081.MSKM_RRKS_MLAD, ")
.append(" KK2081.MKM_YUSEN_RRKS_SKBT_CD, ")
.append(" KK2081.HJRRKS_NM, ")
.append(" KK2081.NISNNO, ")
.append(" KK2081.HJRRKS_TNTSHA_SHOZKBSHO_NM, ")
.append(" KK2081.HJRRKS_TNTSHA_KANA, ")
.append(" KK2081.HJRRKS_TNTSHA_NM, ")
.append(" KK2081.KAISEN_PLC_KSH_AD_SAI_FLG, ")
.append(" KK2081.KEISHA_AD_MAN_INPUT_UM, ")
.append(" KK2081.KEISHA_PCD_BF, ")
.append(" KK2081.KEISHA_PCD_AF, ")
.append(" KK2081.KEISHA_STATE_NM, ")
.append(" KK2081.KEISHA_CITY_NM, ")
.append(" KK2081.KEISHA_OAZTSU_NM, ")
.append(" KK2081.KEISHA_AZCHO_NM, ")
.append(" KK2081.KEISHA_BNCHIGO, ")
.append(" KK2081.KEISHA_ADRTTM, ")
.append(" KK2081.KEISHA_ADRRM, ")
.append(" KK2081.KEISHA_AD_CD, ")
.append(" KK2081.KEISHA_TELNO, ")
.append(" KK2081.YUSEN_RRKS_TELNO, ")
.append(" KK2081.CUST_BIRTHD_YEAR, ")
.append(" KK2081.CUST_BIRTHD_MON, ")
.append(" KK2081.CUST_BIRTHD_DAY, ")
.append(" KK2081.CUST_SEX_CD, ")
.append(" KK2081.SHOKUGYO_CD, ")
.append(" KK2081.KIKI_ATICLE_SHS_AD_SKBT_CD, ")
.append(" KK2081.KIKI_SOHUS_MAN_INPUT_UM, ")
.append(" KK2081.KIKI_SOHUS_PCD_BF, ")
.append(" KK2081.KIKI_SOHUS_PCD_AF, ")
.append(" KK2081.KIKI_SOHUS_STATE_NM, ")
.append(" KK2081.KIKI_SOHUS_CITY_NM, ")
.append(" KK2081.KIKI_SOHUS_OAZTSU_NM, ")
.append(" KK2081.KIKI_SOHUS_AZCHO_NM, ")
.append(" KK2081.KIKI_SOHUS_BNCHIGO, ")
.append(" KK2081.KIKI_SOHUS_ADRTTM, ")
.append(" KK2081.KIKI_SOHUS_ADRRM, ")
.append(" KK2081.KIKI_SOHUS_AD_CD, ")
.append(" KK2081.KIKI_SOHUS_NM, ")
.append(" KK2081.KIKI_SOHUS_KANA, ")
.append(" KK2081.KIKI_SOHUS_TELNO, ")
.append(" KK2081.SOKU_WARI_MSKM_UM, ")
.append(" KK2081.CHOKZUWRI_MSKM_UM, ")
.append(" KK2081.CHOKZUWRI_AT_KEIZK_MSKM_UM, ")
.append(" KK2081.HNIN_CFM_ATICLE_SBT_CD, ")
.append(" KK2081.HNIN_CFM_ATICLE_NM, ")
.append(" KK2081.KOJI_REQ_INFO_RRK_JIKO, ")
.append(" KK2081.KDDI_VAL_CD, ")
.append(" KK2081.RRK_WAY_CD, ")
.append(" KK2081.RRK_WAY_HOKI, ")
.append(" KK2081.MENKAIHAT_ANKEN_NO, ")
.append(" KK2081.CHMT_HJIN_EO_YKAE_SVKEI_NO, ")
.append(" KK2081.MKM_UK_SBT_CD, ")
.append(" KK2081.SHOSA_BF_RRK_JIKO_YH, ")
.append(" KK2081.SHOSA_BF_RRK_JIKO, ")
.append(" KK2081.KJ_TEL_RRK_KIBOD_SBT_CD, ")
.append(" KK2081.KJ_TEL_RRK_KBTMZ_CD, ")
.append(" KK2081.KJ_TAKCHO_KIBOD_SBT_CD, ")
.append(" KK2081.NEWCONST_BUKKEN_CD, ")
.append(" KK2081.HUKKAT_ANKEN_FLG, ")
.append(" KK2081.SAME_EQUIP_RE_MSKM_CD, ")
.append(" KK2081.DSL_ATICLE_SOHU_KIBO_UM, ")
.append(" KK2081.MANSION_ID, ")
.append(" KK2081.CATID, ")
.append(" KK2081.PID, ")
.append(" KK2081.KEI_HUKA_CD, ")
.append(" KK2081.VDSL_MODEM_TAKNKIKI_MDL_CD, ")
.append(" KK2081.ADD_DTM, ")
.append(" KK2081.ADD_OPEACNT, ")
.append(" KK2081.UPD_DTM, ")
.append(" KK2081.UPD_OPEACNT, ")
.append(" KK2081.DEL_DTM, ")
.append(" KK2081.DEL_OPEACNT, ")
.append(" KK2081.MK_FLG, ")
.append(" KK2081.KEPG_KJNIF_TRAT_DOI_CD, ")
.append(" KK2081.KEPCOG_KJNIFT_FFG, ")
.append(" KK2081.SAME_PLACE_EOELEC_SVKEI_NO, ")
.append(" KK2081.AGNT_MKM_UK_EOSTF_USER_ID, ")
.append(" KK2081.AGNT_MKM_UK_RHSTF_KANA_SEI, ")
.append(" KK2081.KAP_PLAN_CD, ")
.append(" KK2081.KOSOKUWRI_MSKM_UM, ")
// ANK-3885-00-00 ADD START
// ANK-4096-00-00 MOD START
// .append(" KK2081.KAISEN_PLACE_TOU_INFO ")
.append(" KK2081.KAISEN_PLACE_TOU_INFO, ")
// ANK-4096-00-00 MOD END
// ANK-3885-00-00 ADD END
// ANK-4096-00-00 ADD START
.append(" KK2081.NOW_USE_SK_KEI_KISN_DIV, ")
.append(" KK2081.KIKI_SETPLC_CHGUM, ")
// ANK-4075-00-00 MOD START
// .append(" KK2081.DOJITU_JSSI_KBUM ")
.append(" KK2081.DOJITU_JSSI_KBUM, ")
// ANK-4075-00-00 MOD END
// ANK-4096-00-00 ADD END
// ANK-4075-00-00 ADD START
.append(" KK2081.SCM_TYPE_CD, ")
// ANK-4244-00-00 MOD START
// .append(" KK2081.SCM_JGS_CD ")
// ANK-4075-00-00 ADD END
.append(" KK2081.SCM_JGS_CD, ")
// ANK-4244-00-00 MOD END
// ANK-4318-00-00 MOD START
// ANK-4244-00-00 ADD START
// .append(" KK2081.KAISEN_PLACE_RENBAN ")
// ANK-4244-00-00 ADD END
.append(" KK2081.KAISEN_PLACE_RENBAN, ")
// ANK-4318-00-00 MOD END
// ANK-4318-00-00 ADD START
.append(" KK2081.SKSHA_NM, ")
.append(" KK2081.SKSHA_KANA, ")
.append(" KK2081.SKSHA_TELNO, ")
.append(" KK2081.SKSHA_BIRTHD_YEAR, ")
.append(" KK2081.SKSHA_BIRTHD_MON, ")
.append(" KK2081.SKSHA_BIRTHD_DAY, ")
.append(" KK2081.SKSHA_ZOKUGARA_CD, ")
// ANK-4427-00-00 MOD START
// .append(" KK2081.ZOKUGARA_OTHER ")
.append(" KK2081.ZOKUGARA_OTHER, ")
// ANK-4427-00-00 MOD END
// ANK-4318-00-00 ADD END
//ANK-4427-00-00 ADD START
.append(" KK2081.WAO_HAKEN_YH_KIBO, ")
.append(" KK2081.WAO_KOJI_KIBO_YMD_1, ")
.append(" KK2081.WAO_KOJI_KIBO_TIMEZ_1, ")
.append(" KK2081.WAO_KOJI_KIBO_YMD_2, ")
.append(" KK2081.WAO_KOJI_KIBO_TIMEZ_2, ")
.append(" KK2081.WAO_KOJI_KIBO_YMD_3, ")
.append(" KK2081.WAO_KOJI_KIBO_TIMEZ_3, ")
.append(" KK2081.WAO_KOCOMP_RRK_JIKO, ")
.append(" KK2081.WAO_TENYO_DIV, ")
.append(" KK2081.WAO_TENYO_SHODAKU_NO, ")
.append(" KK2081.WAO_YK_KIGEN, ")
.append(" KK2081.WAO_AD_BNCHI_MEMO, ")
.append(" KK2081.ITENM_SVC_KEI_NO ")
//ANK-4427-00-00 ADD END
.append(" FROM ")
.append(" KK_T_MSKM_PNY_TPPV KK2081 ");
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(EKK2081A010CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" KK2081.MSKM_PNY_TPPV_NO = ? AND ")
.append(" KK2081.MK_FLG = '0' ");
}
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if ( "1".equals( inMsg.getString(EKK2081A010CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(ＫＥＹ＿申込保留内容一時保存番号を指定)
CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(EKK2081A010CBSMsg.KEY_MSKM_PNY_TPPV_NO));
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EKK2081A010CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EKK2081A010CBSMsg1List.MSKM_PNY_TPPV_NO
, EKK2081A010CBSMsg1List.MSKM_UK_USER_ID
, EKK2081A010CBSMsg1List.MSKM_PDING_UK_YMD
, EKK2081A010CBSMsg1List.ADD_MOTO_SVC_KEI_NO
, EKK2081A010CBSMsg1List.ADD_MT_SYSID
, EKK2081A010CBSMsg1List.USE_KISN_CD
, EKK2081A010CBSMsg1List.UK_TNTSHA_SKBT_CD
, EKK2081A010CBSMsg1List.JKYO_TYPE_SKBT_CD
, EKK2081A010CBSMsg1List.MSKM_ROUTE_SKBT_CD
, EKK2081A010CBSMsg1List.AGNT_CD
, EKK2081A010CBSMsg1List.TTL_BUSINESS_MSKM_OPT_CD
, EKK2081A010CBSMsg1List.MANSION_BUKKEN_NO
, EKK2081A010CBSMsg1List.MANSION_OWNR_ID
, EKK2081A010CBSMsg1List.KEISHA_TYPE_CD
, EKK2081A010CBSMsg1List.PAYWAY_KEIZOKU_FLG
, EKK2081A010CBSMsg1List.KAISEN_PLACE_PCD_BF
, EKK2081A010CBSMsg1List.KAISEN_PLACE_PCD_AF
, EKK2081A010CBSMsg1List.KAISEN_PLACE_STATE_NM
, EKK2081A010CBSMsg1List.KAISEN_PLACE_CITY_NM
, EKK2081A010CBSMsg1List.KAISEN_PLACE_OAZTSU_NM
, EKK2081A010CBSMsg1List.KAISEN_PLACE_AZCHO_NM
, EKK2081A010CBSMsg1List.KAISEN_PLACE_BNCHIGO
, EKK2081A010CBSMsg1List.KAISEN_PLACE_ADRTTM
, EKK2081A010CBSMsg1List.KAISEN_PLACE_ADRRM
, EKK2081A010CBSMsg1List.SKS_YO_KISN_PLACE_AD_RM_NO
, EKK2081A010CBSMsg1List.KAISEN_PLACE_AD_CD
, EKK2081A010CBSMsg1List.KAISEN_PLACE_TELNO
, EKK2081A010CBSMsg1List.AD_FORM_CD
, EKK2081A010CBSMsg1List.SHUGJ_NYUKYO_FLR_CNT_CD
, EKK2081A010CBSMsg1List.SHUNKO_RSV_YMD_YEAR
, EKK2081A010CBSMsg1List.SHUNKO_RSV_YMD_MON
, EKK2081A010CBSMsg1List.NYUKYO_RSV_YMD_YEAR
, EKK2081A010CBSMsg1List.NYUKYO_RSV_YMD_MON
, EKK2081A010CBSMsg1List.NYUKYO_RSV_YMD_DAY
, EKK2081A010CBSMsg1List.KISN_PLC_HSK_MEMO
, EKK2081A010CBSMsg1List.KISN_PLC_AD_MI_FIX_FLG
, EKK2081A010CBSMsg1List.KISN_PLC_KKK_SEIRI_CHU_FLG
, EKK2081A010CBSMsg1List.KSHAD_CHG_UM
, EKK2081A010CBSMsg1List.KSHAD_CHG_KIBO_YMD
, EKK2081A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM
, EKK2081A010CBSMsg1List.XZAHYO
, EKK2081A010CBSMsg1List.YZAHYO
, EKK2081A010CBSMsg1List.LGTD
, EKK2081A010CBSMsg1List.LTTD
, EKK2081A010CBSMsg1List.KEPCO_BUSIOFFICE_CD
, EKK2081A010CBSMsg1List.CUST_NM
, EKK2081A010CBSMsg1List.CUST_KANA
, EKK2081A010CBSMsg1List.HOJIN_ZENGO_SHITEI_CD
, EKK2081A010CBSMsg1List.HOJIN_SBT_CD
, EKK2081A010CBSMsg1List.COMP_NM
, EKK2081A010CBSMsg1List.COMP_KANA
, EKK2081A010CBSMsg1List.GSHU_CD
, EKK2081A010CBSMsg1List.RRKS_KTAI_TELNO
, EKK2081A010CBSMsg1List.RRKS_TELNO
, EKK2081A010CBSMsg1List.MSKM_RRKS_MLAD
, EKK2081A010CBSMsg1List.MKM_YUSEN_RRKS_SKBT_CD
, EKK2081A010CBSMsg1List.HJRRKS_NM
, EKK2081A010CBSMsg1List.NISNNO
, EKK2081A010CBSMsg1List.HJRRKS_TNTSHA_SHOZKBSHO_NM
, EKK2081A010CBSMsg1List.HJRRKS_TNTSHA_KANA
, EKK2081A010CBSMsg1List.HJRRKS_TNTSHA_NM
, EKK2081A010CBSMsg1List.KAISEN_PLC_KSH_AD_SAI_FLG
, EKK2081A010CBSMsg1List.KEISHA_AD_MAN_INPUT_UM
, EKK2081A010CBSMsg1List.KEISHA_PCD_BF
, EKK2081A010CBSMsg1List.KEISHA_PCD_AF
, EKK2081A010CBSMsg1List.KEISHA_STATE_NM
, EKK2081A010CBSMsg1List.KEISHA_CITY_NM
, EKK2081A010CBSMsg1List.KEISHA_OAZTSU_NM
, EKK2081A010CBSMsg1List.KEISHA_AZCHO_NM
, EKK2081A010CBSMsg1List.KEISHA_BNCHIGO
, EKK2081A010CBSMsg1List.KEISHA_ADRTTM
, EKK2081A010CBSMsg1List.KEISHA_ADRRM
, EKK2081A010CBSMsg1List.KEISHA_AD_CD
, EKK2081A010CBSMsg1List.KEISHA_TELNO
, EKK2081A010CBSMsg1List.YUSEN_RRKS_TELNO
, EKK2081A010CBSMsg1List.CUST_BIRTHD_YEAR
, EKK2081A010CBSMsg1List.CUST_BIRTHD_MON
, EKK2081A010CBSMsg1List.CUST_BIRTHD_DAY
, EKK2081A010CBSMsg1List.CUST_SEX_CD
, EKK2081A010CBSMsg1List.SHOKUGYO_CD
, EKK2081A010CBSMsg1List.KIKI_ATICLE_SHS_AD_SKBT_CD
, EKK2081A010CBSMsg1List.KIKI_SOHUS_MAN_INPUT_UM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_PCD_BF
, EKK2081A010CBSMsg1List.KIKI_SOHUS_PCD_AF
, EKK2081A010CBSMsg1List.KIKI_SOHUS_STATE_NM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_CITY_NM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_OAZTSU_NM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_AZCHO_NM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_BNCHIGO
, EKK2081A010CBSMsg1List.KIKI_SOHUS_ADRTTM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_ADRRM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_AD_CD
, EKK2081A010CBSMsg1List.KIKI_SOHUS_NM
, EKK2081A010CBSMsg1List.KIKI_SOHUS_KANA
, EKK2081A010CBSMsg1List.KIKI_SOHUS_TELNO
, EKK2081A010CBSMsg1List.SOKU_WARI_MSKM_UM
, EKK2081A010CBSMsg1List.CHOKZUWRI_MSKM_UM
, EKK2081A010CBSMsg1List.CHOKZUWRI_AT_KEIZK_MSKM_UM
, EKK2081A010CBSMsg1List.HNIN_CFM_ATICLE_SBT_CD
, EKK2081A010CBSMsg1List.HNIN_CFM_ATICLE_NM
, EKK2081A010CBSMsg1List.KOJI_REQ_INFO_RRK_JIKO
, EKK2081A010CBSMsg1List.KDDI_VAL_CD
, EKK2081A010CBSMsg1List.RRK_WAY_CD
, EKK2081A010CBSMsg1List.RRK_WAY_HOKI
, EKK2081A010CBSMsg1List.MENKAIHAT_ANKEN_NO
, EKK2081A010CBSMsg1List.CHMT_HJIN_EO_YKAE_SVKEI_NO
, EKK2081A010CBSMsg1List.MKM_UK_SBT_CD
, EKK2081A010CBSMsg1List.SHOSA_BF_RRK_JIKO_YH
, EKK2081A010CBSMsg1List.SHOSA_BF_RRK_JIKO
, EKK2081A010CBSMsg1List.KJ_TEL_RRK_KIBOD_SBT_CD
, EKK2081A010CBSMsg1List.KJ_TEL_RRK_KBTMZ_CD
, EKK2081A010CBSMsg1List.KJ_TAKCHO_KIBOD_SBT_CD
, EKK2081A010CBSMsg1List.NEWCONST_BUKKEN_CD
, EKK2081A010CBSMsg1List.HUKKAT_ANKEN_FLG
, EKK2081A010CBSMsg1List.SAME_EQUIP_RE_MSKM_CD
, EKK2081A010CBSMsg1List.DSL_ATICLE_SOHU_KIBO_UM
, EKK2081A010CBSMsg1List.MANSION_ID
, EKK2081A010CBSMsg1List.CATID
, EKK2081A010CBSMsg1List.PID
, EKK2081A010CBSMsg1List.KEI_HUKA_CD
, EKK2081A010CBSMsg1List.VDSL_MODEM_TAKNKIKI_MDL_CD
, EKK2081A010CBSMsg1List.ADD_DTM
, EKK2081A010CBSMsg1List.ADD_OPEACNT
, EKK2081A010CBSMsg1List.UPD_DTM
, EKK2081A010CBSMsg1List.UPD_OPEACNT
, EKK2081A010CBSMsg1List.DEL_DTM
, EKK2081A010CBSMsg1List.DEL_OPEACNT
, EKK2081A010CBSMsg1List.MK_FLG
, EKK2081A010CBSMsg1List.KEPG_KJNIF_TRAT_DOI_CD
, EKK2081A010CBSMsg1List.KEPCOG_KJNIFT_FFG
, EKK2081A010CBSMsg1List.SAME_PLACE_EOELEC_SVKEI_NO
, EKK2081A010CBSMsg1List.AGNT_MKM_UK_EOSTF_USER_ID
, EKK2081A010CBSMsg1List.AGNT_MKM_UK_RHSTF_KANA_SEI
, EKK2081A010CBSMsg1List.KAP_PLAN_CD
, EKK2081A010CBSMsg1List.KOSOKUWRI_MSKM_UM
// ANK-3885-00-00 ADD START
, EKK2081A010CBSMsg1List.KAISEN_PLACE_TOU_INFO
// ANK-3885-00-00 ADD END
// ANK-4096-00-00 ADD START
, EKK2081A010CBSMsg1List.NOW_USE_SK_KEI_KISN_DIV
, EKK2081A010CBSMsg1List.KIKI_SETPLC_CHGUM
, EKK2081A010CBSMsg1List.DOJITU_JSSI_KBUM
// ANK-4096-00-00 ADD END
// ANK-4075-00-00 ADD START
, EKK2081A010CBSMsg1List.SCM_TYPE_CD
, EKK2081A010CBSMsg1List.SCM_JGS_CD
// ANK-4075-00-00 ADD END
// ANK-4244-00-00 ADD START
, EKK2081A010CBSMsg1List.KAISEN_PLACE_RENBAN
// ANK-4244-00-00 ADD END
// ANK-4318-00-00 ADD START
, EKK2081A010CBSMsg1List.SKSHA_NM
, EKK2081A010CBSMsg1List.SKSHA_KANA
, EKK2081A010CBSMsg1List.SKSHA_TELNO
, EKK2081A010CBSMsg1List.SKSHA_BIRTHD_YEAR
, EKK2081A010CBSMsg1List.SKSHA_BIRTHD_MON
, EKK2081A010CBSMsg1List.SKSHA_BIRTHD_DAY
, EKK2081A010CBSMsg1List.SKSHA_ZOKUGARA_CD
, EKK2081A010CBSMsg1List.ZOKUGARA_OTHER
// ANK-4318-00-00 ADD END
// ANK-4427-00-00 ADD START
, EKK2081A010CBSMsg1List.WAO_HAKEN_YH_KIBO
, EKK2081A010CBSMsg1List.WAO_KOJI_KIBO_YMD_1
, EKK2081A010CBSMsg1List.WAO_KOJI_KIBO_TIMEZ_1
, EKK2081A010CBSMsg1List.WAO_KOJI_KIBO_YMD_2
, EKK2081A010CBSMsg1List.WAO_KOJI_KIBO_TIMEZ_2
, EKK2081A010CBSMsg1List.WAO_KOJI_KIBO_YMD_3
, EKK2081A010CBSMsg1List.WAO_KOJI_KIBO_TIMEZ_3
, EKK2081A010CBSMsg1List.WAO_KOCOMP_RRK_JIKO
, EKK2081A010CBSMsg1List.WAO_TENYO_DIV
, EKK2081A010CBSMsg1List.WAO_TENYO_SHODAKU_NO
, EKK2081A010CBSMsg1List.WAO_YK_KIGEN
, EKK2081A010CBSMsg1List.WAO_AD_BNCHI_MEMO
, EKK2081A010CBSMsg1List.ITENM_SVC_KEI_NO
// ANK-4427-00-00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK2081A010CBSMsg1List",0);
// inMsg(CBSMsg)に明細をセット
inMsg.set("EKK2081A010CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EKK2081A010CBSMsg.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(EKK2081A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}