Statement Class Reference

FOR INTERNAL USE - do not invoke directly. More...

Inheritance diagram for Statement:

Collaboration diagram for Statement:

Public Member Functions
	AddBatch (_.Library.String sql)
	Sets the value of the designated parameter with the given object. More...
	Cancel ()
	Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
	ClearBatch ()
	Empties this Statement object's current list of SQL commands.
	Close ()
	Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
_.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. More...
_.Library.ListOfDataTypes	ExecuteBatch ()
	Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
_.XDBC.Gateway.JDBC.ResultSet	ExecuteQuery (_.Library.String sql)
	list of int More...
_.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...
_.XDBC.Gateway.JDBC.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.JDBC.ResultSet	GetGeneratedKeys ()
	Retrieves any auto-generated keys created as a result of executing this Statement object.
_.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 (_.Library.Integer option)
	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.JDBC.ResultSet	GetResultSet ()
	Retrieves the current result as a ResultSet object.
_.Library.Integer	GetUpdateCount ()
	Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
_.Library.Boolean	IsClosed ()
	Retrieves whether this Statement object has been closed.
	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)
	Sets the limit for the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
	SetMaxRows (_.Library.Integer max)
	Sets the limit for the maximum number of rows that any ResultSet object generated by this Statement object can contain to the given number.
	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
_.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.
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...

Detailed Description

FOR INTERNAL USE - do not invoke directly.

Member Function Documentation

AddBatch()

AddBatch

(

_.Library.String

sql

)

Sets the value of the designated parameter with the given object.

Method SetObject(parameterName As String, parameter As ObjectHandle) {} Adds the given SQL command to the current list of commmands for this Statement object.

Reimplemented from Statement.

Reimplemented in PreparedStatement.

Execute()

_.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.

xecutes the given SQL statement, which may return multiple results. In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string. The execute method executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s). Note:This method cannot be called on a PreparedStatement or CallableStatement.

Reimplemented from Statement.

ExecuteQuery()

_.XDBC.Gateway.JDBC.ResultSet ExecuteQuery

(

_.Library.String

sql

)

list of int

Executes the given SQL statement, which returns a single ResultSet object

Reimplemented from Statement.

Reimplemented in PreparedStatement.

ExecuteUpdate()

_.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.

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. Cannot be executed on PreparedStatement or CallableStatement.

Reimplemented from Statement.

Member Data Documentation

connection

connection

 

 

statement

statement