jOOQ 3.18.7 · org.jooq.tools.jdbc.DefaultStatement

Modifier and Type	Field and Description
private final Connection	creator
private final Statement	delegate
private final Supplier<? extends SQLException>	errorIfUnsupported

Access	Constructor and Description
public	DefaultStatement(Statement delegate)
public	DefaultStatement(Statement delegate, Connection creator)
public	DefaultStatement(Statement delegate, Connection creator, Supplier<? extends SQLException> errorIfUnsupported)

Method Summary

Modifier and Type	Method and Description
public void	addBatch(String typically this is a SQL `INSERT` or `UPDATE` statement sql) Implements java.sql.Statement.addBatch. Adds the given SQL command to the current list of commands for this `Statement` object.
public void	cancel() Implements java.sql.Statement.cancel. Cancels this `Statement` object if both the DBMS and driver support aborting an SQL statement.
public void	clearBatch() Implements java.sql.Statement.clearBatch. Empties this `Statement` object's current list of SQL commands.
public void	clearWarnings() Implements java.sql.Statement.clearWarnings. Clears all the warnings reported on this `Statement` object.
public void	close() Implements java.sql.Statement.close. Releases this `Statement` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
public void	closeOnCompletion() Overrides org.jooq.tools.jdbc.JDBC41Statement.closeOnCompletion. Implements java.sql.Statement.closeOnCompletion. Specifies that this `Statement` will be closed when all its dependent result sets are closed.
public String	enquoteIdentifier(String a SQL identifier identifier, boolean indicates if a simple SQL identifier should be returned as a quoted identifier alwaysQuote) Overrides default java.sql.Statement.enquoteIdentifier. Returns a SQL identifier.
public String	enquoteLiteral(String a character string val) Overrides default java.sql.Statement.enquoteLiteral. Returns a `String` enclosed in single quotes.
public String	enquoteNCharLiteral(String a character string val) Overrides default java.sql.Statement.enquoteNCharLiteral. Returns a `String` representing a National Character Set Literal enclosed in single quotes and prefixed with a upper case letter N.
public boolean	execute(String any SQL statement sql) Implements java.sql.Statement.execute. Executes the given SQL statement, which may return multiple results.
public boolean	execute(String any SQL statement sql, int a constant indicating whether auto-generated keys should be made available for retrieval using the method `getGeneratedKeys`; one of the following constants: `Statement.RETURN_GENERATED_KEYS` or `Statement.NO_GENERATED_KEYS` autoGeneratedKeys) Implements java.sql.Statement.execute. 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.
public boolean	execute(String any SQL statement sql, int[] an array of the indexes of the columns in the inserted row that should be made available for retrieval by a call to the method `getGeneratedKeys` columnIndexes) Implements java.sql.Statement.execute. 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.
public boolean	execute(String any SQL statement sql, String[] an array of the names of the columns in the inserted row that should be made available for retrieval by a call to the method `getGeneratedKeys` columnNames) Implements java.sql.Statement.execute. 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.
public int[]	executeBatch() Implements java.sql.Statement.executeBatch. Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
public long[]	executeLargeBatch() Overrides default java.sql.Statement.executeLargeBatch. Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
public long	executeLargeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql) Overrides default java.sql.Statement.executeLargeUpdate. 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.
public long	executeLargeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql, int a flag indicating whether auto-generated keys should be made available for retrieval; one of the following constants: `Statement.RETURN_GENERATED_KEYS` `Statement.NO_GENERATED_KEYS` autoGeneratedKeys) Overrides default java.sql.Statement.executeLargeUpdate. 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.
public long	executeLargeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql, int[] an array of column indexes indicating the columns that should be returned from the inserted row columnIndexes) Overrides default java.sql.Statement.executeLargeUpdate. 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.
public long	executeLargeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql, String[] an array of the names of the columns that should be returned from the inserted row columnNames) Overrides default java.sql.Statement.executeLargeUpdate. 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.
public ResultSet	executeQuery(String an SQL statement to be sent to the database, typically a static SQL `SELECT` statement sql) Implements java.sql.Statement.executeQuery. Executes the given SQL statement, which returns a single `ResultSet` object.
public int	executeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql) Implements java.sql.Statement.executeUpdate. 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.
public int	executeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql, int a flag indicating whether auto-generated keys should be made available for retrieval; one of the following constants: `Statement.RETURN_GENERATED_KEYS` `Statement.NO_GENERATED_KEYS` autoGeneratedKeys) Implements java.sql.Statement.executeUpdate. 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.
public int	executeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql, int[] an array of column indexes indicating the columns that should be returned from the inserted row columnIndexes) Implements java.sql.Statement.executeUpdate. 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.
public int	executeUpdate(String an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement. sql, String[] an array of the names of the columns that should be returned from the inserted row columnNames) Implements java.sql.Statement.executeUpdate. 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.
public Connection	getConnection() Implements java.sql.Statement.getConnection. Retrieves the `Connection` object that produced this `Statement` object.
public Statement	getDelegate()
public Statement	getDelegateStatement()
public int	getFetchDirection() Implements java.sql.Statement.getFetchDirection. Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this `Statement` object.
public int	getFetchSize() Implements java.sql.Statement.getFetchSize. Retrieves the number of result set rows that is the default fetch size for `ResultSet` objects generated from this `Statement` object.
public ResultSet	getGeneratedKeys() Implements java.sql.Statement.getGeneratedKeys. Retrieves any auto-generated keys created as a result of executing this `Statement` object.
public long	getLargeMaxRows() Overrides default java.sql.Statement.getLargeMaxRows. Retrieves the maximum number of rows that a `ResultSet` object produced by this `Statement` object can contain.
public long	getLargeUpdateCount() Overrides default java.sql.Statement.getLargeUpdateCount. Retrieves the current result as an update count; if the result is a `ResultSet` object or there are no more results, -1 is returned.
public int	getMaxFieldSize() Implements java.sql.Statement.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.
public int	getMaxRows() Implements java.sql.Statement.getMaxRows. Retrieves the maximum number of rows that a `ResultSet` object produced by this `Statement` object can contain.
public boolean	getMoreResults() Implements java.sql.Statement.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`.
public boolean	getMoreResults(int one of the following `Statement` constants indicating what should happen to current `ResultSet` objects obtained using the method `getResultSet`: `Statement.CLOSE_CURRENT_RESULT`, `Statement.KEEP_CURRENT_RESULT`, or `Statement.CLOSE_ALL_RESULTS` current) Implements java.sql.Statement.getMoreResults. 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.
public int	getQueryTimeout() Implements java.sql.Statement.getQueryTimeout. Retrieves the number of seconds the driver will wait for a `Statement` object to execute.
public ResultSet	getResultSet() Implements java.sql.Statement.getResultSet. Retrieves the current result as a `ResultSet` object.
public int	getResultSetConcurrency() Implements java.sql.Statement.getResultSetConcurrency. Retrieves the result set concurrency for `ResultSet` objects generated by this `Statement` object.
public int	getResultSetHoldability() Implements java.sql.Statement.getResultSetHoldability. Retrieves the result set holdability for `ResultSet` objects generated by this `Statement` object.
public int	getResultSetType() Implements java.sql.Statement.getResultSetType. Retrieves the result set type for `ResultSet` objects generated by this `Statement` object.
public int	getUpdateCount() Implements java.sql.Statement.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.
public SQLWarning	getWarnings() Implements java.sql.Statement.getWarnings. Retrieves the first warning reported by calls on this `Statement` object.
public boolean	isClosed() Implements java.sql.Statement.isClosed. Retrieves whether this `Statement` object has been closed.
public boolean	isCloseOnCompletion() Overrides org.jooq.tools.jdbc.JDBC41Statement.isCloseOnCompletion. Implements java.sql.Statement.isCloseOnCompletion. Returns a value indicating whether this `Statement` will be closed when all its dependent result sets are closed.
public boolean	isPoolable() Implements java.sql.Statement.isPoolable. Returns a value indicating whether the `Statement` is poolable or not.
public boolean	isSimpleIdentifier(String a SQL identifier identifier) Overrides default java.sql.Statement.isSimpleIdentifier. Retrieves whether `identifier` is a simple SQL identifier.
public boolean	isWrapperFor(Class<?> a Class defining an interface. iface) Implements java.sql.Wrapper.isWrapperFor. Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
public void	setCursorName(String the new cursor name, which must be unique within a connection name) Implements java.sql.Statement.setCursorName. Sets the SQL cursor name to the given `String`, which will be used by subsequent `Statement` object `execute` methods.
public void	setEscapeProcessing(boolean `true` to enable escape processing; `false` to disable it enable) Implements java.sql.Statement.setEscapeProcessing. Sets escape processing on or off.
public void	setFetchDirection(int the initial direction for processing rows direction) Implements java.sql.Statement.setFetchDirection. Gives the driver a hint as to the direction in which rows will be processed in `ResultSet` objects created using this `Statement` object.
public void	setFetchSize(int the number of rows to fetch rows) Implements java.sql.Statement.setFetchSize. Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for `ResultSet` objects generated by this `Statement`.
public void	setLargeMaxRows(long the new max rows limit; zero means there is no limit max) Overrides default java.sql.Statement.setLargeMaxRows. Sets the limit for the maximum number of rows that any `ResultSet` object generated by this `Statement` object can contain to the given number.
public void	setMaxFieldSize(int the new column size limit in bytes; zero means there is no limit max) Implements java.sql.Statement.setMaxFieldSize. Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a `ResultSet` object produced by this `Statement` object.
public void	setMaxRows(int the new max rows limit; zero means there is no limit max) Implements java.sql.Statement.setMaxRows. Sets the limit for the maximum number of rows that any `ResultSet` object generated by this `Statement` object can contain to the given number.
public void	setPoolable(boolean requests that the statement be pooled if true and that the statement not be pooled if false poolable) Implements java.sql.Statement.setPoolable. Requests that a `Statement` be pooled or not pooled.
public void	setQueryTimeout(int the new query timeout limit in seconds; zero means there is no limit seconds) Implements java.sql.Statement.setQueryTimeout. Sets the number of seconds the driver will wait for a `Statement` object to execute to the given number of seconds.
public <T> T	unwrap(Class<T> A Class defining an interface that the result must implement. iface) Implements java.sql.Wrapper.unwrap. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
protected ResultSet	wrap(ResultSet wrapped)

Inherited from org.jooq.tools.jdbc.JDBC41Statement:: getObject getObject

public Class DefaultStatement

Field Summary

Constructor Summary

Method Summary