[Spring] 게시판 만들기 : 최신글

1) BoardService.java

    public ArrayList<HashMap<String, Object>> getBoardList() {
 
        ArrayList<HashMap<String, Object>> dataList = new ArrayList<HashMap<String, Object>>();
 
        ArrayList<BoardVo> boardVoList = boardSQLMapper.getBoardList(); // SELECT * FROM FP_Board ORDER BY board_no DESC
 
        for (BoardVo boardVo : boardVoList) {
 
            int userNo = boardVo.getUser_no(); // 작성자 번호...
            UserVo userVo = userSQLMapper.getUserByNo(userNo); // SELECT * FROM FP_MEMBER WHERE member_no = #{no}
 
            HashMap<String, Object> map = new HashMap<String, Object>();
            map.put("userVo", userVo);
            map.put("boardVo", boardVo);
 
            // 현재 글이...지금시간 -3 시간 보다 클때...
            Date writeDate = boardVo.getBoard_writedate();
            long writeTime = writeDate.getTime();
 
            long currentTime = System.currentTimeMillis();
            long targetTime = currentTime - 1000 * 60 * 60 * 3;
 
            if (writeTime > targetTime) {
                map.put("newKeyword", true);
            }
 
            dataList.add(map);
        }
 
        return dataList;
 
    }

 

2) BoardSQLMapper.xml

    <select id="getBoardList" resultType="com.spring.example.vo.BoardVo">
        SELECT * FROM EXAMPLE_BOARD ORDER BY board_writedate DESC
    </select>

 

3) 실행결과