JDBCUtils工具类（事务）

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();
            }

        }

    }


}