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(ResultSet rs)
static <T> List<T>	executeList(ResultSetImpl rs, 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(ResultSet rs, String keyColumn, String valueColumn, Map<K,V> map)
static void	executeNStream(ResultSetImpl rs, String streamLabel, Writer out, ResultSetHandler handler)
static <T> T	executeSingle(ResultSetImpl rs, ResultSetMapper<T> mapper)
static void	executeStream(ResultSetImpl rs, String streamLabel, OutputStream out, ResultSetHandler handler)
static void	executeStream(ResultSetImpl rs, String streamLabel, Writer out, ResultSetHandler handler)
static String[]	getColumnLabels(ResultSet rs)
static boolean	isAutoCommit(Connection conn)
static void	setParameters(StatementImpl stat, JdbcSql sql, Map<String,Object> params)
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

isAutoCommit

public static boolean isAutoCommit(Connection conn)
                            throws UncheckedSQLException

Throws:

UncheckedSQLException

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,
                                 JdbcSql sql,
                                 Map<String,Object> params)
                          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

executeList

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

Throws:

SQLException

executeSingle

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

Throws:

SQLException

executeExists

public static boolean executeExists(ResultSet rs)
                             throws SQLException

Throws:

SQLException

executeStream

public static void executeStream(ResultSetImpl rs,
                                 String streamLabel,
                                 OutputStream out,
                                 ResultSetHandler handler)
                          throws Exception

Throws:

Exception

executeStream

public static void executeStream(ResultSetImpl rs,
                                 String streamLabel,
                                 Writer out,
                                 ResultSetHandler handler)
                          throws Exception

Throws:

Exception

executeNStream

public static void executeNStream(ResultSetImpl rs,
                                  String streamLabel,
                                  Writer out,
                                  ResultSetHandler handler)
                           throws Exception

Throws:

Exception