Package org.apache.juneau.dto

Class ResultSetList

java.lang.Object

java.util.AbstractCollection<E>

java.util.AbstractList<E>

java.util.AbstractSequentialList<E>

java.util.LinkedList<Map<String,Object>>

org.apache.juneau.dto.ResultSetList

All Implemented Interfaces:

Serializable, Cloneable, Iterable<Map<String,Object>>, Collection<Map<String,Object>>, Deque<Map<String,Object>>, List<Map<String,Object>>, Queue<Map<String,Object>>

public final class ResultSetList
extends LinkedList<Map<String,Object>>

Transforms an SQL ResultSet into a list of maps.

Loads the entire result set into an in-memory data structure, and then closes the result set object.

See Also:

Field Summary

Fields inherited from class java.util.AbstractList

modCount

Constructor Summary

Constructors

Constructor	Description
ResultSetList(ResultSet rs, int pos, int limit, boolean includeRowNums)	Constructor.

Method Summary

Modifier and Type	Method	Description
protected static Object	readEntry(ResultSet rs, int col, int dataType)	Reads the specified column from the current row in the result set.

Methods inherited from class java.util.LinkedList

add, add, addAll, addAll, addFirst, addLast, clear, clone, contains, descendingIterator, element, get, getFirst, getLast, indexOf, lastIndexOf, listIterator, offer, offerFirst, offerLast, peek, peekFirst, peekLast, poll, pollFirst, pollLast, pop, push, remove, remove, remove, removeFirst, removeFirstOccurrence, removeLast, removeLastOccurrence, set, size, spliterator, toArray, toArray

Methods inherited from class java.util.AbstractSequentialList

iterator

Methods inherited from class java.util.AbstractList

equals, hashCode, listIterator, removeRange, subList

Methods inherited from class java.util.AbstractCollection

containsAll, isEmpty, removeAll, retainAll, toString

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.util.Collection

parallelStream, removeIf, stream, toArray

Methods inherited from interface java.util.Deque

iterator

Methods inherited from interface java.lang.Iterable

forEach

Methods inherited from interface java.util.List

containsAll, equals, hashCode, isEmpty, iterator, listIterator, removeAll, replaceAll, retainAll, sort, subList

Constructor Details

ResultSetList

public ResultSetList(ResultSet rs,
 int pos,
 int limit,
 boolean includeRowNums)
              throws SQLException

Constructor.

Parameters:

rs - The result set to load into this DTO.

pos - The start position (zero-indexed).

limit - The maximum number of rows to retrieve.

includeRowNums - Make the first column be the row number.

Throws:

SQLException - Database error.

Method Details

readEntry

protected static Object readEntry(ResultSet rs,
 int col,
 int dataType)

Reads the specified column from the current row in the result set.

Subclasses can override this method to handle specific data types in special ways.

Parameters:

rs - The result set to read from.

col - The column number (indexed by 1).

dataType - The type of the entry.

Returns:

The entry as an Object.