2005/5/9

--
down ACDK
down API Docs
down Namespaces
down acdk
down acdk::sql
down acdk::sql::sqlite
down LiteStatement
  down members
See also:
  down LiteStatement.cpp
  down LiteStatement.h

(c) 2005 by
Roger Rene Kommer

Kindly hosted at:
SourceForge.net Logo

     
 

class LiteStatement
artefaktur
Modules   Namespace List   Class Hierarchy   Alphabetical List   Compound List   Namespace Members   Compound Members   Related Pages  

acdk::sql::sqlite::LiteStatement Class Reference

#include <LiteStatement.h>

Inheritance diagram for acdk::sql::sqlite::LiteStatement:

acdk::lang::Object acdk::sql::Statement acdk::lang::ObjectBase acdk::lang::dmi::StdDispatch acdk::sql::sqlite::LitePreparedStatement List of all members.

Detailed Description

Statement for a SQLite database.

Not all methods are implemented.


Public Member Functions

 LiteStatement (IN(RLiteConnection) con)
virtual void addBatch (INP(RString) sql)
 currently not supported

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 ()
 currently not supported

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 ()
 always return ResultSet::FETCH_UNKNOWN

virtual int getFetchSize ()
 always return 1

virtual int getMaxFieldSize ()
 always return 0

virtual int getMaxRows ()
 always return 0

virtual bool getMoreResults ()
 always return false

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 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)
 sqlite supports only forward direction

virtual void setFetchSize (int rows)
 will be ignored

virtual void setMaxFieldSize (int max)
 will be ignored

virtual void setMaxRows (int max)
 will be ignored

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

RLiteConnection _con
int _updateCount
RResultSet _rset

Constructor & Destructor Documentation

acdk::sql::sqlite::LiteStatement::LiteStatement (  IN(RLiteConnection)  con  )  [inline]
 

Member Function Documentation

virtual void acdk::sql::sqlite::LiteStatement::addBatch (  INP(RString)  sql  )  [inline, virtual]
 

currently not supported

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::cancel (   )  [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::sqlite::LiteStatement::clearBatch (   )  [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::sqlite::LiteStatement::clearWarnings (   )  [virtual]
 

currently not supported

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::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.

virtual bool acdk::sql::sqlite::LiteStatement::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::sqlite::LiteStatement::executeBatch (   )  [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::sqlite::LiteStatement::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::sqlite::LiteStatement::executeUpdate (  INP(RString)  sql  )  [virtual]
 

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

Implements acdk::sql::Statement.

virtual RConnection acdk::sql::sqlite::LiteStatement::getConnection (   )  [inline, virtual]
 

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

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getFetchDirection (   )  [inline, virtual]
 

always return ResultSet::FETCH_UNKNOWN

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getFetchSize (   )  [inline, virtual]
 

always return 1

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getMaxFieldSize (   )  [inline, virtual]
 

always return 0

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getMaxRows (   )  [inline, virtual]
 

always return 0

Implements acdk::sql::Statement.

virtual bool acdk::sql::sqlite::LiteStatement::getMoreResults (   )  [inline, virtual]
 

always return false

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getQueryTimeout (   )  [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::sqlite::LiteStatement::getResultSet (   )  [virtual]
 

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

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getResultSetConcurrency (   )  [virtual]
 

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

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getResultSetType (   )  [virtual]
 

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

Implements acdk::sql::Statement.

virtual int acdk::sql::sqlite::LiteStatement::getUpdateCount (   )  [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 RSQLWarning acdk::sql::sqlite::LiteStatement::getWarnings (   )  [virtual]
 

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

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::setCursorName (  INP(RString)  name  )  [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::sqlite::LiteStatement::setEscapeProcessing (  bool  enable  )  [virtual]
 

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

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::setFetchDirection (  int  direction  )  [virtual]
 

sqlite supports only forward direction

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::setFetchSize (  int  rows  )  [virtual]
 

will be ignored

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::setMaxFieldSize (  int  max  )  [virtual]
 

will be ignored

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::setMaxRows (  int  max  )  [virtual]
 

will be ignored

Implements acdk::sql::Statement.

virtual void acdk::sql::sqlite::LiteStatement::setQueryTimeout (  int  seconds  )  [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.

Member Data Documentation

RLiteConnection acdk::sql::sqlite::LiteStatement::_con [protected]
 

RResultSet acdk::sql::sqlite::LiteStatement::_rset [protected]
 

int acdk::sql::sqlite::LiteStatement::_updateCount [protected]