Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

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 and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.