com.openindex.openestate.impl.db

Class JdbcUtils

java.lang.Object

com.openindex.openestate.impl.db.JdbcUtils

public class JdbcUtils
extends Object

JdbcUtils.

Author:

Andreas Rudolph

Constructor Summary

Constructors

Constructor and Description
JdbcUtils()

Method Summary

Modifier and Type	Method and Description
static void	closeQuietly(Connection c) Close a database connection quietly without throwing any exceptions.
static void	closeQuietly(NamedCallableStatement s) Close a database statement quietly without throwing any exceptions.
static void	closeQuietly(NamedPreparedStatement s) Close a database statement quietly without throwing any exceptions.
static void	closeQuietly(ResultSet r) Close a database statement quietly without throwing any exceptions.
static void	closeQuietly(Statement s) Close a database statement quietly without throwing any exceptions.
static TableModel	createTableModelFromResultSet(ResultSet result)
static void	debugResult(ResultSet result)
static String	writeQuestionMarkList(int number) Writes a list of question marks, separated by ','.

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

closeQuietly

public static void closeQuietly(ResultSet r)

Close a database statement quietly without throwing any exceptions.

Parameters:

r - result set

closeQuietly

public static void closeQuietly(Statement s)

Close a database statement quietly without throwing any exceptions.

Parameters:

s - statement

closeQuietly

public static void closeQuietly(NamedCallableStatement s)

Close a database statement quietly without throwing any exceptions.

Parameters:

s - statement

closeQuietly

public static void closeQuietly(NamedPreparedStatement s)

Close a database statement quietly without throwing any exceptions.

Parameters:

s - statement

closeQuietly

public static void closeQuietly(Connection c)

Close a database connection quietly without throwing any exceptions.

Parameters:

c - database connection

createTableModelFromResultSet

public static TableModel createTableModelFromResultSet(ResultSet result)
                                                throws SQLException

Throws:

SQLException

debugResult

public static void debugResult(ResultSet result)
                        throws SQLException

Throws:

SQLException

writeQuestionMarkList

public static String writeQuestionMarkList(int number)

Writes a list of question marks, separated by ','.

Parameters:

number - Number of question marks

Returns:

List of question marks.