|
|||||||||
| 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 | ||||||||