Package nxt.db

Class DbUtils

java.lang.Object

nxt.db.DbUtils

public final class DbUtils
extends Object

Method Summary

Modifier and Type	Method	Description
static void	close(AutoCloseable... closeables)
static <T> T[]	getArray(ResultSet rs, String columnName, Class<? extends T[]> cls)
static <T> T[]	getArray(ResultSet rs, String columnName, Class<? extends T[]> cls, T[] ifNull)
static String	limitsClause(int from, int to)
static void	rollback(Connection con)
static <T> void	setArray(PreparedStatement pstmt, int index, T[] array)
static <T> void	setArrayEmptyToNull(PreparedStatement pstmt, int index, T[] array)
static void	setBytes(PreparedStatement pstmt, int index, byte[] bytes)
static void	setIntZeroToNull(PreparedStatement pstmt, int index, int n)
static int	setLimits(int index, PreparedStatement pstmt, int from, int to)
static void	setLong(PreparedStatement pstmt, int index, Long l)
static void	setLongZeroToNull(PreparedStatement pstmt, int index, long l)
static void	setShortZeroToNull(PreparedStatement pstmt, int index, short s)
static void	setString(PreparedStatement pstmt, int index, String s)

Methods inherited from class java.lang.Object

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

Method Details

close

public static void close(AutoCloseable... closeables)

rollback

public static void rollback(Connection con)

setBytes

public static void setBytes(PreparedStatement pstmt,
 int index,
 byte[] bytes)
                     throws SQLException

Throws:

SQLException

setString

public static void setString(PreparedStatement pstmt,
 int index,
 String s)
                      throws SQLException

Throws:

SQLException

setLong

public static void setLong(PreparedStatement pstmt,
 int index,
 Long l)
                    throws SQLException

Throws:

SQLException

setShortZeroToNull

public static void setShortZeroToNull(PreparedStatement pstmt,
 int index,
 short s)
                               throws SQLException

Throws:

SQLException

setIntZeroToNull

public static void setIntZeroToNull(PreparedStatement pstmt,
 int index,
 int n)
                             throws SQLException

Throws:

SQLException

setLongZeroToNull

public static void setLongZeroToNull(PreparedStatement pstmt,
 int index,
 long l)
                              throws SQLException

Throws:

SQLException

getArray

public static <T> T[] getArray(ResultSet rs,
 String columnName,
 Class<? extends T[]> cls)
                        throws SQLException

Throws:

SQLException

getArray

public static <T> T[] getArray(ResultSet rs,
 String columnName,
 Class<? extends T[]> cls,
 T[] ifNull)
                        throws SQLException

Throws:

SQLException

setArray

public static <T> void setArray(PreparedStatement pstmt,
 int index,
 T[] array)
                         throws SQLException

Throws:

SQLException

setArrayEmptyToNull

public static <T> void setArrayEmptyToNull(PreparedStatement pstmt,
 int index,
 T[] array)
                                    throws SQLException

Throws:

SQLException

limitsClause

public static String limitsClause(int from,
 int to)

setLimits

public static int setLimits(int index,
 PreparedStatement pstmt,
 int from,
 int to)
                     throws SQLException

Throws:

SQLException