Java-JDBC-连接不同数据库

PostgreSQL

private static Connection getConn() throws Exception {
	Class.forName("org.postgresql.Driver");
	String url = "jdbc:postgresql://192.168.2.150:5432/hive_query_info";
	String user = "root";
	String password = "123456"; // 不验证密码
	Connection conn = DriverManager.getConnection(url, user, password);
	System.out.println("connect PostgreSQL OK,conn: " + conn + "\n");
	return conn;
}

MySQL

private static Connection getConn() throws Exception { 
	Class.forName("com.mysql.jdbc.Driver");
	String url = "jdbc:mysql://172.16.16.12:3306/schedule";
	String user = "root";
	String password = "123456";
	Connection conn = DriverManager.getConnection(url, user, password);
	System.out.println("connect MySQL OK,conn: " + conn + "\n");
	return conn; 
}

Oracle

	private static void connOracle() throws Exception {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@172.16.16.13:1521:XE";
			String user = "system";
			String password = "123456"; 
			Connection conn = DriverManager.getConnection(url, user, password);
			System.out.println("connect Oracle OK,conn: " + conn + "\n");
			 
			String sql = "SELECT * FROM system.test_t1";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				System.out.println(rs.getString("c1"));
			}
	} 

 

连接Oracle RAC

String url = "jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=no)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.125.60.12)(PORT=1521)))(CONNECT_DATA= (SERVICE_NAME=DEDICATED)(SERVICE_NAME=dw2)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC))))(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.125.60.11)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.125.60.13)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.125.60.14)(PORT=1521)))(LOAD_BALANCE=yes)(CONNECT_DATA= (SERVICE_NAME=DEDICATED)(SERVICE_NAME=dw134)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)))))";