public List<BoardVO> new_list(BoardVO b) throws Exception;// main 최신글 목록
BoardDAOImpl
@Override
public List<BoardVO> new_list(BoardVO b) throws Exception {
return sqlSession.selectList(namespace+".new_list", b);
}
BoardService
public List<BoardVO> new_list(BoardVO b) throws Exception;// main 최신글 목록
BoardServiceImpl
@Override
public List<BoardVO> new_list(BoardVO b) throws Exception {
return dao.new_list(b);
}
BoardMapper
<select id="new_list" resultType="BoardVO">
<![CDATA[
select * from board where id=#{id} and not tab='v' order by regdate desc limit 0,4;
]]>
</select>
BoardController
@GetMapping("/main")
public void mainGET(Model model, BoardVO b) throws Exception {
//logger.info("main start====");
model.addAttribute("new_list", service.new_list(b));
}
