jdbc 连接oracle例子,JDBC连接数据库的例子(oracle)

import java.sql.*;

public class Ora8iConnect

{

public Ora8iConnect(String db,String id,String pwd)

{ dbNAME=db;

userID=id;

userPWD=pwd;

beginConnect(); //连接数据库

}

/*-

*返回一个Connection对象

*/

public Connection getConnection(){return conn;}

/*-

*连接数据库，成功后返回1否则返回0

*/

public int beginConnect()

{ try

{ //加载一个Oracle驱动

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

//使用OCI8连接到数据库

conn=DriverManager.getConnection("jdbc:oracle:oci8:@"+dbNAME,userID,userPWD);

return 1;

}

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;

return 0;

}

}

private Connection conn; //连接对象private String dbNAME; //实例private String userID; //用户名private String userPWD; //口令}