import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
*
* @description
* @author sue
* @createdate 2016-1-20
* @projectname
* @packageclass com.xx.atm.utilMyJDBCUtil.java
*/
public class MyJDBCUtil {
private static ThreadLocal<Connection> threadlocal = new ThreadLocal<Connection>();
/**
*
* @return
* @throws Exception
*/
public static Connection getConnection(){
Connection conn = threadlocal.get();
if(conn == null){
try {
Class.forName(Config.getInstance().getConfig("database.driver"));
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(
Config.getInstance().getConfig("oracle.jdbc.url"), Config
.getInstance().getConfig("oracle.jdbc.user"),
Config.getInstance().getConfig("oracle.jdbc.pwd"));
threadlocal.set(conn);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return conn;
}
/**
*
* @param rs
* @param pstm
* @param conn
*/
public static void close(ResultSet rs, PreparedStatement pstm, Connection conn) {
System.out.println("关闭连接");
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (pstm != null) {
try {
pstm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
threadlocal.remove();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
*
* @description
* @author sue
* @createdate 2016-1-20
* @projectname
* @packageclass com.xx.atm.utilMyJDBCUtil.java
*/
public class MyJDBCUtil {
private static ThreadLocal<Connection> threadlocal = new ThreadLocal<Connection>();
/**
*
* @return
* @throws Exception
*/
public static Connection getConnection(){
Connection conn = threadlocal.get();
if(conn == null){
try {
Class.forName(Config.getInstance().getConfig("database.driver"));
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(
Config.getInstance().getConfig("oracle.jdbc.url"), Config
.getInstance().getConfig("oracle.jdbc.user"),
Config.getInstance().getConfig("oracle.jdbc.pwd"));
threadlocal.set(conn);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return conn;
}
/**
*
* @param rs
* @param pstm
* @param conn
*/
public static void close(ResultSet rs, PreparedStatement pstm, Connection conn) {
System.out.println("关闭连接");
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (pstm != null) {
try {
pstm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
threadlocal.remove();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}