/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEKK2211B010TPDA
* ソースファイル名：JSYejbEKK2211B010TPDA.java
* 作成者 ：EK942336
* 日付 ：2018年09月25日
*＜機能概要＞
* 申込保留内容サービス契約一時保存一覧照会テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* ｖ5.00.00 2013/03/06 FJ）三浦【ANK-1421-00-00】IP_STB
* ｖ32.00.00 2017/04/03 FJ）笠川【ANK-3149-00-00】新セキュリティパック導入
* ｖ31.00.00 2017/11/30 FJ）麻生【ANK-3136-00-00】OPMSハードウエア保守切れ対応(STEP2-2)
* ｖ39.00.00 2018/09/25 FJ）三原【ANK-3484-00-00】端末補償サービス導入対応
* v52.00.00 2021/01/06 FJ) 西窪【ANK-3987-00-00】Netflix導入対応（STEP2）
* ｖ52.00.01 2021/01/14 FJ)星野 【ANK-3910-00-00】定額サービスリース品追加対応
* ｖ57.00.00 2021/02/04 FJ) 吉村【ANK-4088-00-00】宅内調査の日程調整業務における省人化施策(Step2)
* ｖ73.00.00 2024/10/22 FJ) 森下【ANK-4427-00-00】NTT卸対応
* ｖ75.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.EKK2211B010CBSMsg;
import eo.ejb.cbs.cbsmsg.EKK2211B010CBSMsg1List;
import eo.ejb.cbm.entity.KK2211ETMsg;
/**
*
* テンプレートDBアクセス部品 EKK2211B010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEKK2211B010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEKK2211B010TPDA() {
}
/**
* EKK2211B010_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(KK2211ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" KK2211.MSKM_PNY_TPPV_NO, ")
.append(" KK2211.MPNY_SVKEI_TPPV_NO, ")
.append(" KK2211.MSKM_TG_SVC_SBT_CD, ")
.append(" KK2211.PRC_GRP_CD, ")
.append(" KK2211.PCRS_CD, ")
.append(" KK2211.PPLAN_CD, ")
.append(" KK2211.SVC_STA_KIBO_YMD_YEAR, ")
.append(" KK2211.SVC_STA_KIBO_YMD_MON, ")
.append(" KK2211.SVC_STA_KIBO_YMD_DAY, ")
.append(" KK2211.USE_SVC_KEIZK_SBT_CD, ")
.append(" KK2211.OP_SVC_HKTGI_UM, ")
.append(" KK2211.VDSL_MODEM_KKTK_SBT_CD, ")
.append(" KK2211.FAMILY_PACK_MSKM_UM, ")
.append(" KK2211.EOH_ROUTER_RENT_MKM_UM, ")
.append(" KK2211.RMTSPRT_PLUS_MSKM_UM, ")
.append(" KK2211.EOH_PLC_ADAPT_RENT_MSKM_UM, ")
.append(" KK2211.TABLET_BUY_MKM_UM, ")
.append(" KK2211.PREMIUM_OP_MKM_UM, ")
.append(" KK2211.RE_SEND_TK_SVC_SBT_CD, ")
.append(" KK2211.DMPS_ANKEN_NO, ")
.append(" KK2211.STB_MSKM_CNT, ")
.append(" KK2211.STB_KIND_CD, ")
.append(" KK2211.STB_BETU_EOHTV_PCRS_CD, ")
.append(" KK2211.LINK_STB_KIBO_UM, ")
.append(" KK2211.CABLE_GUIDE_MSKM_CNT, ")
.append(" KK2211.MBL_KIKI_SHS_AD_SKBT_CD, ")
.append(" KK2211.MBKIKSHS_AD_MAN_INPUT_UM, ")
.append(" KK2211.MOBILE_KIKI_SHS_AD_CD, ")
.append(" KK2211.MOBILE_KIKI_SHS_PCD_BF, ")
.append(" KK2211.MOBILE_KIKI_SHS_PCD_AF, ")
.append(" KK2211.MOBILE_KIKI_SHS_STATE_NM, ")
.append(" KK2211.MOBILE_KIKI_SHS_CITY_NM, ")
.append(" KK2211.MOBILE_KIKI_SHS_OAZTSU_NM, ")
.append(" KK2211.MOBILE_KIKI_SHS_AZCHO_NM, ")
.append(" KK2211.MOBILE_KIKI_SHS_BNCHIGO, ")
.append(" KK2211.MOBILE_KIKI_SHS_ADRTTM, ")
.append(" KK2211.MOBILE_KIKI_SHS_ADRRM, ")
.append(" KK2211.MOBILE_KIKI_SOHUS_FSTNM, ")
.append(" KK2211.MOBILE_KIKI_SOHUS_KANA, ")
.append(" KK2211.MOBILE_KIKI_SOHUS_TELNO, ")
.append(" KK2211.WORK_RRK_BIKO, ")
.append(" KK2211.AREA_CKRLT_CD, ")
.append(" KK2211.AREA_CKRLT_UM, ")
.append(" KK2211.AREA_CKRLT_DTAIL_CD, ")
.append(" KK2211.ADD_DTM, ")
.append(" KK2211.ADD_OPEACNT, ")
.append(" KK2211.UPD_DTM, ")
.append(" KK2211.UPD_OPEACNT, ")
.append(" KK2211.DEL_DTM, ")
.append(" KK2211.DEL_OPEACNT, ")
.append(" KK2211.MK_FLG, ")
.append(" KK2211.TABLET_TAKNKIKI_MODEL_CD, ")
.append(" KK2211.TABLET_KAP_HAMBAI_FORM_CD, ")
.append(" KK2211.TNMT_BUY_UK_TNTSHA_NM, ")
.append(" KK2211.IPSTB_RENT_MSKM_UM, ")
.append(" KK2211.IPSTB_RENT_MSKM_CNT, ")
.append(" KK2211.TABLET_TNMT_COMPS_MKM_UM, ")
//20170403 ANK-3149-00-00 MOD START
// .append(" KK2211.CDBS_STCH_SET_MSKM_UM ")
.append(" KK2211.CDBS_STCH_SET_MSKM_UM, ")
//20170403 ANK-3149-00-00 MOD END
//20170403 ANK-3149-00-00 ADD START
.append(" KK2211.SECURITY_PACK_MSKM_UM, ")
.append(" KK2211.INETSGWL_MSKM_UM, ")
// ANK-3136-00-00 DEL START
// .append(" KK2211.NTFMLPRM_MSKM_UM ")
// ANK-3136-00-00 DEL END
//20170403 ANK-3149-00-00 ADD END
// ANK-3136-00-00 ADD START
.append(" KK2211.NTFMLPRM_MSKM_UM, ")
.append(" KK2211.TSYRN_KJ_RRKS_NM, ")
.append(" KK2211.TSYRN_KJ_RRKS_TLN, ")
.append(" KK2211.TSYRN_TAKCHO_JI_RRKS_NM, ")
.append(" KK2211.TSYRN_TAKCHO_JI_RRKS_TLN, ")
.append(" KK2211.TSYRN_RRK_KIBO_DATE, ")
.append(" KK2211.TSYRN_TAKCHO_YH, ")
.append(" KK2211.TSYRN_MAP_UM, ")
.append(" KK2211.TSYRN_KZN_KEI_INF, ")
.append(" KK2211.TSYRN_HBI_KAISHOU_YMD, ")
.append(" KK2211.EQUIP_RYUYO_UM, ")
.append(" KK2211.RYUYO_MOTO_KJAK_NO, ")
// ANK-3484-00-00 MOD START
//.append(" KK2211.SBRY_KJ_FIN_KIBOYMD ")
.append(" KK2211.SBRY_KJ_FIN_KIBOYMD, ")
// ANK-3484-00-00 MOD END
// ANK-3136-00-00 ADD END
// ANK-3484-00-00 ADD START
.append(" KK2211.TMCP_PC_PLAN_KEI_UM, ")
.append(" KK2211.TMCP_PC_WIDE_PLAN_KEI_UM, ")
// ANK-3987-00-00 MOD START
// .append(" KK2211.TMCP_TV_PLAN_KEI_UM ")
.append(" KK2211.TMCP_TV_PLAN_KEI_UM, ")
// ANK-3910-00-00対応 20210114 星野 ADD START
.append(" KK2211.TEGAK_SVC_MSKM_KIKI, ")
// ANK-3910-00-00対応 20210114 星野 ADD END
.append(" KK2211.SMP_TAKNKIKI_MODEL_CD, ")
// ANK-4088-00-00 MOD START
// .append(" KK2211.SMP_BUY_UK_TNTSHA_NM ")
// ANK-3987-00-00 MOD END
.append(" KK2211.SMP_BUY_UK_TNTSHA_NM, ")
// ANK-4427-00-00 MOD START
// .append(" KK2211.TAKCHO_APO_KADEN_KIBO_UM ")
.append(" KK2211.TAKCHO_APO_KADEN_KIBO_UM, ")
// ANK-4427-00-00 MOD END
// ANK-4088-00-00 MOD END
// ANK-3484-00-00 ADD END
// ANK-4427-00-00 ADD START
.append(" KK2211.TYPEN_TEL_SVC_MKUM, ")
.append(" KK2211.TYPEN_TELNO, ")
.append(" KK2211.TYPEN_BMP_SBT, ")
.append(" KK2211.TYPEN_KEISHA_NM, ")
.append(" KK2211.TYPEN_AD_CD, ")
.append(" KK2211.TYPEN_PCD, ")
.append(" KK2211.TYPEN_STATE_NM, ")
.append(" KK2211.TYPEN_CITY_NM, ")
.append(" KK2211.TYPEN_OAZTSU_NM, ")
.append(" KK2211.TYPEN_AZCHO_NM, ")
.append(" KK2211.TYPEN_BNCHIGO, ")
.append(" KK2211.TYPEN_ADRTTM, ")
.append(" KK2211.TYPEN_ADRRM, ")
.append(" KK2211.TYPEN_AD_MAN_INPUT_FLG, ")
.append(" KK2211.TYPEN_TEL_KNKN_TRAT_CD, ")
.append(" KK2211.TYPEN_TELNO_SBT_CD, ")
.append(" KK2211.HSNSH_NO_DSP_UM, ")
.append(" KK2211.HITCHI_INCMHI_UM, ")
.append(" KK2211.HSNSH_NO_TCH_UM, ")
// ANK-4640-00-00 MOD START
// .append(" KK2211.KKSI_TEL_USE_YOKSI_UM ")
// ANK-4427-00-00 ADD END
.append(" KK2211.KKSI_TEL_USE_YOKSI_UM, ")
// ANK-4640-00-00 MOD END
// ANK-4640-00-00 ADD START
.append(" KK2211.TYPEN_TSJGS_CD ")
// ANK-4640-00-00 ADD END
.append(" FROM ")
.append(" KK_T_MPNY_SVKEI_TPPV KK2211 ");
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(EKK2211B010CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" KK2211.MSKM_PNY_TPPV_NO = ? AND ");
/* 20120307 ADD START*/
if(!inMsg.isNull((EKK2211B010CBSMsg.KEY_MPNY_SVKEI_TPPV_NO))){
sql_Buff.append(" KK2211.MPNY_SVKEI_TPPV_NO = ? AND ");
}
/* 20120307 ADD END */
sql_Buff.append(" KK2211.MK_FLG = '0' ")
.append(" ORDER BY ")
.append(" KK2211.MSKM_PNY_TPPV_NO, ")
.append(" KK2211.MPNY_SVKEI_TPPV_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(EKK2211B010CBSMsg.FUNC_CODE) ) )
{
// パラメータの設定(ＫＥＹ＿申込保留内容一時保存番号を指定)
CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(EKK2211B010CBSMsg.KEY_MSKM_PNY_TPPV_NO));
if(!inMsg.isNull( (EKK2211B010CBSMsg.KEY_MPNY_SVKEI_TPPV_NO)))
{
// パラメータの設定(ＫＥＹ＿申込保留内容サービス契約一時保存番号を指定)
CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(EKK2211B010CBSMsg.KEY_MPNY_SVKEI_TPPV_NO));
}
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EKK2211B010CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EKK2211B010CBSMsg1List.MSKM_PNY_TPPV_NO
, EKK2211B010CBSMsg1List.MPNY_SVKEI_TPPV_NO
, EKK2211B010CBSMsg1List.MSKM_TG_SVC_SBT_CD
, EKK2211B010CBSMsg1List.PRC_GRP_CD
, EKK2211B010CBSMsg1List.PCRS_CD
, EKK2211B010CBSMsg1List.PPLAN_CD
, EKK2211B010CBSMsg1List.SVC_STA_KIBO_YMD_YEAR
, EKK2211B010CBSMsg1List.SVC_STA_KIBO_YMD_MON
, EKK2211B010CBSMsg1List.SVC_STA_KIBO_YMD_DAY
, EKK2211B010CBSMsg1List.USE_SVC_KEIZK_SBT_CD
, EKK2211B010CBSMsg1List.OP_SVC_HKTGI_UM
, EKK2211B010CBSMsg1List.VDSL_MODEM_KKTK_SBT_CD
, EKK2211B010CBSMsg1List.FAMILY_PACK_MSKM_UM
, EKK2211B010CBSMsg1List.EOH_ROUTER_RENT_MKM_UM
, EKK2211B010CBSMsg1List.RMTSPRT_PLUS_MSKM_UM
, EKK2211B010CBSMsg1List.EOH_PLC_ADAPT_RENT_MSKM_UM
, EKK2211B010CBSMsg1List.TABLET_BUY_MKM_UM
, EKK2211B010CBSMsg1List.PREMIUM_OP_MKM_UM
, EKK2211B010CBSMsg1List.RE_SEND_TK_SVC_SBT_CD
, EKK2211B010CBSMsg1List.DMPS_ANKEN_NO
, EKK2211B010CBSMsg1List.STB_MSKM_CNT
, EKK2211B010CBSMsg1List.STB_KIND_CD
, EKK2211B010CBSMsg1List.STB_BETU_EOHTV_PCRS_CD
, EKK2211B010CBSMsg1List.LINK_STB_KIBO_UM
, EKK2211B010CBSMsg1List.CABLE_GUIDE_MSKM_CNT
, EKK2211B010CBSMsg1List.MBL_KIKI_SHS_AD_SKBT_CD
, EKK2211B010CBSMsg1List.MBKIKSHS_AD_MAN_INPUT_UM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_AD_CD
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_PCD_BF
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_PCD_AF
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_STATE_NM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_CITY_NM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_OAZTSU_NM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_AZCHO_NM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_BNCHIGO
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_ADRTTM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SHS_ADRRM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SOHUS_FSTNM
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SOHUS_KANA
, EKK2211B010CBSMsg1List.MOBILE_KIKI_SOHUS_TELNO
, EKK2211B010CBSMsg1List.WORK_RRK_BIKO
, EKK2211B010CBSMsg1List.AREA_CKRLT_CD
, EKK2211B010CBSMsg1List.AREA_CKRLT_UM
, EKK2211B010CBSMsg1List.AREA_CKRLT_DTAIL_CD
, EKK2211B010CBSMsg1List.ADD_DTM
, EKK2211B010CBSMsg1List.ADD_OPEACNT
, EKK2211B010CBSMsg1List.UPD_DTM
, EKK2211B010CBSMsg1List.UPD_OPEACNT
, EKK2211B010CBSMsg1List.DEL_DTM
, EKK2211B010CBSMsg1List.DEL_OPEACNT
, EKK2211B010CBSMsg1List.MK_FLG
, EKK2211B010CBSMsg1List.TABLET_TAKNKIKI_MODEL_CD
, EKK2211B010CBSMsg1List.TABLET_KAP_HAMBAI_FORM_CD
, EKK2211B010CBSMsg1List.TNMT_BUY_UK_TNTSHA_NM
, EKK2211B010CBSMsg1List.IPSTB_RENT_MSKM_UM
, EKK2211B010CBSMsg1List.IPSTB_RENT_MSKM_CNT
, EKK2211B010CBSMsg1List.TABLET_TNMT_COMPS_MKM_UM
, EKK2211B010CBSMsg1List.CDBS_STCH_SET_MSKM_UM
//20170403 ANK-3149-00-00 ADD START
, EKK2211B010CBSMsg1List.SECURITY_PACK_MSKM_UM
, EKK2211B010CBSMsg1List.INETSGWL_MSKM_UM
, EKK2211B010CBSMsg1List.NTFMLPRM_MSKM_UM
//20170403 ANK-3149-00-00 ADD END
// ANK-3136-00-00 ADD START
, EKK2211B010CBSMsg1List.TSYRN_KJ_RRKS_NM
, EKK2211B010CBSMsg1List.TSYRN_KJ_RRKS_TLN
, EKK2211B010CBSMsg1List.TSYRN_TAKCHO_JI_RRKS_NM
, EKK2211B010CBSMsg1List.TSYRN_TAKCHO_JI_RRKS_TLN
, EKK2211B010CBSMsg1List.TSYRN_RRK_KIBO_DATE
, EKK2211B010CBSMsg1List.TSYRN_TAKCHO_YH
, EKK2211B010CBSMsg1List.TSYRN_MAP_UM
, EKK2211B010CBSMsg1List.TSYRN_KZN_KEI_INF
, EKK2211B010CBSMsg1List.TSYRN_HBI_KAISHOU_YMD
, EKK2211B010CBSMsg1List.EQUIP_RYUYO_UM
, EKK2211B010CBSMsg1List.RYUYO_MOTO_KJAK_NO
, EKK2211B010CBSMsg1List.SBRY_KJ_FIN_KIBOYMD
// ANK-3136-00-00 ADD END
// ANK-3484-00-00 ADD START
, EKK2211B010CBSMsg1List.TMCP_PC_PLAN_KEI_UM
, EKK2211B010CBSMsg1List.TMCP_PC_WIDE_PLAN_KEI_UM
, EKK2211B010CBSMsg1List.TMCP_TV_PLAN_KEI_UM
// ANK-3484-00-00 ADD END
// ANK-3910-00-00対応 20210114 星野 ADD START
, EKK2211B010CBSMsg1List.TEGAK_SVC_MSKM_KIKI
// ANK-3910-00-00対応 20210114 星野 ADD END
// ANK-3987-00-00 ADD START
, EKK2211B010CBSMsg1List.SMP_TAKNKIKI_MODEL_CD
, EKK2211B010CBSMsg1List.SMP_BUY_UK_TNTSHA_NM
// ANK-3987-00-00 ADD END
// ANK-4088-00-00 ADD START
, EKK2211B010CBSMsg1List.TAKCHO_APO_KADEN_KIBO_UM
// ANK-4088-00-00 ADD END
// ANK-4427-00-00 ADD START
, EKK2211B010CBSMsg1List.TYPEN_TEL_SVC_MKUM
, EKK2211B010CBSMsg1List.TYPEN_TELNO
, EKK2211B010CBSMsg1List.TYPEN_BMP_SBT
, EKK2211B010CBSMsg1List.TYPEN_KEISHA_NM
, EKK2211B010CBSMsg1List.TYPEN_AD_CD
, EKK2211B010CBSMsg1List.TYPEN_PCD
, EKK2211B010CBSMsg1List.TYPEN_STATE_NM
, EKK2211B010CBSMsg1List.TYPEN_CITY_NM
, EKK2211B010CBSMsg1List.TYPEN_OAZTSU_NM
, EKK2211B010CBSMsg1List.TYPEN_AZCHO_NM
, EKK2211B010CBSMsg1List.TYPEN_BNCHIGO
, EKK2211B010CBSMsg1List.TYPEN_ADRTTM
, EKK2211B010CBSMsg1List.TYPEN_ADRRM
, EKK2211B010CBSMsg1List.TYPEN_AD_MAN_INPUT_FLG
, EKK2211B010CBSMsg1List.TYPEN_TEL_KNKN_TRAT_CD
, EKK2211B010CBSMsg1List.TYPEN_TELNO_SBT_CD
, EKK2211B010CBSMsg1List.HSNSH_NO_DSP_UM
, EKK2211B010CBSMsg1List.HITCHI_INCMHI_UM
, EKK2211B010CBSMsg1List.HSNSH_NO_TCH_UM
, EKK2211B010CBSMsg1List.KKSI_TEL_USE_YOKSI_UM
// ANK-4427-00-00 ADD END
// ANK-4640-00-00 ADD START
, EKK2211B010CBSMsg1List.TYPEN_TSJGS_CD
// ANK-4640-00-00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK2211B010CBSMsg1List",0);
// inMsg(CBSMsg)に明細をセット
inMsg.set("EKK2211B010CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EKK2211B010CBSMsg.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(EKK2211B010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}