com.shift.framework.persistance
Class SqlHelper

java.lang.Object
  com.shift.framework.persistance.SqlHelper

public class SqlHelper
extends java.lang.Object

Bean¿¡¼­ SQL query¸¦ ÀÛ¼ºÇÒ¶§ query¸¦ ¼¼ÆÃÇØÁÖ°í À̸¦ executeÇØÁÖ´Â ¿ªÇÒÀ» ÇÑ´Ù.

Since:

1.0

Author:

Shift Information & Communication

Constructor Summary

SqlHelper()

Method Summary

void	call(java.sql.Connection conn, java.util.Map param) ½ºÅä¾î ÇÁ·Î½ÃÀú¸¦ È£ÃâÇÑ´Ù.
boolean	execute(java.sql.Connection conn) ¼³Á¤µÇ¾î ÀÖ´Â SQL¹®À» ½ÇÇàÇÑ´Ù.
int[]	executeBatch(java.sql.Connection conn, java.util.List param) ¿©·¯°³ÀÇ row¸¦ insert, update, delete ÇÒ¶§ ¾²ÀδÙ.
java.lang.Object	executeQuery(java.sql.Connection conn, java.lang.Class klass) DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.
void	executeQuery(java.sql.Connection conn, ModelSet set) DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.
java.lang.Object	executeQuery(java.sql.Connection conn, java.lang.Object param, java.lang.Class klass) DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.
void	executeQuery(java.sql.Connection conn, java.lang.Object param, ModelSet set) DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.
int	executeUpdate(java.sql.Connection conn) INSERT, UPDATE, DELETE SQL¹®À̳ª DDL°°ÀÌ °á°ú°ªÀÌ ¾ø´Â SQL¹®À» ½ÇÇà½ÃŲ´Ù.
int	executeUpdate(java.sql.Connection conn, java.util.Map map, java.lang.Object param) ÇÑ°³ÀÇ row¸¦ insert, update, deleteÇÒ¶§ »ç¿ëÇÑ´Ù.
int	executeUpdate(java.sql.Connection conn, java.lang.Object param) ÇÑ°³ÀÇ row¸¦ insert, update, deleteÇÒ¶§ »ç¿ëÇÑ´Ù.
void	setQuery(java.lang.String sql) Äõ¸®¹®À» executeÇÒ¼ö ÀÖ°Ô °¡°øÇÑ´Ù.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqlHelper

public SqlHelper()

Method Detail

executeBatch

public int[] executeBatch(java.sql.Connection conn,
                          java.util.List param)
                   throws java.sql.SQLException,
                          java.lang.IllegalArgumentException,
                          java.lang.IllegalAccessException,
                          java.lang.reflect.InvocationTargetException

¿©·¯°³ÀÇ row¸¦ insert, update, delete ÇÒ¶§ ¾²ÀδÙ.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

param - ÀÔ·ÂÇÏ°íÀÚ ÇÏ´Â parameterµéÀÇ List°´Ã¼

Returns:

int[]ŸÀÔÀ¸·Î ¼º°øÇÑ update Ƚ¼ö¸¦ ¹ÝȯÇÑ´Ù.

Throws:

java.lang.reflect.InvocationTargetException

java.lang.IllegalAccessException

java.lang.IllegalArgumentException

java.sql.SQLException

executeUpdate

public int executeUpdate(java.sql.Connection conn,
                         java.lang.Object param)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException

ÇÑ°³ÀÇ row¸¦ insert, update, deleteÇÒ¶§ »ç¿ëÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

param - updateÇÏ°íÀÚ ÇÏ´Â parameter °´Ã¼

Returns:

update ¼º°øÇÑ È½¼ö¸¦ intÇüÀ¸·Î ¹Ýȯ

Throws:

java.lang.reflect.InvocationTargetException

java.lang.IllegalAccessException

java.lang.IllegalArgumentException

java.sql.SQLException

executeUpdate

public int executeUpdate(java.sql.Connection conn)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException

INSERT, UPDATE, DELETE SQL¹®À̳ª DDL°°ÀÌ °á°ú°ªÀÌ ¾ø´Â SQL¹®À» ½ÇÇà½ÃŲ´Ù.

Parameters:

conn - java.sql.Connection °´Ã¼

Returns:

INSERT, UPDATE, DELETE ¹®ÀÎ °æ¿ì row count, DDL ¹®ÀÎ °æ¿ì 0

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

executeUpdate

public int executeUpdate(java.sql.Connection conn,
                         java.util.Map map,
                         java.lang.Object param)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException

ÇÑ°³ÀÇ row¸¦ insert, update, deleteÇÒ¶§ »ç¿ëÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

map - updateÇÏ°íÀÚ ÇÏ´Â parameter °´Ã¼

Returns:

update ¼º°øÇÑ È½¼ö¸¦ intÇüÀ¸·Î ¹Ýȯ

Throws:

java.lang.reflect.InvocationTargetException

java.lang.IllegalAccessException

java.lang.IllegalArgumentException

java.sql.SQLException

executeQuery

public java.lang.Object executeQuery(java.sql.Connection conn,
                                     java.lang.Object param,
                                     java.lang.Class klass)
                              throws java.sql.SQLException,
                                     java.lang.IllegalArgumentException,
                                     java.lang.IllegalAccessException,
                                     java.lang.reflect.InvocationTargetException

DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

param - °Ë»öÇÏ°íÀÚ ÇÏ´Â parameter

klass - ResultSetÀ» ¹Þ¾Æ³¾ Ŭ·¡½º

Returns:

ResultSetÀ» POJO·Î parsingÇÏ¿© À̸¦ List¿¡ ´ã¾Æ¼­ ¹ÝȯÇÑ´Ù.

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

executeQuery

public java.lang.Object executeQuery(java.sql.Connection conn,
                                     java.lang.Class klass)
                              throws java.sql.SQLException,
                                     java.lang.IllegalArgumentException,
                                     java.lang.IllegalAccessException,
                                     java.lang.reflect.InvocationTargetException

DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

klass - ResultSetÀ» ¹Þ¾Æ³¾ Ŭ·¡½º

Returns:

Qeury¼öÇà °á°ú°¡ ´ã±ä Object

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

executeQuery

public void executeQuery(java.sql.Connection conn,
                         java.lang.Object param,
                         ModelSet set)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException,
                         java.lang.Exception

DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

param - SQL¹®¿¡ ¼³Á¤µÇ¾î ÀÖ´Â parameter¿¡ ġȯµÉ ´ë»óÀÌ µÇ´Â °´Ã¼

set - SQL¹® ½ÇÇà °á°ú¸¦ Ãâ·ÂÇÒ ´ë»ó °´Ã¼

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

executeQuery

public void executeQuery(java.sql.Connection conn,
                         ModelSet set)
                  throws java.sql.SQLException,
                         java.lang.IllegalArgumentException,
                         java.lang.IllegalAccessException,
                         java.lang.reflect.InvocationTargetException,
                         java.lang.Exception

DB¿¡ select query¸¦ executeÇØÁÖ°í ±× °á°ú¸¦ List ŸÀÔÀÇ °´Ã¼·Î ¹ÝȯÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

set - SQL¹® ½ÇÇà °á°ú¸¦ Ãâ·ÂÇÒ ´ë»ó °´Ã¼

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

call

public void call(java.sql.Connection conn,
                 java.util.Map param)
          throws java.sql.SQLException,
                 java.lang.IllegalArgumentException,
                 java.lang.IllegalAccessException,
                 java.lang.reflect.InvocationTargetException,
                 java.lang.Exception

½ºÅä¾î ÇÁ·Î½ÃÀú¸¦ È£ÃâÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

param - ½ºÅä¾î ÇÁ·Î½ÃÀúÀÇ parameterÀ» ġȯÇÒ ´ë»ó °´Ã¼

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

execute

public boolean execute(java.sql.Connection conn)
                throws java.sql.SQLException,
                       java.lang.IllegalArgumentException,
                       java.lang.IllegalAccessException,
                       java.lang.reflect.InvocationTargetException,
                       java.lang.Exception

¼³Á¤µÇ¾î ÀÖ´Â SQL¹®À» ½ÇÇàÇÑ´Ù.

Parameters:

conn - Á¢¼ÓÇÏ°íÀÚ ÇÏ´Â DBÀÇ Connection °´Ã¼

Returns:

trueÀ̸é ResultSet °´Ã¼ÇüÅ·Π°á°ú°¡ Á¸ÀçÇÏ°í, falseÀ̸é countÇüÅ·Π°á°ú°¡ Á¸ÀçÇÑ´Ù.

Throws:

java.sql.SQLException

java.lang.IllegalArgumentException

java.lang.IllegalAccessException

java.lang.reflect.InvocationTargetException

java.lang.Exception

setQuery

public void setQuery(java.lang.String sql)
              throws java.lang.Exception

Äõ¸®¹®À» executeÇÒ¼ö ÀÖ°Ô °¡°øÇÑ´Ù. ±¸Ã¼ÀûÀ¸·Î parameter¸¦ #°ú #»çÀÌ¿¡(#example#)³Ö¾î¼­ ÁÖ¸é À̸¦ PreparedStatement±¸¹®¿¡ ¸ÂÃß¾î ó¸®ÇÒ¼ö ÀÖ°Ô ¹°À½Ç¥·Î ¹Ù²ãÁÖ°í ÇØ´ç parameter¸¦ ÃßÃâÇÏ¿© ³Ñ°ÜÁØ´Ù. ex. "insert into table values(#value1#,#value2#);"¸¦ "insert into table values(?,?);

Parameters:

sql - ¼¼ÆÃÇÏ°íÀÚ ÇÏ´Â SQL query¹®

Throws:

java.lang.Exception