DB Connection

// 일반적인 db 커넥션
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;

public class DBConnection {
 String driver = "oracle.jdbc.driver.OracleDriver";
 String user = ""; // 사용자
 String pw = ""; //password
 String url = "jdbc:oracle:thin:@localhost:1521:xe";
 
 Connection conn = null;
  
 public Connection getConnection(){
  try {
   // Driver Loading..
   Class.forName(driver);
   conn = DriverManager.getConnection(url, user, pw);
   //System.out.println(conn);
  }catch (SQLException se) {
   se.printStackTrace();
  }catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }catch (Exception e){
   e.printStackTrace();
  }
  
  return conn;
 }
 
 public void close(Connection conn){
  try{
   if(conn!=null){
    conn.close();
   }
  }catch(SQLException se){
   se.printStackTrace();
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   this.close(conn);
  }
 } 
}

// Connection pool을 사용하는 방법
import pool.JDCConnectionDriver;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;

public class PollingTest {
 // static 변수로 선언
 static JDCConnectionDriver jdcpool;
  
 public static Connection getConnection(){
  String driver = "oracle.jdbc.driver.OracleDriver";
  String url = "jdbc:oracle:thin:@localhost:1521:xe";
  String user = "";
  String pw = "";
  Connection conn = null;
  
  try{
   Class.forName(driver);
   if(jdcpool==null){
    new JDCConnectionDriver(driver, url, user, pw);
   }
   conn =  DriverManager.getConnection("jdbc:jdc:jdcpool");
  }catch(SQLException se){
   se.printStackTrace();
  }catch(Exception e){
   e.printStackTrace();
  }
  return conn;
 }
 
 public void close(Connection conn){
  try{
   if(conn!=null){
    conn.close();
   }
  }catch(SQLException se){
   se.printStackTrace();
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   this.close(conn);
  }
 }
 
 public static void main(String[] args){
  System.out.println(getConnection());
 }
}