2005/5/9

acdk::sql::Statement Class Reference

Inheritance diagram for acdk::sql::Statement:

Detailed Description

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.