Module is.codion.common.db

Package is.codion.common.db.result

Interface ResultIterator<T>

Type Parameters:

T - the type to fetch from the ResultSet

All Superinterfaces:

AutoCloseable, Iterable<T>

public interface ResultIterator<T>
extends AutoCloseable, Iterable<T>

Iterates through a ResultSet fetching instances of T. Use try with resources or remember to call close() in order to close underlying resources.

Method Summary

Modifier and Type	Method	Description
void	close()	Closes the underlying ResultSet and other resources held by this iterator
boolean	hasNext()	Returns true if a row is available in the underlying ResultSet.
default Iterator<T>	iterator()	Wraps this ResultIterator in a Iterator.
T	next()

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Method Details

hasNext

boolean hasNext()
         throws SQLException

Returns true if a row is available in the underlying ResultSet.

Returns:

true if a row is available in the underlying ResultSet

Throws:

SQLException - in case of an exception

next

T next()
throws SQLException

Returns:

an instance of T fetched from the ResultSet

Throws:

SQLException - in case of an exception

NoSuchElementException - in case no more rows are available

close

void close()

Closes the underlying ResultSet and other resources held by this iterator

Specified by:

close in interface AutoCloseable

iterator

default Iterator<T> iterator()

Wraps this ResultIterator in a Iterator. Any SQLExceptions that occur are rethrown wrapped in a RuntimeException.

Specified by:

iterator in interface Iterable<T>

Returns:

a Iterator instance based on this ResultIterator