oracle客户端和jdbc,Oracle 客户端JDBC联接测试工具

Oracle 客户端JDBC连接测试工具

实现代码

package org.kjcx.liuqing.oracle.tool;

import java.io.BufferedReader;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

/**

*

* @author LiuQing

*ConnDb.isExits(str,function(data){

* var userObj = $(data).encodeJson();

* userObj.name;

*});

*/

public class ConnDb {

public static void isExit(String str) {

if (str != null && ("exit".equalsIgnoreCase(str)

|| "quit".equalsIgnoreCase(str)) ) {

System.exit(0);

}

}

/**

* @param args

* @throws Exception

*/

public static void main(String[] args) throws Exception {

// TODO Auto-generated method stub

while (true) {

System.out.print("ip address or Hostname:");

InputStream input = System.in;

InputStreamReader bufInput = new InputStreamReader(input);

BufferedReader bufReader = new BufferedReader(bufInput);

String ipAddress = bufReader.readLine();

isExit(ipAddress);

System.out.print("please enter username:");

String username = bufReader.readLine();

isExit(username);

System.out.println("please enter password:");

String password = bufReader.readLine();

isExit(password);

Connection conn = null;

try {

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

String url = "jdbc:oracle:thin:@" +

ipAddress + ":1521:orcl";

System.out.println("url:"+ url + " username:" + username + " password:" + password);

conn = DriverManager.getConnection(url, username, password);

System.out.println(conn);

if (conn != null) {

System.out.println("Database connection successful!!!!");

}

}

catch (Exception e) {

e.printStackTrace();

}

finally {

if (conn != null) {

try {

conn.close();

}

catch (SQLException e) {

e.printStackTrace();

}

}

}

}

}

}