Package guru.mikelue.jdut.jdbc.function

Class DbResultSet

java.lang.Object

guru.mikelue.jdut.jdbc.function.DbResultSet

public final class DbResultSet
extends Object

Utility used to build JdbcRunnable or JdbcSupplier for processing a ResultSet with some primitive values(e.g., SQL string).

Method Summary

Modifier and Type	Method	Description
static JdbcRunnable	buildRunnable(Connection conn, String sql, JdbcVoidFunction<? super ResultSet> executor)	Builds runnable by connection and SQL string. This method would use Statement.executeQuery(java.lang.String) for getting result set.
static JdbcRunnable	buildRunnable(Statement statement, String sql, JdbcVoidFunction<? super ResultSet> executor)	Builds runnable by Statement and SQL string. This method would use Statement.executeQuery(java.lang.String) for getting result set.
static <T> JdbcSupplier<T>	buildSupplier(Connection conn, String sql, JdbcFunction<? super ResultSet,? extends T> supplier)	Builds supplier by connection and SQL string. This method would use Statement.executeQuery(java.lang.String) for getting result set.
static <T> JdbcSupplier<T>	buildSupplier(Statement statement, String sql, JdbcFunction<? super ResultSet,? extends T> supplier)	Builds supplier by Statement and SQL string. This method would use Statement.executeQuery(java.lang.String) for getting result set.

Methods inherited from class java.lang.Object

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

Method Detail

buildRunnable

public static JdbcRunnable buildRunnable(Connection conn,
                                         String sql,
                                         JdbcVoidFunction<? super ResultSet> executor)

Builds runnable by connection and SQL string.
This method would use Statement.executeQuery(java.lang.String) for getting result set.

Parameters:

conn - The connection of database(won't be closed in the lambda)

sql - The SQL to query data

executor - The executor of result set from query

Returns:

The instance of lambda

buildRunnable

public static JdbcRunnable buildRunnable(Statement statement,
                                         String sql,
                                         JdbcVoidFunction<? super ResultSet> executor)

Builds runnable by Statement and SQL string.
This method would use Statement.executeQuery(java.lang.String) for getting result set.

Parameters:

statement - The statement to be used(won't be closed in the lambda)

sql - The SQL to query data

executor - The executor of accepting set from query

Returns:

The instance of lambda

buildSupplier

public static <T> JdbcSupplier<T> buildSupplier(Connection conn,
                                                String sql,
                                                JdbcFunction<? super ResultSet,? extends T> supplier)

Builds supplier by connection and SQL string.
This method would use Statement.executeQuery(java.lang.String) for getting result set.

Type Parameters:

T - The type of returned value

Parameters:

conn - The connection of database(won't be closed in the lambda)

sql - The SQL to query data

supplier - The supplier accepting result set from query

Returns:

The instance of lambda

buildSupplier

public static <T> JdbcSupplier<T> buildSupplier(Statement statement,
                                                String sql,
                                                JdbcFunction<? super ResultSet,? extends T> supplier)

Builds supplier by Statement and SQL string.
This method would use Statement.executeQuery(java.lang.String) for getting result set.

Type Parameters:

T - The type of returned value

Parameters:

statement - The statement to be used(won't be closed in the lambda)

sql - The SQL to query data

supplier - The supplier accepting result set from query

Returns:

The instance of lambda