| Modifier and Type | Field and Description |
|---|---|
| protected CallableStatement |
| Access | Constructor and Description |
|---|---|
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| private void | |
| public synchronized void | addBatch()
Implements java. Adds a set of parameters to this |
| public synchronized void | addBatch(String
typically this is a SQL a)INSERT or
UPDATE statementImplements java. Adds the given SQL command to the current list of commands for this
|
| public synchronized void | cancel()
Implements java. Cancels this |
| public synchronized void | clearBatch()
Implements java. Empties this |
| public synchronized void | clearParameters()
Implements java. Clears the current parameter values immediately. |
| public synchronized void | clearWarnings()
Implements java. Clears all the warnings reported on this |
| public synchronized void | close()
Implements java. Releases this |
| public synchronized void | closeOnCompletion()
Implements java. Specifies that this |
| public synchronized boolean | execute()
Implements java. Executes the SQL statement in this |
| 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
b)getGeneratedKeys; one of the following constants:
Statement.RETURN_GENERATED_KEYS or
Statement.NO_GENERATED_KEYSImplements java. 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 b)getGeneratedKeysImplements java. 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. 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 b)getGeneratedKeysImplements java. 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. 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. Executes the SQL query in this |
| public synchronized ResultSet | executeQuery(String
an SQL statement to be sent to the database, typically a
static SQL a)SELECT statementImplements java. Executes the given SQL statement, which returns a single
|
| public synchronized int | executeUpdate()
Implements java. Executes the SQL statement in this |
| public synchronized int | executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as a, int[] INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.an array of column indexes indicating the columns
that should be returned from the inserted row b)Implements java. 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 a, String[] INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.an array of the names of the columns that should be
returned from the inserted row b)Implements java. 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 a)INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.Implements java. Executes the given SQL statement, which may be an |
| public synchronized int | executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as a, int INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.a flag indicating whether auto-generated keys
should be made available for retrieval;
one of the following constants:
b)Statement.RETURN_GENERATED_KEYS
Statement.NO_GENERATED_KEYSImplements java. Executes the given SQL statement and signals the driver with the
given flag about whether the
auto-generated keys produced by this |
| public synchronized Array | getArray(int
the first parameter is 1, the second is 2, and
so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Array | getArray(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized 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. Retrieves the value of the designated JDBC |
| public synchronized BigDecimal | getBigDecimal(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized BigDecimal | getBigDecimal(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Blob | getBlob(int
the first parameter is 1, the second is 2, and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Blob | getBlob(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized boolean | getBoolean(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized boolean | getBoolean(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized byte | getByte(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized byte | getByte(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized byte[] | getBytes(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized byte[] | getBytes(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized Reader | getCharacterStream(int
the first parameter is 1, the second is 2, ... a)Implements java. Retrieves the value of the designated parameter as a
|
| public synchronized Reader | getCharacterStream(String
the name of the parameter a)Implements java. Retrieves the value of the designated parameter as a
|
| public synchronized Clob | getClob(int
the first parameter is 1, the second is 2, and
so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Clob | getClob(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized Connection | getConnection()
Implements java. Retrieves the |
| public synchronized Date | getDate(int
the first parameter is 1, the second is 2,
and so on a, Calendar the b)Calendar object the driver will use
to construct the dateImplements java. Retrieves the value of the designated JDBC |
| public synchronized Date | getDate(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Date | getDate(String
the name of the parameter a, Calendar the b)Calendar object the driver will use
to construct the dateImplements java. Retrieves the value of a JDBC |
| public synchronized Date | getDate(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized double | getDouble(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized double | getDouble(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized int | getFetchDirection()
Implements java. Retrieves the direction for fetching rows from
database tables that is the default for result sets
generated from this |
| public synchronized int | getFetchSize()
Implements java. Retrieves the number of result set rows that is the default
fetch size for |
| public synchronized float | getFloat(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized float | getFloat(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized ResultSet | getGeneratedKeys()
Implements java. Retrieves any auto-generated keys created as a result of executing this
|
| public synchronized CallableStatement | |
| public synchronized int | getInt(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized int | getInt(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized long | getLong(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized long | getLong(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized int | getMaxFieldSize()
Implements java. Retrieves the maximum number of bytes that can be
returned for character and binary column values in a |
| public synchronized int | getMaxRows()
Implements java. Retrieves the maximum number of rows that a
|
| public synchronized ResultSetMetaData | getMetaData()
Implements java. Retrieves a |
| public synchronized boolean | getMoreResults()
Implements java. Moves to this |
| public synchronized boolean | getMoreResults(int
one of the following a)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_RESULTSImplements java. Moves to this |
| public synchronized Reader | getNCharacterStream(int
the first parameter is 1, the second is 2, ... a)Implements java. Retrieves the value of the designated parameter as a
|
| public synchronized Reader | getNCharacterStream(String
the name of the parameter a)Implements java. Retrieves the value of the designated parameter as a
|
| public synchronized NClob | getNClob(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized NClob | getNClob(int
the first parameter is 1, the second is 2, and
so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized String | getNString(int
index of the first parameter is 1, the second is 2, ... a)Implements java. Retrieves the value of the designated |
| public synchronized String | getNString(String
the name of the parameter a)Implements java. Retrieves the value of the designated |
| public synchronized Object | getObject(String
the name of the parameter a)Implements java. Retrieves the value of a parameter as an |
| public synchronized Object | getObject(String
the name of the parameter a, Map<K, V> the mapping from SQL type names to Java classes b)Implements java. Returns an object representing the value of OUT parameter
|
| public synchronized 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. Returns an object representing the value of OUT parameter
|
| public synchronized Object | getObject(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated parameter as an |
| public synchronized 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. Returns an object representing the value of OUT parameter
|
| public synchronized 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. Returns an object representing the value of OUT parameter
|
| public synchronized ParameterMetaData | getParameterMetaData()
Implements java. Retrieves the number, types and properties of this
|
| public synchronized int | getQueryTimeout()
Implements java. Retrieves the number of seconds the driver will
wait for a |
| public synchronized Ref | getRef(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Ref | getRef(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized ResultSet | getResultSet()
Implements java. Retrieves the current result as a |
| public synchronized int | getResultSetConcurrency()
Implements java. Retrieves the result set concurrency for |
| public synchronized int | getResultSetHoldability()
Implements java. Retrieves the result set holdability for |
| public synchronized int | getResultSetType()
Implements java. Retrieves the result set type for |
| public synchronized RowId | getRowId(String
the name of the parameter a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized RowId | getRowId(int
the first parameter is 1, the second is 2,... a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized short | getShort(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized short | getShort(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized SQLXML | getSQLXML(String
the name of the parameter a)Implements java. Retrieves the value of the designated |
| public synchronized SQLXML | getSQLXML(int
index of the first parameter is 1, the second is 2, ... a)Implements java. Retrieves the value of the designated |
| public synchronized String | getString(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized String | getString(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Time | getTime(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized Time | getTime(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Time | getTime(String
the name of the parameter a, Calendar the b)Calendar object the driver will use
to construct the timeImplements java. Retrieves the value of a JDBC |
| public synchronized Time | getTime(int
the first parameter is 1, the second is 2,
and so on a, Calendar the b)Calendar object the driver will use
to construct the timeImplements java. Retrieves the value of the designated JDBC |
| public synchronized Timestamp | getTimestamp(String
the name of the parameter a, Calendar the b)Calendar object the driver will use
to construct the timestampImplements java. Retrieves the value of a JDBC |
| public synchronized Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized Timestamp | getTimestamp(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on a, Calendar the b)Calendar object the driver will use
to construct the timestampImplements java. Retrieves the value of the designated JDBC |
| public synchronized int | getUpdateCount()
Implements java. Retrieves the current result as an update count;
if the result is a |
| public synchronized URL | getURL(int
the first parameter is 1, the second is 2,... a)Implements java. Retrieves the value of the designated JDBC |
| public synchronized URL | getURL(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public synchronized SQLWarning | getWarnings()
Implements java. Retrieves the first warning reported by calls on this |
| public synchronized boolean | isClosed()
Implements java. Retrieves whether this |
| public synchronized boolean | isCloseOnCompletion()
Implements java. Returns a value indicating whether this |
| public synchronized boolean | isPoolable()
Implements java. Returns a value indicating whether the |
| public synchronized boolean | isWrapperFor(Class<T>
a Class defining an interface. a)Implements java. Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. |
| public synchronized void | registerOutParameter(String
the name of the parameter a, int a value from b, String java.the fully-qualified name of an SQL structured type c)Implements java. Registers the designated output parameter. |
| public synchronized void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on a, int the JDBC type code defined by b)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.Implements java. Registers the OUT parameter in ordinal position
|
| public synchronized void | registerOutParameter(int
the first parameter is 1, the second is 2,... a, int a value from b, String java.the fully-qualified name of an SQL structured type c)Implements java. Registers the designated output parameter. |
| public synchronized void | registerOutParameter(String
the name of the parameter a, int SQL type code defined by b, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. c)Implements java. Registers the parameter named
|
| public synchronized void | registerOutParameter(String
the name of the parameter a, int the JDBC type code defined by b)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.Implements java. Registers the OUT parameter named
|
| public synchronized void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on a, int the SQL type code defined by b, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. c)Implements java. Registers the parameter in ordinal position
|
| public synchronized void | setArray(int
the first parameter is 1, the second is 2, ... a, Array an b)Array object that maps an SQL ARRAY valueImplements java. Sets the designated parameter to the given |
| public synchronized void | setAsciiStream(String
the name of the parameter a, InputStream the Java input stream that contains the ASCII parameter value b)Implements java. Sets the designated parameter to the given input stream. |
| public synchronized 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. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public synchronized 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. 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, long the number of bytes in the stream c)Implements java. 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. 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. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public synchronized void | setBigDecimal(String
the name of the parameter a, BigDecimal the parameter value b)Implements java. Sets the designated parameter to the given
|
| public synchronized void | setBigDecimal(int
the first parameter is 1, the second is 2, ... a, BigDecimal the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setBinaryStream(String
the name of the parameter a, InputStream the java input stream which contains the binary parameter value b)Implements java. Sets the designated parameter to the given input stream. |
| public synchronized 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. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public synchronized 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. 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, int the number of bytes in the stream c)Implements java. 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. 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. Sets the designated parameter to the given input stream. |
| public synchronized void | setBlob(String
the name of the parameter a, Blob a b)Blob object that maps an SQL BLOB valueImplements java. Sets the designated parameter to the given |
| public synchronized 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. Sets the designated parameter to an |
| public synchronized 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. Sets the designated parameter to an |
| 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. Sets the designated parameter to a |
| public synchronized void | setBlob(int
the first parameter is 1, the second is 2, ... a, Blob a b)Blob object that maps an SQL BLOB valueImplements java. Sets the designated parameter to the given |
| 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. Sets the designated parameter to a |
| public synchronized void | setBoolean(String
the name of the parameter a, boolean the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setBoolean(int
the first parameter is 1, the second is 2, ... a, boolean the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setByte(String
the name of the parameter a, byte the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setByte(int
the first parameter is 1, the second is 2, ... a, byte the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setBytes(String
the name of the parameter a, byte[] the parameter value b)Implements java. Sets the designated parameter to the given Java array of bytes. |
| public synchronized void | setBytes(int
the first parameter is 1, the second is 2, ... a, byte[] the parameter value b)Implements java. Sets the designated parameter to the given Java array of bytes. |
| public synchronized void | setCharacterStream(String
the name of the parameter a, Reader the b, long java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream c)Implements java. Sets the designated parameter to the given |
| public synchronized void | setCharacterStream(String
the name of the parameter a, Reader the b)java.io.Reader object that contains the
Unicode dataImplements java. Sets the designated parameter to the given |
| public synchronized void | setCharacterStream(String
the name of the parameter a, Reader the b, int java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream c)Implements java. Sets the designated parameter to the given |
| public synchronized void | setCharacterStream(int
the first parameter is 1, the second is 2, ... a, Reader the b)java.io.Reader object that contains the
Unicode dataImplements java. Sets the designated parameter to the given |
| public synchronized void | setCharacterStream(int
the first parameter is 1, the second is 2, ... a, Reader the b, int java.io.Reader object that contains the
Unicode datathe number of characters in the stream c)Implements java. Sets the designated parameter to the given |
| public synchronized void | setCharacterStream(int
the first parameter is 1, the second is 2, ... a, Reader the b, long java.io.Reader object that contains the
Unicode datathe number of characters in the stream c)Implements java. Sets the designated parameter to the given |
| public synchronized 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. Sets the designated parameter to a |
| public synchronized void | setClob(String
the name of the parameter a, Clob a b)Clob object that maps an SQL CLOB valueImplements java. Sets the designated parameter to the given |
| public synchronized 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. Sets the designated parameter to a |
| 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. Sets the designated parameter to a |
| 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. Sets the designated parameter to a |
| public synchronized void | setClob(int
the first parameter is 1, the second is 2, ... a, Clob a b)Clob object that maps an SQL CLOB valueImplements java. Sets the designated parameter to the given |
| public synchronized void | setCursorName(String
the new cursor name, which must be unique within
a connection a)Implements java. Sets the SQL cursor name to the given |
| public synchronized void | setDate(String
the name of the parameter a, Date the parameter value b, Calendar the c)Calendar object the driver will use
to construct the dateImplements java. Sets the designated parameter to the given |
| public synchronized void | setDate(String
the name of the parameter a, Date the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setDate(int
the first parameter is 1, the second is 2, ... a, Date the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setDate(int
the first parameter is 1, the second is 2, ... a, Date the parameter value b, Calendar the c)Calendar object the driver will use
to construct the dateImplements java. Sets the designated parameter to the given |
| public synchronized void | setDouble(String
the name of the parameter a, double the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setDouble(int
the first parameter is 1, the second is 2, ... a, double the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setEscapeProcessing(boolean
true to enable escape processing;
false to disable itImplements java. Sets escape processing on or off. |
| public synchronized void | setFetchDirection(int
the initial direction for processing rows a)Implements java. Gives the driver a hint as to the direction in which
rows will be processed in |
| public synchronized void | setFetchSize(int
the number of rows to fetch a)Implements java. 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
|
| public synchronized void | setFloat(String
the name of the parameter a, float the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setFloat(int
the first parameter is 1, the second is 2, ... a, float the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | |
| public synchronized void | setInt(String
the name of the parameter a, int the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setInt(int
the first parameter is 1, the second is 2, ... a, int the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setLong(String
the name of the parameter a, long the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setLong(int
the first parameter is 1, the second is 2, ... a, long the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setMaxFieldSize(int
the new column size limit in bytes; zero means there is no limit a)Implements java. Sets the limit for the maximum number of bytes that can be returned for
character and binary column values in a |
| public synchronized void | setMaxRows(int
the new max rows limit; zero means there is no limit a)Implements java. Sets the limit for the maximum number of rows that any
|
| public synchronized void | setNCharacterStream(String
the name of the parameter a, Reader the parameter value b)Implements java. Sets the designated parameter to a |
| public synchronized 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. Sets the designated parameter to a |
| 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. Sets the designated parameter to a |
| public synchronized void | setNCharacterStream(int
of the first parameter is 1, the second is 2, ... a, Reader the parameter value b)Implements java. Sets the designated parameter to a |
| public synchronized 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. Sets the designated parameter to a |
| public synchronized void | setNClob(String
the name of the parameter to be set a, NClob the parameter value b)Implements java. Sets the designated parameter to a |
| public synchronized 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. Sets the designated parameter to a |
| 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. Sets the designated parameter to a |
| 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. Sets the designated parameter to a |
| public synchronized void | setNClob(int
of the first parameter is 1, the second is 2, ... a, NClob the parameter value b)Implements java. Sets the designated parameter to a |
| public synchronized void | setNString(String
the name of the parameter to be set a, String the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setNString(int
of the first parameter is 1, the second is 2, ... a, String the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setNull(String
the name of the parameter a, int a value from b, String java.sql.Typesthe fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or
SQL c)REF valueImplements java. Sets the designated parameter to SQL |
| public synchronized void | setNull(String
the name of the parameter a, int the SQL type code defined in b)java.sql.TypesImplements java. Sets the designated parameter to SQL |
| public synchronized void | setNull(int
the first parameter is 1, the second is 2, ... a, int the SQL type code defined in b)java.sql.TypesImplements java. Sets the designated parameter to SQL |
| public synchronized void | setNull(int
the first parameter is 1, the second is 2, ... a, int a value from b, String java.sql.Typesthe fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or REF c)Implements java. Sets the designated parameter to SQL |
| public synchronized void | setObject(String
the name of the parameter a, Object the object containing the input parameter value b)Implements java. Sets the value of the designated parameter with the given object. |
| public synchronized 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. Sets the value of the designated parameter with the given object. |
| public synchronized 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. 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 c)Implements java. 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 d)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.Implements java. 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. 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. Requests that a |
| public synchronized void | setQueryTimeout(int
the new query timeout limit in seconds; zero means
there is no limit a)Implements java. Sets the number of seconds the driver will wait for a
|
| public synchronized void | setRef(int
the first parameter is 1, the second is 2, ... a, Ref an SQL b)REF valueImplements java. Sets the designated parameter to the given
|
| public synchronized void | setRowId(String
the name of the parameter a, RowId the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setRowId(int
the first parameter is 1, the second is 2, ... a, RowId the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setShort(String
the name of the parameter a, short the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setShort(int
the first parameter is 1, the second is 2, ... a, short the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setSQLXML(String
the name of the parameter a, SQLXML a b)SQLXML object that maps an SQL XML valueImplements java. Sets the designated parameter to the given |
| public synchronized void | setSQLXML(int
index of the first parameter is 1, the second is 2, ... a, SQLXML a b)SQLXML object that maps an SQL XML valueImplements java. Sets the designated parameter to the given |
| public synchronized void | setString(String
the name of the parameter a, String the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setString(int
the first parameter is 1, the second is 2, ... a, String the parameter value b)Implements java. Sets the designated parameter to the given Java |
| public synchronized void | setTime(String
the name of the parameter a, Time the parameter value b, Calendar the c)Calendar object the driver will use
to construct the timeImplements java. Sets the designated parameter to the given |
| public synchronized void | setTime(String
the name of the parameter a, Time the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setTime(int
the first parameter is 1, the second is 2, ... a, Time the parameter value b, Calendar the c)Calendar object the driver will use
to construct the timeImplements java. Sets the designated parameter to the given |
| public synchronized void | setTime(int
the first parameter is 1, the second is 2, ... a, Time the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setTimestamp(String
the name of the parameter a, Timestamp the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setTimestamp(String
the name of the parameter a, Timestamp the parameter value b, Calendar the c)Calendar object the driver will use
to construct the timestampImplements java. Sets the designated parameter to the given |
| public synchronized void | setTimestamp(int
the first parameter is 1, the second is 2, ... a, Timestamp the parameter value b, Calendar the c)Calendar object the driver will use
to construct the timestampImplements java. Sets the designated parameter to the given |
| public synchronized void | setTimestamp(int
the first parameter is 1, the second is 2, ... a, Timestamp the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setUnicodeStream(int
the first parameter is 1, the second is 2, ... a, InputStream a b, int java.io.InputStream object that contains the
Unicode parameter valuethe number of bytes in the stream c)Implements java. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public synchronized void | setURL(String
the name of the parameter a, URL the parameter value b)Implements java. Sets the designated parameter to the given |
| public synchronized void | setURL(int
the first parameter is 1, the second is 2, ... a, URL the b)java.net.URL object to be setImplements java. Sets the designated parameter to the given |
| public synchronized Object | unwrap(Class<T>
A Class defining an interface that the result must implement. a)Implements java. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. |
| public synchronized boolean | wasNull()
Implements java. Retrieves whether the last OUT parameter read had the value of
SQL |