framework.util
Class DataTablesUtil

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

public class DataTablesUtil
extends java.lang.Object

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


Method Summary
static java.lang.String escapeJS(java.lang.String str)
          ÀÚ¹Ù½ºÅ©¸³Æ®»ó¿¡ Ư¼öÇÏ°Ô ÀνĵǴ ¹®ÀÚµéÀ» JSONµî¿¡ »ç¿ëÇϱâ À§ÇØ º¯È¯ÇÏ¿©ÁØ´Ù.
static java.lang.String format(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList)
          List°´Ã¼¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(RecordSet rs)
          RecordSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(RecordSet rs, java.lang.String[] colNames)
          RecordSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.sql.ResultSet rs)
          ResultSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static java.lang.String format(java.sql.ResultSet rs, java.lang.String[] colNames)
          ResultSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
static int setRecordSet(javax.servlet.http.HttpServletResponse response, RecordSet rs)
          RecordSetÀ» DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
static int setRecordSet(javax.servlet.http.HttpServletResponse response, RecordSet rs, java.lang.String[] colNames)
          RecordSetÀ» DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
static int setResultSet(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs)
          ResultSetÀ» DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
static int setResultSet(javax.servlet.http.HttpServletResponse response, java.sql.ResultSet rs, java.lang.String[] colNames)
          ResultSetÀ» DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

setRecordSet

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

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

setRecordSet

public static int setRecordSet(javax.servlet.http.HttpServletResponse response,
                               RecordSet rs,
                               java.lang.String[] colNames)
                        throws ColumnNotFoundException,
                               java.io.IOException
RecordSetÀ» DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
ex) response·Î rs¸¦ DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => DataTablesUtil.setRecordSet(response, rs, new String[] { "col1", "col2" })

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - DataTables Çü½ÄÀ¸·Î º¯È¯ÇÒ RecordSet °´Ã¼
colNames - Ä÷³À̸§ ¹è¿­
Returns:
󸮰Ǽö
Throws:
ColumnNotFoundException
java.io.IOException

format

public static java.lang.String format(RecordSet rs)
                               throws ColumnNotFoundException
RecordSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String json = DataTablesUtil.format(rs)

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

format

public static java.lang.String format(RecordSet rs,
                                      java.lang.String[] colNames)
                               throws ColumnNotFoundException
RecordSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String json = DataTablesUtil.format(rs, new String[] { "col1", "col2" })

Parameters:
rs - DataTables Çü½ÄÀ¸·Î º¯È¯ÇÒ RecordSet °´Ã¼
colNames - Ä÷³À̸§ ¹è¿­
Returns:
DataTables Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
ColumnNotFoundException

setResultSet

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

Parameters:
response - Ŭ¶óÀÌ¾ðÆ®·Î ÀÀ´äÇÒ Response °´Ã¼
rs - DataTables Çü½ÄÀ¸·Î º¯È¯ÇÒ 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[] colNames)
                        throws java.sql.SQLException,
                               java.io.IOException
ResultSetÀ» DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÑ´Ù.
ex) response·Î rs¸¦ DataTables Çü½ÄÀ¸·Î Ãâ·ÂÇÏ´Â °æ¿ì => DataTablesUtil.setResultSet(response, rs, new String[] { "col1", "col2" })

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

format

public static java.lang.String format(java.sql.ResultSet rs)
                               throws java.sql.SQLException
ResultSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String json = DataTablesUtil.format(rs)

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

format

public static java.lang.String format(java.sql.ResultSet rs,
                                      java.lang.String[] colNames)
                               throws java.sql.SQLException
ResultSetÀ» DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex) rs¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String json = DataTablesUtil.format(rs, new String[] { "col1", "col2" })

Parameters:
rs - DataTables Çü½ÄÀ¸·Î º¯È¯ÇÒ ResultSet °´Ã¼
colNames - Ä÷³À̸§ ¹è¿­
Returns:
DataTables Çü½ÄÀ¸·Î º¯È¯µÈ ¹®ÀÚ¿­
Throws:
java.sql.SQLException

format

public static java.lang.String format(java.util.List<java.util.Map<java.lang.String,java.lang.Object>> mapList)
List°´Ã¼¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÑ´Ù.
ex1) mapList¸¦ DataTables Çü½ÄÀ¸·Î º¯È¯ÇÏ´Â °æ¿ì => String json = DataTablesUtil.format(mapList)

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

escapeJS

public static java.lang.String escapeJS(java.lang.String str)
ÀÚ¹Ù½ºÅ©¸³Æ®»ó¿¡ Ư¼öÇÏ°Ô ÀνĵǴ ¹®ÀÚµéÀ» JSONµî¿¡ »ç¿ëÇϱâ À§ÇØ º¯È¯ÇÏ¿©ÁØ´Ù.

Parameters:
str - º¯È¯ÇÒ ¹®ÀÚ¿­