artefaktur
software engineer &        architecture
 
 
 
 

class Statement

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

acdk::sql::Statement Class Reference

#include <Statement.h>

Inheritance diagram for acdk::sql::Statement:

acdk::sql::odbc::ODBCStatement acdk::sql::PreparedStatement acdk::sql::sqlite::LiteStatement acdk::sql::odbc::ODBCPreparedStatement acdk::sql::CallableStatement acdk::sql::odbc::ODBCPreparedStatement acdk::sql::sqlite::LitePreparedStatement acdk::sql::sqlite::LitePreparedStatement acdk::sql::odbc::ODBCCallableStatement acdk::sql::odbc::ODBCCallableStatement acdk::sql::odbc::ODBCCallableStatement List of all members.

Detailed Description

API: JDBC 2.0.

Author:
Roger Rene Kommer
Version:
Revision
1.12
Date:
Date
2005/04/08 10:53:21


Public Member Functions

virtual void addBatch (INP(RString) sql)=0
 API: JDK JDKDOC: JDBC 2.0 Adds a SQL command to the current batch of commmands for the statement.

virtual void cancel ()=0
 API: JDK JDKDOC: Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.

virtual void clearBatch ()=0
 API: JDK JDKDOC: JDBC 2.0 Makes the set of commands in the current batch empty.

virtual void clearWarnings ()=0
 API: JDK JDKDOC: Clears all the warnings reported on this Statement object.

virtual void close ()=0
 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)=0
 API: JDK JDKDOC: Executes a SQL statement that may return multiple results.

virtual RintArray executeBatch ()=0
 API: JDK JDKDOC: JDBC 2.0 Submits a batch of commands to the database for execution.

virtual RResultSet executeQuery (INP(RString) sql)=0
 API: JDK JDKDOC: Executes a SQL statement that returns a single ResultSet.

virtual int executeUpdate (INP(RString) sql)=0
 API: JDK JDKDOC: Executes an SQL INSERT, UPDATE or DELETE statement.

virtual RConnection getConnection ()=0
 API: JDK JDKDOC: JDBC 2.0 Returns the Connection object that produced this Statement object.

virtual int getFetchDirection ()=0
 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 ()=0
 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 ()=0
 API: JDK JDKDOC: Returns the maximum number of bytes allowed for any column value.

virtual int getMaxRows ()=0
 API: JDK JDKDOC: Retrieves the maximum number of rows that a ResultSet can contain.

virtual bool getMoreResults ()=0
 API: JDK JDKDOC: Moves to a Statement's next result.

virtual int getQueryTimeout ()=0
 API: JDK JDKDOC: Retrieves the number of seconds the driver will wait for a Statement to execute.

virtual RResultSet getResultSet ()=0
 API: JDK JDKDOC: Returns the current result as a ResultSet object.

virtual int getResultSetConcurrency ()=0
 API: JDK JDKDOC: JDBC 2.0 Retrieves the result set concurrency.

virtual int getResultSetType ()=0
 API: JDK JDKDOC: JDBC 2.0 Determine the result set type.

virtual int getUpdateCount ()=0
 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 RSQLWarning getWarnings ()=0
 API: JDK JDKDOC: Retrieves the first warning reported by calls on this Statement.

virtual void setCursorName (INP(RString) name)=0
 API: JDK JDKDOC: Defines the SQL cursor name that will be used by subsequent Statement execute methods.

virtual void setEscapeProcessing (bool enable)=0
 API: JDK JDKDOC: Sets escape processing on or off.

virtual void setFetchDirection (int direction)=0
 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)=0
 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)=0
 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)=0
 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)=0
 API: JDK JDKDOC: Sets the number of seconds the driver will wait for a Statement to execute to the given number of seconds.

Member Function Documentation

virtual void acdk::sql::Statement::addBatch (  INP(RString)  sql  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::cancel (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::clearBatch (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::clearWarnings (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::close (   )  [pure 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.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual bool acdk::sql::Statement::execute (  INP(RString)  sql  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual RintArray acdk::sql::Statement::executeBatch (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual RResultSet acdk::sql::Statement::executeQuery (  INP(RString)  sql  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::executeUpdate (  INP(RString)  sql  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual RConnection acdk::sql::Statement::getConnection (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getFetchDirection (   )  [pure 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.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getFetchSize (   )  [pure 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.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getMaxFieldSize (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getMaxRows (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual bool acdk::sql::Statement::getMoreResults (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getQueryTimeout (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual RResultSet acdk::sql::Statement::getResultSet (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getResultSetConcurrency (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getResultSetType (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual int acdk::sql::Statement::getUpdateCount (   )  [pure 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.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual RSQLWarning acdk::sql::Statement::getWarnings (   )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setCursorName (  INP(RString)  name  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setEscapeProcessing (  bool  enable  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setFetchDirection (  int  direction  )  [pure 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.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setFetchSize (  int  rows  )  [pure 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.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setMaxFieldSize (  int  max  )  [pure virtual]
 

API: JDK JDKDOC: Sets the limit for the maximum number of bytes in a column to the given number of bytes.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setMaxRows (  int  max  )  [pure virtual]
 

API: JDK JDKDOC: Sets the limit for the maximum number of rows that any ResultSet can contain to the given number.

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

virtual void acdk::sql::Statement::setQueryTimeout (  int  seconds  )  [pure virtual]
 

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

Implemented in acdk::sql::odbc::ODBCStatement, and acdk::sql::sqlite::LiteStatement.

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