Module com.appslandia.common

Package com.appslandia.common.jdbc

Class JdbcUtils

java.lang.Object

com.appslandia.common.jdbc.JdbcUtils

public class JdbcUtils
extends Object

Author:

Loc Ha

Constructor Summary

Constructors

Constructor	Description
JdbcUtils()

Method Summary

Modifier and Type	Method	Description
static boolean	executeExists(Connection conn, String sql)
static boolean	executeExists(Connection conn, String pSql, Object... params)
static boolean	executeExists(Connection conn, String pSql, Map<String,Object> params)
static boolean	executeExists(ResultSet rs)
static <T> List<T>	executeList(ResultSetImpl rs, ResultSetMapper<T> mapper, List<T> list)
static <T> List<T>	executeList(Connection conn, String sql, ResultSetMapper<T> mapper)
static <T> List<T>	executeList(Connection conn, String sql, ResultSetMapper<T> mapper, List<T> list)
static <T> List<T>	executeList(Connection conn, String pSql, Object[] params, ResultSetMapper<T> mapper)
static <T> List<T>	executeList(Connection conn, String pSql, Object[] params, ResultSetMapper<T> mapper, List<T> list)
static <T> List<T>	executeList(Connection conn, String pSql, Map<String,Object> params, ResultSetMapper<T> mapper)
static <T> List<T>	executeList(Connection conn, String pSql, Map<String,Object> params, ResultSetMapper<T> mapper, List<T> list)
static <K,V> Map<K,V>	executeMap(ResultSetImpl rs, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(Connection conn, String sql, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper)
static <K,V> Map<K,V>	executeMap(Connection conn, String sql, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Object[] params, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Object[] params, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Object[] params, String keyColumn, String valueColumn)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Object[] params, String keyColumn, String valueColumn, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(Connection conn, String sql, String keyColumn, String valueColumn)
static <K,V> Map<K,V>	executeMap(Connection conn, String sql, String keyColumn, String valueColumn, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Map<String,Object> params, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Map<String,Object> params, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Map<String,Object> params, String keyColumn, String valueColumn)
static <K,V> Map<K,V>	executeMap(Connection conn, String pSql, Map<String,Object> params, String keyColumn, String valueColumn, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(ResultSet rs, String keyColumn, String valueColumn, Map<K,V> map)
static void	executeQuery(Connection conn, String sql, ResultSetHandler handler)
static void	executeQuery(Connection conn, String pSql, Object[] params, ResultSetHandler handler)
static void	executeQuery(Connection conn, String pSql, Map<String,Object> params, ResultSetHandler handler)
static <T> T	executeScalar(Connection conn, String sql)
static <T> T	executeScalar(Connection conn, String pSql, Object... params)
static <T> T	executeScalar(Connection conn, String pSql, Map<String,Object> params)
static <T> T	executeSingle(ResultSetImpl rs, ResultSetMapper<T> mapper)
static <T> T	executeSingle(Connection conn, String sql, ResultSetMapper<T> mapper)
static <T> T	executeSingle(Connection conn, String pSql, Object[] params, ResultSetMapper<T> mapper)
static <T> T	executeSingle(Connection conn, String pSql, Map<String,Object> params, ResultSetMapper<T> mapper)
static int	executeUpdate(Connection conn, String sql)
static int	executeUpdate(Connection conn, String pSql, Object... params)
static int	executeUpdate(Connection conn, String pSql, Map<String,Object> params)
static String[]	getColumnLabels(ResultSet rs)
static void	rollback(Connection conn)
static void	setAutoCommit(Connection conn)
static void	setParameters(StatementImpl stat, Sql sql, Map<String,Object> params)
static void	setTransactional(Connection conn)
static Map<String,Object>	toParameters(Object[] params)

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcUtils

public JdbcUtils()

Method Detail

rollback

public static void rollback(Connection conn)
                     throws SQLException

Throws:

SQLException

setTransactional

public static void setTransactional(Connection conn)
                             throws SQLException

Throws:

SQLException

setAutoCommit

public static void setAutoCommit(Connection conn)
                          throws SQLException

Throws:

SQLException

executeExists

public static boolean executeExists(ResultSet rs)
                             throws SQLException

Throws:

SQLException

executeSingle

public static <T> T executeSingle(ResultSetImpl rs,
                                  ResultSetMapper<T> mapper)
                           throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(ResultSetImpl rs,
                                      ResultSetMapper<T> mapper,
                                      List<T> list)
                               throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(ResultSet rs,
                                                    String keyColumn,
                                                    String valueColumn,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(ResultSetImpl rs,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

getColumnLabels

public static String[] getColumnLabels(ResultSet rs)
                                throws SQLException

Throws:

SQLException

toParameters

public static Map<String,Object> toParameters(Object[] params)

setParameters

public static void setParameters(StatementImpl stat,
                                 Sql sql,
                                 Map<String,Object> params)
                          throws SQLException

Throws:

SQLException

executeUpdate

public static int executeUpdate(Connection conn,
                                String sql)
                         throws SQLException

Throws:

SQLException

executeUpdate

public static int executeUpdate(Connection conn,
                                String pSql,
                                Object... params)
                         throws SQLException

Throws:

SQLException

executeUpdate

public static int executeUpdate(Connection conn,
                                String pSql,
                                Map<String,Object> params)
                         throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String sql,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String sql,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Object[] params,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Map<String,Object> params,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Object[] params,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Map<String,Object> params,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String sql,
                                                    String keyColumn,
                                                    String valueColumn)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String sql,
                                                    String keyColumn,
                                                    String valueColumn,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Object[] params,
                                                    String keyColumn,
                                                    String valueColumn)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Map<String,Object> params,
                                                    String keyColumn,
                                                    String valueColumn)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Object[] params,
                                                    String keyColumn,
                                                    String valueColumn,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeMap

public static <K,V> Map<K,V> executeMap(Connection conn,
                                                    String pSql,
                                                    Map<String,Object> params,
                                                    String keyColumn,
                                                    String valueColumn,
                                                    Map<K,V> map)
                                             throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(Connection conn,
                                      String sql,
                                      ResultSetMapper<T> mapper)
                               throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(Connection conn,
                                      String sql,
                                      ResultSetMapper<T> mapper,
                                      List<T> list)
                               throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(Connection conn,
                                      String pSql,
                                      Object[] params,
                                      ResultSetMapper<T> mapper)
                               throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(Connection conn,
                                      String pSql,
                                      Map<String,Object> params,
                                      ResultSetMapper<T> mapper)
                               throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(Connection conn,
                                      String pSql,
                                      Object[] params,
                                      ResultSetMapper<T> mapper,
                                      List<T> list)
                               throws SQLException

Throws:

SQLException

executeList

public static <T> List<T> executeList(Connection conn,
                                      String pSql,
                                      Map<String,Object> params,
                                      ResultSetMapper<T> mapper,
                                      List<T> list)
                               throws SQLException

Throws:

SQLException

executeSingle

public static <T> T executeSingle(Connection conn,
                                  String sql,
                                  ResultSetMapper<T> mapper)
                           throws SQLException

Throws:

SQLException

executeSingle

public static <T> T executeSingle(Connection conn,
                                  String pSql,
                                  Object[] params,
                                  ResultSetMapper<T> mapper)
                           throws SQLException

Throws:

SQLException

executeSingle

public static <T> T executeSingle(Connection conn,
                                  String pSql,
                                  Map<String,Object> params,
                                  ResultSetMapper<T> mapper)
                           throws SQLException

Throws:

SQLException

executeScalar

public static <T> T executeScalar(Connection conn,
                                  String sql)
                           throws SQLException

Throws:

SQLException

executeScalar

public static <T> T executeScalar(Connection conn,
                                  String pSql,
                                  Object... params)
                           throws SQLException

Throws:

SQLException

executeScalar

public static <T> T executeScalar(Connection conn,
                                  String pSql,
                                  Map<String,Object> params)
                           throws SQLException

Throws:

SQLException

executeExists

public static boolean executeExists(Connection conn,
                                    String sql)
                             throws SQLException

Throws:

SQLException

executeExists

public static boolean executeExists(Connection conn,
                                    String pSql,
                                    Object... params)
                             throws SQLException

Throws:

SQLException

executeExists

public static boolean executeExists(Connection conn,
                                    String pSql,
                                    Map<String,Object> params)
                             throws SQLException

Throws:

SQLException

executeQuery

public static void executeQuery(Connection conn,
                                String sql,
                                ResultSetHandler handler)
                         throws Exception

Throws:

Exception

executeQuery

public static void executeQuery(Connection conn,
                                String pSql,
                                Object[] params,
                                ResultSetHandler handler)
                         throws Exception

Throws:

Exception

executeQuery

public static void executeQuery(Connection conn,
                                String pSql,
                                Map<String,Object> params,
                                ResultSetHandler handler)
                         throws Exception

Throws:

Exception