Method Summary |
|
public void | addBatch(String sql) JDBC 2.0
Adds a SQL command to the current batch of commmands for the statement. |
public void | cancel() This can be used by another thread to cancel a statement. |
public void | clearBatch() JDBC 2.0
Makes the set of commands in the current batch empty. |
public void | clearWarnings() |
public void | close() Close any result sets. |
public boolean | execute(String sql) Executes some SQL and returns true or false, depending on
the success. |
public int[] | executeBatch() JDBC 2.0
Submits a batch of commands to the database for execution.
This method is optional.
an array of update counts containing one element for eachcommand in the batch. |
public synchronized ResultSet | executeQuery(String sql) Execute an SQL statement and return a result set. |
public synchronized int | executeUpdate(String sql) Execute an update, insert, delete, create table, etc. |
public Connection | getConnection() JDBC 2.0
Returns the Connection object
that produced this Statement object. |
public int | getFetchDirection() JDBC 2.0
Retrieves the direction for fetching rows from
database tables that is the default for result sets
generated from this Statement object. |
public int | getFetchSize() JDBC 2.0
Retrieves the number of result set rows that is the default
fetch size for result sets
generated from this Statement object. |
public int | getMaxFieldSize() Get the maximum field size to return in a result set. |
public int | getMaxRows() Get the maximum row count that can be returned by a result set. |
public boolean | getMoreResults() This returns true if there are any pending result sets. |
public int | getQueryTimeout() Discover the query timeout. |
public ResultSet | getResultSet() |
public int | getResultSetConcurrency() JDBC 2.0
Retrieves the result set concurrency. |
public int | getResultSetType() JDBC 2.0
Determine the result set type. |
public String | getSQLString() |
public int | getUpdateCount() Return the row count of the last operation. |
final public SQLWarning | getWarnings() |
public void | setCursorName(String unused) Sets the cursor name for this connection. |
public void | setEscapeProcessing(boolean enable) If escape scanning is on (the default) the driver will do
escape substitution before sending the SQL to the database. |
public void | setFetchDirection(int direction) JDBC 2.0
Gives the driver a hint as to the direction in which
the rows in a result set
will be processed. |
public void | setFetchSize(int rows) JDBC 2.0
Gives the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed. |
public void | setMaxFieldSize(int max) set the max field size. |
public void | setMaxRows(int max) Get the maximum row count that can be returned by a result set. |
public void | setQueryTimeout(int x) Set the query timeout. |