Interface JdbcClient.Rows<T>

Type Parameters:

T - mapped type

Enclosing interface:

JdbcClient

public static interface JdbcClient.Rows<T>

Materialized result terminals for a mapped query or generated key result.

The stage accepts exactly one terminal invocation and is not safe for concurrent use. An exception from an application mapper is propagated unchanged.

Method Summary

Modifier and Type	Method	Description
List<T>	list()	Returns all rows in JDBC encounter order.
T	one()	Returns exactly one row.
Optional<T>	optional()	Returns zero or one row.

Method Details

one

T one()

Returns exactly one row.

Returns:

mapped row

Throws:

NoResultException - if no row is returned

NonUniqueResultException - if more than one row is returned

DataException - if JDBC execution or provider mapping fails

IllegalStateException - if a terminal operation has started

optional

Optional<T> optional()

Returns zero or one row.

For a scalar stage created by JdbcClient.Statement.map(Class), an empty result represents either no row or exactly one row whose first column is SQL NULL. For a stage created by JdbcClient.Statement.map(RowMapper), an empty result represents no row; the mapper may return an Optional value to represent column nullability separately.

Returns:

empty if no row is returned or, for scalar mapping selected by JdbcClient.Statement.map(Class), if one row contains SQL NULL in column one; otherwise the mapped row

Throws:

NonUniqueResultException - if more than one row is returned

DataException - if JDBC execution or provider mapping fails

IllegalStateException - if a terminal operation has started

list

List<T> list()

Returns all rows in JDBC encounter order.

Returns:

materialized rows

Throws:

DataException - if JDBC execution or provider mapping fails

IllegalStateException - if a terminal operation has started