org.jminor.common.db

Interface ResultPacker<T>

Type Parameters:

T - the type of object resulting from the packing

public interface ResultPacker<T>

A ResultPacker packs the contents of a ResultSet into a List.

Method Summary

Modifier and Type	Method and Description
T	fetch(java.sql.ResultSet resultSet) Fetches a single instance from the given result set, assumes ResultSet.next() has been called
default java.util.List<T>	pack(java.sql.ResultSet resultSet, int fetchCount) Iterates through the given ResultSet, packing its contents into a List using fetch(ResultSet) in the order they appear.

Method Detail

pack

default java.util.List<T> pack(java.sql.ResultSet resultSet,
                               int fetchCount)
                        throws java.sql.SQLException

Iterates through the given ResultSet, packing its contents into a List using fetch(ResultSet) in the order they appear. Items are skipped if fetch(ResultSet) returns null. This method does not close or modify the ResultSet in any way.

Parameters:

resultSet - the ResultSet instance containing the query result to process

fetchCount - the maximum number of records to fetch from the result set, a negative value means all should be fetched.

Returns:

a List containing the data from the query result

Throws:

java.sql.SQLException - thrown if anything goes wrong during the packing

java.lang.NullPointerException - in case resultSet is null

fetch

T fetch(java.sql.ResultSet resultSet)
 throws java.sql.SQLException

Fetches a single instance from the given result set, assumes ResultSet.next() has been called

Parameters:

resultSet - the result set

Returns:

the instance fetched from the ResultSet, null if the item should not be fetched for some reason

Throws:

java.sql.SQLException - in case of failure