public interface Statement
Modifier and Type | Field and Description |
---|---|
static int |
CLOSE_ALL_RESULTS |
static int |
CLOSE_CURRENT_RESULT |
static int |
EXECUTE_FAILED |
static int |
KEEP_CURRENT_RESULT |
static int |
NO_GENERATED_KEYS |
static int |
RETURN_GENERATED_KEYS |
static int |
SUCCESS_NO_INFO |
Modifier and Type | Method and Description |
---|---|
void |
addBatch(String sql)
This method adds a SQL statement to a SQL batch.
|
void |
cancel()
This method cancels an outstanding statement, if the database supports
that operation.
|
void |
clearBatch()
This method clears out any SQL statements that have been populated in
the current batch.
|
void |
clearWarnings()
This method clears any SQL warnings that have been attached to this
statement.
|
void |
close()
This method closes the statement and frees any associated resources.
|
boolean |
execute(String sql)
This method executes an arbitrary SQL statement of any time.
|
boolean |
execute(String sql,
int autoGeneratedKeys) |
boolean |
execute(String sql,
int[] columnIndexes) |
boolean |
execute(String sql,
String[] columnNames) |
int[] |
executeBatch()
This method executes the SQL batch and returns an array of update
counts - one for each SQL statement in the batch - ordered in the same
order the statements were added to the batch.
|
ResultSet |
executeQuery(String sql)
This method executes the specified SQL SELECT statement and returns a
(possibly empty)
ResultSet with the results of the query. |
int |
executeUpdate(String sql)
This method executes the specified SQL INSERT, UPDATE, or DELETE statement
and returns the number of rows affected, which may be 0.
|
int |
executeUpdate(String sql,
int autoGeneratedKeys) |
int |
executeUpdate(String sql,
int[] columnIndexes) |
int |
executeUpdate(String sql,
String[] columnNames) |
Connection |
getConnection()
This method returns the
Connection instance that was
used to create this object. |
int |
getFetchDirection()
This method returns the current direction that the driver thinks the
result set will be accessed int.
|
int |
getFetchSize()
This method returns the number of rows the driver believes should be
fetched from the database at a time.
|
ResultSet |
getGeneratedKeys() |
int |
getMaxFieldSize()
This method returns the maximum length of any column value in bytes.
|
int |
getMaxRows()
This method returns the maximum possible number of rows in a result set.
|
boolean |
getMoreResults()
This method advances the result set pointer to the next result set,
which can then be retrieved using
getResultSet |
boolean |
getMoreResults(int current) |
int |
getQueryTimeout()
The method returns the number of seconds a statement may be in process
before timing out.
|
ResultSet |
getResultSet()
This method returns the result set of the SQL statement that was
executed.
|
int |
getResultSetConcurrency()
This method returns the concurrency type of the result set for this
statement.
|
int |
getResultSetHoldability() |
int |
getResultSetType()
This method returns the result set type for this statement.
|
int |
getUpdateCount()
This method returns the update count of the SQL statement that was
executed.
|
SQLWarning |
getWarnings()
This method returns the first SQL warning attached to this statement.
|
void |
setCursorName(String name)
This method sets the cursor name that will be used by the result set.
|
void |
setEscapeProcessing(boolean escape)
This method sets the local escape processing mode on or off.
|
void |
setFetchDirection(int direction)
This method informs the driver which direction the result set will
be accessed in.
|
void |
setFetchSize(int numRows)
This method informs the driver how many rows it should fetch from the
database at a time.
|
void |
setMaxFieldSize(int maxSize)
This method sets the limit for the maximum length of any column in bytes.
|
void |
setMaxRows(int maxRows)
This method sets the maximum number of rows that can be present in a
result set.
|
void |
setQueryTimeout(int seconds)
This method sets the number of seconds a statement may be in process
before timing out.
|
static final int CLOSE_CURRENT_RESULT
static final int KEEP_CURRENT_RESULT
static final int CLOSE_ALL_RESULTS
static final int SUCCESS_NO_INFO
static final int EXECUTE_FAILED
static final int RETURN_GENERATED_KEYS
static final int NO_GENERATED_KEYS
ResultSet executeQuery(String sql) throws SQLException
ResultSet
with the results of the query.sql
- The SQL statement to execute.SQLException
- If an error occurs.int executeUpdate(String sql) throws SQLException
sql
- The SQL statement to execute.SQLException
- If an error occurs.void close() throws SQLException
SQLException
- If an error occurs.int getMaxFieldSize() throws SQLException
SQLException
- If an error occurs.void setMaxFieldSize(int maxSize) throws SQLException
maxSize
- The new maximum length of any column in bytes.SQLException
- If an error occurs.int getMaxRows() throws SQLException
SQLException
- If an error occurs.void setMaxRows(int maxRows) throws SQLException
maxRows
- The maximum possible number of rows in a result set.SQLException
- If an error occurs.void setEscapeProcessing(boolean escape) throws SQLException
escape
- true
to enable local escape processing,
false
to disable it.SQLException
- If an error occurs.int getQueryTimeout() throws SQLException
SQLException
- If an error occurs.void setQueryTimeout(int seconds) throws SQLException
seconds
- The new SQL statement timeout value.SQLException
- If an error occurs.void cancel() throws SQLException
SQLException
- If an error occurs.SQLWarning getWarnings() throws SQLException
SQLException
- If an error occurs.void clearWarnings() throws SQLException
SQLException
- If an error occurs.void setCursorName(String name) throws SQLException
name
- The cursor name to use for this statement.SQLException
- If an error occurs.boolean execute(String sql) throws SQLException
getResultSet
, getMoreResults
and
getUpdateCount
retrieve the results.true
if a result set was returned, false
if an update count was returned.SQLException
- If an error occurs.ResultSet getResultSet() throws SQLException
null
if there was
no result set (for example, if the statement was an UPDATE).SQLException
- If an error occurs.execute(String)
,
execute(String, int)
,
execute(String, int[])
,
execute(String, String[])
int getUpdateCount() throws SQLException
SQLException
- If an error occurs.execute(String)
,
execute(String, int)
,
execute(String, int[])
,
execute(String, String[])
boolean getMoreResults() throws SQLException
getResultSet
true
if there is another result set,
false
otherwise (for example, the next result is an
update count).SQLException
- If an error occurs.execute(String)
,
execute(String, int)
,
execute(String, int[])
,
execute(String, String[])
void setFetchDirection(int direction) throws SQLException
direction
- The direction the result set will be accessed in (?????)SQLException
- If an error occurs.int getFetchDirection() throws SQLException
SQLException
- If an error occurs.void setFetchSize(int numRows) throws SQLException
numRows
- The number of rows the driver should fetch at a time
to populate the result set.SQLException
- If an error occurs.int getFetchSize() throws SQLException
SQLException
- If an error occurs.int getResultSetConcurrency() throws SQLException
ResultSet
.SQLException
- If an error occurs.ResultSet
int getResultSetType() throws SQLException
ResultSet
.SQLException
- If an error occurs.ResultSet
void addBatch(String sql) throws SQLException
sql
- The sql statement to add to the batch.SQLException
- If an error occurs.void clearBatch() throws SQLException
SQLException
- If an error occurs.int[] executeBatch() throws SQLException
SQLException
- If an error occurs.Connection getConnection() throws SQLException
Connection
instance that was
used to create this object.SQLException
- If an error occurs.boolean getMoreResults(int current) throws SQLException
SQLException
ResultSet getGeneratedKeys() throws SQLException
SQLException
int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
SQLException
int executeUpdate(String sql, int[] columnIndexes) throws SQLException
SQLException
int executeUpdate(String sql, String[] columnNames) throws SQLException
SQLException
boolean execute(String sql, int autoGeneratedKeys) throws SQLException
SQLException
boolean execute(String sql, int[] columnIndexes) throws SQLException
SQLException
boolean execute(String sql, String[] columnNames) throws SQLException
SQLException
int getResultSetHoldability() throws SQLException
SQLException