|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface Statement
This interface provides a mechanism for executing SQL statements.
Field Summary | |
---|---|
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
|
Method Summary | |
---|---|
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. |
Field Detail |
---|
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
Method Detail |
---|
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
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |