Interface ResultSetReturn

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

See Also:

• JdbcCoordinator.getResultSetReturn()

Method Summary

Modifier and Type	Method	Description
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, 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(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 Details

extract

ResultSet extract(PreparedStatement statement,
 String sql)

Extract the ResultSet from the PreparedStatement.

Parameters:

statement - The PreparedStatement 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,
 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,
 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