091028 - 요즘 하고 있는 거

 

※ 영어 주의

 





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<-<