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 void	closeQuietly(AutoCloseable closeable)
static <T> List<T>	executeList(ResultSetImpl rs, ResultSetMapper<T> mapper, List<T> list)
static <T> List<T>	executeList(StatementImpl stat, 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(StatementImpl stat, ResultSetMapper<K> keyMapper, ResultSetMapper<V> valueMapper, Map<K,V> map)
static <K,V> Map<K,V>	executeMap(StatementImpl stat, 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 <T> T	executeSingle(ResultSetImpl rs, ResultSetMapper<T> mapper)
static <T> T	executeSingle(StatementImpl stat, ResultSetMapper<T> mapper)
static String[]	getColumnLabels(ResultSet rs)
static void	rollback(Connection conn)
static void	setAutoCommit(Connection conn)

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

setAutoCommit

public static void setAutoCommit(Connection conn)
                          throws SQLException

Throws:

SQLException

closeQuietly

public static void closeQuietly(AutoCloseable closeable)

executeSingle

public static <T> T executeSingle(StatementImpl stat,
                                  ResultSetMapper<T> mapper)
                           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(StatementImpl stat,
                                      ResultSetMapper<T> mapper,
                                      List<T> list)
                               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(StatementImpl stat,
                                                    String keyColumn,
                                                    String valueColumn,
                                                    Map<K,V> map)
                                             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(StatementImpl stat,
                                                    ResultSetMapper<K> keyMapper,
                                                    ResultSetMapper<V> valueMapper,
                                                    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