트러스트폼의 화면 구성도

---------------------------------------------------------------------------------------------------------------------------------------------------------------
1 . trustForm 
 화일 이름 : D:\Workspace\Project\ALP\ALP_GSW\WebSource\xfm\test\test.xfm

---------------------------------------------------------------------------------------------------------------------------------------------------------------
2. actionInfo
 화일이름 : D:\Workspace\Project\ALP\ALP_GSW\Config\AS_VHRP_serviceinfo.xml

---------------------------------------------------------------------------------------------------------------------------------------------------------------
3. Facade
 화일이름 : D:\Workspace\Project\ALP\ALP_GSW\JavaSource\alp\as\hkmc\vhrp\service\GrnRoWorkInpFacade.java

 public RoListCdto[] selectRoList(String startDt, String endDt, AdminSessionInfo baseInfo) throws BizException {
  LogonInfo logonInfo = LoginHelper.getLogonInfo(baseInfo);
  return GrnRoWorkInp.getInstance().selectRoList(startDt, endDt, logonInfo);
 }       

---------------------------------------------------------------------------------------------------------------------------------------------------------------
4. biz
 화일이름 : D:\Workspace\Project\ALP\ALP_GSW\JavaSource\alp\as\hkmc\vhrp\service\GrnRoWorkInp.java

 public RoListCdto[] selectRoList(String startDt, String endDt, LogonInfo logonInfo) throws BizException {
  return GrnRoMainDao.selectRoList(startDt, endDt, logonInfo);
 }

---------------------------------------------------------------------------------------------------------------------------------------------------------------
5. dao( DAO ) 
 화일이름 : D:\Workspace\Project\ALP\ALP_GSW\JavaSource\alp\as\hkmc\vhrp\dao\GrnRoMainDao.java

 public static RoListCdto[] selectRoList(String startDt, String endDt, LogonInfo logonInfo) throws BizException {
         RoListCdto[] resArrCdto   = null;
         PreparedStatementWrapper psw  = null;

  try { 
   StringBuffer sql = new StringBuffer();
   sql.append("\n   select ASN_CD     ");
   sql.append("\n             ,RO_NO     ");
   sql.append("\n            ,VIN      ");
   sql.append("\n           ,CSMR_NM     ");
   sql.append("\n           ,I_CDT      ");
   sql.append("\n   from t_ro_info     ");
   sql.append("\n   WHERE ASN_CD = ?    ");
   sql.append("\n         AND i_cdt between ? and ? ");

   psw = new PreparedStatementWrapper(logonInfo.getCoScnCd() + AsConstants.DATA_SOURCE_NAME, sql.toString());

   int index = 1;

   psw.setString(index++,"MA0D96");  
   psw.setString(index++,startDt);    
   psw.setString(index++, endDt);    

   DBManager db = new DBManager();
   List dbData = db.selectList(psw, RoListCdto.class.getName());

   if(dbData.size() > 0) {
   resArrCdto = (RoListCdto[]) dbData.toArray(new RoListCdto[dbData.size()]);
   }

  } catch(SQLException se) {
   logger.error(se.getMessage());
   throw new BizException(AsConstants.SYSTEM_ID, "AS0001");
  } finally {
   if(psw != null)
   psw.release();
  }
   return resArrCdto;
  } 

---------------------------------------------------------------------------------------------------------------------------------------------------------------
6. dto( VO )
 화일이름 : D:\Workspace\Project\ALP\ALP_GSW\JavaSource\alp\as\hkmc\vhrp\dto\RoListCdto.java

---------------------------------------------------------------------------------------------------------------------------------------------------------------
7. jsp 
 화일이름 : D:\Workspace\Project\ALP\ALP_GSW\WebSource\jsp\test_selectRoList.jsp

 
<%--
***************************************************************************************************
* JSP 페이지 태그 선언
***************************************************************************************************
--%>
<%@page contentType="text/xml; charset=EUC-KR"%>
<%@page import="alp.as.hkmc.vhrp.dto.RoListCdto"%>
<%@page import="alp.as.hkmc.util.XmlGenHelper"%>
<%@page import="com.ebstorm.jframework.foundation.message.MsgParameter"%>
<%--
***************************************************************************************************
* 변수 선언 및 선행 로직
***************************************************************************************************
--%>

<%
    XmlGenHelper xml = new XmlGenHelper(0);
    try {

 //메소드 이름을 작성합니다.
     RoListCdto[] result = (RoListCdto[]) request.getAttribute("test_selectRoList");
        
 // 컬럼 이름 작성(반환받는 곳의 이름)
        String[] column = {
      "asnCd"
       ,"roNo"
       ,"vin"
       ,"csmrNm"
       ,"iCdt"                
     };
 
        // 노드 스트림의 위치를 작성합니다. 
 int pNode = xml.add (0, "res", "");
        
 //소스가 있는 곳을 작성합니다.
        xml.setSourceClassName("alp.as.hkmc.vhrp.dto.RoListCdto");
        xml.genXml(pNode, "grid", column, result);

        MsgParameter param = new MsgParameter();

        param.add( result.length );
        xml.setMessage("AS0002", param);

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        out.println(xml.getXmlString());
    }
%>