package com.sy.utils;
import java.sql.Connection;
import java.sql.DriverManager;
public class JDBCUtil {
private static final ThreadLocal<Connection> THREAD_LOCAL = new ThreadLocal<Connection>();
static {
try {
Class.forName("com.mysql.jdbc.Driver");
}catch (Exception e){
e.printStackTrace();
}
}
/**
* 获取connection对像
* @return
*/
public static Connection findConnection(){
Connection connection = THREAD_LOCAL.get();
if(connection ==null){
try {
connection= DriverManager.getConnection("jdbc:mysql:///javaee", "root", "tiger");
}catch (Exception e){
e.printStackTrace();
}
THREAD_LOCAL.set(connection);
}
return connection;
}
/**
* 关闭资源
*/
public static void closeConnection(){
Connection connection = THREAD_LOCAL.get();
if(connection !=null){
THREAD_LOCAL.remove();
try {
connection.close();
}catch (Exception e){
e.printStackTrace();
}
}
}
}
JDBCUtils工具类(事务)
最新推荐文章于 2022-11-03 11:26:48 发布