日期:2014-05-16 浏览次数:20503 次
实现代码
?
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(); } } } } } }?