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>
|
最终结果如下:
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。
原文链接:http://www.cnblogs.com/jiaoyiping/p/4189114.html