※ 영어 주의
public int insertBoard(BoardBean board){
int ans=0;
Connection con=null;
PreparedStatement pstmt=null;
String sql="insert into board" +
"(b_no,fid,lev,pos,title,name,content,reg_count,img_name," +
"data_name,data_origin,data_size,user_ip,reg_date)" +
" values(board_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,sysdate)";
try{
con=ds.getConnection();
pstmt=con.prepareStatement(sql);
pstmt.setInt(1, board.getFid());
pstmt.setInt(2, board.getLev());
pstmt.setInt(3, board.getPos());
pstmt.setString(4, board.getTitle());
pstmt.setString(5, board.getName());
pstmt.setString(6, board.getContent());
pstmt.setInt(7, board.getReg_count());
pstmt.setString(8, board.getImg_name());
pstmt.setString(9, board.getData_name());
pstmt.setString(10, board.getData_origin());
pstmt.setInt(11, board.getData_size());
pstmt.setString(12, board.getUser_ip());
ans=pstmt.executeUpdate();
System.out.println("insertBoard 성공"+ans);
}catch(Exception ex){
System.out.println("insertBoard 실패"+ex);
}finally{
try {
if(pstmt!=null)pstmt.close();
if(con!=null)con.close();
} catch (Exception e) {
}
}
return ans;
}
얘 치는게 제일 지겨워요...
손으로 다 짜서 친다는 거, 아...O<-<
최근 덧글