#include <ODBCStatement.h>
Inheritance diagram for acdk::sql::odbc::ODBCStatement:
Public Member Functions | |
virtual void | setScrollableCursor (bool enable) |
virtual bool | getScrollableCursor () |
virtual RODBCHandle | _getODBCHandle () |
ODBCStatement (INP(RODBCConnection) conn) | |
~ODBCStatement () | |
virtual RODBCStatement | init (INP(acdk::util::RProperties) prop) |
void | deinit () |
virtual void | addBatch (INP(RString) sql) |
API: JDK JDKDOC: JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement. | |
virtual void | cancel () |
API: JDK JDKDOC: Cancels this Statement object if both the DBMS and driver support aborting an SQL statement. | |
virtual void | clearBatch () |
API: JDK JDKDOC: JDBC 2.0 Makes the set of commands in the current batch empty. | |
virtual void | clearWarnings () |
API: JDK JDKDOC: Clears all the warnings reported on this Statement object. | |
virtual void | close () |
API: JDK JDKDOC: Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. | |
virtual bool | execute (INP(RString) sql) |
API: JDK JDKDOC: Executes a SQL statement that may return multiple results. | |
virtual RintArray | executeBatch () |
API: JDK JDKDOC: JDBC 2.0 Submits a batch of commands to the database for execution. | |
virtual RResultSet | executeQuery (INP(RString) sql) |
API: JDK JDKDOC: Executes a SQL statement that returns a single ResultSet. | |
virtual int | executeUpdate (INP(RString) sql) |
API: JDK JDKDOC: Executes an SQL INSERT, UPDATE or DELETE statement. | |
virtual RConnection | getConnection () |
API: JDK JDKDOC: JDBC 2.0 Returns the Connection object that produced this Statement object. | |
virtual int | getFetchDirection () |
API: JDK JDKDOC: JDBC 2.0 Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object. | |
virtual int | getFetchSize () |
API: JDK JDKDOC: JDBC 2.0 Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object. | |
virtual int | getMaxFieldSize () |
API: JDK JDKDOC: Returns the maximum number of bytes allowed for any column value. | |
virtual int | getMaxRows () |
API: JDK JDKDOC: Retrieves the maximum number of rows that a ResultSet can contain. | |
virtual bool | getMoreResults () |
API: JDK JDKDOC: Moves to a Statement's next result. | |
virtual int | getQueryTimeout () |
API: JDK JDKDOC: Retrieves the number of seconds the driver will wait for a Statement to execute. | |
virtual RResultSet | getResultSet () |
API: JDK JDKDOC: Returns the current result as a ResultSet object. | |
virtual int | getResultSetConcurrency () |
API: JDK JDKDOC: JDBC 2.0 Retrieves the result set concurrency. | |
virtual int | getResultSetType () |
API: JDK JDKDOC: JDBC 2.0 Determine the result set type. | |
virtual int | getUpdateCount () |
API: JDK JDKDOC: Returns the current result as an update count; if the result is a ResultSet or there are no more results, -1 is returned. | |
virtual::acdk::sql::RSQLWarning | getWarnings () |
API: JDK JDKDOC: Retrieves the first warning reported by calls on this Statement. | |
virtual void | setCursorName (INP(RString) name) |
API: JDK JDKDOC: Defines the SQL cursor name that will be used by subsequent Statement execute methods. | |
virtual void | setEscapeProcessing (bool enable) |
API: JDK JDKDOC: Sets escape processing on or off. | |
virtual void | setFetchDirection (int direction) |
API: JDK JDKDOC: JDBC 2.0 Gives the driver a hint as to the direction in which the rows in a result set will be processed. | |
virtual void | setFetchSize (int rows) |
API: JDK JDKDOC: 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. | |
virtual void | setMaxFieldSize (int max) |
API: JDK JDKDOC: Sets the limit for the maximum number of bytes in a column to the given number of bytes. | |
virtual void | setMaxRows (int max) |
API: JDK JDKDOC: Sets the limit for the maximum number of rows that any ResultSet can contain to the given number. | |
virtual void | setQueryTimeout (int seconds) |
API: JDK JDKDOC: Sets the number of seconds the driver will wait for a Statement to execute to the given number of seconds. | |
Protected Attributes | |
RODBCHandle | _stmth |
RODBCConnection | _conn |
RString | _sql |
int | _queryTimeout |
int | _maxLength |
int | _maxRows |
bool | _scanEscapes |
bool | _scrollableCursors |
FetchDirection | _direction |
|
|
|
|
|
|
|
API: JDK JDKDOC: JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Makes the set of commands in the current batch empty.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Clears all the warnings reported on this Statement object.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
Implements acdk::sql::Statement. |
|
|
|
API: JDK JDKDOC: Executes a SQL statement that may return multiple results.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Submits a batch of commands to the database for execution.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Executes a SQL statement that returns a single ResultSet.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Executes an SQL INSERT, UPDATE or DELETE statement.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Returns the Connection object that produced this Statement object.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Returns the maximum number of bytes allowed for any column value.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Retrieves the maximum number of rows that a ResultSet can contain.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Moves to a Statement's next result.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Retrieves the number of seconds the driver will wait for a Statement to execute.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Returns the current result as a ResultSet object.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Retrieves the result set concurrency.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Determine the result set type.
Implements acdk::sql::Statement. |
|
|
|
API: JDK JDKDOC: Returns the current result as an update count; if the result is a ResultSet or there are no more results, -1 is returned.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Retrieves the first warning reported by calls on this Statement.
Implements acdk::sql::Statement. |
|
Reimplemented in acdk::sql::odbc::ODBCCallableStatement, and acdk::sql::odbc::ODBCPreparedStatement. |
|
API: JDK JDKDOC: Defines the SQL cursor name that will be used by subsequent Statement execute methods.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Sets escape processing on or off.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: JDBC 2.0 Gives the driver a hint as to the direction in which the rows in a result set will be processed.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: 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.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Sets the limit for the maximum number of bytes in a column to the given number of bytes.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Sets the limit for the maximum number of rows that any ResultSet can contain to the given number.
Implements acdk::sql::Statement. |
|
API: JDK JDKDOC: Sets the number of seconds the driver will wait for a Statement to execute to the given number of seconds.
Implements acdk::sql::Statement. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|