net.maizegenetics.util.db

Class SQL

java.lang.Object

net.maizegenetics.util.db.SQL

public class SQL
extends Object

Set of utilities for working with JDBC User: julian3 Date: 2013/11/10 Time: 7:14 PM PROJECT: ${PROJECT} DESCRIPTION: Code Borrowed from http://java.dzone.com/articles/adding-java-8-lambda-goodness Original package can be downloaded from https://github.com/jexenberger/lambda-tuples

Constructor Summary

Constructors

Constructor and Description
SQL()

Method Summary

Modifier and Type	Method and Description
static <T> T	exec(SQLAction<T> action)
static void	execDDL(Connection connection, String sql)
static int	execDML(Connection connection, String sql, Object... values)
static DBTuple	rowAsTuple(String sql, ResultSet rs)
static void	select(Connection connection, String sql, ResultSetProcessor processor, Object... params)
static Stream<DBTuple>	stream(Connection connection, String sql, Object... parms)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQL

public SQL()

Method Detail

select

public static void select(Connection connection,
                          String sql,
                          ResultSetProcessor processor,
                          Object... params)

execDDL

public static void execDDL(Connection connection,
                           String sql)

execDML

public static int execDML(Connection connection,
                          String sql,
                          Object... values)

rowAsTuple

public static DBTuple rowAsTuple(String sql,
                                 ResultSet rs)

exec

public static <T> T exec(SQLAction<T> action)

stream

public static Stream<DBTuple> stream(Connection connection,
                                     String sql,
                                     Object... parms)