使用jdbc连接不同版本的数据库

lowVersion.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db_mybatis
username=root
password=123456

highVersion.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db_mybatis
jdbc.userName=root
jdbc.password=123456

JDBCUtil

public class JDBCUtil {
    private String driver;
    private String url;
    private String userName;
    private String password;

    public void init() {
        try {
            //FileInputStream stream = new FileInputStream("E:" + File.separator + "highVersion.properties");
           FileInputStream stream=new FileInputStream("src\\highVersion.properties");
            Properties p = new Properties();//创建
            p.load(stream);//将文件流的内容装载到properties对象中
            driver = p.getProperty("jdbc.driver");
            url = p.getProperty("jdbc.url");
            userName = p.getProperty("jdbc.userName");
            password = p.getProperty("jdbc.password");
            this.registerDriver();
        } catch (FileNotFoundException e) {
            e.printStackTrace();
            System.out.println("配置文件加载不到");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private void registerDriver() {
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.out.println("数据库驱动加载失败");
        }
    }


    public  Connection getConnection() {
        Connection conn = null;
        try {

            conn = DriverManager.getConnection(url,userName, password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }

    public static void close(Statement stmt, Connection conn) {
        try {
            if (stmt != null && stmt.isClosed() == false) {
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                stmt = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (conn != null && conn.isClosed() == false) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                conn = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void close(ResultSet rs, Statement stmt, Connection conn) {
        try {
            if (rs != null && rs.isClosed() == false) {
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                rs = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (stmt != null && stmt.isClosed() == false) {
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                stmt = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        try {
            if (conn != null && conn.isClosed() == false) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                conn = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}