DatabaseConnection.java 数据库连接

package com.util.dbc;
import java.sql.*;

public class DatabaseConnection {
    public static final String DBDRIVER = "com.mysql.cj.jdbc.Driver";
    public static final String DBURL = "jdbc:mysql://localhost:3306/yu";
    public static final String USER = "root";
    public static final String PASSWORD = "r387013";


    //？？
    private static final ThreadLocal<Connection> THREAD_LOCAL = new ThreadLocal<>();
    //构造方法私有化
    private DatabaseConnection(){}
    //重新创建数据库连接
    public static Connection rebuildConnection(){
        Connection conn = null;
        try {
            Class.forName(DBDRIVER);    //加载驱动
            conn = DriverManager.getConnection(DBURL,USER,PASSWORD);    //连接数据库
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }
    //
    public static Connection getConnection(){
        Connection conn = THREAD_LOCAL.get();   //获取当前线程中的连接对象
        if(conn == null){   //如果没有连接对象
            conn = rebuildConnection(); //建立数据库连接
            THREAD_LOCAL.set(conn); //保存连接对象
        }
        return conn;
    }
    //
    public static void close(){
        Connection conn = THREAD_LOCAL.get();   //取得当前线程中的连接对象
        if (conn != null){
            try {
                conn.close();   //关闭数据库连接
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
            THREAD_LOCAL.remove();  //情况ThreadLocal
        }
    }

}