个人中心
gpt4 book ai didi

SpringData JPA实现查询分页demo

转载 作者：qq735679552 更新时间：2022-09-29 22:32:09 25 4
gpt4 key购买 nike

CFSDN坚持开源创造价值，我们致力于搭建一个资源共享平台，让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章SpringData JPA实现查询分页demo由作者收集整理，如果你对这篇文章有兴趣，记得点赞哟.

SpringData JPA 的 PagingAndSortingRepository接口已经提供了对分页的支持，查询的时候我们只需要传入一个 org.springframework.data.domain.Pageable 。

接口的实现类,指定PageNumber和pageSize即可 。

springData包中的 PageRequest类已经实现了Pageable接口，我们可以直接使用下边是部分代码:

DAO:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
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提供的分页组件:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<%@ 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

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持我.

原文链接：http://www.cnblogs.com/jiaoyiping/p/4189114.html 。

最后此篇关于SpringData JPA实现查询分页demo的文章就讲到这里了,如果你想了解更多关于SpringData JPA实现查询分页demo的内容请搜索CFSDN的文章或继续浏览相关文章，希望大家以后支持我的博客！ 。

25 4 0
文章推荐： java 中堆内存和栈内存理解
文章推荐： centos6使用docker部署zookeeper操作示例
文章推荐： Mybatis增删改查mapper文件写法详解
文章推荐： centos6使用docker部署redis主从数据库操作示例
qq735679552
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com