[JSP] 게시판 조회수 구현

 

jsp 회원등록,수정,삭제,리스트(CRUD) 로직 구현하기 게시판 조회수

    public void boardCnt(int bidx) {            // 게시판 조회수
        int cnt = 0 ;
        int rs = 0;
        
        
        String sql = "update board SET HIT =(HIT+1) where bidx = ?";
        
        try {
            pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, bidx);
            rs = pstmt.executeUpdate();
            
            
            
        } catch (Exception e) {
            e.printStackTrace();
          }
 
    }
    
    

public BoardVo boardSelectOne(int bidx) {
        
        boardCnt(bidx);          // 글작성 조회수 같이 실행해주기.. 같은  bidx 이니   글내용볼때 증가시켜주기 !! 
        
        
        BoardVo bv = null;
        ResultSet rs= null;
        String sql="select * from board where bidx=?";
        
        try {
            pstmt = conn.prepareStatement(sql);   
            pstmt.setInt(1, bidx);
            rs  = pstmt.executeQuery();
            
            if(rs.next()) {  
                 bv = new BoardVo();
                
                bv.setBidx(rs.getInt("bidx"));   
                bv.setOriginbidx(rs.getInt("originbidx"));
                bv.setDepth(rs.getInt("depth"));
                bv.setLevel_(rs.getInt("level_"));
                
                bv.setSubject(rs.getString("subject"));
                bv.setContent(rs.getString("content"));
                bv.setWriter(rs.getString("writer"));
                bv.setWriteday(rs.getString("writeday"));    
                bv.setFilename(rs.getString("filename"));
                bv.setHit(rs.getInt("hit"));
            }            
            
        } catch (SQLException e) {            
            e.printStackTrace();
        } finally {
            
            try {
                rs.close();
                pstmt.close();
                conn.close();
            } catch (SQLException e) {                
                e.printStackTrace();
            }
            
        }    
        
        return bv;
    }