JDBCUtil

#the info of DB store in the application-env.yml
public final class JDBCUtil{

    public classDriver Connection getConnection(){
        String classDriver = System.getenv();
        String jdbcUrl = System.getenv();
        String userName = System.getenv();
        String passWord = System.getenv();
        if(!System.getenv("spring.profiles.active").equals("local")){
            userName = System.getenv(userName);
            passWord = System.getenv(passWord);
        }
    Class.forName(classDriver); #执行对应的数据库driver注册
    Connection con = null ;
    Properties info = new Properties();
    info.setProperty("user",userName);
    info.setProperty("passWord",passWord);
    con = DriverManege.getConnection(jdbcUrl,info)
    return con;
}
    public static void closeResource(Connection conn, Statement st, ResultSet rs){
        closeResultSet(rs);
        closeStatement(st);
        closeConnection(conn);
    }
    public static void closeConnection( Connection conn) {
        if(conn !=null){
            conn.close();
        }
    }
    }

}

Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
    con = JDBCUtil.getConnection();
    con.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
    stmt = con.createStatement();
    rs = stmt.executeQuery(sql);
    while (rs.next()) {
}

} finally {
    JDBCUtil.closeResource(con, stmt, rs);
}

Class.forName 等同 DriverManager.registerDriver(new Driver)