Package com.acanx.util

Class JDBCUtil

java.lang.Object

com.acanx.util.JDBCUtil

public class JDBCUtil
extends Object

Constructor Summary

Constructors

Constructor	Description
JDBCUtil()

Method Summary

Modifier and Type	Method	Description
static Connection	getConnection(String driverClass, String jdbcUrl, String user, String password)
static ResultSet	getResultSet(Connection connection, String sql)	链接关闭后无法使用ResultSet
static ResultSetMetaData	getResultSetMetaData(Connection connection, String sql)	链接关闭后无法使用ResultSetMetaData
static void	release(ResultSet rs, Statement statement, Connection conn)	释放数据库连接

Methods inherited from class java.lang.Object

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

Constructor Details

JDBCUtil

public JDBCUtil()

Method Details

getConnection

public static Connection getConnection(String driverClass,
 String jdbcUrl,
 String user,
 String password)
                                throws Exception

Parameters:

driverClass - 驱动类

jdbcUrl - url

user - 用户名

password - 密码

Returns:

数据库连接

Throws:

Exception - 异常信息

release

public static void release(ResultSet rs,
 Statement statement,
 Connection conn)

释放数据库连接

Parameters:

rs - 查询结果集

statement - statement

conn - 连接

getResultSet

public static ResultSet getResultSet(Connection connection,
 String sql)

链接关闭后无法使用ResultSet

Parameters:

connection - 数据库连接

sql - 查询SQL语句

Returns:

返回的查询结果

getResultSetMetaData

public static ResultSetMetaData getResultSetMetaData(Connection connection,
 String sql)

链接关闭后无法使用ResultSetMetaData

Parameters:

connection - 数据库连接

sql - 查询SQL

Returns:

返回的查询结果