jdbc连接orcle数据库_java Jdbc连接oracle数据库连接测试

java  Jdbc连接数据库连接测试

实际环境中发现java连接有问题，写一测试用例，用于测试，内容如下：

Redhat java  Jdbc连接数据库连接测试

vi   test.java

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.Date;

import java.text.SimpleDateFormat;

public class test {

public static void main(String arg[]) {

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式

int x = 1;

Date datestr = new Date();

String now_str = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(datestr);

Date d1 = new Date();

String now_str1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(d1);

Date d2 = new Date();

String now_str2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(d2);

while( x < 20 ) {

try {

d1 = new Date();

now_str1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(d1);

System.out.println("第"+x+"次连接数据库，开始连接数据数据库时间点："+now_str1 );

x++;

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

String url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.93.15)(PORT = 1523))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.94.15)(PORT = 1523))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.95.17)(PORT = 1523))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =ljg)))";

Connection conn = DriverManager.getConnection(url,"ljg","ljg");

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select utl_inaddr.get_host_address from dual");

while(rs.next()) {

System.out.println("数据库ip地址为："+rs.getString(1));

}

d2 = new Date();

now_str2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(d2);

System.out.println("        连接数据库，连接到数据数据库时间点："+now_str2);

long diff = d2.getTime() - d1.getTime();

long days = diff / (1000 * 60 * 60 * 24);

System.out.println("连接数据时长为：                                "+diff/1000+"秒");

System.out.println("连接数据时长为：                                "+days+"天");

conn.close();//关闭数据库

}catch(Exception e) {

System.out.println(e.toString());

}

}

}

}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24179204/viewspace-2126920/，如需转载，请注明出处，否则将追究法律责任。