LibreOffice
LibreOffice 6.2 SDK API Reference
Public Member Functions | List of all members
XPreparedStatement Interface Referencepublished

provides the possibility of executing a precompiled SQL statement. More...

import"XPreparedStatement.idl";

Inheritance diagram for XPreparedStatement:
XInterface PreparedStatement PreparedStatement CallableStatement PreparedStatement CallableStatement CallableStatement

Public Member Functions

XResultSet executeQuery () raises (SQLException)
 executes the SQL query in this PreparedStatement object and returns the result set generated by the query. More...
 
long executeUpdate () raises (SQLException)
 executes the SQL INSERT, UPDATE or DELETE statement in this com::sun::star::sdbc::PreparedStatement object. More...
 
boolean execute () raises (SQLException)
 executes any kind of SQL statement. More...
 
XConnection getConnection () raises (SQLException)
 returns the com::sun::star::sdbc::Connection object that produced this com::sun::star::sdbc::Statement object. More...
 
- Public Member Functions inherited from XInterface
any queryInterface ([in] type aType)
 queries for a new interface to an existing UNO object. More...
 
void acquire ()
 increases the reference counter by one. More...
 
void release ()
 decreases the reference counter by one. More...
 

Detailed Description

provides the possibility of executing 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.

Member Function Documentation

boolean execute ( )
raises (SQLException
)

executes any kind of SQL statement.

Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.

Returns
TRUE if successful
Exceptions
SQLExceptionif a database access error occurs.
XResultSet executeQuery ( )
raises (SQLException
)

executes the SQL query in this PreparedStatement object and returns the result set generated by the query.

Returns
the ResultSet object
Exceptions
SQLExceptionif a database access error occurs.
long executeUpdate ( )
raises (SQLException
)

executes the SQL INSERT, UPDATE or DELETE statement in this com::sun::star::sdbc::PreparedStatement object.


In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed.

Returns
either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing
Exceptions
SQLExceptionif a database access error occurs.
XConnection getConnection ( )
raises (SQLException
)

returns the com::sun::star::sdbc::Connection object that produced this com::sun::star::sdbc::Statement object.

Returns
the Connection object
Exceptions
SQLExceptionif a database access error occurs.

The documentation for this interface was generated from the following file: