测试数据库连接状态

while (true) {

long start = System.currentTimeMillis();
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String uud_url = "jdbc:oracle:thin:@xx.xx.xxx.xxx:1521:pubd1";
String uud_user = "xxxxx";
String uud_pwd = "xxxxx";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(uud_url, uud_user, uud_pwd);
stmt = conn.createStatement();
rs = stmt.executeQuery("select sysdate from dual");

} catch (Exception e) {
e.printStackTrace();
} finally {
rs.close();
stmt.close();
conn.close();
}
System.out.println("get oracle conn time>>" + (System.currentTimeMillis() - start

) + " ms");

try{
Thread.sleep(3000);
}catch(Exception e){}
}