Method Summary |
|
public synchronized void | addBatch(String sql) |
public void | cancel() Cancels this Statement object if both the DBMS and driver support
aborting an SQL statement. |
protected void | checkClosed() |
protected void | checkForDml(String sql, char firstStatementChar) Checks if the given SQL query with the given first non-ws char is a DML
statement. |
protected void | checkNullOrEmptyQuery(String sql) Method checkNullOrEmptyQuery. |
public synchronized void | clearBatch() JDBC 2.0 Make the set of commands in the current batch empty. |
public void | clearWarnings() After this call, getWarnings returns null until a new warning is reported
for this Statement. |
public void | close() In many cases, it is desirable to immediately release a Statement's
database and JDBC resources instead of waiting for this to happen when it
is automatically closed. |
protected void | closeAllOpenResults() |
protected boolean | createStreamingResultSet() |
public void | disableStreamingResults() |
protected void | doPingInstead() |
public void | enableStreamingResults() |
public boolean | execute(String sql) Execute a SQL statement that may return multiple results. |
public boolean | execute(String sql, int returnGeneratedKeys) |
public boolean | execute(String sql, int[] generatedKeyIndices) |
public boolean | execute(String sql, String[] generatedKeyNames) |
public synchronized int[] | executeBatch() JDBC 2.0 Submit a batch of commands to the database for execution. |
public java.sql.ResultSet | executeQuery(String sql) |
protected void | executeSimpleNonQuery(ConnectionImpl c, String nonQuery) |
public int | executeUpdate(String sql) Execute a SQL INSERT, UPDATE or DELETE statement. |
protected int | executeUpdate(String sql, boolean isBatch) |
public int | executeUpdate(String sql, int returnGeneratedKeys) |
public int | executeUpdate(String sql, int[] generatedKeyIndices) |
public int | executeUpdate(String sql, String[] generatedKeyNames) |
protected int | findStartOfStatement(String sql) |
protected ResultSetInternalMethods | generatePingResultSet() |
protected void | getBatchedGeneratedKeys(java.sql.Statement batchedStatement) |
protected void | getBatchedGeneratedKeys() |
protected Calendar | getCalendarInstanceForSessionOrNew() |
public java.sql.Connection | getConnection() JDBC 2.0 Return the Connection that produced the Statement. |
public int | getFetchDirection() JDBC 2.0 Determine the fetch direction. |
public int | getFetchSize() JDBC 2.0 Determine the default fetch size. |
public synchronized java.sql.ResultSet | getGeneratedKeys() |
protected java.sql.ResultSet | getGeneratedKeysInternal() |
protected int | getId() |
public long | getLastInsertID() getLastInsertID returns the value of the auto_incremented key after an
executeQuery() or excute() call. |
public synchronized InputStream | getLocalInfileInputStream() |
public long | getLongUpdateCount() getLongUpdateCount returns the current result as an update count, if the
result is a ResultSet or there are no more results, -1 is returned. |
public int | getMaxFieldSize() The maxFieldSize limit (in bytes) is the maximum amount of data returned
for any column value; it only applies to BINARY, VARBINARY,
LONGVARBINARY, CHAR, VARCHAR and LONGVARCHAR columns. |
public int | getMaxRows() The maxRows limit is set to limit the number of rows that any ResultSet
can contain. |
public boolean | getMoreResults() getMoreResults moves to a Statement's next result. |
public boolean | getMoreResults(int current) |
public int | getQueryTimeout() The queryTimeout limit is the number of seconds the driver will wait for
a Statement to execute. |
public java.sql.ResultSet | getResultSet() getResultSet returns the current result as a ResultSet. |
public int | getResultSetConcurrency() JDBC 2.0 Determine the result set concurrency. |
public int | getResultSetHoldability() |
protected ResultSetInternalMethods | getResultSetInternal() |
public int | getResultSetType() JDBC 2.0 Determine the result set type. |
public int | getUpdateCount() getUpdateCount returns the current result as an update count, if the
result is a ResultSet or there are no more results, -1 is returned. |
public java.sql.SQLWarning | getWarnings() The first warning reported by calls on this Statement is returned. |
protected SQLException | handleExceptionForBatch(int endOfBatchIndex, int numValuesPerBatch, int[] updateCounts, SQLException ex) |
public synchronized boolean | isClosed() |
public boolean | isPoolable() |
public boolean | isWrapperFor(Class iface) Returns true if this either implements the interface argument or is directly or indirectly a wrapper
for an object that does. |
protected int | processMultiCountsAndKeys(StatementImpl batchedStatement, int updateCountCounter, int[] updateCounts) |
protected void | realClose(boolean calledExplicitly, boolean closeOpenResults) Closes this statement, and frees resources. |
protected synchronized void | resetCancelledState() |
public void | setCursorName(String name) setCursorName defines the SQL cursor name that will be used by subsequent
execute methods. |
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 Give 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 Give the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed. |
protected void | setHoldResultsOpenOverClose(boolean holdResultsOpenOverClose) |
public synchronized void | setLocalInfileInputStream(InputStream stream) |
public void | setMaxFieldSize(int max) |
public void | setMaxRows(int max) |
public synchronized void | setPingTarget(PingTarget pingTarget) |
public void | setPoolable(boolean poolable) |
public void | setQueryTimeout(int seconds) |
void | setResultSetConcurrency(int concurrencyFlag) |
void | setResultSetType(int typeFlag) |
public Object | unwrap(Class iface) Returns an object that implements the given interface to allow access to non-standard methods,
or standard methods not exposed by the proxy.
The result may be either the object found to implement the interface or a proxy for that object.
If the receiver implements the interface then that is the object. |