BORARDDAO

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 sun.jdbc.odbc.ee.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 ex){
   System.out.println("DB 연결 실패 : " + ex);
   return;
  }
 }

 //글의 개수 구하기.
 public int getListCount(){
  int x = 0;
  
  try {
   pstmt = con.prepareStatement("select count(*) from board");
   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;
 }
 
 
 //글 목록 보기.
 public List getBoardList(int page, int limit){
  String board_list_sql="select * from " +
  "(select rownum rnum, BOARD_FILE, BOARD_RE_REF, BOARD_RE_LEV,"+
  "BOARD_RE_SEQ, BOARD_READCOUNT, BOARD_DATE from " +
  "(select * from board order by BOARD_RE_REF desc,BOARD_RE_SEQ asc))" +
  "where rnum >=? and rnum<= ? ";
  
 List list = new ArrayList();
 
 int startrow = (page-1)*10+1; //읽기 시작할 row번호.
 int endrow = startrow+limit-1; //읽을 마지막 row 번호.
 
 try {
  pstmt = con.prepareStatement(board_list_sql);

 pstmt.setInt(1, startrow);
 pstmt.setInt(2, endrow);
 rs = pstmt.executeQuery();
 
 while(rs.next()){
  BoardBean board = new BoardBean();
  board.setBOARD_NUM(rs.getInt("BOARD_NUM"));
  board.setBOARD_NAME(rs.getString("BOARD_NAME"));
  board.setBOARD_SUBJECT(rs.getString("BOARD_SUBJECT")); 
  board.setBOARD_CONTENT(rs.getString("BOARD_CONTENT"));
  board.setBOARD_FILE(rs.getString("BOARD_FILE"));
  board.setBOARD_REF(rs.getInt("BOARD_REF"));
  board.setBOARD_RE_LEV(rs.getInt("BOARD_RE_LEV"));
  board.setBOARD_READCOUNT(rs.getInt("BOARD_READCOUNT"));
  board.setBOARD_DATE(rs.getDate("BOARD_DATE"));
  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{pstmt.close();}catch(SQLException e){}
   
  }
  return list;
 }
 
}