Package com.appslandia.common.jdbc

Class JdbcUtils

java.lang.Object

com.appslandia.common.jdbc.JdbcUtils

public class JdbcUtils
extends Object

Author:

Loc Ha

Constructor Summary

Constructors

Constructor	Description
JdbcUtils()

Method Summary

Modifier and Type	Method	Description
static void	closeQuietly(AutoCloseable closeable)
static long	fixIdSeq(String tableName, String idColumn, boolean idInt, String idPkSeq, String idNotNull, String idPk, String idSeq, Connection conn)
static String[]	getColumnLabels(ResultSet rs)
static void	rollback(Connection conn)
static void	setAutoCommit(Connection conn)

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

rollback

public static void rollback(Connection conn)
                     throws SQLException

Throws:

SQLException

setAutoCommit

public static void setAutoCommit(Connection conn)
                          throws SQLException

Throws:

SQLException

closeQuietly

public static void closeQuietly(AutoCloseable closeable)

getColumnLabels

public static String[] getColumnLabels(ResultSet rs)
                                throws SQLException

Throws:

SQLException

fixIdSeq

public static long fixIdSeq(String tableName,
                            String idColumn,
                            boolean idInt,
                            String idPkSeq,
                            String idNotNull,
                            String idPk,
                            String idSeq,
                            Connection conn)
                     throws SQLException

Throws:

SQLException