net.sf.kdgcommons.sql

Class JDBCUtil

java.lang.Object

net.sf.kdgcommons.sql.JDBCUtil

public class JDBCUtil
extends Object

A collection of utility methods for working at the JDBC level.

Constructor Summary

Constructors

Constructor and Description
JDBCUtil()

Method Summary

Modifier and Type	Method and Description
static void	closeQuietly(Connection cxt) Closes the passed Connection ignoring exceptions.
static void	closeQuietly(ResultSet rslt) Closes the passed ResultSet ignoring exceptions.
static void	closeQuietly(Statement stmt) Closes the passed ResultSet ignoring exceptions.
static List<Map<String,Object>>	executeQuery(Connection cxt, String sql, Object... args) Executes a query and returns the results, ensuring that the created statement and resultset are closed.
static int	executeUpdate(Connection cxt, String sql, Object... args) Executes an update and returns the results, ensuring that the created statement is closed.
static PreparedStatement	prepare(Connection cxt, String sql, Object... args) Creates a PreparedStatement from the provided connection.
static List<Map<String,Object>>	retrieve(ResultSet rslt) Iterates through the passed ResultSet, converting each row into a Map, where keys are the column names as retrieved from metadata, and values are the result of calling getObject().

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCUtil

public JDBCUtil()

Method Detail

executeQuery

public static List<Map<String,Object>> executeQuery(Connection cxt,
                                                    String sql,
                                                    Object... args)
                                             throws SQLException

Executes a query and returns the results, ensuring that the created statement and resultset are closed.

Parameters:

args - Parameters for the query. May be empty.

Returns:

A list of maps, where each entry in the list represents a row from the results, and the keys in the map represent the column names.

Throws:

SQLException

executeUpdate

public static int executeUpdate(Connection cxt,
                                String sql,
                                Object... args)
                         throws SQLException

Executes an update and returns the results, ensuring that the created statement is closed.

Parameters:

args - Parameters for the query. May be empty.

Returns:

The number of rows updated by this statement.

Throws:

SQLException

prepare

public static PreparedStatement prepare(Connection cxt,
                                        String sql,
                                        Object... args)
                                 throws SQLException

Creates a PreparedStatement from the provided connection.

Parameters:

args - Parameters for the query. May be empty.

Throws:

SQLException

retrieve

public static List<Map<String,Object>> retrieve(ResultSet rslt)
                                         throws SQLException

Iterates through the passed ResultSet, converting each row into a Map, where keys are the column names as retrieved from metadata, and values are the result of calling getObject().

Caller is responsible for closing the ResultSet.

Throws:

SQLException

closeQuietly

public static void closeQuietly(Connection cxt)

Closes the passed Connection ignoring exceptions. This is usually called in a finally block, and throwing an exception there would overwrite any exception thrown by the main code (and if there is an exception when closing, there probably was one there as well).

closeQuietly

public static void closeQuietly(Statement stmt)

Closes the passed ResultSet ignoring exceptions. This is usually called in a finally block, and throwing an exception there would overwrite any exception thrown by the main code (and if there is an exception when closing, there probably was one there as well).

closeQuietly

public static void closeQuietly(ResultSet rslt)

Closes the passed ResultSet ignoring exceptions. This is usually called in a finally block, and throwing an exception there would overwrite any exception thrown by the main code (and if there is an exception when closing, there probably was one there as well).