2005/5/9

--
down ACDK
down API Docs
down Namespaces
down acdk
down acdk::sql
down acdk::sql::odbc
down ODBCStatement
  down members
See also:
  down ODBCStatement.cpp
  down ODBCStatement.h

(c) 2005 by
Roger Rene Kommer

Kindly hosted at:
SourceForge.net Logo

     
 

class ODBCStatement
artefaktur
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]