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

Kindly hosted at:

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:

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]

class ODBCStatement

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

Public Member Functions

Protected Attributes

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation