JDBC获得数据库连接(包括释放资源)的工具类终极版

package com.bjpowernode.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcUtils {

	private JdbcUtils() {
	}
    //加载DB驱动
	static {
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
		} catch (Exception e) {
			throw new RuntimeException(e + "数据库连接失败");
		}

	}
	private static Connection con;
    //获取Connection对象
	public static Connection getConnection() throws SQLException {
		String url = "jdbc:mysql://localhost:3306/mybase?serverTimezone=UTC";
		String username = "root", password = "ls12345";
		if (con == null || con.isClosed()) {
			con = DriverManager.getConnection(url, username, password);
		}
		return con;
	}

	

	// 关闭资源
	public static void close(Connection con, Statement stat, ResultSet rs) throws SQLException {

		if (con != null && !con.isClosed()) {
			con.close();
		}
		if (stat != null && !stat.isClosed()) {
			stat.close();
		}
		if (rs != null && !rs.isClosed()) {
			rs.close();
		}

	}

}