| Modifier and Type | Field and Description |
|---|---|
| protected CallableStatement |
| Access | Constructor and Description |
|---|---|
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| private void | |
| public void | addBatch()
Implements java. Adds a set of parameters to this |
| public 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 void | cancel()
Implements java. Cancels this |
| public void | clearBatch()
Implements java. Empties this |
| public void | clearParameters()
Implements java. Clears the current parameter values immediately. |
| public void | clearWarnings()
Implements java. Clears all the warnings reported on this |
| public void | close()
Implements java. Releases this |
| public void | closeOnCompletion()
Implements java. Specifies that this |
| public boolean | execute()
Implements java. Executes the SQL statement in this |
| public 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 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 boolean | execute(String
any SQL statement a)Implements java. Executes the given SQL statement, which may return multiple results. |
| public 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 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 ResultSet | executeQuery()
Implements java. Executes the SQL query in this |
| public 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 int | executeUpdate()
Implements java. Executes the SQL statement in this |
| public 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 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 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 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 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 Array | getArray(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 BigDecimal | getBigDecimal(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 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 Blob | getBlob(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public boolean | getBoolean(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 byte | getByte(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 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 byte[] | getBytes(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 Reader | getCharacterStream(String
the name of the parameter a)Implements java. Retrieves the value of the designated parameter as a
|
| public 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 Clob | getClob(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public Connection | getConnection()
Implements java. Retrieves the |
| public 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 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 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 Date | getDate(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public double | getDouble(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 int | getFetchDirection()
Implements java. Retrieves the direction for fetching rows from
database tables that is the default for result sets
generated from this |
| public int | getFetchSize()
Implements java. Retrieves the number of result set rows that is the default
fetch size for |
| public 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 float | getFloat(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public ResultSet | getGeneratedKeys()
Implements java. Retrieves any auto-generated keys created as a result of executing this
|
| public CallableStatement | |
| public 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 int | getInt(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 long | getLong(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public int | getMaxFieldSize()
Implements java. Retrieves the maximum number of bytes that can be
returned for character and binary column values in a |
| public int | getMaxRows()
Implements java. Retrieves the maximum number of rows that a
|
| public ResultSetMetaData | getMetaData()
Implements java. Retrieves a |
| public boolean | getMoreResults()
Implements java. Moves to this |
| public 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 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 Reader | getNCharacterStream(String
the name of the parameter a)Implements java. Retrieves the value of the designated parameter as a
|
| public NClob | getNClob(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 String | getNString(int
index of the first parameter is 1, the second is 2, ... a)Implements java. Retrieves the value of the designated |
| public String | getNString(String
the name of the parameter a)Implements java. Retrieves the value of the designated |
| public Object | getObject(String
the name of the parameter a)Implements java. Retrieves the value of a parameter as an |
| public 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 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 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 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 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 ParameterMetaData | getParameterMetaData()
Implements java. Retrieves the number, types and properties of this
|
| public int | getQueryTimeout()
Implements java. Retrieves the number of seconds the driver will
wait for a |
| public 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 Ref | getRef(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public ResultSet | getResultSet()
Implements java. Retrieves the current result as a |
| public int | getResultSetConcurrency()
Implements java. Retrieves the result set concurrency for |
| public int | getResultSetHoldability()
Implements java. Retrieves the result set holdability for |
| public int | getResultSetType()
Implements java. Retrieves the result set type for |
| public RowId | getRowId(String
the name of the parameter a)Implements java. Retrieves the value of the designated JDBC |
| public RowId | getRowId(int
the first parameter is 1, the second is 2,... a)Implements java. Retrieves the value of the designated JDBC |
| public short | getShort(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 SQLXML | getSQLXML(String
the name of the parameter a)Implements java. Retrieves the value of the designated |
| public SQLXML | getSQLXML(int
index of the first parameter is 1, the second is 2, ... a)Implements java. Retrieves the value of the designated |
| public String | getString(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 Time | getTime(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 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 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 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 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 Timestamp | getTimestamp(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public 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 int | getUpdateCount()
Implements java. Retrieves the current result as an update count;
if the result is a |
| public URL | getURL(int
the first parameter is 1, the second is 2,... a)Implements java. Retrieves the value of the designated JDBC |
| public URL | getURL(String
the name of the parameter a)Implements java. Retrieves the value of a JDBC |
| public SQLWarning | getWarnings()
Implements java. Retrieves the first warning reported by calls on this |
| public boolean | isClosed()
Implements java. Retrieves whether this |
| public boolean | isCloseOnCompletion()
Implements java. Returns a value indicating whether this |
| public boolean | isPoolable()
Implements java. Returns a value indicating whether the |
| public 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 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 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 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 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 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 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 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 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 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 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 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 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 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 void | setBigDecimal(String
the name of the parameter a, BigDecimal the parameter value b)Implements java. Sets the designated parameter to the given
|
| public 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 void | setDate(String
the name of the parameter a, Date the parameter value b)Implements java. Sets the designated parameter to the given |
| public 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 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 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 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 void | setEscapeProcessing(boolean
true to enable escape processing;
false to disable itImplements java. Sets escape processing on or off. |
| public 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 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 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 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 void | |
| public 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 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 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 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 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 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 void | setNCharacterStream(String
the name of the parameter a, Reader the parameter value b)Implements java. Sets the designated parameter to a |
| public 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 void | setRowId(String
the name of the parameter a, RowId the parameter value b)Implements java. Sets the designated parameter to the given |
| public 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 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 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 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 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 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 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 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 void | setTime(String
the name of the parameter a, Time the parameter value b)Implements java. Sets the designated parameter to the given |
| public 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 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 void | setTimestamp(String
the name of the parameter a, Timestamp the parameter value b)Implements java. Sets the designated parameter to the given |
| public 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 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 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 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 void | setURL(String
the name of the parameter a, URL the parameter value b)Implements java. Sets the designated parameter to the given |
| public 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 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 boolean | wasNull()
Implements java. Retrieves whether the last OUT parameter read had the value of
SQL |