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