多样数据库的连接(mysql,oracle,hive,hbase)

mysql

// 测试能否与mysql数据库连接成功
    public static void main(String[] args) throws Exception {
        String url = "jdbc:mysql://localhost:3306/bladex";
        String user = "root";
        String password = "123456";
        // 初始化驱动包
        Class.forName("com.mysql.cj.jdbc.Driver");
        // 根据数据库连接字符，名称，密码给conn赋值
        Connection conn = DriverManager.getConnection(url, user, password);
        if (conn == null) {
            System.out.println("与mysql数据库连接失败！");
        } else {
            System.out.println("与mysql数据库连接成功！");
        }
    }

oracle

// 测试能否与oracle数据库连接成功
    public static void main(String[] args) throws Exception {
        String url = "jdbc:oracle:thin:@192.168.1.170:1521:ICATI";
        String user = "cs_hai";
        String password = "ca_hai";
        // 初始化驱动包
        Class.forName("oracle.jdbc.driver.OracleDriver");
        // 根据数据库连接字符，名称，密码给conn赋值
        Connection conn = DriverManager.getConnection(url, user, password);
        if (conn == null) {
            System.out.println("与oracle数据库连接失败！");
        } else {
            System.out.println("与oracle数据库连接成功！");
        }
    }

hive

// 测试能否与hive数据库连接成功
    public static void main(String[] args) throws Exception {
        String url = "jdbc:hive2://192.168.137.189:10000/default";
        String user = "";
        String password = "";
        Class.forName("org.apache.hive.jdbc.HiveDriver");
        // 根据数据库连接字符，名称，密码给conn赋值
        conn = DriverManager.getConnection(url, user, password);
        if (conn == null) {
            System.out.println("与hive数据库连接失败！");
        } else {
            System.out.println("与hive数据库连接成功！");
        }
    }

hbase

// 测试能否与hbase数据库连接成功
    public static void main(String[] args) throws Exception {
        String url = "jdbc:phoenix:192.168.1.74:2181:/hbase-unsecure";
        String user = "";
        String password = "";
        // 初始化驱动包
        Class.forName("org.apache.phoenix.jdbc.PhoenixDriver");
        // 根据数据库连接字符，名称，密码给conn赋值
//            conn = DriverManager.getConnection(url, user, password);
        Properties props = new Properties();
        props.setProperty("phoenix.query.timeoutMs", "12000");
        props.setProperty("hbase.rpc.timeout", "12000");
        props.setProperty("hbase.client.scanner.timeout.period", "12000");
        props.setProperty("hbase.client.retries.number", "3");
        props.put("user", user);
        props.put("password", password);
        conn = DriverManager.getConnection(url, props);
        if (conn == null) {
            System.out.println("与phoenix数据库连接失败！");
        } else {
            System.out.println("与phoenix数据库连接成功！");
        }
    }

数据库更多操作——源码链接：
https://github.com/pingzhengguo/sqlproject
https://gitee.com/BingZhenPingGuo/sqlproject