Statement Class Reference

Inheritance diagram for Statement:

Collaboration diagram for Statement:

Public Member Functions
	AddBatch (_.Library.String sql, _.Library.Boolean ColumnBinding, _.Library.Integer size, _.Library.Boolean statusArray)
	Method Not Supported, use PreparedStatement.AddBatchEx.
	Cancel ()
	Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
	ClearBatch ()
	Method Not Supported.
	Close ()
	Releases this Statement object's database and resources immediately instead of waiting for this to happen when it is automatically closed.
_.Library.Boolean	Execute ()
	Executes the prepared SQL statement, which may return multiple results.
_.Library.ListOfDataTypes	ExecuteBatch ()
	Method Not Supported, use PreparedStatement.ExecuteBatchEx.
_.Library.Boolean	ExecuteDirect (_.Library.String sql)
	Executes the given SQL statement, which may return multiple results.
_.XDBC.Gateway.ResultSet	ExecuteQuery (_.Library.String sql)
	Executes the given SQL statement, which returns a single ResultSet object.
_.Library.Integer	ExecuteUpdate (_.Library.String sql)
	Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement. More...
_.XDBC.Gateway.ODBC.Connection	GetConnection ()
	Retrieves the Connection object that produced this Statement object.
_.Library.Integer	GetFetchSize ()
	Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
_.XDBC.Gateway.ResultSet	GetGeneratedKeys ()
	Method Not Supported.
_.Library.Integer	GetMaxFieldSize ()
	Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
_.Library.Integer	GetMaxRows ()
	Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
_.Library.Boolean	GetMoreResults ()
	Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.
_.Library.Integer	GetQueryTimeout ()
	Retrieves the number of seconds the driver will wait for a Statement object to execute.
_.XDBC.Gateway.ResultSet	GetResultSet ()
	Retrieves the current result as a ResultSet object.
_.Library.Integer	GetUpdateCount ()
	Method Not Supported.
_.Library.Boolean	IsClosed ()
	Method Not Supported.
	SetFetchSize (_.Library.Integer rows)
	Gives the driver a hint as to the number of rows that should be fetched from the database when more rows are needed for ResultSet objects genrated by this Statement.
	SetMaxFieldSize (_.Library.Integer max)
	Method Not Supported.
	SetMaxRows (_.Library.Integer max)
	Method Not Supported.
	SetQueryTimeout (_.Library.Integer seconds)
	Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
Public Member Functions inherited from Statement
	AddBatch (_.Library.String sql)
	FOR INTERNAL USE - do not invoke directly. More...
_.Library.Boolean	Execute (_.Library.String sql, _.Library.Integer autoGeneratedKeys)
	Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval.
_.Library.Integer	ExecuteUpdate (_.Library.String sql, _.Library.Integer autoGeneratedKeys)
	Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement. More...
Public Member Functions inherited from RegisteredObject
_.Library.Status	OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount)
	This callback method is invoked when the current object is added to the SaveSet,. More...
_.Library.Status	OnClose ()
	This callback method is invoked by the <METHOD>Close</METHOD> method to. More...
_.Library.Status	OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned)
	This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More...
_.Library.Status	OnNew ()
	This callback method is invoked by the <METHOD>New</METHOD> method to. More...
_.Library.Status	OnValidateObject ()
	This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More...

Public Attributes
	connection
	More...
	statement
	More...

Additional Inherited Members
Static Public Attributes inherited from RegisteredObject
	CAPTION = None
	Optional name used by the Form Wizard for a class when generating forms. More...
	JAVATYPE = None
	The Java type to be used when exported.
	PROPERTYVALIDATION = None
	This parameter controls the default validation behavior for the object. More...

Member Function Documentation

ExecuteUpdate()

_.Library.Integer ExecuteUpdate

(

_.Library.String

sql

)

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.

Member Data Documentation

connection

connection

 

 

statement

statement