try {

//加载一个Oracle驱动

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

//使用OCI8连接到数据库

conn=DriverManager.getConnection("jdbc:oracle:oci8:@DatabaseName"+,"user","password");

}catch(SQLException e) { //捕捉SQL违例

System.out.println("Ora8iConnect在连接oracle8数据库时捕获");

while (e!=null)

{ System.out.println("SQLState:"+e.getSQLState());

System.out.println("Message :"+e.getMessage());

System.out.println("Vendor :"+e.getErrorCode());

e=e.getNextException();

System.out.println(" ");

}

conn=null;

}

try {

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

//orcl为你的数据库的SID

String url="jdbc:oracle:thin:@localhost:1521:orcl";

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

}catch(SQLException e) { //捕捉SQL违例

System.out.println("Ora8iConnect在连接oracle8数据库时捕获");

while (e!=null)

{ System.out.println("SQLState:"+e.getSQLState());

System.out.println("Message :"+e.getMessage());

System.out.println("Vendor :"+e.getErrorCode());

e=e.getNextException();

System.out.println(" ");

}

conn=null;

}