mysql 페이징3

Controllertest중

	@Test
	public void testListPaging() throws Exception{
		log.info(mockMvc.perform(MockMvcRequestBuilders.get("/board/list")
				.param("pageNum", "2")
				.param("amount","50"))
				.andReturn().getModelAndView().getModelMap());
	}

 

 

INFO : org.moominzero.controller.BoardController - list: Criteria(pageNum=2, amount=50, skipCount=50)
INFO : org.moominzero.service.BoardServiceImpl - get List with criteria: Criteria(pageNum=2, amount=50, skipCount=50)
INFO : jdbc.sqlonly - select R1.* FROM( SELECT * FROM tbl_board order by bno desc ) R1 LIMIT 50 OFFSET 50 

INFO : jdbc.sqltiming - select R1.* FROM( SELECT * FROM tbl_board order by bno desc ) R1 LIMIT 50 OFFSET 50 
 {executed in 62 msec}
INFO : jdbc.resultsettable - 
|----|------|--------|-------|--------|-----------|
|bno |title |content |writer |regdate |updatedate |
|----|------|--------|-------|--------|-----------|
|----|------|--------|-------|--------|-----------|

테스트결과 아무것도 안뜸..

 

예상 sql문은

limit 50, offset 10 이여야하는데

왜 skipCount가 50이되었을까

 

==>수정

 

offset 50이 맞다.

왜냐면 1page 50 amount까지출력되어야하니까

offset은 50이 맞다!

 

 

this.skipCount = (pageNum -1) * amount;       (2-1)*50; ==> 50

this.skipCount = (pageNum -1) * amount;