is used for executing a static SQL statement and obtaining the results produced by it.
More...
|
void | close () raises (SQLException) |
| releases all resources connected to an object. More...
|
|
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...
|
|
com::sun::star::beans::XPropertySetInfo | getPropertySetInfo () |
|
void | setPropertyValue ([in] string aPropertyName, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException ) |
| sets the value of the property with the specified name. More...
|
|
any | getPropertyValue ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
|
void | addPropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener xListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XPropertyChangeListener to the specified property. More...
|
|
void | removePropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XPropertyChangeListener from the listener list. More...
|
|
void | addVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XVetoableChangeListener to the specified property with the name PropertyName. More...
|
|
void | removeVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XVetoableChangeListener from the listener list. More...
|
|
XResultSet | executeQuery ([in]string sql) raises (SQLException) |
| executes a SQL statement that returns a single ResultSet. More...
|
|
long | executeUpdate ([in]string sql) raises (SQLException) |
| executes an SQL INSERT, UPDATE, or DELETE statement. More...
|
|
boolean | execute ([in]string sql) raises (SQLException) |
| executes a SQL statement that may return multiple results. More...
|
|
XConnection | getConnection () raises (SQLException) |
| returns the com::sun::star::sdbc::Connection object that produced this Statement object. More...
|
|
any | getWarnings () raises (SQLException) |
| returns the first warning reported by calls on an object that supports the usage of warnings. More...
|
|
void | clearWarnings () raises (SQLException) |
| clears all warnings reported for the object implementing the interface. More...
|
|
void | dispose () |
| The owner of an object calls this method to explicitly free all resources kept by this object and thus break cyclic references. More...
|
|
void | addEventListener ([in] XEventListener xListener) |
| adds an event listener to the object. More...
|
|
void | removeEventListener ([in] XEventListener aListener) |
| removes an event listener from the listener list. More...
|
|
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...
|
|
void | close () raises (SQLException) |
| releases all resources connected to an object. More...
|
|
com::sun::star::beans::XPropertySetInfo | getPropertySetInfo () |
|
void | setPropertyValue ([in] string aPropertyName, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException ) |
| sets the value of the property with the specified name. More...
|
|
any | getPropertyValue ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
|
void | addPropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener xListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XPropertyChangeListener to the specified property. More...
|
|
void | removePropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XPropertyChangeListener from the listener list. More...
|
|
void | addVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| adds an XVetoableChangeListener to the specified property with the name PropertyName. More...
|
|
void | removeVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException ) |
| removes an XVetoableChangeListener from the listener list. More...
|
|
void | cancel () |
| cancels the current job of the object. More...
|
|
XResultSet | executeQuery ([in]string sql) raises (SQLException) |
| executes a SQL statement that returns a single ResultSet. More...
|
|
long | executeUpdate ([in]string sql) raises (SQLException) |
| executes an SQL INSERT, UPDATE, or DELETE statement. More...
|
|
boolean | execute ([in]string sql) raises (SQLException) |
| executes a SQL statement that may return multiple results. More...
|
|
XConnection | getConnection () raises (SQLException) |
| returns the com::sun::star::sdbc::Connection object that produced this Statement object. More...
|
|
void | addBatch ([in]string sql) raises (SQLException) |
| adds a SQL command to the current batch of commands for the statement object. More...
|
|
void | clearBatch () raises (SQLException) |
| makes the set of commands in the current batch empty. More...
|
|
sequence< long > | executeBatch () raises (SQLException) |
| submits a batch of commands to the database for execution. More...
|
|
any | getWarnings () raises (SQLException) |
| returns the first warning reported by calls on an object that supports the usage of warnings. More...
|
|
void | clearWarnings () raises (SQLException) |
| clears all warnings reported for the object implementing the interface. More...
|
|
XResultSet | getResultSet () raises (SQLException) |
| returns the current result as a com::sun::star::sdbc::ResultSet object. More...
|
|
long | getUpdateCount () raises (SQLException) |
| returns the current result as an update count. More...
|
|
boolean | getMoreResults () raises (SQLException) |
| moves to a Statement's next result. More...
|
|
is used for executing a static SQL statement and obtaining the results produced by it.
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.
- Developers Guide
- Database Access - Creating Statements