/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbECH0111B010TPDA * ソースファイル名：JSYejbECH0111B010TPDA.java * 作成者 ：EKek0088 * 日付 ：2011年11月07日 *＜機能概要＞ * SQLFacility * テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン 修正日 修正者 修正内容 * ｖ1.00.00 * ｖ67.00.00 2023/08/21 FJ) 中川 【ANK-4415-00-00】口振請求及びWeb申込システム移行 STEP1 * ********************************************************************************/ package eo.ejb.cbs.sqlf; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; 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.common.constant.JPCModelConstant; import eo.ejb.cbm.entity.CH0111ETMsg; import eo.ejb.cbs.cbsmsg.ECH0111B010CBSMsg; import eo.ejb.cbs.cbsmsg.ECH0111B010CBSMsg1List; import eo.ejb.common.JPCModelCommon; /** * * テンプレートDBアクセス部品　ECH0111B010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbECH0111B010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbECH0111B010TPDA() { } /** * ECH0111B010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void */ public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){ // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt1 = null; PreparedStatement pstmt2 = null; // リザルトセット ResultSet rsltQuery1 = null; ResultSet rsltQuery2 = null; // 手修正箇所S // ページング用 int iTotalSearchNum = 0; // 総検索数 int iTotalPageNum = 0; // 総ページ数 int iDisplayNum = 0; // 表示件数 int iMaxSearchNum = 0; // 最大検索件数 int iDisplayPageNum = 0; // 表示ページ番号 int iArrayCopyStart = 0; // 取得範囲先頭 int iArrayCopyCount = 0; // 取得件数 // 手修正箇所E // パラメータ設定リスト List replaceListCnt = new ArrayList(); /******************** * SQL文の作成 ********************/ try{ // 運用日付 String opeDate = (String)JPCModelCommon.getOpeDate(inMsg, inContext, null); // 請求契約番号 String seikyKeiNo = inMsg.getString(ECH0111B010CBSMsg.KEY_SEIKY_KEI_NO); //コネクション取得 con1 = JSYejbConnection.getConnection(CH0111ETMsg.getTableName()); // 手修正箇所S // 総件数取得 // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT COUNT(CH0111.NYUKIN_NO) AS CNT "); // 条件1 追加 StringBuilder condition1 = getCondition1(inMsg, opeDate, replaceListCnt); sql_Buff.append(condition1); //prepareStatementにSQL文をセット pstmt1 = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 for (int idx = 0; idx < replaceListCnt.size(); idx++ ) { CAANJDBCUtil.setParam(pstmt1, idx+1, replaceListCnt.get(idx)); } // ResultSetの取得 rsltQuery1 = pstmt1.executeQuery(); // ECH0111B010CBSMsgの明細にセットする項目 String[] msgKeyList1 = { ECH0111B010CBSMsg.TOTAL_SEARCH_NUM }; rsltQuery1.next(); mapMessage(rsltQuery1, msgKeyList1, inMsg); // パラメータの設定 // パラメータの最大検索件数がnullでない場合、最大検索件数の設定 if (!inMsg.isNull(ECH0111B010CBSMsg.MAX_SEARCH_NUM)) { iMaxSearchNum = Integer.parseInt(inMsg.getString(ECH0111B010CBSMsg.MAX_SEARCH_NUM)); } // パラメータの表示件数がnullでない場合、表示件数の設定 if (!inMsg.isNull(ECH0111B010CBSMsg.DISPLAY_NUM)) { iDisplayNum = Integer.parseInt(inMsg.getString(ECH0111B010CBSMsg.DISPLAY_NUM)); } // パラメータの表示ページ番号がnullでない場合、表示ページ番号の設定 if (!inMsg.isNull(ECH0111B010CBSMsg.DISPLAY_PAGE_NUM)) { iDisplayPageNum = Integer.parseInt(inMsg.getString(ECH0111B010CBSMsg.DISPLAY_PAGE_NUM)); } // 総検索件数の設定 iTotalSearchNum = Integer.parseInt(inMsg.getString(ECH0111B010CBSMsg.TOTAL_SEARCH_NUM)); // 総ページ数の設定 // 表示件数が0の場合 if (0 == iDisplayNum) { iTotalPageNum = 1; } // 検索件数/表示件数の余りがない場合 else if (0 == iTotalSearchNum % iDisplayNum) { iTotalPageNum = iTotalSearchNum / iDisplayNum; } else { iTotalPageNum = iTotalSearchNum / iDisplayNum + 1; } // 総検索数と総ページ数の設定 inMsg.set(ECH0111B010CBSMsg.TOTAL_SEARCH_NUM, String.valueOf(iTotalSearchNum)); inMsg.set(ECH0111B010CBSMsg.TOTAL_PAGE_NUM, String.valueOf(iTotalPageNum)); // 検索エラーの設定 // 総検索件数が0の場合 if(0 == iTotalSearchNum) { inMsg.set(ECH0111B010CBSMsg.SEARCH_ERR_FLG , "1"); return; } // 総検索件数が最大検索件数より大きい場合(最大検索件数超え) else if(0 != iMaxSearchNum && iTotalSearchNum > iMaxSearchNum) { inMsg.set(ECH0111B010CBSMsg.SEARCH_ERR_FLG , "2"); return; } // 表示ページに該当するデータがない場合 else if(iTotalPageNum < iDisplayPageNum) { inMsg.set(ECH0111B010CBSMsg.SEARCH_ERR_FLG , "3"); return; } // 手修正箇所E // SQL文_基本部1 sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT CH0111.NYUKIN_NO ") .append(" ,CH0111.RECEIPT_YMD AS PAY_YMD ") .append(" ,CH0111.ADD_DTM ") .append(" ,CH0111.NYUKIN_ROUTE_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00176' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_ROUTE_CD ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_ROUTE_CD_NM ") .append(" ,(SELECT ZM0171.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00176' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_ROUTE_CD ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_ROUTE_CD_ALI ") .append(" ,CH0111.NYUKIN_ADD_WAY_CD AS NYUKIN_WAY_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00979' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_ADD_WAY_CD ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_WAY_CD_NM ") .append(" ,(SELECT ZM0171.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00979' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_ADD_WAY_CD ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_WAY_CD_ALI ") .append(" ,CH0111.NYUKIN_STAT ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00175' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_STAT ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_STAT_NM ") .append(" ,(SELECT ZM0171.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00175' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_STAT ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_STAT_ALI ") .append(" ,( ") .append(" CASE WHEN ") .append(" (SELECT ") .append(" COUNT(1) ") .append(" FROM ") .append(" CH_T_KNK CH0191_1 ") .append(" WHERE ") .append(" CH0191_1.NYUKIN_NO = CH0111.NYUKIN_NO ") .append(" AND CH0191_1.SEIKY_KEI_NO = CH0111.SEIKY_KEI_NO ") .append(" AND CH0191_1.RIREKI_DATA_FLG = '1' ") .append(" AND CH0191_1.MK_FLG = '0' ") .append(" GROUP BY ") .append(" CH0191_1.NYUKIN_NO, ") .append(" CH0191_1.SEIKY_KEI_NO ") .append(" ) > 1 THEN '*' ELSE ") .append(" (SELECT ") .append(" MAX(KNK_NO) ") .append(" FROM ") .append(" CH_T_KNK CH0191_2 ") .append(" WHERE ") .append(" CH0191_2.NYUKIN_NO = CH0111.NYUKIN_NO ") .append(" AND CH0191_2.SEIKY_KEI_NO = CH0111.SEIKY_KEI_NO ") .append(" AND CH0191_2.RIREKI_DATA_FLG = '1' ") .append(" AND CH0191_2.MK_FLG = '0' ") .append(" ) END ") .append(" ) AS KNK_NO ") .append(" ,CH0111.NYUKIN_AMNT ") .append(" ,CH0201_1.JUTO_AMNT AS JUTO_AMNT ") .append(" ,(SELECT ") .append(" SUM(CH0191_3.KNK_AMNT) ") .append(" FROM ") .append(" CH_T_KNK CH0191_3 ") .append(" WHERE ") .append(" CH0191_3.NYUKIN_NO = CH0111.NYUKIN_NO ") .append(" AND CH0191_3.SEIKY_KEI_NO = CH0111.SEIKY_KEI_NO ") .append(" AND CH0191_3.RIREKI_DATA_FLG = '1' ") .append(" AND CH0191_3.MK_FLG = '0' ") .append(" GROUP BY ") .append(" CH0191_3.NYUKIN_NO, ") .append(" CH0191_3.SEIKY_KEI_NO ") .append(" ) AS KNK_AMNT ") .append(" ,CH0111.OUT_ORG_SHUNO_YMD ") .append(" ,CH0111.NYUKIN_TRN_YMD ") .append(" ,CH0111.NYUKIN_TRN_HMS ") .append(" ,CH0111.RECEIPT_HMS ") .append(" ,CH0111.NYUKIN_CL_YMD ") .append(" ,CH0111.NYUKIN_CLRE_CD ") .append(" ,(SELECT ZM0171.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00177' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_CLRE_CD ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_CLRE_CD_NM ") .append(" ,(SELECT ZM0171.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171 ") .append(" WHERE ZM0171.CD_SBT_CD = 'CD00177' ") .append(" AND ZM0171.CD_DIV = CH0111.NYUKIN_CLRE_CD ") .append(" AND ZM0171.CD_TSTAYMD <= ? ") .append(" AND ZM0171.CD_TENDYMD >= ? ") .append(" AND ZM0171.MK_FLG = '0' ") .append(" ) AS NYUKIN_CLRE_CD_ALI ") .append(" ,( ") .append(" SELECT ") .append(" COUNT(1) ") .append(" FROM ") .append(" CH_T_KNK CH0191_4 ") .append(" INNER JOIN ") .append(" ( ") .append(" SELECT ") .append(" CH0191_Y.KNK_NO ") .append(" FROM ") .append(" CH_T_KNK CH0191_Y ") .append(" WHERE ") .append(" CH0191_Y.SEIKY_KEI_NO = ? ") .append(" AND CH0191_Y.TOGO_KNK_NO IS NOT NULL ") .append(" AND CH0191_Y.MK_FLG = '0' ") .append(" ) CH0191_X ") .append(" ON CH0191_X.KNK_NO = CH0191_4.KNK_NO ") .append(" WHERE ") .append(" CH0191_4.SEIKY_KEI_NO = CH0111.SEIKY_KEI_NO ") .append(" AND CH0191_4.NYUKIN_NO = CH0111.NYUKIN_NO ") .append(" AND CH0191_4.MK_FLG = '0' ") .append(" AND ROWNUM = 1 ") .append(" ) AS TOGO_FLG "); // from句、where句のパラメータはreplaceListCntにセット済であるため、リストに挿入する int insIndex = 0; replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, opeDate); replaceListCnt.add(insIndex++, seikyKeiNo); // 条件1 追加 sql_Buff.append(condition1); // ソート条件 追加 sql_Buff.append(getSortCondition(inMsg)); //prepareStatementにSQL文をセット pstmt2 = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 for (int idx = 0; idx < replaceListCnt.size(); idx++ ) { CAANJDBCUtil.setParam(pstmt2, idx+1, replaceListCnt.get(idx)); } // ResultSetの取得 rsltQuery2 = pstmt2.executeQuery(); // ECH0111B010CBSMsgの明細にセットする項目 String[] msgKeyList2 = { ECH0111B010CBSMsg1List.NYUKIN_NO , ECH0111B010CBSMsg1List.PAY_YMD , ECH0111B010CBSMsg1List.ADD_DTM , ECH0111B010CBSMsg1List.NYUKIN_ROUTE_CD , ECH0111B010CBSMsg1List.NYUKIN_ROUTE_CD_NM , ECH0111B010CBSMsg1List.NYUKIN_ROUTE_CD_ALI , ECH0111B010CBSMsg1List.NYUKIN_WAY_CD , ECH0111B010CBSMsg1List.NYUKIN_WAY_CD_NM , ECH0111B010CBSMsg1List.NYUKIN_WAY_CD_ALI , ECH0111B010CBSMsg1List.NYUKIN_STAT , ECH0111B010CBSMsg1List.NYUKIN_STAT_NM , ECH0111B010CBSMsg1List.NYUKIN_STAT_ALI , ECH0111B010CBSMsg1List.KNK_NO , ECH0111B010CBSMsg1List.NYUKIN_AMNT , ECH0111B010CBSMsg1List.JUTO_AMNT , ECH0111B010CBSMsg1List.KNK_AMNT , ECH0111B010CBSMsg1List.OUT_ORG_SHUNO_YMD , ECH0111B010CBSMsg1List.NYUKIN_TRN_YMD , ECH0111B010CBSMsg1List.NYUKIN_TRN_HMS , ECH0111B010CBSMsg1List.RECEIPT_HMS , ECH0111B010CBSMsg1List.NYUKIN_CL_YMD , ECH0111B010CBSMsg1List.NYUKIN_CLRE_CD , ECH0111B010CBSMsg1List.NYUKIN_CLRE_CD_NM , ECH0111B010CBSMsg1List.NYUKIN_CLRE_CD_ALI , ECH0111B010CBSMsg1List.TOGO_KBN }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery2,msgKeyList2,"eo.ejb.cbs.cbsmsg.ECH0111B010CBSMsg1List",0); // inMsg(CBSMsg)に取得した明細をセット inMsg.set("ECH0111B010CBSMsg1List", outMsg1); // 手修正箇所S // ページング関連処理 CAANMsg[] outMsg2 = null; // 対象データの取得 if(null == inMsg.getString(ECH0111B010CBSMsg.SEARCH_ERR_FLG)) { // 取得範囲の設定 // 取得範囲先頭の設定 iArrayCopyStart = iDisplayNum * (iDisplayPageNum - 1); // 取得範囲末尾の設定 // 表示件数が指定されていない場合 if (0 == iDisplayNum) { // 取得件数に総検索件数を設定 iArrayCopyCount = iTotalSearchNum; } // 表示ページ数が最終ページかつ総検索件数/表示件数の余りがある場合 else if(iTotalPageNum == iDisplayPageNum && 0 < iTotalSearchNum % iDisplayNum) { // 取得件数に総検索数/表示件数の余りを設定 iArrayCopyCount = iTotalSearchNum % iDisplayNum; } // 表示ページ数が最終ページでないまたは総検索件数/表示件数の余りがない場合 else { // 取得件数に総検索数/表示件数を設定 iArrayCopyCount = iDisplayNum; } // ページング範囲のデータを取得 outMsg2 = new CAANMsg[iArrayCopyCount]; System.arraycopy(outMsg1, iArrayCopyStart, outMsg2, 0, iArrayCopyCount); // inMsg(CBSMsg)に取得した明細をセット inMsg.set("ECH0111B010CBSMsg1List", outMsg2); } // 手修正箇所E } catch(SQLException e) { inMsg.set(ECH0111B010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } finally { // 資源の解放 try{ if(rsltQuery1 != null){ rsltQuery1.close(); } if(rsltQuery2 != null){ rsltQuery2.close(); } if(pstmt1 != null){ pstmt1.close(); } if(pstmt2 != null){ pstmt2.close(); } if(con1 != null){ closeConnection(con1); } }catch(SQLException e){ inMsg.set(ECH0111B010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } /** * ECH0111B010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @param opeDate 運用日付
* @param replaceListCnt パラメータ設定リスト
* @return StringBuilder */ private StringBuilder getCondition1(CAANMsg inMsg, String opeDate, List replaceListCnt){ String funcCode = inMsg.getString(ECH0111B010CBSMsg.FUNC_CODE); String seikyKeiNo = inMsg.getString(ECH0111B010CBSMsg.KEY_SEIKY_KEI_NO); StringBuilder sql_Buff = new StringBuilder(); sql_Buff.append(" FROM ") .append(" CH_T_NYUKIN CH0111 ") .append(" LEFT OUTER JOIN ") .append(" (SELECT CH0201.NYUKIN_NO ") .append(" ,SUM(CH0201.JUTO_AMNT) AS JUTO_AMNT ") .append(" FROM CH_T_JUTO CH0201 ") .append(" WHERE CH0201.CL_YMD IS NULL ") .append(" AND CH0201.JUTO_SBT_CD IN ('0', '1') ") .append(" AND CH0201.MK_FLG = '0' ") .append(" GROUP BY CH0201.NYUKIN_NO ") .append(" ) CH0201_1 ") .append(" ON CH0201_1.NYUKIN_NO = CH0111.NYUKIN_NO "); // SQL文_個別部1 if (JPCModelConstant.FUNC_CD_1.equals(funcCode)) { sql_Buff.append(" WHERE CH0111.SEIKY_KEI_NO = ? ") .append(" AND CH0111.MK_FLG = '0' "); replaceListCnt.add(seikyKeiNo); } else if (JPCModelConstant.FUNC_CD_2.equals(funcCode)) { sql_Buff.append(" WHERE CH0111.SEIKY_KEI_NO = ? ") .append(" AND CH0111.MK_FLG = '0' "); replaceListCnt.add(seikyKeiNo); } else if (JPCModelConstant.FUNC_CD_3.equals(funcCode)) { sql_Buff.append(" WHERE CH0111.SEIKY_KEI_NO = ? ") .append(" AND CH0111.MK_FLG = '0' "); replaceListCnt.add(seikyKeiNo); } // ANK-4415-00-00 ADD START else if (JPCModelConstant.FUNC_CD_4.equals(funcCode)) { String seikyNo = inMsg.getString(ECH0111B010CBSMsg.KEY_SEIKY_NO); sql_Buff.append(" WHERE CH0111.SEIKY_KEI_NO = ? ") .append(" AND CH0111.SEIKY_NO = ? ") .append(" AND CH0111.MK_FLG = '0' "); replaceListCnt.add(seikyKeiNo); replaceListCnt.add(seikyNo); } // ANK-4415-00-00 ADD END return sql_Buff; } /** * ECH0111B010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return StringBuilder */ private StringBuilder getSortCondition(CAANMsg inMsg) { String funcCode = inMsg.getString(ECH0111B010CBSMsg.FUNC_CODE); StringBuilder sql_Buff = new StringBuilder(); if (JPCModelConstant.FUNC_CD_2.equals(funcCode)){ sql_Buff.append(" ORDER BY ") .append(" NYUKIN_TRN_YMD ASC, ") .append(" NYUKIN_ROUTE_CD ASC "); } else if (JPCModelConstant.FUNC_CD_3.equals(funcCode)) { sql_Buff.append(" ORDER BY ") .append(" NYUKIN_TRN_YMD DESC, ") .append(" NYUKIN_ROUTE_CD ASC "); } return sql_Buff; } }