org.hisp.quick

Interface StatementHolder

All Known Implementing Classes:

DefaultStatementHolder

public interface StatementHolder

Interface which wraps a JDBC Connection and Statement and provides caching.

Author:

Lars Helge Overland

Method Summary

Modifier and Type	Method and Description
void	close() Closes the underlying Statement and Connection if this StatementHolder is not pooled.
int	executeUpdate(String sql) Executes the given SQL statement.
int	executeUpdate(String sql, boolean ignoreException) Executes the given SQL statement.
void	forceClose() Closes the underlying Statement and Connection disregarding whether this StatementHolder is not pooled or not.
Connection	getConnection() Returns the wrapped Connection.
Statement	getStatement() Returns the wrapped Statement.
boolean	isPooled() Method indicating whether the wrapped Connection is pooled.
Double	queryForDouble(String sql) Executes the given SQL statement and returns the first column of the first row in the resulting ResultSet as a Double.
Integer	queryForInteger(String sql) Executes the given SQL statement and returns the first column of the first row in the resulting ResultSet as an Integer.
String	queryForString(String sql) Executes the given SQL statement and returns the first column of the first row in the resulting ResultSet as a String.
int	update(String sql) Executes a INSERT, UPDATE or DELETE SQL statement or an SQL statement that returns nothing.

Method Detail

getStatement

Statement getStatement()

Returns the wrapped Statement.

Returns:

a Statement.

getConnection

Connection getConnection()

Returns the wrapped Connection.

Returns:

a Connection.

executeUpdate

int executeUpdate(String sql)

Executes the given SQL statement. Closes the underlying database connection and throws an unchecked StatementException if an exception occurs.

Parameters:

sql - the SQL statement.

Returns:

the number of affected rows.

Throws:

RuntimeException - if an exception occurs.

executeUpdate

int executeUpdate(String sql,
                  boolean ignoreException)

Executes the given SQL statement. Closes the underlying database connection and throws an unchecked StatementException if an exception occurs.

Parameters:

sql - the SQL statement.

ignoreException - indicates whether to skip closing the underlying connection if an exception occurs.

Returns:

the number of affected rows.

Throws:

RuntimeException - if an exception occurs.

queryForInteger

Integer queryForInteger(String sql)

Executes the given SQL statement and returns the first column of the first row in the resulting ResultSet as an Integer.

Parameters:

sql - the SQL statement

Returns:

the value returned by the query.

queryForDouble

Double queryForDouble(String sql)

Executes the given SQL statement and returns the first column of the first row in the resulting ResultSet as a Double.

Parameters:

sql - the SQL statement

Returns:

the value returned by the query.

queryForString

String queryForString(String sql)

Executes the given SQL statement and returns the first column of the first row in the resulting ResultSet as a String.

Parameters:

sql - the SQL statement

Returns:

the value returned by the query.

update

int update(String sql)

Executes a INSERT, UPDATE or DELETE SQL statement or an SQL statement that returns nothing.

Parameters:

sql - the SQL statement to execute.

Returns:

the row count resulting from the operation or nothing.

isPooled

boolean isPooled()

Method indicating whether the wrapped Connection is pooled.

Returns:

true if the wrapped Connection is pooled, false otherwise.

close

void close()

Closes the underlying Statement and Connection if this StatementHolder is not pooled. Ignores potential exceptions which are thrown in the process.

forceClose

void forceClose()

Closes the underlying Statement and Connection disregarding whether this StatementHolder is not pooled or not. Ignores potential exceptions which are thrown in the process.