±âº» °Ô½ÃÆÇ 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
}
}
|