de.ipcon.tools.jdbc

Class StatementAdaptor

java.lang.Object

de.ipcon.tools.jdbc.StatementAdaptor

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

PreparedStatementAdaptor

public class StatementAdaptor
extends java.lang.Object
implements java.sql.Statement

Adaptor for JDBC Statement which can be used as a base class for your own JDBC Statement class. All methods just throw an UnsupportedOperationException.

Field Summary

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Constructor Summary

Constructors

Constructor and Description
StatementAdaptor()

Method Summary

Modifier and Type	Method and Description
void	addBatch(java.lang.String sql) Adds the given SQL command to the current list of commmands for this Statement object.
void	cancel() Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
void	clearBatch() Empties this Statement object's current list of SQL commands.
void	clearWarnings() Clears all the warnings reported on this Statement object.
void	close() Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
void	closeOnCompletion()
boolean	execute(java.lang.String sql) Executes the given SQL statement, which may return multiple results.
boolean	execute(java.lang.String sql, int autoGeneratedKeys) Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
boolean	execute(java.lang.String sql, int[] columnIndexes) Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
boolean	execute(java.lang.String sql, java.lang.String[] columnNames) Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
int[]	executeBatch() Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
java.sql.ResultSet	executeQuery(java.lang.String sql) Executes the given SQL statement, which returns a single ResultSet object.
int	executeUpdate(java.lang.String sql) Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
int	executeUpdate(java.lang.String sql, int autoGeneratedKeys) Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
int	executeUpdate(java.lang.String sql, int[] columnIndexes) Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
int	executeUpdate(java.lang.String sql, java.lang.String[] columnNames) Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
java.sql.Connection	getConnection()
int	getFetchDirection() Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.
int	getFetchSize() Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
java.sql.ResultSet	getGeneratedKeys() Retrieves any auto-generated keys created as a result of executing this Statement object.
int	getMaxFieldSize() Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
int	getMaxRows() Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
boolean	getMoreResults() Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.
boolean	getMoreResults(int current) Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.
int	getQueryTimeout() Retrieves the number of seconds the driver will wait for a Statement object to execute.
java.sql.ResultSet	getResultSet() Retrieves the current result as a ResultSet object.
int	getResultSetConcurrency() Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
int	getResultSetHoldability() Retrieves the result set holdability for ResultSet objects generated by this Statement object.
int	getResultSetType() Retrieves the result set type for ResultSet objects generated by this Statement object.
int	getUpdateCount() Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
java.sql.SQLWarning	getWarnings() Retrieves the first warning reported by calls on this Statement object.
boolean	isClosed()
boolean	isCloseOnCompletion()
boolean	isPoolable()
boolean	isWrapperFor(java.lang.Class c)
void	setCursorName(java.lang.String name) Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods.
void	setEscapeProcessing(boolean enable) Sets escape processing on or off.
void	setFetchDirection(int direction) Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement object.
void	setFetchSize(int rows) Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
void	setMaxFieldSize(int max) Sets the limit for the maximum number of bytes in a ResultSet column storing character or binary values to the given number of bytes.
void	setMaxRows(int max) Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number.
void	setPoolable(boolean b)
void	setQueryTimeout(int seconds) Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
java.lang.Object	unwrap(java.lang.Class c)

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Statement

executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRows

Constructor Detail

StatementAdaptor

public StatementAdaptor()

Method Detail

addBatch

public void addBatch(java.lang.String sql)

Adds the given SQL command to the current list of commmands for this Statement object.

Specified by:

addBatch in interface java.sql.Statement

cancel

public void cancel()

Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.

Specified by:

cancel in interface java.sql.Statement

clearBatch

public void clearBatch()

Empties this Statement object's current list of SQL commands.

Specified by:

clearBatch in interface java.sql.Statement

clearWarnings

public void clearWarnings()

Clears all the warnings reported on this Statement object.

Specified by:

clearWarnings in interface java.sql.Statement

close

public void close()

Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.Statement

execute

public boolean execute(java.lang.String sql)

Executes the given SQL statement, which may return multiple results.

Specified by:

execute in interface java.sql.Statement

execute

public boolean execute(java.lang.String sql,
                       int autoGeneratedKeys)

Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.

Specified by:

execute in interface java.sql.Statement

execute

public boolean execute(java.lang.String sql,
                       int[] columnIndexes)

Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

Specified by:

execute in interface java.sql.Statement

execute

public boolean execute(java.lang.String sql,
                       java.lang.String[] columnNames)

Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

Specified by:

execute in interface java.sql.Statement

executeBatch

public int[] executeBatch()

Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.

Specified by:

executeBatch in interface java.sql.Statement

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)

Executes the given SQL statement, which returns a single ResultSet object.

Specified by:

executeQuery in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String sql)

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

Specified by:

executeUpdate in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String sql,
                         int autoGeneratedKeys)

Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.

Specified by:

executeUpdate in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String sql,
                         int[] columnIndexes)

Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

Specified by:

executeUpdate in interface java.sql.Statement

executeUpdate

public int executeUpdate(java.lang.String sql,
                         java.lang.String[] columnNames)

Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.

Specified by:

executeUpdate in interface java.sql.Statement

getFetchDirection

public int getFetchDirection()

Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.

Specified by:

getFetchDirection in interface java.sql.Statement

getFetchSize

public int getFetchSize()

Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.

Specified by:

getFetchSize in interface java.sql.Statement

getGeneratedKeys

public java.sql.ResultSet getGeneratedKeys()

Retrieves any auto-generated keys created as a result of executing this Statement object.

Specified by:

getGeneratedKeys in interface java.sql.Statement

getMaxFieldSize

public int getMaxFieldSize()

Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.

Specified by:

getMaxFieldSize in interface java.sql.Statement

getMaxRows

public int getMaxRows()

Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.

Specified by:

getMaxRows in interface java.sql.Statement

getMoreResults

public boolean getMoreResults()

Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.

Specified by:

getMoreResults in interface java.sql.Statement

getMoreResults

public boolean getMoreResults(int current)

Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.

Specified by:

getMoreResults in interface java.sql.Statement

getQueryTimeout

public int getQueryTimeout()

Retrieves the number of seconds the driver will wait for a Statement object to execute.

Specified by:

getQueryTimeout in interface java.sql.Statement

getResultSet

public java.sql.ResultSet getResultSet()

Retrieves the current result as a ResultSet object.

Specified by:

getResultSet in interface java.sql.Statement

getResultSetConcurrency

public int getResultSetConcurrency()

Retrieves the result set concurrency for ResultSet objects generated by this Statement object.

Specified by:

getResultSetConcurrency in interface java.sql.Statement

getResultSetHoldability

public int getResultSetHoldability()

Retrieves the result set holdability for ResultSet objects generated by this Statement object.

Specified by:

getResultSetHoldability in interface java.sql.Statement

getResultSetType

public int getResultSetType()

Retrieves the result set type for ResultSet objects generated by this Statement object.

Specified by:

getResultSetType in interface java.sql.Statement

getUpdateCount

public int getUpdateCount()

Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.

Specified by:

getUpdateCount in interface java.sql.Statement

getWarnings

public java.sql.SQLWarning getWarnings()

Retrieves the first warning reported by calls on this Statement object.

Specified by:

getWarnings in interface java.sql.Statement

setCursorName

public void setCursorName(java.lang.String name)

Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods.

Specified by:

setCursorName in interface java.sql.Statement

setEscapeProcessing

public void setEscapeProcessing(boolean enable)

Sets escape processing on or off.

Specified by:

setEscapeProcessing in interface java.sql.Statement

setFetchDirection

public void setFetchDirection(int direction)

Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement object.

Specified by:

setFetchDirection in interface java.sql.Statement

setFetchSize

public void setFetchSize(int rows)

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.

Specified by:

setFetchSize in interface java.sql.Statement

setMaxFieldSize

public void setMaxFieldSize(int max)

Sets the limit for the maximum number of bytes in a ResultSet column storing character or binary values to the given number of bytes.

Specified by:

setMaxFieldSize in interface java.sql.Statement

setMaxRows

public void setMaxRows(int max)

Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number.

Specified by:

setMaxRows in interface java.sql.Statement

setQueryTimeout

public void setQueryTimeout(int seconds)

Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.

Specified by:

setQueryTimeout in interface java.sql.Statement

unwrap

public java.lang.Object unwrap(java.lang.Class c)

Specified by:

unwrap in interface java.sql.Wrapper

isWrapperFor

public boolean isWrapperFor(java.lang.Class c)

Specified by:

isWrapperFor in interface java.sql.Wrapper

isClosed

public boolean isClosed()

Specified by:

isClosed in interface java.sql.Statement

setPoolable

public void setPoolable(boolean b)

Specified by:

setPoolable in interface java.sql.Statement

getConnection

public java.sql.Connection getConnection()

Specified by:

getConnection in interface java.sql.Statement

isPoolable

public boolean isPoolable()

Specified by:

isPoolable in interface java.sql.Statement

closeOnCompletion

public void closeOnCompletion()

Specified by:

closeOnCompletion in interface java.sql.Statement

isCloseOnCompletion

public boolean isCloseOnCompletion()

Specified by:

isCloseOnCompletion in interface java.sql.Statement