gnu.caf.db.impl
Class RchXmlExporter

java.lang.Object
  extended by gnu.caf.db.impl.RchXmlExporter
All Implemented Interfaces:
RowCallbackHandler

public class RchXmlExporter
extends java.lang.Object
implements RowCallbackHandler

RowCallbackHandler ÀÇ ±¸Çö Ŭ·¡½º·Î½á ResultSet 󸮽à Ä÷³¿¡ ÇØ´çÇÏ´Â µ¥ÀÌŸ¸¦ Xml ÇüÅ·Π¹ÝȯÇÔ. ¼­ºñ½ºÅ¬·¡½º¿¡¼­ ±¸ÇöµÈ ¿¹Á¦´Â ¾Æ·¡¼Ò½º¸¦ ÂüÁ¶.

                public void exportXml(DBManager2 dbmanager, RequestObject requestObject, HttpServletRequest request, HttpServletResponse response ) throws Exception {
                        Attribute params = requestObject.getParams();
                        int pageNo = 1;
                        int pageSize = 10;

                        RchXmlExporter rchXml = RchFactory.getXmlExporter(dbmanager, "Q_com_sample", "list", params, pageNo, pageSize);

                        //rchXml.appendTotalCountParams(rchXml.getTotalCount());
                        rchXml.appendTotalCountParams(rchXml.getTotalCount(), pageNo, pageSize);

                        requestObject.exportXml(rchXml);
                }
    

Since:
2.0
Author:
ÀÌÈ£¼º
See Also:
RowCallbackHandler, XMLUtils

Constructor Summary
RchXmlExporter()
           
 
Method Summary
 RchXmlExporter appendParams(java.lang.String paramName, int paramValue)
          Xml ÀÇ PARAMS ű׿¡ °ª¿¡ ÇØ´çÇÏ´Â PARAM ű׸¦ Ãß°¡ÇÔ.
 RchXmlExporter appendParams(java.lang.String paramName, java.lang.String paramValue)
          Xml ÀÇ PARAMS ű׿¡ °ª¿¡ ÇØ´çÇÏ´Â PARAM ű׸¦ Ãß°¡ÇÔ.
 void appendTotalCountParams(int totalCount)
          Xml ÀÇ PARAM ¿¡ TotalCount ÆĶó¹ÌÅ͸¦ Ãß°¡ÇÔ.
 void appendTotalCountParams(int totalCount, int pageNo, int pageSize)
          Xml ¿¡ PARAM ¿¡ TotalCount, PageNo, PageSize ÆĶó¹ÌÅ͸¦ Ãß°¡ÇÔ.
 int getReturnCode()
          ReturnCode ¸¦ ¹ÝȯÇÑ´Ù. 0ÀÎ °æ¿ì´Â ¼º°ø.
 java.lang.String getReturnMessage()
          ReturnMessage¸¦ ¹ÝȯÇÑ´Ù.
 java.util.List getRsList(java.sql.ResultSet rs, int startRow, int maxRows)
          ResultSet ¿¡ ´ëÇÏ¿© firstRow¿¡ ÇØ´çÇÏ´Â ¸¸Å­ rs.next() ó¸®ÈÄ maxResults ¸¸Å­ µ¥ÀÌŸ¸¦ ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ.
 int getTotalCount()
          ResultSet¿¡ ´ëÇÑ TotalCount¸¦ °¡Á®¿Â´Ù.
 boolean isRownumPrint()
           
 java.lang.String makeXML()
          Xml String À» ¹ÝȯÇÔ.
static RchXmlExporter query(DBManager2 dbmanager, java.lang.String sqlFilename, java.lang.String sqlID, Attribute params)
          CAF sqlID È£Ãâ±â´ÉÀ» È°¿ëÇÏ¿© sqlID¿¡ ÇØ´çÇÏ´Â XML ½ºÆ®¸µÀ» ¹ÝȯÇÏ´Â ¸Þ¼ÒµåÀÓ.
static RchXmlExporter queryForPaging(DBManager2 dbmanager, java.lang.String sqlFilename, java.lang.String sqlID, Attribute params, int pageNo, int pageSize)
          CAF sqlID È£Ãâ±â´ÉÀ» È°¿ëÇÏ¿© sqlID¿¡ ÇØ´çÇÏ´Â XML ½ºÆ®¸µÀ» ¹ÝȯÇÏ´Â ¸Þ¼ÒµåÀÓ.
 RchXmlExporter setReturnCode(int returnCode)
           
 RchXmlExporter setReturnMessage(java.lang.String returnMessage)
           
 void setRownumPrint(boolean rownumPrint)
          Xml ¹ÝȯÄ÷³Àº µðºñÄ÷³±âÁØÀÌÁö¸¸, ºÎ°¡ÀûÀ¸·Î ROWNUM, RROWNUM Ä÷³À» ÀÚµ¿À¸·Î Ãß°¡ÇÑ XmlÀ» ¹ÝȯÇÏ°íÀÚ ÇÏ´Â °æ¿ì ¼³Á¤ÇÔ.
 void setTotalCount(int totalCount)
          totalCount set
 java.lang.String toString()
          Xml String À» ¹ÝȯÇÔ.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

RchXmlExporter

public RchXmlExporter()
Method Detail

getRsList

public java.util.List getRsList(java.sql.ResultSet rs,
                                int startRow,
                                int maxRows)
                         throws java.sql.SQLException
Description copied from interface: RowCallbackHandler
ResultSet ¿¡ ´ëÇÏ¿© firstRow¿¡ ÇØ´çÇÏ´Â ¸¸Å­ rs.next() ó¸®ÈÄ maxResults ¸¸Å­ µ¥ÀÌŸ¸¦ ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ. maxResults °¡ -1 ÀÎ °æ¿ì¿¡´Â Àüü rs ¿¡ ´ëÇÏ¿© ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ.

Specified by:
getRsList in interface RowCallbackHandler
Returns:
List
Throws:
java.sql.SQLException
See Also:
RowCallbackHandler.getRsList(ResultSet, int, int)

appendTotalCountParams

public void appendTotalCountParams(int totalCount,
                                   int pageNo,
                                   int pageSize)
Xml ¿¡ PARAM ¿¡ TotalCount, PageNo, PageSize ÆĶó¹ÌÅ͸¦ Ãß°¡ÇÔ.

Parameters:
totalCount -
pageNo -
pageSize -

appendTotalCountParams

public void appendTotalCountParams(int totalCount)
Xml ÀÇ PARAM ¿¡ TotalCount ÆĶó¹ÌÅ͸¦ Ãß°¡ÇÔ.

Parameters:
totalCount -

makeXML

public java.lang.String makeXML()
Xml String À» ¹ÝȯÇÔ.

Returns:
String

toString

public java.lang.String toString()
Xml String À» ¹ÝȯÇÔ.

Overrides:
toString in class java.lang.Object
Returns:
String

getTotalCount

public int getTotalCount()
ResultSet¿¡ ´ëÇÑ TotalCount¸¦ °¡Á®¿Â´Ù.

Returns:
int

setTotalCount

public void setTotalCount(int totalCount)
totalCount set

Parameters:
totalCount -

getReturnCode

public int getReturnCode()
ReturnCode ¸¦ ¹ÝȯÇÑ´Ù. 0ÀÎ °æ¿ì´Â ¼º°ø.

Returns:
int

setReturnCode

public RchXmlExporter setReturnCode(int returnCode)

getReturnMessage

public java.lang.String getReturnMessage()
ReturnMessage¸¦ ¹ÝȯÇÑ´Ù.

Returns:
String

setReturnMessage

public RchXmlExporter setReturnMessage(java.lang.String returnMessage)

isRownumPrint

public boolean isRownumPrint()

setRownumPrint

public void setRownumPrint(boolean rownumPrint)
Xml ¹ÝȯÄ÷³Àº µðºñÄ÷³±âÁØÀÌÁö¸¸, ºÎ°¡ÀûÀ¸·Î ROWNUM, RROWNUM Ä÷³À» ÀÚµ¿À¸·Î Ãß°¡ÇÑ XmlÀ» ¹ÝȯÇÏ°íÀÚ ÇÏ´Â °æ¿ì ¼³Á¤ÇÔ. µðÆúÆ®°ªÀº false ÀÌ°í, queryForPaging ¸Þ¼Òµå¼öÇà½Ã´Â true ÀÓ.


appendParams

public RchXmlExporter appendParams(java.lang.String paramName,
                                   java.lang.String paramValue)
Xml ÀÇ PARAMS ű׿¡ °ª¿¡ ÇØ´çÇÏ´Â PARAM ű׸¦ Ãß°¡ÇÔ.

Parameters:
paramName -
paramValue -
Returns:
RchXmlExporter

appendParams

public RchXmlExporter appendParams(java.lang.String paramName,
                                   int paramValue)
Xml ÀÇ PARAMS ű׿¡ °ª¿¡ ÇØ´çÇÏ´Â PARAM ű׸¦ Ãß°¡ÇÔ.

Parameters:
paramName -
paramValue -
Returns:
RchXmlExporter

query

public static RchXmlExporter query(DBManager2 dbmanager,
                                   java.lang.String sqlFilename,
                                   java.lang.String sqlID,
                                   Attribute params)
CAF sqlID È£Ãâ±â´ÉÀ» È°¿ëÇÏ¿© sqlID¿¡ ÇØ´çÇÏ´Â XML ½ºÆ®¸µÀ» ¹ÝȯÇÏ´Â ¸Þ¼ÒµåÀÓ.

Parameters:
dbmanager -
sqlFilename -
sqlID -
params -
Returns:
RchXmlExporter

queryForPaging

public static RchXmlExporter queryForPaging(DBManager2 dbmanager,
                                            java.lang.String sqlFilename,
                                            java.lang.String sqlID,
                                            Attribute params,
                                            int pageNo,
                                            int pageSize)
CAF sqlID È£Ãâ±â´ÉÀ» È°¿ëÇÏ¿© sqlID¿¡ ÇØ´çÇÏ´Â XML ½ºÆ®¸µÀ» ¹ÝȯÇÏ´Â ¸Þ¼ÒµåÀÓ. ÆäÀÌÁö±â´ÉÀ» È°¿ëÇÑ XML ½ºÆ®¸µ¹Ýȯ. ±âº»ÀûÀ¸·Î ROWNUM, RROWNUM Ä÷³À» ·Î¿ìÀÇ ¸Ç ³¡¿¡ ºÎ°¡ÀûÀ¸·Î Ãß°¡ÇÔ.

Parameters:
dbmanager -
sqlFilename -
sqlID -
params -
pageNo -
pageSize -
Returns:
RchXmlExporter


Copyright © 2003 All Rights Reserved.