mchange-commons-java 0.3.1 · com.mchange.v2.sql.filter.SynchronizedFilterPreparedStatement

Modifier and Type	Field and Description
protected PreparedStatement	inner

Access	Constructor and Description
public	SynchronizedFilterPreparedStatement(PreparedStatement inner)
public	SynchronizedFilterPreparedStatement()

Method Summary

Modifier and Type	Method and Description
private void	__setInner(PreparedStatement inner)
public synchronized void	addBatch() Implements java.sql.PreparedStatement.addBatch. Adds a set of parameters to this `PreparedStatement` object's batch of commands.
public synchronized void	addBatch(String typically this is a SQL `INSERT` or `UPDATE` statement a) Implements java.sql.Statement.addBatch. Adds the given SQL command to the current list of commands for this `Statement` object.
public synchronized void	cancel() Implements java.sql.Statement.cancel. Cancels this `Statement` object if both the DBMS and driver support aborting an SQL statement.
public synchronized void	clearBatch() Implements java.sql.Statement.clearBatch. Empties this `Statement` object's current list of SQL commands.
public synchronized void	clearParameters() Implements java.sql.PreparedStatement.clearParameters. Clears the current parameter values immediately.
public synchronized void	clearWarnings() Implements java.sql.Statement.clearWarnings. Clears all the warnings reported on this `Statement` object.
public synchronized 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 synchronized void	closeOnCompletion() Implements java.sql.Statement.closeOnCompletion. Specifies that this `Statement` will be closed when all its dependent result sets are closed.
public synchronized boolean	execute() Implements java.sql.PreparedStatement.execute. Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
public synchronized boolean	execute(String any SQL statement a, 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` b) 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 synchronized boolean	execute(String any SQL statement a, 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` b) 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 synchronized boolean	execute(String any SQL statement a) Implements java.sql.Statement.execute. Executes the given SQL statement, which may return multiple results.
public synchronized boolean	execute(String any SQL statement a, 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` b) 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 synchronized 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 synchronized ResultSet	executeQuery() Implements java.sql.PreparedStatement.executeQuery. Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
public synchronized ResultSet	executeQuery(String an SQL statement to be sent to the database, typically a static SQL `SELECT` statement a) Implements java.sql.Statement.executeQuery. Executes the given SQL statement, which returns a single `ResultSet` object.
public synchronized int	executeUpdate() Implements java.sql.PreparedStatement.executeUpdate. Executes the SQL statement in this `PreparedStatement` object, which must be 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.
public synchronized 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. a, int[] an array of column indexes indicating the columns that should be returned from the inserted row b) 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 synchronized 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. a, String[] an array of the names of the columns that should be returned from the inserted row b) 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 synchronized 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. a) 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 synchronized 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. a, 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` b) 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 synchronized Connection	getConnection() Implements java.sql.Statement.getConnection. Retrieves the `Connection` object that produced this `Statement` object.
public synchronized 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 synchronized 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 synchronized ResultSet	getGeneratedKeys() Implements java.sql.Statement.getGeneratedKeys. Retrieves any auto-generated keys created as a result of executing this `Statement` object.
public synchronized PreparedStatement	getInner()
public synchronized 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 synchronized 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 synchronized ResultSetMetaData	getMetaData() Implements java.sql.PreparedStatement.getMetaData. Retrieves a `ResultSetMetaData` object that contains information about the columns of the `ResultSet` object that will be returned when this `PreparedStatement` object is executed.
public synchronized 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 synchronized 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` a) 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 synchronized ParameterMetaData	getParameterMetaData() Implements java.sql.PreparedStatement.getParameterMetaData. Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
public synchronized int	getQueryTimeout() Implements java.sql.Statement.getQueryTimeout. Retrieves the number of seconds the driver will wait for a `Statement` object to execute.
public synchronized ResultSet	getResultSet() Implements java.sql.Statement.getResultSet. Retrieves the current result as a `ResultSet` object.
public synchronized int	getResultSetConcurrency() Implements java.sql.Statement.getResultSetConcurrency. Retrieves the result set concurrency for `ResultSet` objects generated by this `Statement` object.
public synchronized int	getResultSetHoldability() Implements java.sql.Statement.getResultSetHoldability. Retrieves the result set holdability for `ResultSet` objects generated by this `Statement` object.
public synchronized int	getResultSetType() Implements java.sql.Statement.getResultSetType. Retrieves the result set type for `ResultSet` objects generated by this `Statement` object.
public synchronized 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 synchronized SQLWarning	getWarnings() Implements java.sql.Statement.getWarnings. Retrieves the first warning reported by calls on this `Statement` object.
public synchronized boolean	isClosed() Implements java.sql.Statement.isClosed. Retrieves whether this `Statement` object has been closed.
public synchronized boolean	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 synchronized boolean	isPoolable() Implements java.sql.Statement.isPoolable. Returns a value indicating whether the `Statement` is poolable or not.
public synchronized boolean	isWrapperFor(Class<T> a Class defining an interface. a) 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 synchronized void	setArray(int the first parameter is 1, the second is 2, ... a, Array an `Array` object that maps an SQL `ARRAY` value b) Implements java.sql.PreparedStatement.setArray. Sets the designated parameter to the given `java.sql.Array` object.
public synchronized void	setAsciiStream(int the first parameter is 1, the second is 2, ... a, InputStream the Java input stream that contains the ASCII parameter value b, long the number of bytes in the stream c) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public synchronized void	setAsciiStream(int the first parameter is 1, the second is 2, ... a, InputStream the Java input stream that contains the ASCII parameter value b) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream.
public synchronized void	setAsciiStream(int the first parameter is 1, the second is 2, ... a, InputStream the Java input stream that contains the ASCII parameter value b, int the number of bytes in the stream c) Implements java.sql.PreparedStatement.setAsciiStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public synchronized void	setBigDecimal(int the first parameter is 1, the second is 2, ... a, BigDecimal the parameter value b) Implements java.sql.PreparedStatement.setBigDecimal. Sets the designated parameter to the given `java.math.BigDecimal` value.
public synchronized void	setBinaryStream(int the first parameter is 1, the second is 2, ... a, InputStream the java input stream which contains the binary parameter value b, int the number of bytes in the stream c) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public synchronized void	setBinaryStream(int the first parameter is 1, the second is 2, ... a, InputStream the java input stream which contains the binary parameter value b, long the number of bytes in the stream c) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public synchronized void	setBinaryStream(int the first parameter is 1, the second is 2, ... a, InputStream the java input stream which contains the binary parameter value b) Implements java.sql.PreparedStatement.setBinaryStream. Sets the designated parameter to the given input stream.
public synchronized void	setBlob(int index of the first parameter is 1, the second is 2, ... a, InputStream An object that contains the data to set the parameter value to. b, long the number of bytes in the parameter data. c) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
public synchronized void	setBlob(int the first parameter is 1, the second is 2, ... a, Blob a `Blob` object that maps an SQL `BLOB` value b) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to the given `java.sql.Blob` object.
public synchronized void	setBlob(int index of the first parameter is 1, the second is 2, ... a, InputStream An object that contains the data to set the parameter value to. b) Implements java.sql.PreparedStatement.setBlob. Sets the designated parameter to a `InputStream` object.
public synchronized void	setBoolean(int the first parameter is 1, the second is 2, ... a, boolean the parameter value b) Implements java.sql.PreparedStatement.setBoolean. Sets the designated parameter to the given Java `boolean` value.
public synchronized void	setByte(int the first parameter is 1, the second is 2, ... a, byte the parameter value b) Implements java.sql.PreparedStatement.setByte. Sets the designated parameter to the given Java `byte` value.
public synchronized void	setBytes(int the first parameter is 1, the second is 2, ... a, byte[] the parameter value b) Implements java.sql.PreparedStatement.setBytes. Sets the designated parameter to the given Java array of bytes.
public synchronized void	setCharacterStream(int the first parameter is 1, the second is 2, ... a, Reader the `java.io.Reader` object that contains the Unicode data b) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object.
public synchronized void	setCharacterStream(int the first parameter is 1, the second is 2, ... a, Reader the `java.io.Reader` object that contains the Unicode data b, int the number of characters in the stream c) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public synchronized void	setCharacterStream(int the first parameter is 1, the second is 2, ... a, Reader the `java.io.Reader` object that contains the Unicode data b, long the number of characters in the stream c) Implements java.sql.PreparedStatement.setCharacterStream. Sets the designated parameter to the given `Reader` object, which is the given number of characters long.
public synchronized void	setClob(int index of the first parameter is 1, the second is 2, ... a, Reader An object that contains the data to set the parameter value to. b, long the number of characters in the parameter data. c) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public synchronized void	setClob(int index of the first parameter is 1, the second is 2, ... a, Reader An object that contains the data to set the parameter value to. b) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to a `Reader` object.
public synchronized void	setClob(int the first parameter is 1, the second is 2, ... a, Clob a `Clob` object that maps an SQL `CLOB` value b) Implements java.sql.PreparedStatement.setClob. Sets the designated parameter to the given `java.sql.Clob` object.
public synchronized void	setCursorName(String the new cursor name, which must be unique within a connection a) 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 synchronized void	setDate(int the first parameter is 1, the second is 2, ... a, Date the parameter value b) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value using the default time zone of the virtual machine that is running the application.
public synchronized void	setDate(int the first parameter is 1, the second is 2, ... a, Date the parameter value b, Calendar the `Calendar` object the driver will use to construct the date c) Implements java.sql.PreparedStatement.setDate. Sets the designated parameter to the given `java.sql.Date` value, using the given `Calendar` object.
public synchronized void	setDouble(int the first parameter is 1, the second is 2, ... a, double the parameter value b) Implements java.sql.PreparedStatement.setDouble. Sets the designated parameter to the given Java `double` value.
public synchronized void	setEscapeProcessing(boolean `true` to enable escape processing; `false` to disable it a) Implements java.sql.Statement.setEscapeProcessing. Sets escape processing on or off.
public synchronized void	setFetchDirection(int the initial direction for processing rows a) 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 synchronized void	setFetchSize(int the number of rows to fetch a) 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 synchronized void	setFloat(int the first parameter is 1, the second is 2, ... a, float the parameter value b) Implements java.sql.PreparedStatement.setFloat. Sets the designated parameter to the given Java `float` value.
public synchronized void	setInner(PreparedStatement inner)
public synchronized void	setInt(int the first parameter is 1, the second is 2, ... a, int the parameter value b) Implements java.sql.PreparedStatement.setInt. Sets the designated parameter to the given Java `int` value.
public synchronized void	setLong(int the first parameter is 1, the second is 2, ... a, long the parameter value b) Implements java.sql.PreparedStatement.setLong. Sets the designated parameter to the given Java `long` value.
public synchronized void	setMaxFieldSize(int the new column size limit in bytes; zero means there is no limit a) 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 synchronized void	setMaxRows(int the new max rows limit; zero means there is no limit a) 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 synchronized void	setNCharacterStream(int of the first parameter is 1, the second is 2, ... a, Reader the parameter value b, long the number of characters in the parameter data. c) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public synchronized void	setNCharacterStream(int of the first parameter is 1, the second is 2, ... a, Reader the parameter value b) Implements java.sql.PreparedStatement.setNCharacterStream. Sets the designated parameter to a `Reader` object.
public synchronized void	setNClob(int index of the first parameter is 1, the second is 2, ... a, Reader An object that contains the data to set the parameter value to. b) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public synchronized void	setNClob(int index of the first parameter is 1, the second is 2, ... a, Reader An object that contains the data to set the parameter value to. b, long the number of characters in the parameter data. c) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `Reader` object.
public synchronized void	setNClob(int of the first parameter is 1, the second is 2, ... a, NClob the parameter value b) Implements java.sql.PreparedStatement.setNClob. Sets the designated parameter to a `java.sql.NClob` object.
public synchronized void	setNString(int of the first parameter is 1, the second is 2, ... a, String the parameter value b) Implements java.sql.PreparedStatement.setNString. Sets the designated parameter to the given `String` object.
public synchronized void	setNull(int the first parameter is 1, the second is 2, ... a, int the SQL type code defined in `java.sql.Types` b) Implements java.sql.PreparedStatement.setNull. Sets the designated parameter to SQL `NULL`.
public synchronized void	setNull(int the first parameter is 1, the second is 2, ... a, int a value from `java.sql.Types` b, String the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or REF c) Implements java.sql.PreparedStatement.setNull. Sets the designated parameter to SQL `NULL`.
public synchronized void	setObject(int the first parameter is 1, the second is 2, ... a, Object the object containing the input parameter value b, int the SQL type (as defined in java.sql.Types) to be sent to the database c) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public synchronized void	setObject(int the first parameter is 1, the second is 2, ... a, Object the object containing the input parameter value b, int the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type. c, int for `java.sql.Types.DECIMAL` or `java.sql.Types.NUMERIC types`, this is the number of digits after the decimal point. For Java Object types `InputStream` and `Reader`, this is the length of the data in the stream or reader. For all other types, this value will be ignored. d) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter with the given object.
public synchronized void	setObject(int the first parameter is 1, the second is 2, ... a, Object the object containing the input parameter value b) Implements java.sql.PreparedStatement.setObject. Sets the value of the designated parameter using the given object.
public synchronized void	setPoolable(boolean requests that the statement be pooled if true and that the statement not be pooled if false a) Implements java.sql.Statement.setPoolable. Requests that a `Statement` be pooled or not pooled.
public synchronized void	setQueryTimeout(int the new query timeout limit in seconds; zero means there is no limit a) 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 synchronized void	setRef(int the first parameter is 1, the second is 2, ... a, Ref an SQL `REF` value b) Implements java.sql.PreparedStatement.setRef. Sets the designated parameter to the given `REF(<structured-type>)` value.
public synchronized void	setRowId(int the first parameter is 1, the second is 2, ... a, RowId the parameter value b) Implements java.sql.PreparedStatement.setRowId. Sets the designated parameter to the given `java.sql.RowId` object.
public synchronized void	setShort(int the first parameter is 1, the second is 2, ... a, short the parameter value b) Implements java.sql.PreparedStatement.setShort. Sets the designated parameter to the given Java `short` value.
public synchronized void	setSQLXML(int index of the first parameter is 1, the second is 2, ... a, SQLXML a `SQLXML` object that maps an SQL `XML` value b) Implements java.sql.PreparedStatement.setSQLXML. Sets the designated parameter to the given `java.sql.SQLXML` object.
public synchronized void	setString(int the first parameter is 1, the second is 2, ... a, String the parameter value b) Implements java.sql.PreparedStatement.setString. Sets the designated parameter to the given Java `String` value.
public synchronized void	setTime(int the first parameter is 1, the second is 2, ... a, Time the parameter value b, Calendar the `Calendar` object the driver will use to construct the time c) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value, using the given `Calendar` object.
public synchronized void	setTime(int the first parameter is 1, the second is 2, ... a, Time the parameter value b) Implements java.sql.PreparedStatement.setTime. Sets the designated parameter to the given `java.sql.Time` value.
public synchronized void	setTimestamp(int the first parameter is 1, the second is 2, ... a, Timestamp the parameter value b, Calendar the `Calendar` object the driver will use to construct the timestamp c) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value, using the given `Calendar` object.
public synchronized void	setTimestamp(int the first parameter is 1, the second is 2, ... a, Timestamp the parameter value b) Implements java.sql.PreparedStatement.setTimestamp. Sets the designated parameter to the given `java.sql.Timestamp` value.
public synchronized void	setUnicodeStream(int the first parameter is 1, the second is 2, ... a, InputStream a `java.io.InputStream` object that contains the Unicode parameter value b, int the number of bytes in the stream c) Implements java.sql.PreparedStatement.setUnicodeStream. Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public synchronized void	setURL(int the first parameter is 1, the second is 2, ... a, URL the `java.net.URL` object to be set b) Implements java.sql.PreparedStatement.setURL. Sets the designated parameter to the given `java.net.URL` value.
public synchronized Object	unwrap(Class<T> A Class defining an interface that the result must implement. a) 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.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

public abstract Class SynchronizedFilterPreparedStatement

Field Summary

Constructor Summary

Method Summary