Spring 게시판 페이지

맵퍼

<select id="selectByLecIdwithRownums" parameterType="map"

resultType="databoardvo">

select databoard_id, databoard_title,

databoard_regid,databoard_content,databoard_filename, databoard_uploaddate, lecture_id,

databoard_regname,category

from

(

select rownum rn, ln.*

from

(select *

from databoard

where lecture_id=#{lecture_id}

order by databoard_id desc) ln

)

where rn between #{start_row} and #{finish_row}

order by databoard_id desc

</select>

컨트롤러

@RequestMapping(value = "databoard.do", method = RequestMethod.GET)

public ModelAndView dataBoard(HttpServletRequest request,

HttpSession session) {

ModelAndView mv = new ModelAndView();

int start_row = Integer.parseInt(request.getParameter("start_row"));

int finish_row = Integer.parseInt(request.getParameter("finish_row"));

int nowpage = Integer.parseInt(request.getParameter("nowpage"));

LectureVO lecture = (LectureVO) session.getAttribute("lecture");

int lecture_id = 0;

lecture_id = lecture.getLecture_id();

System.out.println(lecture_id);

System.out.println(start_row + "~~~~" + finish_row + "~~~~"

+ lecture_id);

ArrayList<DataBoardVO> datalist = dataBoardService

.selectByLecIdwithRownums(lecture_id, start_row, finish_row);

// System.out.println(dataBoardService.selectByLecId(lecture_id));

for (DataBoardVO aa : datalist) {

System.out.println(aa);

}

// 게시글 총합 구하기

int boardcount = dataBoardService.countBoardByLecId(lecture_id);

mv.addObject("databoardtotal", boardcount);

mv.addObject("datalist", datalist);

mv.addObject("nowpage", nowpage);

mv.setViewName("lecture/dataBoard");

return mv;

}

JSP

  <c:set var="previous" value=""></c:set>

<c:set var="next" value=""></c:set>

<c:set var="pid" value='id="previous"'></c:set>

<c:set var="nid" value='id="next"'></c:set>

<c:set var="pages" value="${databoardtotal/10}"></c:set>

<c:if test="${nowpage<=1}">

<c:set var="previous" value='class="disabled"'></c:set>

<c:set var="pid" value=""></c:set>

</c:if>

<c:if test="${pages<nowpage}">

<c:set var="next" value='class="disabled"'></c:set>

<c:set var="nid" value=""></c:set>

</c:if>

<div class="row">

<ul class="pager">

<li ${previous }><a ${pid } >Previous</a></li>

<li>${nowpage}</li>

<li ${next }><a ${nid } >Next</a></li>

</ul>

</div>

   

 

<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->

<script

src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

  <script type="text/javascript">

var nowpage =${nowpage};

var start_row ;

var finish_row ;

$(document).ready(function() {

$("#previous").on("click", function() {

--nowpage;

start_row = nowpage * 10 - 9;

finish_row = nowpage * 10;

loadtabpage('databoard.do?start_row='+start_row+'&finish_row='+finish_row+'&nowpage='+nowpage);

});

$("#next").on("click", function() {

++nowpage;

start_row = nowpage * 10 - 9;

finish_row = nowpage * 10;

loadtabpage('databoard.do?start_row='+start_row+'&finish_row='+finish_row+'&nowpage='+nowpage);

});

});

</script>