日期:2014-05-16  浏览次数:20503 次

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

	}

}
?