91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

SpringData JPA實現查詢分頁demo

發布時間:2020-10-09 06:07:07 來源:腳本之家 閱讀:183 作者:夢中彩虹 欄目:編程語言

SpringData JPA 的 PagingAndSortingRepository接口已經提供了對分頁的支持,查詢的時候我們只需要傳入一個 org.springframework.data.domain.Pageable

接口的實現類,指定PageNumber和pageSize即可

springData包中的 PageRequest類已經實現了Pageable接口,我們可以直接使用下邊是部分代碼:

DAO:

package com.jiaoyiping.jdjy.sourcecode.dao;

import com.jiaoyiping.jdjy.sourcecode.bean.SourceCode;
import org.springframework.data.repository.PagingAndSortingRepository;

/**
 * Created with IntelliJ IDEA.
 * User: 焦一平
 * Date: 14-11-20
 * Time: 下午11:18
 * To change this template use File | Settings | File Templates.
 */
public interface SourceCodeDao extends PagingAndSortingRepository<SourceCode, String> {

}

service:

package com.jiaoyiping.jdjy.sourcecode.service;

import com.jiaoyiping.jdjy.sourcecode.bean.SourceCode;
import com.jiaoyiping.jdjy.sourcecode.dao.SourceCodeDao;
import org.apache.solr.client.solrj.SolrServerException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;

import javax.transaction.Transactional;
import java.io.IOException;
import java.sql.Timestamp;
import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * User: 焦一平
 * Date: 14-11-20
 * Time: 下午11:24
 * To change this template use File | Settings | File Templates.
 */
public class SourceCodeService {
  @Autowired
  private SourceCodeDao sourceCodeDao;public Page<SourceCode> getSourceCode(int pageNumber,int pageSize){
    PageRequest request = this.buildPageRequest(pageNumber,pageSize);
    Page<SourceCode> sourceCodes= this.sourceCodeDao.findAll(request);
    return sourceCodes;
  }
  //構建PageRequest
  private PageRequest buildPageRequest(int pageNumber, int pagzSize) {
    return new PageRequest(pageNumber - 1, pagzSize, null);
  }

}

controller:

package com.jiaoyiping.jdjy.sourcecode.controller;
import com.jiaoyiping.jdjy.sourcecode.Const;
import com.jiaoyiping.jdjy.sourcecode.bean.SourceCode;
import com.jiaoyiping.jdjy.sourcecode.service.SourceCodeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Created with IntelliJ IDEA.
 * User: 焦一平
 * Date: 14-11-20
 * Time: 下午11:22
 * To change this template use File | Settings | File Templates.
 */
@Controller
@RequestMapping(value = "/sourcecode")
public class SourceCodeController {
  @Autowired
  private SourceCodeService sourceCodeService;

  
  @RequestMapping(value = "list")
  public ModelAndView listSourceCode(HttpServletRequest request, HttpServletResponse response){
    String pageNumberStr=request.getParameter("pageNumber");
    if(pageNumberStr==null ||"".equals(pageNumberStr)){
      pageNumberStr="1";
    }
    int pageNumber = Integer.parseInt(pageNumberStr);
    int pageSize = Const.PAGE_SIZE;
    ModelAndView modelAndView = new ModelAndView();
    modelAndView.setViewName("/sourcecode/listSourceCode");
    Page<SourceCode> sourceCodes = this.sourceCodeService.getSourceCode(pageNumber, pageSize);
    modelAndView.addObject("sourceCodeList",sourceCodes.getContent());
    modelAndView.addObject("totalPageNumber",sourceCodes.getTotalElements());
    modelAndView.addObject("pageSize",pageSize);
    return modelAndView;

  }

}

 前端分頁:

前端分頁組件我們使用bootstrap提供的分頁組件:

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%--
 Created by IntelliJ IDEA.
 User: 焦一平
 Date: 2014/12/27
 Time: 9:57
 To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
 String basePath = request.getContextPath();
 String MethodURL=basePath+"/sourcecode/list.action?pageNumber=";
%>
<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="utf-8"/>
 <title>源代碼列表</title>

 <link href="<%=basePath%>/resources/assets/css/bootstrap.min.css" rel="external nofollow" rel="stylesheet"/>
 <script type="text/javascript" src="<%=basePath%>/resources/js/jquery/jquery.js"></script>


 <script type="text/javascript">
  $(document).ready(function(){
   var totalNumber = Number(${totalPageNumber});
   var pageSize = Number(${pageSize});
   var pageCount = totalNumber/pageSize;
   var html = "";
   for(var i = 0;i<pageCount;i++){
    var link_Url = "<li><a href=\"<%=MethodURL%>"+(i+1)+"\">"+(i+1)+"</a></li>";
    html += link_Url;
   }
   var fenyeDiv = document.getElementById("link");
   fenyeDiv.innerHTML=html;
  });
 </script>
</head>
<body>
<a href="#" rel="external nofollow" class="list-group-item active">
 源代碼列表
</a>
  <c:forEach items="${sourceCodeList}" var="sourceCode">
   <a href="<%=request.getContextPath()%>/sourcecode/detail.action?id=<c:out value=" rel="external nofollow" ${sourceCode.id}" />" class="list-group-item"><c:out value="${sourceCode.title}" /></a>
  </c:forEach>
<!-- 列表分頁的DIV,由JS動態填充內容-->
<ul class="pagination pagination-lg" id="link">

</ul><br>

</body>
</html> 

最終結果如下:

SpringData JPA實現查詢分頁demo

以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持億速云。

向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

金阳县| 郸城县| 广西| 汤阴县| 九龙县| 泸溪县| 连江县| 白水县| 胶州市| 文安县| 孟村| 绥棱县| 修武县| 中宁县| 枣强县| 南陵县| 唐河县| 三亚市| 阿克| 阿勒泰市| 北安市| 黑山县| 黄山市| 大田县| 青冈县| 伊春市| 吐鲁番市| 宁陕县| 武胜县| 海阳市| 余姚市| 桐乡市| 镇安县| 响水县| 平乡县| 枣阳市| 峨边| 莱州市| 毕节市| 平乐县| 乌兰县|