Module org.itsallcode.jdbc

Package org.itsallcode.jdbc.resultset

Class SimpleResultSet<T>

java.lang.Object

org.itsallcode.jdbc.resultset.SimpleResultSet<T>

Type Parameters:

T - row type

All Implemented Interfaces:

AutoCloseable, Iterable<T>

public class SimpleResultSet<T>
extends Object
implements AutoCloseable, Iterable<T>

This class wraps a ResultSet and allows easy iteration via Iterator, List or Stream.

Constructor Summary

Constructors

Constructor	Description
SimpleResultSet(Context context, ResultSet resultSet, ContextRowMapper<T> rowMapper, AutoCloseable statement)	Create a new instance.

Method Summary

Modifier and Type	Method	Description
void	close()	Close the underlying ResultSet and the statement that created it.
SimpleMetaData	getMetaData()	Get result set metadata.
Iterator<T>	iterator()	Get in Iterator of all rows.
Stream<T>	stream()	Get a stream of all rows.
List<T>	toList()	Collect all rows to a list.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Details

SimpleResultSet

public SimpleResultSet(Context context,
 ResultSet resultSet,
 ContextRowMapper<T> rowMapper,
 AutoCloseable statement)

Create a new instance.

Parameters:

context - database context

resultSet - the underlying result set

rowMapper - a row mapper for converting each row

statement - the statement that created the result set. This will be closed when the result set is closed.

Method Details

getMetaData

public SimpleMetaData getMetaData()

Get result set metadata.

Returns:

metadata

iterator

public Iterator<T> iterator()

Get in Iterator of all rows.

Specified by:

iterator in interface Iterable<T>

Returns:

an iterator with all rows.

toList

public List<T> toList()

Collect all rows to a list.

Returns:

a list with all rows.

stream

public Stream<T> stream()

Get a stream of all rows.

Returns:

a stream with all rows.

close

public void close()

Close the underlying ResultSet and the statement that created it.

Specified by:

close in interface AutoCloseable

Throws:

UncheckedSQLException - if closing fails.