Top Description Fields Constructors Methods
com.mchange.v2.c3p0.impl

public final Class NewProxyCallableStatement

extends Object
implements CallableStatement, C3P0ProxyStatement, ProxyResultSetDetachable
Class Inheritance
All Implemented Interfaces
com.mchange.v2.c3p0.impl.ProxyResultSetDetachable, com.mchange.v2.c3p0.C3P0ProxyStatement, java.sql.Statement, java.lang.AutoCloseable, java.sql.Wrapper, java.sql.CallableStatement, java.sql.PreparedStatement
Imports
com.mchange.v2.c3p0.C3P0ProxyStatement, com.mchange.v2.c3p0.impl.ProxyResultSetDetachable, java.io.InputStream, .Reader, java.lang.Class, .Object, .String, java.math.BigDecimal, java.net.URL, java.sql.Array, .Blob, .CallableStatement, .Clob, .Connection, .Date, .NClob, .ParameterMetaData, .Ref, .ResultSet, .ResultSetMetaData, .RowId, .SQLException, .SQLType, .SQLWarning, .SQLXML, .Time, .Timestamp, java.sql.*, java.util.Calendar, .Map, .HashSet, .Iterator, javax.sql.*, com.mchange.v2.log.*, java.lang.reflect.Method, .InvocationTargetException, com.mchange.v2.sql.SqlUtils

This class was generated by com.mchange.v2.c3p0.codegen.JdbcProxyGenerator$NewProxyAnyStatementGenerator.

Field Summary

Modifier and TypeField and Description
pack-priv ConnectionEventListener
pack-priv NewProxyConnection
protected CallableStatement
pack-priv boolean
private static final MLogger
pack-priv HashSet<E>
pack-priv volatile NewPooledConnection

Constructor Summary

AccessConstructor and Description
pack-priv
pack-priv
pack-priv
NewProxyCallableStatement(CallableStatement inner, NewPooledConnection parentPooledConnection, boolean cached, NewProxyConnection cProxy)

Method Summary

Modifier and TypeMethod and Description
private void
public final void
addBatch()

Implements java.sql.PreparedStatement.addBatch.

Adds a set of parameters to this PreparedStatement object's batch of commands.

public final 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.

pack-priv void
attach(NewPooledConnection parentPooledConnection)

public final void
cancel()

Implements java.sql.Statement.cancel.

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

public final void
clearBatch()

Implements java.sql.Statement.clearBatch.

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

public final void
clearParameters()

Implements java.sql.PreparedStatement.clearParameters.

Clears the current parameter values immediately.

public final void
clearWarnings()

Implements java.sql.Statement.clearWarnings.

Clears all the warnings reported on this Statement object.

public final 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 final void
closeOnCompletion()

Implements java.sql.Statement.closeOnCompletion.

Specifies that this Statement will be closed when all its dependent result sets are closed.

private void
public void
public final String
enquoteIdentifier(String
a SQL identifier
a
,
boolean
indicates if a simple SQL identifier should be returned as a quoted identifier
b
)

Overrides default java.sql.Statement.enquoteIdentifier.

Returns a SQL identifier.

public final String
enquoteLiteral(String
a character string
a
)

Overrides default java.sql.Statement.enquoteLiteral.

Returns a String enclosed in single quotes.

public final String
enquoteNCharLiteral(String
a character string
a
)

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 final boolean
execute()

Implements java.sql.PreparedStatement.execute.

Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

public final boolean
execute(String
any SQL statement
a
)

Implements java.sql.Statement.execute.

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

public final 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 final 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 final 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 final 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 final 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 final long
executeLargeUpdate()

Overrides default java.sql.PreparedStatement.executeLargeUpdate.

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 final 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.
a
)

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 final 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.
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
)

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 final 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.
a
,
String[]
an array of the names of the columns that should be returned from the inserted row
b
)

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 final 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.
a
,
int[]
an array of column indexes indicating the columns that should be returned from the inserted row
b
)

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 final 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 final 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 final 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 final 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 final 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 final 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 final 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 final Array
getArray(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of the designated JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.

public final Array
getArray(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getArray.

Retrieves the value of a JDBC ARRAY parameter as an java.sql.Array object in the Java programming language.

public final BigDecimal
getBigDecimal(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of a JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

public final BigDecimal
getBigDecimal(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with as many digits to the right of the decimal point as the value contains.

public final BigDecimal
getBigDecimal(int
the first parameter is 1, the second is 2, and so on
a
,
int
the number of digits to the right of the decimal point
b
)

Implements java.sql.CallableStatement.getBigDecimal.

Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point.

public final Blob
getBlob(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of the designated JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.

public final Blob
getBlob(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getBlob.

Retrieves the value of a JDBC BLOB parameter as a java.sql.Blob object in the Java programming language.

public final boolean
getBoolean(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

public final boolean
getBoolean(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getBoolean.

Retrieves the value of a JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.

public final byte
getByte(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.

public final byte
getByte(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getByte.

Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.

public final byte[]
getBytes(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

public final byte[]
getBytes(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getBytes.

Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

public final Reader
getCharacterStream(int
the first parameter is 1, the second is 2, ...
a
)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public final Reader
getCharacterStream(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public final Clob
getClob(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

public final Clob
getClob(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getClob.

Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

public final Connection
getConnection()

Implements java.sql.Statement.getConnection.

Retrieves the Connection object that produced this Statement object.

public final Date
getDate(String
the name of the parameter
a
,
Calendar
the Calendar object the driver will use to construct the date
b
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.

public final Date
getDate(int
the first parameter is 1, the second is 2, and so on
a
,
Calendar
the Calendar object the driver will use to construct the date
b
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.

public final Date
getDate(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.

public final Date
getDate(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getDate.

Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.

public final double
getDouble(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.

public final double
getDouble(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getDouble.

Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.

public final 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 final 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 final float
getFloat(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.

public final float
getFloat(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getFloat.

Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.

public final ResultSet
getGeneratedKeys()

Implements java.sql.Statement.getGeneratedKeys.

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

public final int
getInt(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.

public final int
getInt(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getInt.

Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

public final 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 final 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 final long
getLong(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

public final long
getLong(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getLong.

Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

public final 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 final 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 final 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 final 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 final 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 final Reader
getNCharacterStream(int
the first parameter is 1, the second is 2, ...
a
)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public final Reader
getNCharacterStream(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getNCharacterStream.

Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

public final NClob
getNClob(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

public final NClob
getNClob(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getNClob.

Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

public final String
getNString(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

public final String
getNString(int
index of the first parameter is 1, the second is 2, ...
a
)

Implements java.sql.CallableStatement.getNString.

Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

public final Object
getObject(int
the first parameter is 1, the second is 2, and so on
a
,
Class<T>
Class representing the Java data type to convert the designated parameter to.
b
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

public final Object
getObject(int
the first parameter is 1, the second is 2, and so on
a
,
Map<K, V>
the mapping from SQL type names to Java classes
b
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.

public final Object
getObject(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of the designated parameter as an Object in the Java programming language.

public final Object
getObject(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getObject.

Retrieves the value of a parameter as an Object in the Java programming language.

public final Object
getObject(String
the name of the parameter
a
,
Map<K, V>
the mapping from SQL type names to Java classes
b
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.

public final Object
getObject(String
the name of the parameter
a
,
Class<T>
Class representing the Java data type to convert the designated parameter to.
b
)

Implements java.sql.CallableStatement.getObject.

Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

public final ParameterMetaData
getParameterMetaData()

Implements java.sql.PreparedStatement.getParameterMetaData.

Retrieves the number, types and properties of this PreparedStatement object's parameters.

public final int
getQueryTimeout()

Implements java.sql.Statement.getQueryTimeout.

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

public final Ref
getRef(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.

public final Ref
getRef(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getRef.

Retrieves the value of a JDBC REF(<structured-type>) parameter as a java.sql.Ref object in the Java programming language.

public final ResultSet
getResultSet()

Implements java.sql.Statement.getResultSet.

Retrieves the current result as a ResultSet object.

public final int
getResultSetConcurrency()

Implements java.sql.Statement.getResultSetConcurrency.

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

public final int
getResultSetHoldability()

Implements java.sql.Statement.getResultSetHoldability.

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

public final int
getResultSetType()

Implements java.sql.Statement.getResultSetType.

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

public final RowId
getRowId(int
the first parameter is 1, the second is 2,...
a
)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

public final RowId
getRowId(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getRowId.

Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

public final short
getShort(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

public final short
getShort(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getShort.

Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

public final SQLXML
getSQLXML(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

public final SQLXML
getSQLXML(int
index of the first parameter is 1, the second is 2, ...
a
)

Implements java.sql.CallableStatement.getSQLXML.

Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

public final String
getString(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getString.

Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

public final String
getString(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getString.

Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

public final Time
getTime(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.

public final Time
getTime(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.

public final Time
getTime(String
the name of the parameter
a
,
Calendar
the Calendar object the driver will use to construct the time
b
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

public final Time
getTime(int
the first parameter is 1, the second is 2, and so on
a
,
Calendar
the Calendar object the driver will use to construct the time
b
)

Implements java.sql.CallableStatement.getTime.

Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

public final Timestamp
getTimestamp(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

public final Timestamp
getTimestamp(String
the name of the parameter
a
,
Calendar
the Calendar object the driver will use to construct the timestamp
b
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

public final Timestamp
getTimestamp(int
the first parameter is 1, the second is 2, and so on
a
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

public final Timestamp
getTimestamp(int
the first parameter is 1, the second is 2, and so on
a
,
Calendar
the Calendar object the driver will use to construct the timestamp
b
)

Implements java.sql.CallableStatement.getTimestamp.

Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

public final 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 final URL
getURL(String
the name of the parameter
a
)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.

public final URL
getURL(int
the first parameter is 1, the second is 2,...
a
)

Implements java.sql.CallableStatement.getURL.

Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.

public final SQLWarning
getWarnings()

Implements java.sql.Statement.getWarnings.

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

public final boolean
isClosed()

Implements java.sql.Statement.isClosed.

Retrieves whether this Statement object has been closed.

public final 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.

pack-priv boolean
public final boolean
isPoolable()

Implements java.sql.Statement.isPoolable.

Returns a value indicating whether the Statement is poolable or not.

public final boolean
isSimpleIdentifier(String
a SQL identifier
a
)

Overrides default java.sql.Statement.isSimpleIdentifier.

Retrieves whether identifier is a simple SQL identifier.

public final 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.

private boolean
private boolean
pack-priv void
public Object
rawStatementOperation(Method m, Object target, Object[] args)

Implements com.mchange.v2.c3p0.C3P0ProxyStatement.rawStatementOperation.

Allows one to work with the unproxied, raw vendor-provided Statement .

public final void
registerOutParameter(String
the name of the parameter
a
,
SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
b
,
String
the fully-qualified name of an SQL structured type
c
)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public final void
registerOutParameter(String
the name of the parameter
a
,
SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter. If the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
b
)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter named parameterName to the JDBC type sqlType.

public final void
registerOutParameter(int
the first parameter is 1, the second is 2,...
a
,
SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
b
,
String
the fully-qualified name of an SQL structured type
c
)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public final void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
a
,
SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
b
,
int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
c
)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.

public final void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
a
,
SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter. If the parameter is of JDBC type JDBCType.NUMERIC or JDBCType.DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
b
)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

public final void
registerOutParameter(String
the name of the parameter
a
,
SQLType
the JDBC type code defined by SQLType to use to register the OUT Parameter.
b
,
int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
c
)

Overrides default java.sql.CallableStatement.registerOutParameter.

Registers the parameter named parameterName to be of JDBC type sqlType.

public final void
registerOutParameter(String
the name of the parameter
a
,
int
the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
b
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter named parameterName to the JDBC type sqlType.

public final void
registerOutParameter(String
the name of the parameter
a
,
int
SQL type code defined by java.sql.Types.
b
,
int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
c
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter named parameterName to be of JDBC type sqlType.

public final void
registerOutParameter(String
the name of the parameter
a
,
int
a value from java.sql.Types
b
,
String
the fully-qualified name of an SQL structured type
c
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public final void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
a
,
int
the JDBC type code defined by java.sql.Types. If the parameter is of JDBC type NUMERIC or DECIMAL, the version of registerOutParameter that accepts a scale value should be used.
b
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

public final void
registerOutParameter(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 structured type
c
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the designated output parameter.

public final void
registerOutParameter(int
the first parameter is 1, the second is 2, and so on
a
,
int
the SQL type code defined by java.sql.Types.
b
,
int
the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.
c
)

Implements java.sql.CallableStatement.registerOutParameter.

Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.

public final 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 final void
setAsciiStream(String
the name of the parameter
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.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public final void
setAsciiStream(String
the name of the parameter
a
,
InputStream
the Java input stream that contains the ASCII parameter value
b
)

Implements java.sql.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream.

public final void
setAsciiStream(String
the name of the parameter
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.CallableStatement.setAsciiStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public final 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 final 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 final 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 final void
setBigDecimal(String
the name of the parameter
a
,
BigDecimal
the parameter value
b
)

Implements java.sql.CallableStatement.setBigDecimal.

Sets the designated parameter to the given java.math.BigDecimal value.

public final 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 final void
setBinaryStream(String
the name of the parameter
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.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public final void
setBinaryStream(String
the name of the parameter
a
,
InputStream
the java input stream which contains the binary parameter value
b
)

Implements java.sql.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream.

public final void
setBinaryStream(String
the name of the parameter
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.CallableStatement.setBinaryStream.

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

public final 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 final 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 final 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 final void
setBlob(String
the name of the parameter to be set 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.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.

public final void
setBlob(String
the name of the parameter
a
,
Blob
a Blob object that maps an SQL BLOB value
b
)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to the given java.sql.Blob object.

public final void
setBlob(String
the name of the parameter
a
,
InputStream
An object that contains the data to set the parameter value to.
b
)

Implements java.sql.CallableStatement.setBlob.

Sets the designated parameter to an InputStream object.

public final 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 final 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 final 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 final void
setBoolean(String
the name of the parameter
a
,
boolean
the parameter value
b
)

Implements java.sql.CallableStatement.setBoolean.

Sets the designated parameter to the given Java boolean value.

public final 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 final void
setByte(String
the name of the parameter
a
,
byte
the parameter value
b
)

Implements java.sql.CallableStatement.setByte.

Sets the designated parameter to the given Java byte value.

public final 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 final void
setBytes(String
the name of the parameter
a
,
byte[]
the parameter value
b
)

Implements java.sql.CallableStatement.setBytes.

Sets the designated parameter to the given Java array of bytes.

public final 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 final void
setCharacterStream(String
the name of the parameter
a
,
Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
b
,
long
the number of characters in the stream
c
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public final void
setCharacterStream(String
the name of the parameter
a
,
Reader
the java.io.Reader object that contains the UNICODE data used as the designated parameter
b
,
int
the number of characters in the stream
c
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object, which is the given number of characters long.

public final void
setCharacterStream(String
the name of the parameter
a
,
Reader
the java.io.Reader object that contains the Unicode data
b
)

Implements java.sql.CallableStatement.setCharacterStream.

Sets the designated parameter to the given Reader object.

public final 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 final 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 final 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 final void
setClob(String
the name of the parameter
a
,
Clob
a Clob object that maps an SQL CLOB value
b
)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to the given java.sql.Clob object.

public final void
setClob(String
the name of the parameter to be set
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.CallableStatement.setClob.

Sets the designated parameter to a Reader object.

public final void
setClob(String
the name of the parameter
a
,
Reader
An object that contains the data to set the parameter value to.
b
)

Implements java.sql.CallableStatement.setClob.

Sets the designated parameter to a Reader object.

public final 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 final 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 final 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 final 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 final void
setDate(String
the name of the parameter
a
,
Date
the parameter value
b
)

Implements java.sql.CallableStatement.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 final void
setDate(String
the name of the parameter
a
,
Date
the parameter value
b
,
Calendar
the Calendar object the driver will use to construct the date
c
)

Implements java.sql.CallableStatement.setDate.

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

public final 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 final 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 final void
setDouble(String
the name of the parameter
a
,
double
the parameter value
b
)

Implements java.sql.CallableStatement.setDouble.

Sets the designated parameter to the given Java double value.

public final 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 final 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 final 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 final 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 final void
setFloat(String
the name of the parameter
a
,
float
the parameter value
b
)

Implements java.sql.CallableStatement.setFloat.

Sets the designated parameter to the given Java float value.

public final 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 final void
setInt(String
the name of the parameter
a
,
int
the parameter value
b
)

Implements java.sql.CallableStatement.setInt.

Sets the designated parameter to the given Java int value.

public final 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 final void
setLargeMaxRows(long
the new max rows limit; zero means there is no limit
a
)

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 final void
setLong(String
the name of the parameter
a
,
long
the parameter value
b
)

Implements java.sql.CallableStatement.setLong.

Sets the designated parameter to the given Java long value.

public final 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 final 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 final 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 final void
setNCharacterStream(String
the name of the parameter
a
,
Reader
the parameter value
b
)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.

public final void
setNCharacterStream(String
the name of the parameter to be set
a
,
Reader
the parameter value
b
,
long
the number of characters in the parameter data.
c
)

Implements java.sql.CallableStatement.setNCharacterStream.

Sets the designated parameter to a Reader object.

public final 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 final 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 final void
setNClob(String
the name of the parameter
a
,
Reader
An object that contains the data to set the parameter value to.
b
)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.

public final void
setNClob(String
the name of the parameter to be set
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.CallableStatement.setNClob.

Sets the designated parameter to a Reader object.

public final void
setNClob(String
the name of the parameter to be set
a
,
NClob
the parameter value
b
)

Implements java.sql.CallableStatement.setNClob.

Sets the designated parameter to a java.sql.NClob object.

public final 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 final 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 final 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 final void
setNString(String
the name of the parameter to be set
a
,
String
the parameter value
b
)

Implements java.sql.CallableStatement.setNString.

Sets the designated parameter to the given String object.

public final 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 final void
setNull(String
the name of the parameter
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 SQL REF value
c
)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.

public final void
setNull(String
the name of the parameter
a
,
int
the SQL type code defined in java.sql.Types
b
)

Implements java.sql.CallableStatement.setNull.

Sets the designated parameter to SQL NULL.

public final 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 final 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 final void
setObject(String
the name of the parameter
a
,
Object
the object containing the input parameter value
b
)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public final void
setObject(String
the name of the parameter
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.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public final void
setObject(String
the name of the parameter
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 all other types, this value will be ignored.
d
)

Implements java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public final void
setObject(String
the name of the parameter
a
,
Object
the object containing the input parameter value
b
,
SQLType
the SQL type to be sent to the database. The scale argument may further qualify this type.
c
,
int
for java.sql.JDBCType.DECIMAL or java.sql.JDBCType.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
)

Overrides default java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public final void
setObject(String
the name of the parameter
a
,
Object
the object containing the input parameter value
b
,
SQLType
the SQL type to be sent to the database
c
)

Overrides default java.sql.CallableStatement.setObject.

Sets the value of the designated parameter with the given object.

public final 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 final void
setObject(int
the first parameter is 1, the second is 2, ...
a
,
Object
the object containing the input parameter value
b
,
SQLType
the SQL type to be sent to the database
c
)

Overrides default java.sql.PreparedStatement.setObject.

Sets the value of the designated parameter with the given object.

public final void
setObject(int
the first parameter is 1, the second is 2, ...
a
,
Object
the object containing the input parameter value
b
,
SQLType
the SQL type to be sent to the database. The scale argument may further qualify this type.
c
,
int
for java.sql.JDBCType.DECIMAL or java.sql.JDBCType.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
)

Overrides default java.sql.PreparedStatement.setObject.

Sets the value of the designated parameter with the given object.

public final 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 final 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 final 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 final 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 final 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 final void
setRowId(String
the name of the parameter
a
,
RowId
the parameter value
b
)

Implements java.sql.CallableStatement.setRowId.

Sets the designated parameter to the given java.sql.RowId object.

public final 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 final void
setShort(String
the name of the parameter
a
,
short
the parameter value
b
)

Implements java.sql.CallableStatement.setShort.

Sets the designated parameter to the given Java short value.

public final 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 final void
setSQLXML(String
the name of the parameter
a
,
SQLXML
a SQLXML object that maps an SQL XML value
b
)

Implements java.sql.CallableStatement.setSQLXML.

Sets the designated parameter to the given java.sql.SQLXML object.

public final 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 final void
setString(String
the name of the parameter
a
,
String
the parameter value
b
)

Implements java.sql.CallableStatement.setString.

Sets the designated parameter to the given Java String value.

public final 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 final void
setTime(String
the name of the parameter
a
,
Time
the parameter value
b
)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value.

public final void
setTime(String
the name of the parameter
a
,
Time
the parameter value
b
,
Calendar
the Calendar object the driver will use to construct the time
c
)

Implements java.sql.CallableStatement.setTime.

Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.

public final 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 final 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 final void
setTimestamp(String
the name of the parameter
a
,
Timestamp
the parameter value
b
,
Calendar
the Calendar object the driver will use to construct the timestamp
c
)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

public final void
setTimestamp(String
the name of the parameter
a
,
Timestamp
the parameter value
b
)

Implements java.sql.CallableStatement.setTimestamp.

Sets the designated parameter to the given java.sql.Timestamp value.

public final 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 final 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 final 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 final void
setURL(String
the name of the parameter
a
,
URL
the parameter value
b
)

Implements java.sql.CallableStatement.setURL.

Sets the designated parameter to the given java.net.URL object.

public final 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 String
toString()

Overrides java.lang.Object.toString.

Returns a string representation of the object.

public final 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.

public final boolean
wasNull()

Implements java.sql.CallableStatement.wasNull.

Retrieves whether the last OUT parameter read had the value of SQL NULL.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAllwaitwaitwait