Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sdbc ::

service PreparedStatement
Description
represents a precompiled SQL statement.

A SQL statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer, then the method XParameters::setInt() should be used.

If arbitrary parameter type conversions are required, the method XParameters::setObject() should be used with a target SQL type.

Example of setting a parameter; con is an active connection.

Example
:StarBASIC
 
 pstmt = con.prepareStatement("UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?") 
 pstmt.setDouble(1, 153833.00) 
 pstmt.setLong(2, 110592) 
 

Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. All statement execute methods implicitly close a statement's current ResultSet if an open one exists.


Exported Interfaces - Summary
::com::sun::star::lang::XComponent

optional for implementation, controls the releasing of resources and the notification of registered listeners. (details)

XCloseable

freeing all resources of a statement. A related resultset will be freed as well.

::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
::com::sun::star::util::XCancellable

could be used for cancelling the execution of SQL statements, if both the DBMS and the driver support aborting an SQL statement. The implementation is optional. (details)

XPreparedStatement

is the interface for executing SQL prepared commands.

XResultSetMetaDataSupplier

provides access to the description of the result set which would be generated by executing the PreparedStatement.

XParameters

is used for setting parameters before execution of the precompiled statement.

XPreparedBatchExecution

provides the ability of batch execution. This interface is optional for execution. (details)

XWarningsSupplier

controls the chaining of warnings, which may occur on every call to the connected database. Chained warnings from previous calls will be cleared before processing a new call.

XMultipleResults

covers the handling of multiple results after executing an SQL command.

Properties' Summary
long
QueryTimeOut
retrieves the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown. There is no limitation, if set to zero.  
long
MaxFieldSize
returns the maximum number of bytes allowed for any column value.  
long
MaxRows
retrieves the maximum number of rows that a ResultSet can contain. If the limit is exceeded, the excess rows are silently dropped.
There is no limitation, if set to zero.  
string
CursorName
defines the SQL cursor name that will be used by subsequent Statement execute methods.  
long
ResultSetConcurrency
retrieves the result set concurrency.  
long
ResultSetType
Determine the result set type.  
long
FetchDirection
retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.  
long
FetchSize
retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object.  
Exported Interfaces - Details
::com::sun::star::lang::XComponent
Usage Restrictions
optional
Description
optional for implementation, controls the releasing of resources and the notification of registered listeners.
XCloseable
Description
freeing all resources of a statement. A related resultset will be freed as well.
::com::sun::star::beans::XPropertySet
(referenced entity's summary:)
provides information about and access to the properties from an implementation.
::com::sun::star::util::XCancellable
Usage Restrictions
optional
Description
could be used for cancelling the execution of SQL statements, if both the DBMS and the driver support aborting an SQL statement. The implementation is optional.
XPreparedStatement
Description
is the interface for executing SQL prepared commands.
XResultSetMetaDataSupplier
Description
provides access to the description of the result set which would be generated by executing the PreparedStatement.
XParameters
Description
is used for setting parameters before execution of the precompiled statement.
XPreparedBatchExecution
Usage Restrictions
optional
Description
provides the ability of batch execution. This interface is optional for execution.

A driver implementing batch execution must return true for XDatabaseMetaData::supportsBatchUpdates()

XWarningsSupplier
Description
controls the chaining of warnings, which may occur on every call to the connected database. Chained warnings from previous calls will be cleared before processing a new call.
XMultipleResults
Description
covers the handling of multiple results after executing an SQL command.
Properties' Details
QueryTimeOut
long QueryTimeOut;
Description
retrieves the number of seconds the driver will wait for a Statement to execute. If the limit is exceeded, a SQLException is thrown. There is no limitation, if set to zero.
MaxFieldSize
long MaxFieldSize;
Description
returns the maximum number of bytes allowed for any column value.

This limit is the maximum number of bytes that can be returned for any column value. The limit applies only to DataType::BINARY , DataType::VARBINARY , DataType::LONGVARBINARY , DataType::CHAR , DataType::VARCHAR , and DataType::LONGVARCHAR columns. If the limit is exceeded, the excess data is silently discarded.

There is no limitation, if set to zero.

MaxRows
long MaxRows;
Description
retrieves the maximum number of rows that a ResultSet can contain. If the limit is exceeded, the excess rows are silently dropped.
There is no limitation, if set to zero.
CursorName
string CursorName;
Description
defines the SQL cursor name that will be used by subsequent Statement execute methods.

This name can then be used in SQL positioned update/delete statements to identify the current row in the ResultSet generated by this statement. If the database does not support positioned update/delete, this property is a noop. To insure that a cursor has the proper isolation level to support updates, the cursor's SELECT statement should be of the form 'select for update ...'. If the 'for update' phrase is omitted, positioned updates may fail.

Note: By definition, positioned update/delete execution must be done by a different Statement than the one which generated the ResultSet being used for positioning. Also, cursor names must be unique within a connection.

ResultSetConcurrency
long ResultSetConcurrency;
Description
retrieves the result set concurrency.
See also
ResultSetConcurrency
ResultSetType
long ResultSetType;
Description
Determine the result set type.
See also
ResultSetType
FetchDirection
long FetchDirection;
Description
retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.

If this Statement object has not set a fetch direction, the return value is implementation-specific.

FetchSize
long FetchSize;
Description
retrieves the number of result set rows that is the default fetch size for result sets generated from this Statement object.

If this Statement object has not set a fetch size, the return value is implementation-specific.


 
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.