de.must.dataobj

Class PrepStatementHolder

java.lang.Object

de.must.dataobj.PrepStatementHolder

public class PrepStatementHolder
extends java.lang.Object

Wrapper around prepared statement. Useful in restrictive operating environments where e.g. database connection might be closed very quickly when not in use.

Constructor Summary

Constructors

Constructor and Description
PrepStatementHolder(java.lang.String stmtString) Constructs a new prepared statement holder.

Method Summary

Modifier and Type	Method and Description
void	close() Closes the prepared statement if it ever has been build.
java.sql.PreparedStatement	getPreparedStatement(java.sql.Connection connection) Returns a valid prepared statement matching to the connection as specified.
java.sql.PreparedStatement	getPreparedStatement(ConnectionHolder connectionHolder) Returns a valid prepared statement by checking if connection has not been closes, e.g. by timeout condition.

Methods inherited from class java.lang.Object

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

Constructor Detail

PrepStatementHolder

public PrepStatementHolder(java.lang.String stmtString)

Constructs a new prepared statement holder.

Parameters:

stmtString - the string to use to build the prepared statement.

Method Detail

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(ConnectionHolder connectionHolder)
                                                throws java.sql.SQLException

Returns a valid prepared statement by checking if connection has not been closes, e.g. by timeout condition.

Parameters:

connectionHolder - the connection holder whose connection is to be used to create the prepared statement

Returns:

a valid prepared statement

Throws:

java.sql.SQLException

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.sql.Connection connection)
                                                throws java.sql.SQLException

Returns a valid prepared statement matching to the connection as specified.

Parameters:

connection - the connection to use to create the prepared statement

Returns:

a valid prepared statement

Throws:

java.sql.SQLException

close

public void close()

Closes the prepared statement if it ever has been build.