club.spreadme.database.utils

类 JdbcUtil

java.lang.Object

club.spreadme.database.utils.JdbcUtil

public abstract class JdbcUtil
extends java.lang.Object

从以下版本开始:

2018-6-21

作者:

Wangshuwei

构造器概要

构造器

构造器和说明
JdbcUtil()

方法概要

限定符和类型	方法和说明
static void	closeConnection(java.sql.Connection connection, javax.sql.DataSource dataSource) close a connection from datasource
static void	closeResultSet(java.sql.ResultSet rs) close resultset
static void	closeStatement(java.sql.Statement stmt) close statement
static void	doCloseConnection(java.sql.Connection connection, javax.sql.DataSource dataSource) close a connection from datasource
protected static boolean	equals(java.sql.Connection sourceConnection, java.sql.Connection destinationConnection)
static java.lang.String	getColumnName(java.sql.ResultSetMetaData resultSetMetaData, int columnIndex) get a column name from resultsetmetadata by index
static java.sql.Connection	getConnection(javax.sql.DataSource dataSource) Get a connection from datasource
static java.sql.DatabaseMetaData	getDataBaseMeteData()
static java.lang.Object	getResultSetValue(java.sql.ResultSet rs, int index) get value from resultset by index

从类继承的方法 java.lang.Object

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

构造器详细资料

JdbcUtil

public JdbcUtil()

方法详细资料

getConnection

public static java.sql.Connection getConnection(javax.sql.DataSource dataSource)

Get a connection from datasource

参数:

dataSource - DataSource

返回:

Connection

closeConnection

public static void closeConnection(java.sql.Connection connection,
                                   javax.sql.DataSource dataSource)

close a connection from datasource

参数:

connection - Connection

dataSource - DataSource

doCloseConnection

public static void doCloseConnection(java.sql.Connection connection,
                                     javax.sql.DataSource dataSource)
                              throws java.sql.SQLException

close a connection from datasource

参数:

connection - Connection

dataSource - DataSource

抛出:

java.sql.SQLException - SQLException

closeStatement

public static void closeStatement(java.sql.Statement stmt)

close statement

参数:

stmt - statement

closeResultSet

public static void closeResultSet(java.sql.ResultSet rs)

close resultset

参数:

rs - resultset

getColumnName

public static java.lang.String getColumnName(java.sql.ResultSetMetaData resultSetMetaData,
                                             int columnIndex)

get a column name from resultsetmetadata by index

参数:

resultSetMetaData - RsultsetMetaData

columnIndex - Column index

返回:

column name

getResultSetValue

public static java.lang.Object getResultSetValue(java.sql.ResultSet rs,
                                                 int index)

get value from resultset by index

参数:

rs - Resultset

index - Index

返回:

value

getDataBaseMeteData

public static java.sql.DatabaseMetaData getDataBaseMeteData()

equals

protected static boolean equals(java.sql.Connection sourceConnection,
                                java.sql.Connection destinationConnection)