laypage+SpringMVC實現(xiàn)后端分頁

<div id="log-list"></div>
<div id="page-list"></div>

function paging(curr){
 $.getJSON('/page', {
 page: curr || 1 //向服務端傳的參數(shù)
 }, function(res){
 //此處

/**
 * 功能描述：返回無查詢條件查詢分頁數(shù)據(jù)
 * @param page
 * @return
 * @since 
 */
 @RequestMapping(value="/page")
 @ResponseBody
 public List<SubmitLog> getPage(Integer page){
 if(page == null){
 page = 1;
 }
 List<SubmitLog> submitLogList = new ArrayList<>();
 submitLogList = logService.getAllLog(page);
 return submitLogList;
 }

/**
 * 功能描述 :無查詢條件分頁
 * @param pageCurr
 * @return
 * @since 
 */
 public List<SubmitLog> getAllLog(int pageCurr){
 int pageSize = 10;//每頁顯示十條數(shù)據(jù)
 int pageStart = (pageCurr - 1) * pageSize;// limit=(pageCurr -1)*10,10

 List<SubmitLog> submitLogList = new ArrayList<>();
 submitLogList = logMapper.getAllLog(pageSize, pageStart);
 //計算前端頁面顯示的頁數(shù)
// 當前數(shù)據(jù)庫記錄數(shù)
 int count = submitLogList.get(0).getPageTotal();
 int page = count%pageSize == 0 ? count/pageSize : count/pageSize + 1;
 log.debug("頁數(shù)"+page);
 submitLogList.get(0).setPageTotal(page);
 return submitLogList;
 }

/**
 * 功能描述：查詢所有數(shù)據(jù)--帶分頁
 * @param pageSize 每頁大小
 * @param pageCurr 即將顯示當前頁
 * @return
 * @since 
 */
 @Select("SELECT s.pageTotal,number_id,staff_name,create_time,weekly_id,operation FROM submit_log,"
 + "(SELECT count(1) AS pageTotal FROM submit_log) s ORDER BY number_id DESC LIMIT #{pageStart},#{pageSize}")
 @Results({
 @Result(column="number_id",property="numberId"),
 @Result(column="staff_name",property="staffName"),
 @Result(column="create_time",property="createTime"),
 @Result(column="weekly_id",property="weeklyId")
 })
 List<SubmitLog> getAllLog(@Param("pageSize") int pageSize,@Param("pageStart") int pageStart );

//此處是顯示數(shù)據(jù)的具體HTML代碼
<div id="page-list"></div> //分頁顯示的位置

function paging(){
 $.getJSON('/weekly-page-count',{},function(res){
 //整頁刷新
 laypage({
 cont: 'page-list',
 pages: res, //可以叫服務端把總頁數(shù)放在某一個隱藏域，再獲取。假設我們獲取到的是18
 curr: function(){ //通過url獲取當前頁，也可以同上（pages）方式獲取
 var page = location.search.match(/page=(\d+)/);
 return page ? page[1] : 1;
 }(), 
 skip: true,
 jump: function(e, first){ //觸發(fā)分頁后的回調(diào)
 if(!first){ //一定要加此判斷，否則初始時會無限刷新
 location.href = '?page='+e.curr;
 }
 }
 });
 });
 }
 paging();

/**
 * 功能描述：返回無查詢條件查詢分頁數(shù)--用戶
 * @param page
 * @return
 * @since 
 */
 @RequestMapping(value="/weekly-page-count")
 @ResponseBody
 public Integer getPage1(Integer userId){
 Integer count = weeklyService.getPageCount(userId);
 return count;
 }

/**
 * 功能描述：總頁數(shù)
 * @param userId
 * @return
 * @since 
 */
 public Integer getPageCount(Integer userId){
 int count = 0;
 count = weeklyMapper.getPageCount(userId);

 int pageSize = 5; //每頁顯示條數(shù)
 int page = count%pageSize == 0 ? count/pageSize : count/pageSize + 1; //計算頁數(shù)
 return page;
 }

/**
 * 功能描述：無條件查詢記錄條數(shù)==分頁總數(shù)
 * @param userId
 * @return
 * @since 
 */
 @Select("SELECT count(1) AS pageTotal FROM weekly WHERE user_id = #{userId}")
 Integer getPageCount(@Param("userId") Integer userId);