oracle10g集群资源,Java 连接oracle10g 集群

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

public class TestConnection {

private static String username = "easysite";

private static String password = "huilan";

private static Connection conn = null;

private static Statement stmt = null;

private static ResultSet rs = null;

private static PreparedStatement pstat = null;

public static Connection getConn() throws Exception {

Class.forName("oracle.jdbc.driver.OracleDriver");

String url= "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=10.0.2.162)(PROTOCOL=TCP)(PORT=1521))(ADDRESS=(HOST=10.0.2.172)(PROTOCOL=TCP)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=EHOME)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETIRES=20)(DELAY=15))))";

conn = DriverManager.getConnection(url, "easysite", "huilan");

String sql = "select count(*) as total from p_agent";

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

System.out.println("222");

rs.next();

System.out.println(rs.getInt("total"));

return conn;

}

public static void closeConn(){

try {

if (stmt != null) {

stmt.close();

}

if (rs != null) {

rs.close();

}

if (conn != null) {

conn.close();

}

} catch (Exception e) {

e.printStackTrace();

}

}

public static void main(String[] args){

TestConnection t = new TestConnection();

try {

t.getConn();

t.closeConn();

} catch (Exception e) {

e.printStackTrace();

}

}

}