SpringData JPA实现查询分页demo

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>

<ul class="pagination pagination-lg" id="link">

</ul><br>

</body>

</html>

最终结果如下：

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

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

SpringData JPA实现查询分页demo

相关文章

快网idc优惠网

相关文章

微信

快网idc优惠网

QQ交流群