Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.10

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

interface XMultipleResults
Description
is used for inspecting multiple results produced by the execution of a SQL statement.

Under 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 methods XMultipleResults::getMoreResults() , XMultipleResults::getResultSet() and XMultipleResults::getUpdateCount() let you navigate through multiple results.

See also
XStatement, XPreparedStatement

Methods' Summary
getResultSet returns the current result as a ResultSet object. This method should be called only once per result.  
getUpdateCount returns the current result as an update count.  
getMoreResults moves to a Statement's next result. It returns true if this result is a ResultSet. This method also implicitly closes any current ResultSet obtained with getResultSet.  
Methods' Details
getResultSet
XResultSet
getResultSet()
raises( SQLException );

Description
returns the current result as a ResultSet object. This method should be called only once per result.
Returns
the ResultSet object
Throws
SQLException if a database access error occurs.
getUpdateCount
long
getUpdateCount()
raises( SQLException );

Description
returns the current result as an update count.

If the result is a ResultSet or there are no more results, -1 is returned. This method should be called only once per result.

Returns
the current result as an update count.
Throws
SQLException if a database access error occurs.
getMoreResults
boolean
getMoreResults()
raises( SQLException );

Description
moves to a Statement's next result. It returns true if this result is a ResultSet. This method also implicitly closes any current ResultSet obtained with getResultSet.

There are no more results when (!getMoreResults() && getUpdateCount() == -1).

Returns
true if there exists more ResultSet objects
Throws
SQLException if a database access error occurs.
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.