fi.testee.utils

Class JdbcUtils

java.lang.Object

fi.testee.utils.JdbcUtils

public final class JdbcUtils
extends java.lang.Object

Utilities around JDBC.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	JdbcUtils.JdbcConsumer<I>
static interface	JdbcUtils.JdbcFunction<I,O>
static interface	JdbcUtils.JdbcProducer<O>

Constructor Summary

Constructors

Constructor and Description
JdbcUtils()

Method Summary

Modifier and Type	Method and Description
static void	dumpQuery(java.io.PrintStream out, java.sql.Connection c, java.lang.String sql, java.lang.Object... args)
static <O> O	execute(JdbcUtils.JdbcProducer<O> producer, java.util.function.Function<java.sql.SQLException,java.lang.String> error)
static java.util.Map<java.lang.String,java.lang.Object>	mapRowMapper(java.sql.ResultSet rs)
static <O> java.util.List<O>	query(java.sql.Connection c, java.lang.String sql, JdbcUtils.JdbcFunction<java.sql.ResultSet,O> rowMapper, java.lang.Object... args)
static int	update(java.sql.Connection c, java.lang.String sql, java.lang.Object... args)

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcUtils

public JdbcUtils()

Method Detail

mapRowMapper

public static java.util.Map<java.lang.String,java.lang.Object> mapRowMapper(java.sql.ResultSet rs)
                                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

public static <O> O execute(JdbcUtils.JdbcProducer<O> producer,
                            java.util.function.Function<java.sql.SQLException,java.lang.String> error)

update

public static int update(java.sql.Connection c,
                         java.lang.String sql,
                         java.lang.Object... args)

query

public static <O> java.util.List<O> query(java.sql.Connection c,
                                          java.lang.String sql,
                                          JdbcUtils.JdbcFunction<java.sql.ResultSet,O> rowMapper,
                                          java.lang.Object... args)

dumpQuery

public static void dumpQuery(java.io.PrintStream out,
                             java.sql.Connection c,
                             java.lang.String sql,
                             java.lang.Object... args)