| Access | Constructor and Description |
|---|---|
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| private void | |
| 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 | 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(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(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(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 Connection | getConnection()
Implements java. Retrieves the |
| 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 ResultSet | getGeneratedKeys()
Implements java. Retrieves any auto-generated keys created as a result of executing this
|
| public synchronized Statement | |
| 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 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 int | getQueryTimeout()
Implements java. Retrieves the number of seconds the driver will
wait for a |
| 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 int | getUpdateCount()
Implements java. Retrieves the current result as an update count;
if the result is a |
| 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 | 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 | 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 | |
| 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 | 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 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. |