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; //口令

}