|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--superwaba.ext.xplat.sql.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
|
Constructor Summary | |
Statement()
|
Method Summary | |
abstract void |
addBatch(String sql)
This method adds a SQL statement to a SQL batch. |
abstract void |
clearBatch()
This method clears out any SQL statements that have been populated in the current batch. |
abstract void |
clearWarnings()
This method clears any SQL warnings that have been attached to this statement. |
abstract void |
close()
This method closes the statement and frees any associated resources. |
abstract boolean |
execute(String sql)
This method executes an arbitrary SQL statement of any time. |
abstract 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. |
abstract ResultSet |
executeQuery(String sql)
This method executes the specified SQL SELECT statement and returns a (possibly empty) ResultSet with the results of the query. |
abstract 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. |
abstract Connection |
getConnection()
This method returns the Connection instance that was
used to create this object. |
abstract int |
getFetchDirection()
This method returns the current direction that the driver thinks the result set will be accessed int. |
abstract int |
getFetchSize()
This method returns the number of rows the driver believes should be fetched from the database at a time. |
abstract int |
getMaxFieldSize()
This method returns the maximum length of any column value in bytes. |
abstract int |
getMaxRows()
This method returns the maximum possible number of rows in a result set. |
abstract boolean |
getMoreResults()
This method advances the result set pointer to the next result set, which can then be retrieved using getResultSet |
abstract int |
getQueryTimeout()
The method returns the number of seconds a statement may be in process before timing out. |
abstract ResultSet |
getResultSet()
This method returns the result set of the SQL statement that was executed. |
abstract int |
getResultSetConcurrency()
This method returns the concurrency type of the result set for this statement. |
abstract int |
getResultSetType()
This method returns the result set type for this statement. |
abstract int |
getUpdateCount()
This method returns the update count of the SQL statement that was executed. |
abstract SQLWarning |
getWarnings()
This method returns the first SQL warning attached to this statement. |
abstract void |
setCursorName(String name)
This method sets the cursor name that will be used by the result set. |
abstract void |
setEscapeProcessing(boolean enable)
This method sets the local escape processing mode on or off. |
abstract void |
setFetchDirection(int direction)
This method informs the driver which direction the result set will be accessed in. |
abstract void |
setFetchSize(int rows)
This method informs the driver how many rows it should fetch from the database at a time. |
abstract void |
setMaxFieldSize(int max)
This method sets the limit for the maximum length of any column in bytes. |
abstract void |
setMaxRows(int max)
This method sets the maximum number of rows that can be present in a result set. |
abstract void |
setQueryTimeout(int seconds)
This method sets the number of seconds a statement may be in process before timing out. |
Methods inherited from class java.lang.Object |
equals,
getClass,
hashCode,
notify,
toString,
wait,
wait |
Field Detail |
public static final int CLOSE_CURRENT_RESULT
public static final int KEEP_CURRENT_RESULT
public static final int CLOSE_ALL_RESULTS
public static final int SUCCESS_NO_INFO
public static final int EXECUTE_FAILED
public static final int RETURN_GENERATED_KEYS
public static final int NO_GENERATED_KEYS
Constructor Detail |
public Statement()
Method Detail |
public abstract ResultSet executeQuery(String sql) throws SQLException
ResultSet
with the results of the query.sql
- The SQL statement to execute.public abstract int executeUpdate(String sql) throws SQLException
sql
- The SQL statement to execute.public abstract void close() throws SQLException
public abstract int getMaxFieldSize() throws SQLException
public abstract void setMaxFieldSize(int max) throws SQLException
maxsize
- The new maximum length of any column in bytes.public abstract int getMaxRows() throws SQLException
public abstract void setMaxRows(int max) throws SQLException
maxrows
- The maximum possible number of rows in a result set.public abstract void setEscapeProcessing(boolean enable) throws SQLException
escape
- true
to enable local escape processing,
false
to disable it.public abstract int getQueryTimeout() throws SQLException
public abstract void setQueryTimeout(int seconds) throws SQLException
timeout
- The new SQL statement timeout value.public abstract SQLWarning getWarnings() throws SQLException
public abstract void clearWarnings() throws SQLException
public abstract void setCursorName(String name) throws SQLException
name
- The cursor name to use for this statement.public abstract 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.public abstract ResultSet getResultSet() throws SQLException
null
if there was
no result set (for example, if the statement was an UPDATE).execute(java.lang.String)
public abstract int getUpdateCount() throws SQLException
execute(java.lang.String)
public abstract boolean getMoreResults() throws SQLException
getResultSet
true
if there is another result set,
false
otherwise (for example, the next result is an
update count).execute(java.lang.String)
public abstract void setFetchDirection(int direction) throws SQLException
direction
- The direction the result set will be accessed in (?????)public abstract int getFetchDirection() throws SQLException
public abstract void setFetchSize(int rows) throws SQLException
numrows
- The number of rows the driver should fetch at a time
to populate the result set.public abstract int getFetchSize() throws SQLException
public abstract int getResultSetConcurrency() throws SQLException
ResultSet
.ResultSet
public abstract int getResultSetType() throws SQLException
ResultSet
.ResultSet
public abstract void addBatch(String sql) throws SQLException
sql
- The sql statement to add to the batch.public abstract void clearBatch() throws SQLException
public abstract int[] executeBatch() throws SQLException
public abstract Connection getConnection() throws SQLException
Connection
instance that was
used to create this object.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |