package com.kh.spring.board.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.kh.spring.board.model.service.BoardService;
@Controller
public class BoardController {
@Autowired
private BoardService boardService;
// 메뉴바 클릭 시 => list.bo (기본적으로 1번 페이지 요청)
// 페이징바 클릭 시 => list.bo?cpage=요청하는페이지수
@RequestMapping("list.bo")
public String selectList(@RequestParam(value="cpage") int currentPage) {
System.out.println("cpage: " + currentPage);
// /WEB-INF/views/board/boardListView.jsp
return "board/boardListView";
}
}
📍 현재 쿼리스트링이 없는 경우 400 에러가 뜸!
(쿼리스트링으로 cpage=숫자 값을 붙여 주면 잘 뜸)
💻 defaultValue를 설정한 BoardController
👉🏻 값이 넘어오지 않았다면 대체할 값으로 1을 줌(defaultValue 설정)
👉🏻 url에 default값이 노출되지는 않지만 400 에러가 더 이상 뜨지 않음! (상용 웹사이트도 이런 식으로 디폴트 값을 설정해 줌)
@Controller
public class BoardController {
@Autowired
private BoardService boardService;
// 메뉴바 클릭 시 => list.bo (기본적으로 1번 페이지 요청)
// 페이징바 클릭 시 => list.bo?cpage=요청하는페이지수
@RequestMapping("list.bo")
public String selectList(@RequestParam(value="cpage", defaultValue="1") int currentPage) {
// System.out.println("cpage: " + currentPage);
int listCount = boardService.selectListCount();
// /WEB-INF/views/board/boardListView.jsp
return "board/boardListView";
}
💻 BoardServiceImpl
@Service
public class BoardServiceImpl implements BoardService {
@Autowired
private BoardDao boardDao;
@Autowired
private SqlSessionTemplate sqlSession;
@Override
public int selectListCount() {
return boardDao.selectListCount(sqlSession);
}
}
💻 BoardDao
@Repository
public class BoardDao {
public int selectListCount(SqlSessionTemplate sqlSession) {
// 완성된 쿼리문이므로 두 번째 매개변수는 필요 없음
return sqlSession.selectOne("boardMapper.selectListCount");
}
💻 board-mapper.xml
<select id="selectListCount" resultType="_int">
SELECT COUNT(*)
FROM BOARD
WHERE STATUS = 'Y'
</select>
🔥 페이징 처리 - 전체 조회(상단) 코드가 선행되어야 함 🔥
💻 BoardController
package com.kh.spring.board.controller;
import java.util.ArrayList;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import com.kh.spring.board.model.service.BoardService;
import com.kh.spring.board.model.vo.Board;
import com.kh.spring.common.model.vo.PageInfo;
import com.kh.spring.common.template.Pagination;
@Controller
public class BoardController {
@Autowired
private BoardService boardService;
// 메뉴바 클릭 시 => list.bo (기본적으로 1번 페이지 요청)
// 페이징바 클릭 시 => list.bo?cpage=요청하는페이지수
@RequestMapping("list.bo")
public String selectList(@RequestParam(value="cpage", defaultValue="1") int currentPage, Model model) {
// System.out.println("cpage: " + currentPage);
int listCount = boardService.selectListCount();
int pageLimit = 10;
int boardLimit = 5;
PageInfo pi = Pagination.getPageInfo(listCount, currentPage, pageLimit, boardLimit);
ArrayList<Board> list = boardService.selectList(pi);
model.addAttribute("pi", pi);
model.addAttribute("list", list);
// /WEB-INF/views/board/boardListView.jsp
return "board/boardListView";
}
}
💻 BoardServiceImpl
@Override
public ArrayList<Board> selectList(PageInfo pi) {
return boardDao.selectList(sqlSession, pi);
}
💻 BoardDao
public ArrayList<Board> selectList(SqlSessionTemplate sqlSession, PageInfo pi) {
int limit = pi.getBoardLimit();
int offset = (pi.getCurrentPage() - 1) * limit;
RowBounds rowBounds = new RowBounds(offset, limit);
return (ArrayList)sqlSession.selectList("boardMapper.selectList", null, rowBounds);
}
💻 board-mapper.xml
<resultMap id="boardResultSet" type="board">
<result column="BOARD_NO" property="boardNo" />
<result column="BOARD_TITLE" property="boardTitle" />
<result column="BOARD_WRITER" property="boardWriter" />
<result column="COUNT" property="count" />
<result column="CREATE_DATE" property="createDate" />
<result column="ORIGIN_NAME" property="originName" />
</resultMap>
<select id="selectList">
SELECT BOARD_NO
, BOARD_TITLE
, BOARD_WRITER
, COUNT
, TO_CHAR(CREATE_DATE, 'YYYY-MM-DD') AS "CREATE_DATE"
, ORIGIN_NAME
FROM BOARD
WHERE STATUS = 'Y'
ORDER BY BOARD_NO DESC
</select>
