/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEKK0321B508TPDA
* ソースファイル名：JSYejbEKK0321B508TPDA.java
* 作成者 ：EK909633
* 日付 ：2013年12月13日
*＜機能概要＞
* 課金先一覧照会（MVNO用）テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* ｖ8.00.00 2014/03/10 FJ）宇野 ST-2014-0000079
* ｖ71.00.00 2024/03/24 GDC)CE.Poblete 「ANK-4543-00-00」NTT卸対応：Step0
* v73.00.00 2024/06/24 GDC)v.auditor 【ANK-4427-00-00】NTT卸対応：Step1
*
********************************************************************************/
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.EKK0321B508CBSMsg;
import eo.ejb.cbs.cbsmsg.EKK0321B508CBSMsg1List;
import eo.ejb.cbm.entity.KK0321ETMsg;
import eo.ejb.common.JKKModelCommon;
/**
*
* テンプレートDBアクセス部品 EKK0321B508_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEKK0321B508TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEKK0321B508TPDA() {
}
/**
* EKK0321B508_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void
*/
public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){
// コネクション
Connection con1 = null;
// プリペアステートメント
PreparedStatement pstmt = null;
// リザルトセット
ResultSet rsltQuery = null;
// パラメータのカウント
int iPCnt = 0;
// 運用日付
String sOpeDate = JKKModelCommon.getOpeDate(inMsg);
/********************
* SQL文の作成
********************/
try{
//コネクション取得
con1 = JSYejbConnection.getConnection(KK0321ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" KAKINS_MAIN.SVC_KEI_NO ")
.append(" ,KAKINS_MAIN.SVC_KEI_STAT ")
.append(" ,KAKINS_MAIN.SEIKY_KEI_NO ")
.append(" ,KAKINS_MAIN.SEIKY_WAY_CD ")
.append(" ,KAKINS_MAIN.SEIKY_KEI_KANA ")
.append(" ,KAKINS_MAIN.CRECARD_COMP_NM ")
.append(" ,KAKINS_MAIN.BANK_NM ")
.append(" ,KAKINS_MAIN.NEW_CD ")
// ANK 4543-00-00 MOD START
//.append(" ,KAKINS_MAIN.PRC_GRP_NM ")
// ANK-4427-00-00 MOD START
//.append(",(CASE ")
.append(" ,CASE ")
.append(" WHEN (SELECT KK0791.NTTORS_DIV FROM KK_M_PCRS KK0791 WHERE KK0791.PCRS_CD = KAKINS_MAIN.PCRS_CD) IS NOT NULL")
.append(" THEN (SELECT ZM0321.WORK_PARAM_SETTE_VALUE FROM ZM_M_WORK_PARAM_KNRI ZM0321")
.append(" WHERE ZM0321.WORK_PARAM_ID = 'KK_NTTORS_C_GRPNM_01'")
.append(" ) ELSE(")
.append(" CASE ")
// ANK-4427-00-00 MOD END
.append(" WHEN EXISTS(SELECT 1 FROM KK_T_NTTORS_KEI KK3511 where KK3511.SVC_KEI_NO = KAKINS_MAIN.SVC_KEI_NO) ")
.append(" THEN ")
.append(" (SELECT KK3521.PRC_GRP_NM ")
.append(" FROM KK_T_NTTORS_KEI KK3511")
.append(" INNER JOIN KK_M_NTTORS_PCRS KK3521 ON KK3511.NTTORS_SVC_SBT = KK3521.NTTORS_SVC_SBT ")
.append(" WHERE ")
.append(" KK3511.GENE_ADD_DTM = (SELECT MAX(GENE_ADD_DTM) ")
.append(" FROM KK_T_NTTORS_KEI KK3511_GENE ")
.append(" WHERE ")
.append(" KK3511.SVC_KEI_NO = KK3511_GENE.SVC_KEI_NO ")
.append(" AND KK3511.MK_FLG = 0 ")
.append(" GROUP BY SVC_KEI_NO) ")
.append(" AND KK3511.SVC_KEI_NO = KAKINS_MAIN.SVC_KEI_NO) ")
.append(" ELSE KAKINS_MAIN.PRC_GRP_NM ")
// ANK-4427-00-00 MOD START
//.append(" END)PRC_GRP_NM ")
.append(" END")
.append(" )END AS PRC_GRP_NM ")
// ANK-4427-00-00 MOD END
// ANK 4543-00-00 MOD END
.append(" FROM ")
.append(" (SELECT ")
.append(" ROW_NUMBER() OVER (PARTITION BY KAKINS.SVC_KEI_NO,KAKINS.SEIKY_KEI_NO ORDER BY KAKINS.RSV_APLY_YMD DESC,KAKINS.GENE_ADD_DTM DESC) AS LINE ")
.append(" ,KAKINS.SVC_KEI_NO ")
.append(" ,KAKINS.SVC_KEI_STAT ")
.append(" ,KAKINS.SEIKY_KEI_NO ")
.append(" ,KAKINS.SEIKY_WAY_CD ")
.append(" ,KAKINS.SEIKY_KEI_KANA ")
.append(" ,KAKINS.CRECARD_COMP_NM ")
.append(" ,KAKINS.BANK_NM ")
.append(" ,KAKINS.NEW_CD ")
.append(" ,KAKINS.PRC_GRP_NM ")
// ANK-4427-00-00 ADD START
.append(" ,KAKINS.PCRS_CD ")
// ANK-4427-00-00 ADD END
.append(" ,KAKINS.RSV_APLY_YMD ")
.append(" ,KAKINS.GENE_ADD_DTM ")
.append(" FROM ")
.append(" (SELECT ")
.append(" KK0081.SVC_KEI_NO ")
.append(" ,KK0081.SVC_KEI_STAT ")
.append(" ,KK0491.SEIKY_KEI_NO ")
.append(" ,KK0491.SEIKY_WAY_CD ")
.append(" ,KK0491.SEIKY_KEI_KANA ")
.append(" ,KK0531.CRECARD_COMP_NM ")
.append(" ,NULL AS BANK_NM ")
.append(" ,NULL AS NEW_CD ")
.append(" ,KK0781.PRC_GRP_NM ")
// ANK-4427-00-00 ADD START
.append(" ,KK0081.PCRS_CD ")
// ANK-4427-00-00 ADD END
.append(" ,KK0491.RSV_APLY_YMD ")
.append(" ,KK0491.GENE_ADD_DTM ")
.append(" FROM ")
.append(" KK_T_SVC_KEI KK0081 ")
.append(" INNER JOIN KK_M_PRC_GRP KK0781 ")
.append(" ON KK0081.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" INNER JOIN KK_T_KAKINS KK0321 ")
.append(" ON KK0081.SVC_KEI_NO = KK0321.SVC_KEI_NO ")
.append(" INNER JOIN KK_T_SEIKY_KEI KK0491 ")
.append(" ON KK0321.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO ")
.append(" INNER JOIN KK_T_CRECARD KK0521 ")
.append(" ON KK0491.SEIKY_WAY_NO_CRECARD = KK0521.SEIKY_WAY_NO_CRECARD ")
.append(" INNER JOIN KK_M_CRECARD_COMP KK0531 ")
.append(" ON KK0521.CRECARD_COMP_CD = KK0531.CRECARD_COMP_CD ")
.append(" AND KK0521.CRECARD_JIGYO_CD = KK0531.CRECARD_JIGYO_CD ")
.append(" WHERE ")
.append(" KK0081.SYSID = ? ")
.append(" AND KK0081.SVC_KEI_STAT <> '920' ")
.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) AS KK0081_MAX ")
.append(" FROM KK_T_SVC_KEI KK0081_GENE ")
.append(" WHERE 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(" AND (KK0781.PRC_GRP_CD, KK0781.RSV_APLY_YMD || KK0781.GENE_ADD_DTM) = ")
.append(" (SELECT KK0781_GENE.PRC_GRP_CD,MAX(KK0781_GENE.RSV_APLY_YMD || KK0781_GENE.GENE_ADD_DTM) AS KK0781_MAX ")
.append(" FROM KK_M_PRC_GRP KK0781_GENE ")
.append(" WHERE KK0781_GENE.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KK0781_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0781_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0781_GENE.PRC_GRP_CD ) ")
.append(" AND KK0321.KAKINS_TSTAYMD <= ? ")
.append(" AND KK0321.KAKINS_TENDYMD >= ? ")
.append(" AND KK0321.MK_FLG = '0' ")
.append(" AND (KK0491.SEIKY_KEI_NO, KK0491.RSV_APLY_YMD || KK0491.GENE_ADD_DTM) = ")
.append(" (SELECT KK0491_GENE.SEIKY_KEI_NO, MAX(KK0491_GENE.RSV_APLY_YMD || KK0491_GENE.GENE_ADD_DTM) AS KK0491_MAX ")
.append(" FROM KK_T_SEIKY_KEI KK0491_GENE ")
.append(" WHERE KK0491_GENE.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO ")
.append(" AND KK0491_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0491_GENE.RSV_APLY_CD = '2' ")
.append(" AND KK0491_GENE.SEIKY_WAY_CD = '4' ")
.append(" AND KK0491_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0491_GENE.SEIKY_KEI_NO) ")
.append(" AND (KK0521.SEIKY_WAY_NO_CRECARD, KK0521.GENE_ADD_DTM) = ")
.append(" (SELECT KK0521_GENE.SEIKY_WAY_NO_CRECARD, MAX(KK0521_GENE.GENE_ADD_DTM) AS KK0521_MAX ")
.append(" FROM KK_T_CRECARD KK0521_GENE ")
.append(" WHERE KK0521_GENE.SEIKY_WAY_NO_CRECARD = KK0521.SEIKY_WAY_NO_CRECARD ")
.append(" AND KK0521_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0521_GENE.SEIKY_WAY_NO_CRECARD) ")
.append(" AND (KK0531.CRECARD_COMP_CD, KK0531.CRECARD_JIGYO_CD, KK0531.RSV_APLY_YMD || KK0531.GENE_ADD_DTM) = ")
.append(" (SELECT KK0531_GENE.CRECARD_COMP_CD, KK0531_GENE.CRECARD_JIGYO_CD, MAX(KK0531_GENE.RSV_APLY_YMD || KK0531_GENE.GENE_ADD_DTM) AS KK0531_MAX ")
.append(" FROM KK_M_CRECARD_COMP KK0531_GENE ")
.append(" WHERE KK0531_GENE.CRECARD_COMP_CD = KK0531.CRECARD_COMP_CD ")
.append(" AND KK0531_GENE.CRECARD_JIGYO_CD = KK0531.CRECARD_JIGYO_CD ")
.append(" AND KK0531_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0531_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0531_GENE.CRECARD_COMP_CD, KK0531_GENE.CRECARD_JIGYO_CD) ")
.append(" UNION ")
.append(" SELECT ")
.append(" KK0081.SVC_KEI_NO ")
.append(" ,KK0081.SVC_KEI_STAT ")
.append(" ,KK0491.SEIKY_KEI_NO ")
.append(" ,KK0491.SEIKY_WAY_CD ")
.append(" ,KK0491.SEIKY_KEI_KANA ")
.append(" ,NULL AS CRECARD_COMP_NM ")
.append(" ,KK0511.BANK_NM ")
.append(" ,KK0501.NEW_CD ")
.append(" ,KK0781.PRC_GRP_NM ")
// ANK-4427-00-00 ADD START
.append(" ,KK0081.PCRS_CD ")
// ANK-4427-00-00 ADD END
.append(" ,KK0491.RSV_APLY_YMD ")
.append(" ,KK0491.GENE_ADD_DTM ")
.append(" FROM ")
.append(" KK_T_SVC_KEI KK0081 ")
.append(" INNER JOIN KK_M_PRC_GRP KK0781 ")
.append(" ON KK0081.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" INNER JOIN KK_T_KAKINS KK0321 ")
.append(" ON KK0081.SVC_KEI_NO = KK0321.SVC_KEI_NO ")
.append(" INNER JOIN KK_T_SEIKY_KEI KK0491 ")
.append(" ON KK0321.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO ")
.append(" INNER JOIN KK_T_KOZA KK0501 ")
.append(" ON KK0491.SEIKY_WAY_NO_KOZA = KK0501.SEIKY_WAY_NO_KOZA ")
.append(" INNER JOIN KK_M_BANK KK0511 ")
.append(" ON KK0501.BANK_CD = KK0511.BANK_CD ")
.append(" AND KK0501.BANK_SHITEN_CD = KK0511.BANK_SHITEN_CD ")
.append(" WHERE ")
.append(" KK0081.SYSID = ? ")
.append(" AND KK0081.SVC_KEI_STAT <> '920' ")
.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) AS KK0081_MAX ")
.append(" FROM KK_T_SVC_KEI KK0081_GENE ")
.append(" WHERE 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(" AND (KK0781.PRC_GRP_CD, KK0781.RSV_APLY_YMD || KK0781.GENE_ADD_DTM) = ")
.append(" (SELECT KK0781_GENE.PRC_GRP_CD,MAX(KK0781_GENE.RSV_APLY_YMD || KK0781_GENE.GENE_ADD_DTM) AS KK0781_MAX ")
.append(" FROM KK_M_PRC_GRP KK0781_GENE ")
.append(" WHERE KK0781_GENE.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KK0781_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0781_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0781_GENE.PRC_GRP_CD ) ")
.append(" AND KK0321.KAKINS_TSTAYMD <= ? ")
.append(" AND KK0321.KAKINS_TENDYMD >= ? ")
.append(" AND KK0321.MK_FLG = '0' ")
.append(" AND (KK0491.SEIKY_KEI_NO, KK0491.RSV_APLY_YMD || KK0491.GENE_ADD_DTM) = ")
.append(" (SELECT KK0491_GENE.SEIKY_KEI_NO, MAX(KK0491_GENE.RSV_APLY_YMD || KK0491_GENE.GENE_ADD_DTM) AS KK0491_MAX ")
.append(" FROM KK_T_SEIKY_KEI KK0491_GENE ")
.append(" WHERE KK0491_GENE.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO ")
.append(" AND KK0491_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0491_GENE.RSV_APLY_CD = '2' ")
.append(" AND KK0491_GENE.SEIKY_WAY_CD IN ('2','3') ")
.append(" AND KK0491_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0491_GENE.SEIKY_KEI_NO) ")
.append(" AND (KK0501.SEIKY_WAY_NO_KOZA, KK0501.GENE_ADD_DTM) = ")
.append(" (SELECT KK0501_GENE.SEIKY_WAY_NO_KOZA, MAX(KK0501_GENE.GENE_ADD_DTM) AS KK0501_MAX ")
.append(" FROM KK_T_KOZA KK0501_GENE ")
.append(" WHERE KK0501_GENE.SEIKY_WAY_NO_KOZA = KK0501.SEIKY_WAY_NO_KOZA ")
.append(" AND KK0501_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0501_GENE.SEIKY_WAY_NO_KOZA) ")
.append(" AND (KK0511.BANK_CD, KK0511.BANK_SHITEN_CD, KK0511.RSV_APLY_YMD || KK0511.GENE_ADD_DTM) = ")
.append(" (SELECT KK0511_GENE.BANK_CD, KK0511_GENE.BANK_SHITEN_CD, MAX(KK0511_GENE.RSV_APLY_YMD || KK0511_GENE.GENE_ADD_DTM) AS KK0511_MAX ")
.append(" FROM KK_M_BANK KK0511_GENE ")
.append(" WHERE KK0511_GENE.BANK_CD = KK0511.BANK_CD ")
.append(" AND KK0511_GENE.BANK_SHITEN_CD = KK0511.BANK_SHITEN_CD ")
.append(" AND KK0511_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0511_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0511_GENE.BANK_CD, KK0511_GENE.BANK_SHITEN_CD) ")
.append(" UNION ")
.append(" SELECT ")
.append(" KK0081.SVC_KEI_NO ")
.append(" ,KK0081.SVC_KEI_STAT ")
.append(" ,KK0491.SEIKY_KEI_NO ")
.append(" ,KK0491.SEIKY_WAY_CD ")
.append(" ,KK0491.SEIKY_KEI_KANA ")
.append(" ,NULL AS CRECARD_COMP_NM ")
.append(" ,NULL AS BANK_NM ")
.append(" ,NULL AS NEW_CD ")
.append(" ,KK0781.PRC_GRP_NM ")
// ANK-4427-00-00 ADD START
.append(" ,KK0081.PCRS_CD ")
// ANK-4427-00-00 ADD END
.append(" ,KK0491.RSV_APLY_YMD ")
.append(" ,KK0491.GENE_ADD_DTM ")
.append(" FROM ")
.append(" KK_T_SVC_KEI KK0081 ")
.append(" INNER JOIN KK_M_PRC_GRP KK0781 ")
.append(" ON KK0081.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" INNER JOIN KK_T_KAKINS KK0321 ")
.append(" ON KK0081.SVC_KEI_NO = KK0321.SVC_KEI_NO ")
.append(" INNER JOIN KK_T_SEIKY_KEI KK0491 ")
.append(" ON KK0321.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO ");
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(EKK0321B508CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" KK0081.SYSID = ? ")
.append(" AND KK0081.SVC_KEI_STAT <> '920' ")
.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) AS KK0081_MAX ")
.append(" FROM KK_T_SVC_KEI KK0081_GENE ")
.append(" WHERE 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(" AND (KK0781.PRC_GRP_CD, KK0781.RSV_APLY_YMD || KK0781.GENE_ADD_DTM) = ")
.append(" (SELECT KK0781_GENE.PRC_GRP_CD,MAX(KK0781_GENE.RSV_APLY_YMD || KK0781_GENE.GENE_ADD_DTM) AS KK0781_MAX ")
.append(" FROM KK_M_PRC_GRP KK0781_GENE ")
.append(" WHERE KK0781_GENE.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KK0781_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0781_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0781_GENE.PRC_GRP_CD ) ")
.append(" AND KK0321.KAKINS_TSTAYMD <= ? ")
.append(" AND KK0321.KAKINS_TENDYMD >= ? ")
.append(" AND KK0321.MK_FLG = '0' ")
.append(" AND (KK0491.SEIKY_KEI_NO, KK0491.RSV_APLY_YMD || KK0491.GENE_ADD_DTM) = ")
.append(" (SELECT KK0491_GENE.SEIKY_KEI_NO, MAX(KK0491_GENE.RSV_APLY_YMD || KK0491_GENE.GENE_ADD_DTM) AS KK0491_MAX ")
.append(" FROM KK_T_SEIKY_KEI KK0491_GENE ")
.append(" WHERE KK0491_GENE.SEIKY_KEI_NO = KK0491.SEIKY_KEI_NO ")
.append(" AND KK0491_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0491_GENE.RSV_APLY_CD = '2' ")
.append(" AND KK0491_GENE.SEIKY_WAY_CD = '1' ")
.append(" AND KK0491_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0491_GENE.SEIKY_KEI_NO) ")
.append(" ) KAKINS ")
.append(" ) KAKINS_MAIN ")
.append(" WHERE KAKINS_MAIN.LINE = 1 ");
}
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if ( "1".equals( inMsg.getString(EKK0321B508CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, inMsg.getObject(EKK0321B508CBSMsg.KEY_SYSID));
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, inMsg.getObject(EKK0321B508CBSMsg.KEY_SYSID));
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(ＫＥＹ＿ＳＹＳＩＤを指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, inMsg.getObject(EKK0321B508CBSMsg.KEY_SYSID));
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
// パラメータの設定(運用日付を指定)
CAANJDBCUtil.setParam(pstmt, ++iPCnt, sOpeDate);
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EKK0321B508CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EKK0321B508CBSMsg1List.SVC_KEI_NO
, EKK0321B508CBSMsg1List.SVC_KEI_STAT
, EKK0321B508CBSMsg1List.SEIKY_KEI_NO
, EKK0321B508CBSMsg1List.SEIKY_WAY_CD
, EKK0321B508CBSMsg1List.SEIKY_KEI_KANA
, EKK0321B508CBSMsg1List.CRECARD_COMP_NM
, EKK0321B508CBSMsg1List.BANK_NM
, EKK0321B508CBSMsg1List.NEW_CD
, EKK0321B508CBSMsg1List.PRC_GRP_NM
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK0321B508CBSMsg1List",0);
// inMsg(CBSMsg)に明細をセット
inMsg.set("EKK0321B508CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EKK0321B508CBSMsg.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(EKK0321B508CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}