org.jooq.lambda

Class SQL

java.lang.Object

org.jooq.lambda.SQL

public final class SQL
extends Object

Simplifications for the JDBC APIs when used with Java 8.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
static <T> Seq<T>	seq(PreparedStatement stmt, java.util.function.Function<ResultSet,T> rowFunction) Obtain a stream from a JDBC ResultSet that is obtained from a PreparedStatement with a row mapping function.
static <T> Seq<T>	seq(PreparedStatement stmt, java.util.function.Function<ResultSet,T> rowFunction, java.util.function.Consumer<? super SQLException> exceptionTranslator) Obtain a stream from a JDBC ResultSet that is obtained from a PreparedStatement with a row mapping function.
static <T> Seq<T>	seq(ResultSet rs, java.util.function.Function<ResultSet,T> rowFunction) Obtain a stream from a JDBC ResultSet with a row mapping function.
static <T> Seq<T>	seq(ResultSet rs, java.util.function.Function<ResultSet,T> rowFunction, java.util.function.Consumer<? super SQLException> exceptionTranslator) Obtain a stream from a JDBC ResultSet with a row mapping function.
static <T> Seq<T>	seq(java.util.function.Supplier<? extends ResultSet> supplier, java.util.function.Function<ResultSet,T> rowFunction) Obtain a stream from a JDBC ResultSet Supplier with a row mapping function.
static <T> Seq<T>	seq(java.util.function.Supplier<? extends ResultSet> supplier, java.util.function.Function<ResultSet,T> rowFunction, java.util.function.Consumer<? super SQLException> exceptionTranslator) Obtain a stream from a JDBC ResultSet Supplier with a row mapping function.

Methods inherited from class java.lang.Object

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

Method Detail

seq

public static <T> Seq<T> seq(PreparedStatement stmt,
                             java.util.function.Function<ResultSet,T> rowFunction)

Obtain a stream from a JDBC ResultSet that is obtained from a PreparedStatement with a row mapping function.

Clients are responsible themselves for closing the ResultSet.

Type Parameters:

T - The custom type.

Parameters:

stmt - The JDBC PreparedStatement that generates a ResultSet to be wrapped in a Stream

rowFunction - The row mapping function that maps ResultSet rows to a custom type.

Returns:

A Stream wrapping the ResultSet

seq

public static <T> Seq<T> seq(PreparedStatement stmt,
                             java.util.function.Function<ResultSet,T> rowFunction,
                             java.util.function.Consumer<? super SQLException> exceptionTranslator)

Obtain a stream from a JDBC ResultSet that is obtained from a PreparedStatement with a row mapping function.

Clients are responsible themselves for closing the ResultSet.

Type Parameters:

T - The custom type.

Parameters:

stmt - The JDBC PreparedStatement that generates a ResultSet to be wrapped in a Stream

rowFunction - The row mapping function that maps ResultSet rows to a custom type.

exceptionTranslator - A custom exception translator.

Returns:

A Stream wrapping the ResultSet

seq

public static <T> Seq<T> seq(ResultSet rs,
                             java.util.function.Function<ResultSet,T> rowFunction)

Obtain a stream from a JDBC ResultSet with a row mapping function.

Clients are responsible themselves for closing the ResultSet.

Type Parameters:

T - The custom type.

Parameters:

rs - The JDBC ResultSet to wrap in a Stream

rowFunction - The row mapping function that maps ResultSet rows to a custom type.

Returns:

A Stream wrapping the ResultSet

seq

public static <T> Seq<T> seq(ResultSet rs,
                             java.util.function.Function<ResultSet,T> rowFunction,
                             java.util.function.Consumer<? super SQLException> exceptionTranslator)

Obtain a stream from a JDBC ResultSet with a row mapping function.

Clients are responsible themselves for closing the ResultSet.

Type Parameters:

T - The custom type.

Parameters:

rs - The JDBC ResultSet to wrap in a Stream

rowFunction - The row mapping function that maps ResultSet rows to a custom type.

exceptionTranslator - A custom exception translator.

Returns:

A Stream wrapping the ResultSet

seq

public static <T> Seq<T> seq(java.util.function.Supplier<? extends ResultSet> supplier,
                             java.util.function.Function<ResultSet,T> rowFunction)

Obtain a stream from a JDBC ResultSet Supplier with a row mapping function.

Clients are responsible themselves for closing the ResultSet.

Type Parameters:

T - The custom type.

Parameters:

supplier - The JDBC ResultSet Supplier to wrap in a Stream

rowFunction - The row mapping function that maps ResultSet rows to a custom type.

Returns:

A Stream wrapping the ResultSet

seq

public static <T> Seq<T> seq(java.util.function.Supplier<? extends ResultSet> supplier,
                             java.util.function.Function<ResultSet,T> rowFunction,
                             java.util.function.Consumer<? super SQLException> exceptionTranslator)

Obtain a stream from a JDBC ResultSet Supplier with a row mapping function.

Clients are responsible themselves for closing the ResultSet.

Type Parameters:

T - The custom type.

Parameters:

supplier - The JDBC ResultSet Supplier to wrap in a Stream

rowFunction - The row mapping function that maps ResultSet rows to a custom type.

exceptionTranslator - A custom exception translator.

Returns:

A Stream wrapping the ResultSet