org.sfm.jdbc

Interface JdbcMapper<T>

Type Parameters:

T - the type that the mapper is mapping to

All Superinterfaces:

FieldMapper<ResultSet,T>, Mapper<ResultSet,T>

All Known Implementing Classes:

AbstractDynamicJdbcMapper, AbstractForEachDynamicJdbcMapper, AbstractJdbcMapper, DiscriminatorJdbcMapper, DynamicJdbcMapper, JdbcMapperImpl, JoinJdbcMapper

public interface JdbcMapper<T>
extends Mapper<ResultSet,T>

JdbcMapper will map from a ResultSet to an object of the specified type T

JdbcMapper are instantiable via JdbcMapperFactory.

JdbcMapper<MyClass> mapper = JdbcMapperFactory.newInstance().newMapper(MyClass.class);

...

try (ResultSet rs : ps.executeQuery()){
mapper.stream(rs).forEach(System.out::println);
}


See Also:

JdbcMapperFactory

Method Summary

Modifier and Type	Method and Description
<H extends RowHandler<? super T>> H	forEach(ResultSet rs, H handle) Loop over the resultSet, map each row to a new instance of T and call back the handler
Iterator<T>	iterate(ResultSet rs) Deprecated.
Iterator<T>	iterator(ResultSet rs)
Stream<T>	stream(ResultSet rs)

Methods inherited from interface org.sfm.map.Mapper

map, map, newMappingContext

Methods inherited from interface org.sfm.map.FieldMapper

mapTo

Method Detail

forEach

<H extends RowHandler<? super T>> H forEach(ResultSet rs,
                                            H handle)
                                     throws SQLException,
                                            MappingException

Loop over the resultSet, map each row to a new instance of T and call back the handler

The method will return the handler passed as an argument so you can easily chain the calls like
List<T> list = mapper.forEach(rs, new ListHandler<T>()).getList();

Type Parameters:

H - the row handler type

Parameters:

rs - the resultSet

handle - the handler that will get the callback

Returns:

the handler passed in

Throws:

SQLException - if sql error occurs

MappingException - if an error occurs during the mapping

iterator

Iterator<T> iterator(ResultSet rs)
              throws SQLException,
                     MappingException

Parameters:

rs - the result set

Returns:

an iterator that will return a map object for each row of the result set.

Throws:

SQLException - if sql error occurs

MappingException - if an error occurs during the mapping

iterate

@Deprecated
Iterator<T> iterate(ResultSet rs)
                         throws SQLException,
                                MappingException

Deprecated.

Throws:

SQLException

MappingException

stream

Stream<T> stream(ResultSet rs)
          throws SQLException,
                 MappingException

Parameters:

rs - the result set

Returns:

a stream that will contain a map object for each row of the result set.

Throws:

SQLException - if sql error occurs

MappingException - if an error occurs during the mapping