Package org.hibernate.engine.jdbc.spi

Interface ResultSetReturn

All Known Implementing Classes:

ResultSetReturnImpl

public interface ResultSetReturn

Contract for extracting ResultSets from Statements, executing the statements, managing resources, and logging statement calls. Generally the methods here for dealing with CallableStatement are extremely limited

Method Summary

Modifier and Type	Method	Description
ResultSet	execute(PreparedStatement statement)	Execute the PreparedStatement return its first ResultSet, if any.
ResultSet	execute(PreparedStatement statement, String sql)	Execute the PreparedStatement return its first ResultSet, if any.
ResultSet	execute(Statement statement, String sql)	Performs the given SQL statement, returning its first ResultSet, if any.
int	executeUpdate(PreparedStatement statement)	Execute the PreparedStatement, returning its "affected row count".
int	executeUpdate(PreparedStatement statement, String sql)	Execute the PreparedStatement, returning its "affected row count".
int	executeUpdate(Statement statement, String sql)	Execute the given SQL statement returning its "affected row count".
ResultSet	extract(CallableStatement callableStatement)	Extract the ResultSet from the CallableStatement.
ResultSet	extract(PreparedStatement statement)	Extract the ResultSet from the PreparedStatement.
ResultSet	extract(PreparedStatement statement, String sql)	Extract the ResultSet from the PreparedStatement.
ResultSet	extract(Statement statement, String sql)	Performs the given SQL statement, expecting a ResultSet in return

Method Detail

extract

ResultSet extract(PreparedStatement statement)

Extract the ResultSet from the PreparedStatement.

If client passes CallableStatement reference, this method calls extract(CallableStatement) internally. Otherwise, PreparedStatement.executeQuery() is called.

Parameters:

statement - The PreparedStatement from which to extract the ResultSet

Returns:

The extracted ResultSet

extract

ResultSet extract(PreparedStatement statement,
                  String sql)

Extract the ResultSet from the PreparedStatement.

If client passes CallableStatement reference, this method calls extract(CallableStatement) internally. Otherwise, PreparedStatement.executeQuery() is called.

Parameters:

statement - The PreparedStatement from which to extract the ResultSet

Returns:

The extracted ResultSet

extract

ResultSet extract(CallableStatement callableStatement)

Extract the ResultSet from the CallableStatement. Note that this is the limited legacy form which delegates to Dialect.getResultSet(java.sql.CallableStatement). Better option is to integrate ProcedureCall-like hooks

Parameters:

callableStatement - The CallableStatement from which to extract the ResultSet

Returns:

The extracted ResultSet

extract

ResultSet extract(Statement statement,
                  String sql)

Performs the given SQL statement, expecting a ResultSet in return

Parameters:

statement - The JDBC Statement object to use

sql - The SQL to execute

Returns:

The resulting ResultSet

execute

ResultSet execute(PreparedStatement statement)

Execute the PreparedStatement return its first ResultSet, if any. If there is no ResultSet, returns null

Parameters:

statement - The PreparedStatement to execute

Returns:

The extracted ResultSet, or null

execute

ResultSet execute(PreparedStatement statement,
                  String sql)

Execute the PreparedStatement return its first ResultSet, if any. If there is no ResultSet, returns null

Parameters:

statement - The PreparedStatement to execute

sql - For error reporting

Returns:

The extracted ResultSet, or null

execute

ResultSet execute(Statement statement,
                  String sql)

Performs the given SQL statement, returning its first ResultSet, if any. If there is no ResultSet, returns null

Parameters:

statement - The JDBC Statement object to use

sql - The SQL to execute

Returns:

The extracted ResultSet, or null

executeUpdate

int executeUpdate(PreparedStatement statement)

Execute the PreparedStatement, returning its "affected row count".

Parameters:

statement - The PreparedStatement to execute

Returns:

The PreparedStatement.executeUpdate() result

executeUpdate

int executeUpdate(PreparedStatement statement,
                  String sql)

Execute the PreparedStatement, returning its "affected row count".

Parameters:

statement - The PreparedStatement to execute

sql - For error reporting

Returns:

The PreparedStatement.executeUpdate() result

executeUpdate

int executeUpdate(Statement statement,
                  String sql)

Execute the given SQL statement returning its "affected row count".

Parameters:

statement - The JDBC Statement object to use

sql - The SQL to execute

Returns:

The Statement.executeUpdate(String) result