:: 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.
|
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
- 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
- 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
- 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
Copyright © 2010 Sun Microsystems, Inc.