![]() |
Quadcap Embeddable Database |
Inheritance diagram for com.quadcap.jdbc.Statement:

TODO: setMaxFieldSize TODO: setQueryTimeout TODO: JDBC3.0: return generated keys
Definition at line 69 of file Statement.java.
Public Member Functions | |
| Statement (Connection conn) throws SQLException, IOException | |
| Create a new statement. | |
| Statement (Connection conn, int resultSetType, int resultSetConcurrency) throws SQLException, IOException | |
| Create a new Statement with the specified result set type and concurrency. | |
| void | finalize () throws Throwable |
| My short life is ended. | |
| void | addBatch (String sql) throws SQLException |
| This QED release doesn't support batch statement execution. | |
| void | cancel () throws SQLException |
QED does not support the cancel() feature. | |
| void | clearBatch () throws SQLException |
| This QED release doesn't support batch statement execution. | |
| void | clearWarnings () |
Clear any warnings associated with this Statement object. | |
| void | close () |
| Close this statement object and free up any resources held by it. | |
| String | toString () |
| boolean | execute (String sql) throws SQLException |
Execute the specified SQL statement, returning true if the statement generates a ResultSet object. | |
| int[] | executeBatch () throws SQLException |
| This QED release doesn't support batch statement execution. | |
| java.sql.ResultSet | executeQuery (String sql) throws SQLException |
Execute the specified SQL query statement, returning the ResultSet object containing the results of the query. | |
| int | executeUpdate (String sql) throws SQLException |
| Execute the specified SQL update statement, returning the update count, meaning the number of rows updated or inserted by this statement. | |
| java.sql.Connection | getConnection () |
Return the Connection object used to create this Statement object. | |
| int | getFetchSize () |
| In QED, the fetch size is always 1. | |
| int | getMaxFieldSize () |
| QED imposes no maximum field size. | |
| int | getMaxRows () |
QED imposes no limit on the number of rows in a ResultSet. | |
| boolean | getMoreResults () throws SQLException |
QED only returns one ResultSet per statement, so this function always returns false (after closing the current ResultSet object for this Statement. | |
| int | getQueryTimeout () |
| QED doesn't support query timeouts, so this method always returns zero. | |
| java.sql.ResultSet | getResultSet () |
Return the ResultSet generated by the last call to execute(), unless that ResultSet has been closed, or if there was no ResultSet generated by the last call to execute(), in which case, return null. | |
| int | getUpdateCount () |
| Return the update count for the last statement executed. | |
| SQLWarning | getWarnings () |
Since this QED release doesn't generate SQLWarnings, this function always returns null. | |
| void | setCursorName (String name) throws SQLException |
| This QED release doesn't support SQL named cursors. | |
| void | setEscapeProcessing (boolean enable) |
| Enable or disable JDBC escape processing mode. | |
| void | setFetchDirection (int dir) throws SQLException |
Set the default fetch direction for ResultSet objects generated by this Statement object. | |
| void | setFetchSize (int x) throws SQLException |
| QED, being an embedded driver, fetches rows only when they are needed, with no performance penalty. | |
| void | setMaxFieldSize (int x) throws SQLException |
| Not implemented in this release of QED. | |
| void | setMaxRows (int x) throws SQLException |
| Set the maximum number of rows that will be returned by this ResultSet. | |
| void | setQueryTimeout (int x) throws SQLException |
| Not implemented in this release of QED. | |
| int | getResultSetConcurrency () |
Return the default result set concurrency for ResultSet objects generated by this Statement object. | |
| int | getResultSetType () |
Return the default result set type for ResultSet objects generated by this Statement object. | |
| int | getFetchDirection () |
This release of QED only supports the fetch direction: ResultSet.FETCH_FORWARD. | |
| boolean | getMoreResults (int current) throws SQLException |
Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object. | |
| java.sql.ResultSet | getGeneratedKeys () throws SQLException |
Retrieves any auto-generated keys created as a result of executing this Statement object. | |
| int | executeUpdate (String sql, int autoGeneratedKeys) throws SQLException |
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval. | |
| int | executeUpdate (String sql, int columnIndexes[]) throws SQLException |
| Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. | |
| int | executeUpdate (String sql, String columnNames[]) throws SQLException |
| Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. | |
| boolean | execute (String sql, int autoGeneratedKeys) throws SQLException |
| Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. | |
| boolean | execute (String sql, int columnIndexes[]) throws SQLException |
| Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. | |
| boolean | execute (String sql, String columnNames[]) throws SQLException |
| Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. | |
| int | getResultSetHoldability () throws SQLException |
Retrieves the result set holdability for ResultSet objects generated by this Statement object. | |
Protected Attributes | |
| boolean | escapeProcessing = true |
Package Attributes | |
| Connection | conn |
| com.quadcap.sql.Connection | qConn = null |
| Session | session = null |
| ResultSet | rs = null |
| int | updateCount = -1 |
| int | maxRows = -1 |
| int | resultSetType = ResultSet.TYPE_SCROLL_INSENSITIVE |
| int | resultSetConcurrency = ResultSet.CONCUR_UPDATABLE |
Static Package Attributes | |
| final ConfigNumber | trace |
|
|
Create a new statement.
Definition at line 98 of file Statement.java. References com.quadcap.jdbc.Statement.conn, com.quadcap.jdbc.Connection.getConnection(), com.quadcap.jdbc.Statement.qConn, com.quadcap.jdbc.Connection.qConn, com.quadcap.jdbc.Statement.toString(), and com.quadcap.jdbc.Statement.trace. |
|
||||||||||||||||
|
Create a new Statement with the specified result set type and concurrency.
Definition at line 113 of file Statement.java. References com.quadcap.jdbc.Statement.conn, com.quadcap.jdbc.Statement.resultSetConcurrency, and com.quadcap.jdbc.Statement.resultSetType. |
|
|
This QED release doesn't support batch statement execution.
Definition at line 137 of file Statement.java. References com.quadcap.jdbc.Statement.addBatch(). Referenced by com.quadcap.jdbc.Statement.addBatch(). |
|
|
QED does not support the
Definition at line 144 of file Statement.java. |
|
|
This QED release doesn't support batch statement execution.
Definition at line 152 of file Statement.java. |
|
|
Clear any warnings associated with this
Since this QED release doesn't generate Definition at line 161 of file Statement.java. |
|
|
Close this statement object and free up any resources held by it.
Definition at line 167 of file Statement.java. References com.quadcap.jdbc.Statement.qConn, com.quadcap.jdbc.Statement.session, com.quadcap.jdbc.Statement.toString(), and com.quadcap.jdbc.Statement.trace. Referenced by com.quadcap.jdbc.Statement.finalize(). |
|
||||||||||||
|
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
This array contains the names of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the given SQL statement is not an In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 794 of file Statement.java. |
|
||||||||||||
|
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the given SQL statement is not an Under some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 752 of file Statement.java. |
|
||||||||||||
|
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
The driver will ignore this signal if the SQL statement is not an In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 711 of file Statement.java. |
|
|
Execute the specified SQL statement, returning
Definition at line 201 of file Statement.java. References com.quadcap.jdbc.Statement.escapeProcessing, com.quadcap.jdbc.Statement.execute(), com.quadcap.jdbc.Statement.qConn, com.quadcap.jdbc.Statement.rs, com.quadcap.jdbc.Statement.session, com.quadcap.sql.SQLParser.statement(), com.quadcap.jdbc.Statement.toString(), com.quadcap.jdbc.Statement.trace, and com.quadcap.jdbc.Statement.updateCount. Referenced by com.quadcap.jdbc.Statement.execute(). |
|
|
This QED release doesn't support batch statement execution.
Definition at line 314 of file Statement.java. |
|
|
Execute the specified SQL query statement, returning the
Definition at line 329 of file Statement.java. References com.quadcap.jdbc.Statement.executeQuery(). Referenced by com.quadcap.jdbc.Statement.executeQuery(). |
|
||||||||||||
|
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
The driver will ignore the array if the SQL statement is not an
Definition at line 669 of file Statement.java. |
|
||||||||||||
|
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval.
The driver will ignore the array if the SQL statement is not an
Definition at line 646 of file Statement.java. |
|
||||||||||||
|
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this
Definition at line 618 of file Statement.java. |
|
|
Execute the specified SQL update statement, returning the update count, meaning the number of rows updated or inserted by this statement.
Definition at line 346 of file Statement.java. References com.quadcap.jdbc.Statement.executeUpdate(). Referenced by com.quadcap.jdbc.Statement.executeUpdate(). |
|
|
My short life is ended.
Definition at line 125 of file Statement.java. References com.quadcap.jdbc.Statement.close(). |
|
|
Return the
Definition at line 360 of file Statement.java. References com.quadcap.jdbc.Statement.conn. |
|
|
This release of QED only supports the fetch direction:
Definition at line 540 of file Statement.java. |
|
|
In QED, the fetch size is always 1.
Definition at line 369 of file Statement.java. |
|
|
Retrieves any auto-generated keys created as a result of executing this
If this
Definition at line 591 of file Statement.java. |
|
|
QED imposes no maximum field size.
Definition at line 378 of file Statement.java. |
|
|
QED imposes no limit on the number of rows in a
Definition at line 387 of file Statement.java. |
|
|
Moves to this There are no more results when the following is true:
Definition at line 571 of file Statement.java. References com.quadcap.jdbc.Statement.getMoreResults(). |
|
|
QED only returns one
Definition at line 400 of file Statement.java. References com.quadcap.jdbc.ResultSet.close(), and com.quadcap.jdbc.Statement.rs. Referenced by com.quadcap.jdbc.Statement.getMoreResults(). |
|
|
QED doesn't support query timeouts, so this method always returns zero.
Definition at line 412 of file Statement.java. |
|
|
Return the
Definition at line 426 of file Statement.java. References com.quadcap.jdbc.Statement.rs. |
|
|
Return the default result set concurrency for
Definition at line 520 of file Statement.java. References com.quadcap.jdbc.Statement.resultSetConcurrency. |
|
|
Retrieves the result set holdability for
Definition at line 810 of file Statement.java. |
|
|
Return the default result set type for
Definition at line 530 of file Statement.java. References com.quadcap.jdbc.Statement.resultSetType. |
|
|
Return the update count for the last statement executed. If no records were updated, inserted, or deleted, return -1.
Definition at line 437 of file Statement.java. References com.quadcap.jdbc.Statement.updateCount. |
|
|
Since this QED release doesn't generate
Definition at line 447 of file Statement.java. |
|
|
This QED release doesn't support SQL named cursors.
Definition at line 456 of file Statement.java. References com.quadcap.jdbc.Statement.setCursorName(). Referenced by com.quadcap.jdbc.Statement.setCursorName(). |
|
|
Enable or disable JDBC escape processing mode.
enable Definition at line 466 of file Statement.java. References com.quadcap.jdbc.Statement.escapeProcessing, and com.quadcap.jdbc.Statement.setEscapeProcessing(). Referenced by com.quadcap.jdbc.Statement.setEscapeProcessing(). |
|
|
Set the default fetch direction for
Definition at line 474 of file Statement.java. References com.quadcap.jdbc.Statement.setFetchDirection(). Referenced by com.quadcap.jdbc.Statement.setFetchDirection(). |
|
|
QED, being an embedded driver, fetches rows only when they are needed, with no performance penalty.
Thus, the fetch size is always Definition at line 482 of file Statement.java. References com.quadcap.jdbc.Statement.setFetchSize(). Referenced by com.quadcap.jdbc.Statement.setFetchSize(). |
|
|
Not implemented in this release of QED.
Definition at line 490 of file Statement.java. References com.quadcap.jdbc.Statement.setMaxFieldSize(). Referenced by com.quadcap.jdbc.Statement.setMaxFieldSize(). |
|
|
Set the maximum number of rows that will be returned by this ResultSet.
Definition at line 498 of file Statement.java. References com.quadcap.jdbc.Statement.maxRows, and com.quadcap.jdbc.Statement.setMaxRows(). Referenced by com.quadcap.jdbc.Statement.setMaxRows(). |
|
|
Not implemented in this release of QED.
Definition at line 507 of file Statement.java. References com.quadcap.jdbc.Statement.setQueryTimeout(). Referenced by com.quadcap.jdbc.Statement.setQueryTimeout(). |
|
|
Reimplemented in com.quadcap.jdbc.PreparedStatement. Definition at line 186 of file Statement.java. References com.quadcap.jdbc.Statement.session. Referenced by com.quadcap.jdbc.Statement.close(), com.quadcap.jdbc.Statement.execute(), and com.quadcap.jdbc.Statement.Statement(). |
|
|
Definition at line 87 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.getConnection(), and com.quadcap.jdbc.Statement.Statement(). |
|
|
Definition at line 92 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.execute(), and com.quadcap.jdbc.Statement.setEscapeProcessing(). |
|
|
Definition at line 93 of file Statement.java. Referenced by com.quadcap.jdbc.ResultSet.next(), and com.quadcap.jdbc.Statement.setMaxRows(). |
|
|
Definition at line 88 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.close(), com.quadcap.jdbc.Statement.execute(), and com.quadcap.jdbc.Statement.Statement(). |
|
|
Definition at line 512 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.getResultSetConcurrency(), and com.quadcap.jdbc.Statement.Statement(). |
|
|
Definition at line 511 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.getResultSetType(), com.quadcap.jdbc.ResultSet.setStatement(), and com.quadcap.jdbc.Statement.Statement(). |
|
|
Definition at line 90 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.execute(), com.quadcap.jdbc.Statement.getMoreResults(), and com.quadcap.jdbc.Statement.getResultSet(). |
|
|
Definition at line 89 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.close(), com.quadcap.jdbc.Statement.execute(), and com.quadcap.jdbc.Statement.toString(). |
|
|
Initial value:
Definition at line 84 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.close(), com.quadcap.jdbc.Statement.execute(), and com.quadcap.jdbc.Statement.Statement(). |
|
|
Definition at line 91 of file Statement.java. Referenced by com.quadcap.jdbc.Statement.execute(), and com.quadcap.jdbc.Statement.getUpdateCount(). |