BOARDDAO.java

package net.board.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class BoardDAO {

 Connection con;
 PreparedStatement pstmt;
 ResultSet rs;
 
 public BoardDAO(){
  try{
   Context init= new InitialContext();
   DataSource ds =
    (DataSource)init.lookup("java:comp/env/jdbc/OracleDB");
   con = ds.getConnection();
   
  }catch(Exception e){
   System.out.println("DB 연결 실패  : "+ e);
   return;
  }
 }
 
 //글의 개수 구하기.
 public int getListCount(){
  int x=0;
  try {
   pstmt=con.prepareStatement("select count(*) from EMP");
   rs  = pstmt.executeQuery();
   
   if(rs.next()){
    x=rs.getInt(1);
   }
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   System.out.println("getListCount 에러 : "+ e);
  }finally{
   if(rs!=null)try{rs.close();}catch(SQLException ex){}
   if(pstmt!=null)try{pstmt.close();}catch(SQLException ex){}
  }
  return x;
 }
 
 //글목록 보기.
/*
 private int BOARD_NUM;
 private String BOARD_NAME;
 private String BOARD_JOB;
 private String BOARD_MGR;
 private String BOARD_HIREDATE;
 private String BOARD_SAL;
 private String BOARD_COMM;
 private String BOARD_DEPTNO;
*/ 
 public List getBoardList(){
  String board_list_sql="select * from EMP ";
  
  List list = new ArrayList();
  
  try {
   pstmt = con.prepareStatement(board_list_sql);
   rs = pstmt.executeQuery();
   
   
   while(rs.next()){
    BoardBean board = new BoardBean();
    board.setBOARD_NUM(rs.getInt("EMPNO"));
    board.setBOARD_NAME(rs.getString("ENAME"));
    board.setBOARD_JOB(rs.getString("JOB"));
    board.setBOARD_MGR(rs.getInt("MGR"));
    board.setBOARD_HIREDATE(rs.getDate("HIREDATE"));
    board.setBOARD_SAL(rs.getInt("SAL"));
    board.setBOARD_COMM(rs.getInt("COMM"));
    board.setBOARD_DEPTNO(rs.getInt("DEPTNO"));
    list.add(board);
   }
   
   
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   System.out.println("getBoardList 에러 : "+ e);
  }finally{
   if(rs!=null) try{rs.close();}catch(SQLException e){}
   if(pstmt!=null)try{rs.close();}catch(SQLException e){}
  }
  //return null;// --?  컨넥션은? 컨넥션 은 반환안하면 죽을텐대 -_ -
  
  
  return list;
  
 }
}