建立oracle数据库链接,oracle数据库建立链接

package db;

import java.sql.Connection;

import java.sql.Driver;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Properties;

import java.util.Vector;

public class OracleConn

{

private final static String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";

protected static Connection dbConnection = null;

public static  boolean openConnection() throws SQLException

{

boolean bSucceed = false;

String strURL = "jdbc:oracle:thin:@10.40.111.20:1521:uep" ;

StringBuffer sbInfo = new StringBuffer(200);

sbInfo.append("openConnection():strDriver=oracle.jdbc.driver.OracleDriver;jdbcUrl=jdbc:oracle:thin:@10.40.111.20:1521:uep;dbuser=system;password=password");

Statement stmt = null;

ResultSet rs = null;

try

{

DriverManager.registerDriver((Driver) Class.forName(JDBC_DRIVER).newInstance());

}

catch(Exception ex)

{

ex.printStackTrace();

}

try

{

//加此调试是为了诊断代码是否停在下面的getConnection那里了。

//dMsg.info("- 0 Try to connect: "+dbInfo.getDBMSKey());

Properties prop = new Properties();

prop.put("user", "system");

prop.put("password", "netnumen");

Driver driver = DriverManager.getDriver(strURL);

DriverManager.setLoginTimeout(60);

dbConnection = driver.connect(strURL, prop);

//使用下面代码容易产生阻塞

//dbConnection = DriverManager.getConnection(strURL,

//                                          this.dbInfo.getUser(),

//                                        this.dbInfo.getPassword());

stmt = dbConnection.createStatement();

rs = stmt.executeQuery("select * from caffm.caf_alarm");

while(rs.next())

{

// Vector vecTablespaceInfo = new Vector(5);

System.out.println("haha");

}

bSucceed = true;

}

catch(SQLException sqlEx)

{

if(dbConnection!=null)

{

dbConnection.close();

}

sqlEx.printStackTrace();

bSucceed = false;

throw sqlEx;

}

catch(Exception ignore)

{

if(dbConnection!=null)

{

dbConnection.close();

}

ignore.printStackTrace();

bSucceed = false;

}

//dMsg.info("- 1 End to connect: "+dbInfo.getDBMSKey());

return bSucceed;

}

public static void main(String[] args)

{

try

{

openConnection();

}

catch(SQLException e)

{

e.printStackTrace();

}

System.out.println("ok");

}

}