IRISLIB database
PreparedStatement Class Reference
Inheritance diagram for PreparedStatement:
Collaboration diagram for PreparedStatement:

Public Member Functions

 AddBatchEx (_.Library.Integer size, _.Library.Boolean statusArray)
 Specify is Status array for column binding should be produced by Execute Batch. More...
 
_.Library.List ExecuteBatchEx ()
 Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
 
 SetDouble (_.Library.RawString paramIdx, _.Library.Float value)
 void setDouble(int parameterIndex, double x)
 
 SetInt (_.Library.RawString paramIdx, _.Library.Integer value)
 void setInt(int parameterIndex, int x)
 
 SetString (_.Library.RawString paramIdx, _.Library.String value)
 void setString(int parameterIndex, String x)
 
 SetStringLen (_.Library.RawString paramIdx, _.Library.String value, _.Library.Integer len)
 void setString(int parameterIndex, String x, int len)
 
 SetTimestamp (_.Library.RawString paramIdx, _.Library.TimeStamp value)
 method SetTimestamp(paramIdx as RawString, value As TimeStamp) {}
 
- Public Member Functions inherited from Statement
 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...
 

Additional Inherited Members

- Public Attributes inherited from Statement
 connection
   More...
 
 statement
   More...
 
- 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

◆ AddBatchEx()

AddBatchEx ( _.Library.Integer  size,
_.Library.Boolean  statusArray 
)

Specify is Status array for column binding should be produced by Execute Batch.

This call should be followed by Prepare(...) that pass parameter array in $List format