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();
}
}
}