artefaktur
software engineer &        architecture

 
 
 
 

class ODBCStatement

Modules   Namespace List   Class Hierarchy   Alphabetical List   Compound List   Namespace Members   Compound Members   Related Pages  

acdk::sql::odbc::ODBCStatement Class Reference

#include <ODBCStatement.h>

Inheritance diagram for acdk::sql::odbc::ODBCStatement:

acdk::lang::Object acdk::sql::Statement acdk::lang::ObjectBase acdk::lang::dmi::StdDispatch acdk::sql::odbc::ODBCPreparedStatement acdk::sql::odbc::ODBCCallableStatement List of all members.

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

Constructor & Destructor Documentation

acdk::sql::odbc::ODBCStatement::ODBCStatement INP(RODBCConnection conn  ) 
 

acdk::sql::odbc::ODBCStatement::~ODBCStatement  ) 
 


Member Function Documentation

virtual RODBCHandle acdk::sql::odbc::ODBCStatement::_getODBCHandle  )  [inline, virtual]
 

virtual void acdk::sql::odbc::ODBCStatement::addBatch INP(RString sql  )  [inline, virtual]
 

API: JDK JDKDOC: JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement.

Implements acdk::sql::Statement.

virtual void acdk::sql::odbc::ODBCStatement::cancel  )  [inline, virtual]
 

API: JDK JDKDOC: Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.

Implements acdk::sql::Statement.

virtual void acdk::sql::odbc::ODBCStatement::clearBatch  )  [inline, virtual]
 

API: JDK JDKDOC: JDBC 2.0 Makes the set of commands in the current batch empty.

Implements acdk::sql::Statement.

virtual void acdk::sql::odbc::ODBCStatement::clearWarnings  )  [inline, virtual]
 

API: JDK JDKDOC: Clears all the warnings reported on this Statement object.

Implements acdk::sql::Statement.

virtual void acdk::sql::odbc::ODBCStatement::close  )  [virtual]
 

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.

void acdk::sql::odbc::ODBCStatement::deinit  ) 
 

virtual bool acdk::sql::odbc::ODBCStatement::execute INP(RString sql  )  [virtual]
 

API: JDK JDKDOC: Executes a SQL statement that may return multiple results.

Implements acdk::sql::Statement.

virtual RintArray acdk::sql::odbc::ODBCStatement::executeBatch  )  [inline, virtual]
 

API: JDK JDKDOC: JDBC 2.0 Submits a batch of commands to the database for execution.

Implements acdk::sql::Statement.

virtual RResultSet acdk::sql::odbc::ODBCStatement::executeQuery INP(RString sql  )  [virtual]
 

API: JDK JDKDOC: Executes a SQL statement that returns a single ResultSet.

Implements acdk::sql::Statement.

virtual int acdk::sql::odbc::ODBCStatement::executeUpdate INP(RString sql  )  [virtual]
 

API: JDK JDKDOC: Executes an SQL INSERT, UPDATE or DELETE statement.

Implements acdk::sql::Statement.

virtual RConnection acdk::sql::odbc::ODBCStatement::getConnection  )  [virtual]
 

API: JDK JDKDOC: JDBC 2.0 Returns the Connection object that produced this Statement object.

Implements acdk::sql::Statement.

virtual int acdk::sql::odbc::ODBCStatement::getFetchDirection  )  [inline, virtual]
 

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.

virtual int acdk::sql::odbc::ODBCStatement::getFetchSize  )  [inline, virtual]
 

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.

virtual int acdk::sql::odbc::ODBCStatement::getMaxFieldSize  )  [inline, virtual]
 

API: JDK JDKDOC: Returns the maximum number of bytes allowed for any column value.

Implements acdk::sql::Statement.

virtual int acdk::sql::odbc::ODBCStatement::getMaxRows  )  [inline, virtual]
 

API: JDK JDKDOC: Retrieves the maximum number of rows that a ResultSet can contain.

Implements acdk::sql::Statement.

virtual bool acdk::sql::odbc::ODBCStatement::getMoreResults  )  [inline, virtual]
 

API: JDK JDKDOC: Moves to a Statement's next result.

Implements acdk::sql::Statement.

virtual int acdk::sql::odbc::ODBCStatement::getQueryTimeout  )  [inline, virtual]
 

API: JDK JDKDOC: Retrieves the number of seconds the driver will wait for a Statement to execute.

Implements acdk::sql::Statement.

virtual RResultSet acdk::sql::odbc::ODBCStatement::getResultSet  )  [virtual]
 

API: JDK JDKDOC: Returns the current result as a ResultSet object.

Implements acdk::sql::Statement.

virtual int acdk::sql::odbc::ODBCStatement::getResultSetConcurrency  )  [inline, virtual]
 

API: JDK JDKDOC: JDBC 2.0 Retrieves the result set concurrency.

Implements acdk::sql::Statement.

virtual int acdk::sql::odbc::ODBCStatement::getResultSetType  )  [inline, virtual]
 

API: JDK JDKDOC: JDBC 2.0 Determine the result set type.

Implements acdk::sql::Statement.

virtual bool acdk::sql::odbc::ODBCStatement::getScrollableCursor  )  [virtual]
 

virtual int acdk::sql::odbc::ODBCStatement::getUpdateCount  )  [inline, virtual]
 

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.

virtual ::acdk::sql::RSQLWarning acdk::sql::odbc::ODBCStatement::getWarnings  )  [inline, virtual]
 

API: JDK JDKDOC: Retrieves the first warning reported by calls on this Statement.

Implements acdk::sql::Statement.

virtual RODBCStatement acdk::sql::odbc::ODBCStatement::init INP(acdk::util::RProperties prop  )  [virtual]
 

Reimplemented in acdk::sql::odbc::ODBCCallableStatement, and acdk::sql::odbc::ODBCPreparedStatement.

virtual void acdk::sql::odbc::ODBCStatement::setCursorName INP(RString name  )  [inline, virtual]
 

API: JDK JDKDOC: Defines the SQL cursor name that will be used by subsequent Statement execute methods.

Implements acdk::sql::Statement.

virtual void acdk::sql::odbc::ODBCStatement::setEscapeProcessing bool  enable  )  [inline, virtual]
 

API: JDK JDKDOC: Sets escape processing on or off.

Implements acdk::sql::Statement.

virtual void acdk::sql::odbc::ODBCStatement::setFetchDirection int  direction  )  [virtual]
 

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.

virtual void acdk::sql::odbc::ODBCStatement::setFetchSize int  rows  )  [inline, virtual]
 

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.

virtual void acdk::sql::odbc::ODBCStatement::setMaxFieldSize int  max  )  [inline, virtual]
 

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.

virtual void acdk::sql::odbc::ODBCStatement::setMaxRows int  max  )  [inline, virtual]
 

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.

virtual void acdk::sql::odbc::ODBCStatement::setQueryTimeout int  seconds  )  [inline, virtual]
 

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.

virtual void acdk::sql::odbc::ODBCStatement::setScrollableCursor bool  enable  )  [virtual]
 


Member Data Documentation

RODBCConnection acdk::sql::odbc::ODBCStatement::_conn [protected]
 

FetchDirection acdk::sql::odbc::ODBCStatement::_direction [protected]
 

int acdk::sql::odbc::ODBCStatement::_maxLength [protected]
 

int acdk::sql::odbc::ODBCStatement::_maxRows [protected]
 

int acdk::sql::odbc::ODBCStatement::_queryTimeout [protected]
 

bool acdk::sql::odbc::ODBCStatement::_scanEscapes [protected]
 

bool acdk::sql::odbc::ODBCStatement::_scrollableCursors [protected]
 

RString acdk::sql::odbc::ODBCStatement::_sql [protected]
 

RODBCHandle acdk::sql::odbc::ODBCStatement::_stmth [protected]
 

 
Last modified 2005-05-08 18:33 by SYSTEM By Artefaktur, Ing. Bureau Kommer