sf.database.util

Class DBUtils

java.lang.Object

sf.database.util.DBUtils

public final class DBUtils
extends Object

Constructor Summary

Constructors

Constructor and Description
DBUtils()

Method Summary

Modifier and Type	Method and Description
static void	close(AutoCloseable obj)
static void	closeQuietly(Connection conn)
static void	closeQuietly(ResultSet rs)
static void	closeQuietly(Statement stmt)
static void	closeQuietlyAutoCloseable(AutoCloseable obj)
static DBContext	doGetDBContext(Connection conn) 获取上下文
static DBDialect	doGetDialect(Connection conn, boolean close) 获取连接的方言,如果无法获取连接的方言,则返回默认的方言.
static DBDialect	doGetDialect(DataSource dataSource)
static boolean	doGetTableExist(Connection conn, String tabelName)
static String	getCatalog(Connection conn) 获取catalog不报错
static int	getColumnIndex(ResultSetMetaData meta, String columnName) 获取colName所在的行数
static int	getDatabaseMajorVersion(Connection conn)
static int	getDatabaseMinorVersion(Connection conn)
static String	getDatabaseProductName(Connection conn)
static String	getDatabaseProductVersion(Connection conn) 获取版本号,针对sqlserver
static String	getDriverName(Connection conn)
static String	getIdentifierQuoteString(Connection conn)
static String	getSchema(Connection conn) 获取schema 不报错
static String	getSqlSelectCount(String sql)
static ConnectInfo	tryAnalyzeInfo(Connection conn) 根据已有的连接解析连接信息
static SQLException	wrapExceptions(Collection<SQLException> errors) 将SQL异常构成链表

Methods inherited from class java.lang.Object

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

Constructor Detail

DBUtils

public DBUtils()

Method Detail

close

public static void close(AutoCloseable obj)

closeQuietlyAutoCloseable

public static void closeQuietlyAutoCloseable(AutoCloseable obj)

closeQuietly

public static void closeQuietly(Connection conn)

closeQuietly

public static void closeQuietly(Statement stmt)

closeQuietly

public static void closeQuietly(ResultSet rs)

tryAnalyzeInfo

public static ConnectInfo tryAnalyzeInfo(Connection conn)
                                  throws SQLException

根据已有的连接解析连接信息

Parameters:

conn -

Returns:

Throws:

SQLException

doGetTableExist

public static boolean doGetTableExist(Connection conn,
                                      String tabelName)

doGetDialect

public static DBDialect doGetDialect(DataSource dataSource)

doGetDialect

public static DBDialect doGetDialect(Connection conn,
                                     boolean close)

获取连接的方言,如果无法获取连接的方言,则返回默认的方言.

Parameters:

conn -

close - 是否关闭

Returns:

doGetDBContext

public static DBContext doGetDBContext(Connection conn)

获取上下文

Parameters:

conn -

Returns:

getIdentifierQuoteString

public static String getIdentifierQuoteString(Connection conn)

getDatabaseProductName

public static String getDatabaseProductName(Connection conn)

getDatabaseProductVersion

public static String getDatabaseProductVersion(Connection conn)

获取版本号,针对sqlserver

Parameters:

conn -

Returns:

getDatabaseMajorVersion

public static int getDatabaseMajorVersion(Connection conn)

getDatabaseMinorVersion

public static int getDatabaseMinorVersion(Connection conn)

getDriverName

public static String getDriverName(Connection conn)

Parameters:

conn -

Returns:

getSchema

public static String getSchema(Connection conn)

获取schema 不报错

Parameters:

conn -

Returns:

getCatalog

public static String getCatalog(Connection conn)

获取catalog不报错

Parameters:

conn -

Returns:

wrapExceptions

public static SQLException wrapExceptions(Collection<SQLException> errors)

将SQL异常构成链表

Parameters:

errors -

Returns:

getSqlSelectCount

public static String getSqlSelectCount(String sql)

getColumnIndex

public static int getColumnIndex(ResultSetMetaData meta,
                                 String columnName)
                          throws SQLException

获取colName所在的行数

Parameters:

meta - 从连接中取出的ResultSetMetaData

columnName - 字段名

Returns:

所在的索引, 如果不存在就抛出异常

Throws:

SQLException - 指定的colName找不到