数据库连接公共类-入门Java（学习自用）

public class BaseDao {
    protected PreparedStatement ps;
    protected static Connection conn = null;
    protected ResultSet rs;


    public static Connection getConn() {
        //驱动
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            //System.out.println("加载驱动成功");
        } catch (ClassNotFoundException e) {
            System.out.println("加载驱动失败");
            e.printStackTrace();
        }
        String url = "jdbc:mysql://localhost:3306/<你的数据库名>?&&serverTimezone=UTC";
        try {
            conn = DriverManager.getConnection(url, "root", "<你的密码>");
            //System.out.println("数据库连接成功");
        } catch (SQLException e) {
            System.out.println("数据库连接失败");
            e.printStackTrace();
        }
        return conn;
    }

    public void toClose() {
        try {
            if (rs != null) {
                rs.close();
                rs = null;
            }
            if (ps != null) {
                ps.close();
                ps = null;
            }
            if (conn != null) {
                conn.close();
                conn = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}```