Package ru.curs.celesta.dbutils.jdbc

Class SqlUtils

java.lang.Object

ru.curs.celesta.dbutils.jdbc.SqlUtils

public final class SqlUtils
extends Object

SQL Utility class.

Method Summary

Modifier and Type	Method	Description
static void	executeQuery(Connection conn, String sql, SQLAction action)	Executes query statement on DB connection, returning resultset as a lambda parameter.
static <T> T	executeQuery(Connection conn, String sql, SQLActionReturning<T> action)	Executes query statement on DB connection, returning resultset as a lambda parameter.
static <T> T	executeQuery(Connection conn, String sql, SQLActionReturning<T> action, String errMsg)	Executes query statement on DB connection, returning resultset as a lambda parameter.
static void	executeQuery(Connection conn, String sql, SQLAction action, String errMsg)	Executes query statement on DB connection, returning resultset as a lambda parameter.
static int	executeUpdate(Connection conn, String sql)	Executes update statement on DB connection.

Methods inherited from class java.lang.Object

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

Method Detail

executeUpdate

public static int executeUpdate(Connection conn,
                                String sql)

Executes update statement on DB connection.

Parameters:

conn - DB connection

sql - SQL update statement

executeQuery

public static void executeQuery(Connection conn,
                                String sql,
                                SQLAction action)

Executes query statement on DB connection, returning resultset as a lambda parameter.

This method releases the respective ResultSet and Statement, and also handles exceptions.

Parameters:

conn - DB connection

sql - SQL query statement

action - lambda to be executed for ResultSet

executeQuery

public static <T> T executeQuery(Connection conn,
                                 String sql,
                                 SQLActionReturning<T> action)

Executes query statement on DB connection, returning resultset as a lambda parameter.

This method releases the respective ResultSet and Statement, and also handles exceptions.

Type Parameters:

T - lambda return type

Parameters:

conn - DB connection

sql - SQL query statement

action - lambda to be executed for ResultSet

Returns:

Result of lambda execution

executeQuery

public static void executeQuery(Connection conn,
                                String sql,
                                SQLAction action,
                                String errMsg)

Executes query statement on DB connection, returning resultset as a lambda parameter.

This method releases the respective ResultSet and Statement, and also handles exceptions.

Parameters:

conn - DB connection

sql - SQL query statement

errMsg - Message to be added to the error

action - lambda to be executed for ResultSet

executeQuery

public static <T> T executeQuery(Connection conn,
                                 String sql,
                                 SQLActionReturning<T> action,
                                 String errMsg)

Executes query statement on DB connection, returning resultset as a lambda parameter.

This method releases the respective ResultSet and Statement, and also handles exceptions.

Type Parameters:

T - lambda return type

Parameters:

conn - DB connection

sql - SQL query statement

errMsg - Message to be added to the error

action - lambda to be executed for ResultSet

Returns:

Result of lambda execution