org.hisp.quick.statement

Class DefaultStatementHolder

java.lang.Object

org.hisp.quick.statement.DefaultStatementHolder

All Implemented Interfaces:

StatementHolder

public class DefaultStatementHolder
extends Object
implements StatementHolder

Class for holding JDBC statements.

Author:

Lars Helge Overland

Constructor Summary

Constructors

Constructor and Description
DefaultStatementHolder(Connection connection)
DefaultStatementHolder(Connection connection, boolean pooled)

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.

Methods inherited from class java.lang.Object

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

Constructor Detail

DefaultStatementHolder

public DefaultStatementHolder(Connection connection)

DefaultStatementHolder

public DefaultStatementHolder(Connection connection,
                              boolean pooled)

Method Detail

getStatement

public Statement getStatement()

Description copied from interface: StatementHolder

Returns the wrapped Statement.

Specified by:

getStatement in interface StatementHolder

Returns:

a Statement.

getConnection

public Connection getConnection()

Description copied from interface: StatementHolder

Returns the wrapped Connection.

Specified by:

getConnection in interface StatementHolder

Returns:

a Connection.

isPooled

public boolean isPooled()

Description copied from interface: StatementHolder

Method indicating whether the wrapped Connection is pooled.

Specified by:

isPooled in interface StatementHolder

Returns:

true if the wrapped Connection is pooled, false otherwise.

executeUpdate

public int executeUpdate(String sql)

Description copied from interface: StatementHolder

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

Specified by:

executeUpdate in interface StatementHolder

Parameters:

sql - the SQL statement.

Returns:

the number of affected rows.

executeUpdate

public int executeUpdate(String sql,
                         boolean ignoreException)

Description copied from interface: StatementHolder

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

Specified by:

executeUpdate in interface StatementHolder

Parameters:

sql - the SQL statement.

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

Returns:

the number of affected rows.

queryForInteger

public Integer queryForInteger(String sql)

Description copied from interface: StatementHolder

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

Specified by:

queryForInteger in interface StatementHolder

Parameters:

sql - the SQL statement

Returns:

the value returned by the query.

queryForDouble

public Double queryForDouble(String sql)

Description copied from interface: StatementHolder

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

Specified by:

queryForDouble in interface StatementHolder

Parameters:

sql - the SQL statement

Returns:

the value returned by the query.

queryForString

public String queryForString(String sql)

Description copied from interface: StatementHolder

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

Specified by:

queryForString in interface StatementHolder

Parameters:

sql - the SQL statement

Returns:

the value returned by the query.

update

public int update(String sql)

Description copied from interface: StatementHolder

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

Specified by:

update in interface StatementHolder

Parameters:

sql - the SQL statement to execute.

Returns:

the row count resulting from the operation or nothing.

close

public void close()

Description copied from interface: StatementHolder

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

Specified by:

close in interface StatementHolder

forceClose

public void forceClose()

Description copied from interface: StatementHolder

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

Specified by:

forceClose in interface StatementHolder