Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sdbc ::
interface XMultipleResults
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-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 See also 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() &amp;&amp; getUpdateCount() == -1)` . Returns true if there exists more ResultSet objects Throws SQLException if a database access error occurs.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.