¿¡·¯°¡ ¹ß»ýÇÒ °æ¿ì Á¤È®ÇÑ ¿¡·¯ ¸Þ½ÃÁö¸¦ ĸÃÄÇؼ ¿Ã·ÁÁÖ¼Å¾ß Á» ´õ ±ÙÁ¢ÇÑ µµ¿òÀ» µå¸± ¼ö ÀÖ½À´Ï´Ù.
ÆäÀÌÁöµéÀÌ ¼·Î ¿¬°áµÇ¾î Àֱ⠶§¹®¿¡ ÇÑ ÆäÀÌÁöÀÇ ¼Ò½º¸¸À¸·Î´Â ¿øÀÎÀ» ãÀ» ¼ö°¡ ¾ø½À´Ï´Ù. ¿¡·¯¸Þ½ÃÁö´Â Á¦°¡ µµ¿Íµå¸± ¼ö ÀÖ´Â ºÎºÐ¿¡´Â ÇÑ°è°¡ Àֱ⠶§¹®¿¡ Å« µµ¿òÀÌ µÉ ¼ö ¾øÀ» ¼öµµ ÀÖÀ½À» ¾çÁöÇØ Áֽñ⠹ٶø´Ï´Ù.
¿ÀÇö¼® ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
±âº» °Ô½ÃÆÇ v1¹öÁ¯¿¡¼¿©
package com.songdroid.bean.board;
import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Vector;
import javax.naming.InitialContext; import javax.sql.DataSource;
public class BoardDaoImpl implements IBoardDao {
private DataSource ds; private Connection con; private PreparedStatement pstmt; private ResultSet rs;
public BoardDaoImpl(){ try{ ds = (DataSource)new InitialContext().lookup("java:comp/env/jdbc/OracleDB");
} catch(Exception err){ System.out.println("BoardDaoImpl()¿¡¼ ¿À·ù : " + err); } }
public void freeResource(){ if(con != null){ try{ con.close(); } catch(Exception err){} }
if(rs != null){ try{ rs.close(); } catch(Exception err){} }
if(pstmt != null){ try{ pstmt.close(); } catch(Exception err){} } }
@Override public Vector getBoardList(String keyField, String keyWord) { Vector v = new Vector(); String sql = ""; try{ con=ds.getConnection(); if(keyWord == null || keyWord.isEmpty()) {
sql="select * from tblBoard order by desc";
} else{ sql = "select * from tblBoard where " + keyField + " like '%" + keyWord + "%' order by num desc"; }
pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery();
while(rs.next()){ BoardDto dto = new BoardDto(); dto.setContent(rs.getString("content")); dto.setCount(rs.getInt("count")); dto.setDepth(rs.getInt("depth")); dto.setEmail(rs.getString("email")); dto.setHomepage(rs.getString("homepage")); dto.setIp(rs.getString("ip")); dto.setName(rs.getString("name")); dto.setNum(rs.getInt("num")); dto.setPass(rs.getString("pass")); dto.setPos(rs.getInt("pos")); dto.setRegdate(rs.getString("regdate")); dto.setSubject(rs.getString("subject"));
v.add(dto);
}
}
catch(Exception err){ System.out.println("getBoardList() : " + err); } finally{ freeResource(); } return v; }
@Override public void insertBoard(BoardDto dto) { try{ con = ds.getConnection();
String sql = "insert into tblBoard(num, name, email, homepage, subject, content, regdate, pass, count, ip, pos, depth) " + "values(seq_num.nextVal, ?, ?, ?, ?, ?, sysdate, ?, 0, ?, 0, 0)";
pstmt = con.prepareStatement(sql); pstmt.setString(1, dto.getName()); pstmt.setString(2, dto.getEmail()); pstmt.setString(3, dto.getHomepage()); pstmt.setString(4, dto.getSubject()); pstmt.setString(5, dto.getContent()); pstmt.setString(6, dto.getPass()); pstmt.setString(7, dto.getIp());
pstmt.executeUpdate(); } catch(Exception err){ System.out.println("insertBoard() : " + err); } finally{ freeResource(); } } @Override public BoardDto getBoard(int num) { // TODO Auto-generated method stub return null; }
@Override public void updateBoard(BoardDto dto) { // TODO Auto-generated method stub
}
@Override public void deleteBoard(int num) { // TODO Auto-generated method stub
}
@Override public void replyBoard(BoardDto dto) { // TODO Auto-generated method stub
}
}
|