JDBC 연동 커넥터 파일을

Eclips에 추가 한후


DBControl dbcon = new DBCOntrol();
테스트 해볼 수 있다.


import java.sql.*;

public class DBControl {
 private String DB_ID="DB_ID";
 private String DB_SID="SID";
 private String DB_PASS="DB_PASSWD";
 private String DB_ADDRESS="IP_ADDRESS";
 private Statement stmt;
 private Connection conn=null;
 private String error_message="";

 public DBControl(){
  try{
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn = DriverManager.getConnection(StringDBControl(),DB_ID,DB_PASS);
   stmt = conn.createStatement();
  }catch(Exception e){
   System.out.println(e.getMessage());
  }
 }
 
 private String StringDBControl(){
  String ConnectionString="jdbc:oracle:thin:@"+DB_ADDRESS+":1521:";
      ConnectionString+=DB_SID;
  return ConnectionString;
 }
 
 //for inser, delete, update
 public Boolean execute(String sql){
  Boolean _is=false;
  try{
   _is=stmt.execute(sql);
  }catch(SQLException e){
   error_message = e.getMessage();
  }
  return _is;
 }
 
 //for select
 public ResultSet executeQuery(String sql){
     ResultSet rs=null;
     try{
   rs = stmt.executeQuery(sql);
  }catch(SQLException e){
   error_message = e.getMessage();
  }
  return rs;
 }
 
 public String getErrorMessage(){
  return error_message;
 }
}