framework.util
Class RDUtil

java.lang.Object
  extended by framework.util.RDUtil

public class RDUtil
extends java.lang.Object

RD(Report Designer)¸¦ ÀÌ¿ëÇÏ¿© °³¹ßÇÒ ¶§ ÀÌ¿ëÇÒ ¼ö ÀÖ´Â À¯Æ¿¸®Æ¼ Ŭ·¡½ºÀÌ´Ù.


Field Summary
static java.lang.String DEFAULT_COLSEP
          µðÆúÆ® ¿­ ±¸ºÐÀÚ
static java.lang.String DEFAULT_LINESEP
          µðÆúÆ® Çà ±¸ºÐÀÚ
 
Method Summary
static java.lang.String format(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList)
          List°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList, java.lang.String colSep, java.lang.String lineSep)
          List°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.util.Map<java.lang.String,java.lang.Object> map)
          Map°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.util.Map<java.lang.String,java.lang.Object> map, java.lang.String colSep)
          Map°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(RecordSet rs)
          RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(RecordSet rs, java.lang.String colSep, java.lang.String lineSep)
          RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.sql.ResultSet rs)
          ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.sql.ResultSet rs, java.lang.String colSep, java.lang.String lineSep)
          ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static int setRecordSet(javax.servlet.http.HttpServletResponse response, RecordSet rs)
          RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
static int setRecordSet(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String colSep, java.lang.String lineSep)
          RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
static int setResultSet(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs)
          ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
static int setResultSet(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String colSep, java.lang.String lineSep)
          ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DEFAULT_COLSEP

public static final java.lang.String DEFAULT_COLSEP
µðÆúÆ® ¿­ ±¸ºÐÀÚ

See Also:
Constant Field Values

DEFAULT_LINESEP

public static final java.lang.String DEFAULT_LINESEP
µðÆúÆ® Çà ±¸ºÐÀÚ

See Also:
Constant Field Values
Method Detail

setRecordSet

public static int setRecordSet(javax.servlet.http.HttpServletResponse response,
                               RecordSet rs)
                        throws ColumnNotFoundException,
                               java.io.IOException
RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù. Çà, ¿­ ±¸ºÐÀÚ·Î µðÆúÆ® ±¸ºÐÀÚ¸¦ »ç¿ëÇÑ´Ù.
ex) response·Î rs¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => RDUtil.setRecordSet(response, rs)

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ RecordSet °´Ã¼
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

setRecordSet

public static int setRecordSet(javax.servlet.http.HttpServletResponse response,
                               RecordSet rs,
                               java.lang.String colSep,
                               java.lang.String lineSep)
                        throws ColumnNotFoundException,
                               java.io.IOException
RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
ex) response·Î rs¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => RDUtil.setRecordSet(response, rs)

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ RecordSet °´Ã¼
colSep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
lineSep - Çà ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

format

public static java.lang.String format(RecordSet rs)
                               throws ColumnNotFoundException
RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. Çà, ¿­ ±¸ºÐÀÚ·Î µðÆúÆ® ±¸ºÐÀÚ¸¦ »ç¿ëÇÑ´Ù.
ex) rs¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(rs)

Parameters:
rs - º¯È¯ÇÒ RecordSet °´Ã¼
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
ColumnNotFoundException

format

public static java.lang.String format(RecordSet rs,
                                      java.lang.String colSep,
                                      java.lang.String lineSep)
                               throws ColumnNotFoundException
RecordSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ ¿­±¸ºÐÀÚ ##, Ç౸ºÐÀÚ !! ÀÎ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(rs, "##", "!!")

Parameters:
rs - º¯È¯ÇÒ RecordSet °´Ã¼
colSep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
lineSep - Çà ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
ColumnNotFoundException

setResultSet

public static int setResultSet(javax.servlet.http.HttpServletResponse response,
                               java.sql.ResultSet rs)
                        throws java.sql.SQLException,
                               java.io.IOException
ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù. Çà, ¿­ ±¸ºÐÀÚ·Î µðÆúÆ® ±¸ºÐÀÚ¸¦ »ç¿ëÇÑ´Ù.
ex) response·Î rs¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => RDUtil.setResultSet(response, rs)

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

setResultSet

public static int setResultSet(javax.servlet.http.HttpServletResponse response,
                               java.sql.ResultSet rs,
                               java.lang.String colSep,
                               java.lang.String lineSep)
                        throws java.sql.SQLException,
                               java.io.IOException
ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
ex) response·Î rs¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => RDUtil.setResultSet(response, rs)

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.
colSep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
lineSep - Çà ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
󸮰Ǽö
Throws:
java.sql.SQLException
java.io.IOException

format

public static java.lang.String format(java.sql.ResultSet rs)
                               throws java.sql.SQLException
ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. Çà, ¿­ ±¸ºÐÀÚ·Î µðÆúÆ® ±¸ºÐÀÚ¸¦ »ç¿ëÇÑ´Ù.
ex) rs¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(rs)

Parameters:
rs - º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
java.sql.SQLException

format

public static java.lang.String format(java.sql.ResultSet rs,
                                      java.lang.String colSep,
                                      java.lang.String lineSep)
                               throws java.sql.SQLException
ResultSetÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ ¿­±¸ºÐÀÚ ##, Ç౸ºÐÀÚ !! ÀÎ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(rs, "##", "!!")

Parameters:
rs - º¯È¯ÇÒ ResultSet °´Ã¼, ResultSet °´Ã¼´Â ÀÚµ¿À¸·Î close µÈ´Ù.
colSep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
lineSep - Çà ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
java.sql.SQLException

format

public static java.lang.String format(java.util.Map<java.lang.String,java.lang.Object> map)
Map°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. ¿­ ±¸ºÐÀÚ·Î µðÆúÆ® ±¸ºÐÀÚ¸¦ »ç¿ëÇÑ´Ù.
ex) mapÀ» RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(map)

Parameters:
map - º¯È¯ÇÒ Map°´Ã¼
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­

format

public static java.lang.String format(java.util.Map<java.lang.String,java.lang.Object> map,
                                      java.lang.String colSep)
Map°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) mapÀ» ¿­±¸ºÐÀÚ ## ÀÎ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(map, "##")

Parameters:
map - º¯È¯ÇÒ Map°´Ã¼
colSep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­

format

public static java.lang.String format(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList)
List°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù. Çà, ¿­ ±¸ºÐÀÚ·Î µðÆúÆ® ±¸ºÐÀÚ¸¦ »ç¿ëÇÑ´Ù.
ex1) mapList¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(mapList)

Parameters:
mapList - º¯È¯ÇÒ List°´Ã¼
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­

format

public static java.lang.String format(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList,
                                      java.lang.String colSep,
                                      java.lang.String lineSep)
List°´Ã¼¸¦ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex1) mapList¸¦ ¿­±¸ºÐÀÚ ##, Ç౸ºÐÀÚ !! ÀÎ RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String rd = RDUtil.format(mapList, "##", "!!")

Parameters:
mapList - º¯È¯ÇÒ List°´Ã¼
colSep - ¿­ ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
lineSep - Çà ±¸ºÐÀÚ·Î ¾²ÀÏ ¹®ÀÚ¿­
Returns:
RD ÆÄÀÏ Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­