Oracle 多个连接池

来源:互联网 发布:数据库存储多个坐标 编辑:程序博客网 时间:2024/05/01 04:12
String userid = "system";String password = "ABCabc123";String tnsnames_info = "(DESCRIPTION=(ADDRESS_LIST="+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.15)(PORT=1521))"+ "(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.16)(PORT=1521))"+ "(LOAD_BALANCE=yes)(FAILOVER=on))"+ "(CONNECT_DATA=(SERVICE_NAME=orcl)))";String url = "jdbc:oracle:thin:@" + tnsnames_info;DriverManager.registerDriver(new oracle.jdbc.OracleDriver());Connection dbConnection = DriverManager.getConnection(url, userid,password);Statement stmt = dbConnection.createStatement();ResultSet rset = stmt.executeQuery(" select instance_name from v$instance");while (rset.next()){System.out.println(rset.getString(1));}

0 0
原创粉丝点击