Spring Data JPA+kkpager实现分页功能实例

package com.fendo.entity;  import java.io.Serializable; import java.util.Date;  import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table;  import org.hibernate.annotations.GenericGenerator;    @Entity @Table(name="FAMILY_MEMBER") public class FamilyMember implements Serializable{    private Integer id;   private String FamilyName;   private String FamilyCharge;   private String Mobile;   private String Email;   private String Address;   private Date CreateData;      @Id   @GeneratedValue(strategy=GenerationType.IDENTITY)   public Integer getId() {     return id;   }   public void setId(Integer id) {     this.id = id;   }         @Column(name="FAMILY_NAME")   public String getFamilyName() {     return FamilyName;   }   public void setFamilyName(String familyName) {     FamilyName = familyName;   }      @Column(name="FAMILY_CHARGE")   public String getFamilyCharge() {     return FamilyCharge;   }   public void setFamilyCharge(String familyCharge) {     FamilyCharge = familyCharge;   }      @Column(name="MOBILE")   public String getMobile() {     return Mobile;   }   public void setMobile(String mobile) {     Mobile = mobile;   }         @Column(name="EMAIL")   public String getEmail() {     return Email;   }   public void setEmail(String email) {     Email = email;   }      @Column(name="ADDRESS")   public String getAddress() {     return Address;   }   public void setAddress(String address) {     Address = address;   }      @Column(name="CREATE_DATA")   public Date getCreateData() {     return CreateData;   }   public void setCreateData(Date createData) {     CreateData = createData;   }   public FamilyMember() {     super();     // TODO Auto-generated constructor stub   }   public FamilyMember(Integer id, String familyName, String familyCharge, String mobile, String email, String address,       Date createData) {     super();     this.id = id;     FamilyName = familyName;     FamilyCharge = familyCharge;     Mobile = mobile;     Email = email;     Address = address;     CreateData = createData;   }     } 

package com.fendo.dao;  import java.util.List; import java.util.Map;  import org.springframework.data.jpa.repository.JpaSpecificationExecutor; import org.springframework.data.repository.PagingAndSortingRepository;  import com.fendo.entity.FamilyMember;  public interface FamilyDao extends PagingAndSortingRepository<FamilyMember, String>, JpaSpecificationExecutor<FamilyMember>{   } 

package com.fendo.service;  import java.util.List; import java.util.Map;  import com.fendo.entity.FamilyMember;  public interface FamilyService {      public List<FamilyMember> getAll() throws Exception;      public FamilyMember save(FamilyMember familyMember) throws Exception;      public Map<String, Object> getUserBySearch(Map<String, String> familyArgs, final String sortType) throws Exception;  } 

package com.fendo.service.imp;  import java.util.ArrayList; import java.util.List; import java.util.Map;  import javax.persistence.criteria.CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery;  import org.apache.commons.lang.StringUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.domain.Specification;  import javax.persistence.criteria.Predicate; import javax.persistence.criteria.Root; import javax.transaction.Transactional;  import org.springframework.stereotype.Service;  import com.fendo.dao.FamilyDao; import com.fendo.entity.FamilyMember; import com.fendo.service.FamilyService; import com.fendo.util.PageUtils;  @Service @Transactional public class FamilyServiceImp implements FamilyService{    @Autowired   public FamilyDao familyDao;        @Override   public List<FamilyMember> getAll() throws Exception {     return (List<FamilyMember>) this.familyDao.findAll();   }    @Override   public FamilyMember save(FamilyMember familyMember) throws Exception {     return familyDao.save(familyMember);   }    /**    * 查询用户信息列表(支持分页和多条件查询)。    *     */   @Override   public Map<String, Object> getUserBySearch(Map<String, String> familyArgs, final String sortType) throws Exception {      // 获得分页对象pageable，并且在pageable中页码是从0开始，设定按照sortType升序排列     Pageable pageable = PageUtils.buildPageRequest(Integer.valueOf(familyArgs.get("pageNum")),         Integer.valueOf(familyArgs.get("pageSize")), sortType);     Page<FamilyMember> objPage = familyDao.findAll(new Specification<FamilyMember>() {        public Predicate toPredicate(Root<FamilyMember> root, CriteriaQuery<?> query, CriteriaBuilder cb) {         List<Predicate> lstPredicates = new ArrayList<Predicate>();          if (StringUtils.isNotBlank(familyArgs.get("FamilyName"))) {           lstPredicates.add(cb.like(root.get("familyName").as(String.class), "%" + familyArgs.get("FamilyName") + "%"));         }         if (StringUtils.isNotBlank(familyArgs.get("Mobile"))) {           lstPredicates.add(cb.like(root.get("mobile").as(String.class), "%" + familyArgs.get("Mobile") + "%"));         }                  Predicate[] arrayPredicates = new Predicate[lstPredicates.size()];         return cb.and(lstPredicates.toArray(arrayPredicates));       }     }, pageable);      return PageUtils.getPageMap(objPage);   }  } 

package com.fendo.util;  import java.util.HashMap; import java.util.Map;  import javax.servlet.http.HttpServletRequest;  /**  * 工具类  * @author fendo  *  */ public class FamilyUtil {    /**    * 封装从前台传递过来的查询参数。    *     */   public static Map<String, String> getSelArgsToMap(HttpServletRequest request) throws Exception {     Map<String, String> serArgs = new HashMap<String, String>();      String FamilyName = request.getParameter("FamilyName");     String Mobile = request.getParameter("Mobile");           String pageNum = request.getParameter("pageNum") == null ? "1" : request.getParameter("pageNum");     String pageSize = request.getParameter("pageSize") == null ? "10" : request.getParameter("pageSize");      serArgs.put("FamilyName", FamilyName);     serArgs.put("Mobile", Mobile);          serArgs.put("pageNum", pageNum);     serArgs.put("pageSize", pageSize);      return serArgs;   }  } 

package com.fendo.util;  import java.util.HashMap; import java.util.Map;  import org.apache.commons.lang3.StringUtils; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Sort; import org.springframework.data.domain.Sort.Direction;  public class PageUtils {    /**    * 封装分页数据到Map中。    */   public static Map<String, Object> getPageMap(Page<?> objPage) {          Map<String, Object> resultMap = new HashMap<String, Object>();      resultMap.put("resultList", objPage.getContent()); // 数据集合     resultMap.put("totalNum", objPage.getTotalElements()); // 总记录数     resultMap.put("totalPage", objPage.getTotalPages()); // 总页数     resultMap.put("pageNum", objPage.getNumber()); // 当前页码     resultMap.put("pageSize", objPage.getSize()); // 每页显示数量      return resultMap;   }    /**    * 创建分页请求。    *    * @param pageNum 当前页    * @param pageSize 每页条数    * @param sortType 排序字段    * @param direction 排序方向    */   public static PageRequest buildPageRequest(int pageNum, int pageSize, String sortType, String direction) {     Sort sort = null;          if (!StringUtils.isNotBlank(sortType)) {       return new PageRequest(pageNum - 1, pageSize);     } else if (StringUtils.isNotBlank(direction)) {       if (Direction.ASC.equals(direction)) {         sort = new Sort(Direction.ASC, sortType);       } else {         sort = new Sort(Direction.DESC, sortType);       }       return new PageRequest(pageNum - 1, pageSize, sort);     } else {       sort = new Sort(Direction.ASC, sortType);       return new PageRequest(pageNum - 1, pageSize, sort);     }   }    /**    * 创建分页请求(该方法可以放到util类中).    */   public static PageRequest buildPageRequest(int pageNum, int pageSize, String sortType) {     return buildPageRequest(pageNum, pageSize, sortType, null);   }      /**    * 创建分页请求    *     * @param pageNum    * @param pageSize    * @param sort    * @return    */   public static PageRequest buildPageRequest(int pageNum, int pageSize, Sort sort) {     return new PageRequest(pageNum - 1, pageSize, sort);   }    /**    * 创建分页请求(该方法可以放到util类中).    */   public static PageRequest buildPageRequest(int pageNum, int pageSize) {     return buildPageRequest(pageNum, pageSize, null, null);   }  } 

package com.fendo.controller;  import java.util.HashMap; import java.util.List; import java.util.Map;  import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;  import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView;  import com.fendo.entity.FamilyMember; import com.fendo.service.imp.FamilyServiceImp; import com.fendo.util.FamilyUtil;  @Controller() @RequestMapping(value="DataTable") public class DataTableController {    @Autowired   public FamilyServiceImp FamilyMember;      @RequestMapping(value="/home_list")   public String home(Model model,HttpServletRequest request,HttpServletResponse response){     Map<String, Object> resultMap = new HashMap<>();     List<FamilyMember> list;     try {       list = FamilyMember.getAll();       // 查询表单或分页保持请求时 请求参数的接收       Map<String, String> serArgs = new HashMap<String, String>();       serArgs = FamilyUtil.getSelArgsToMap(request);//这个类在下面给出       resultMap = FamilyMember.getUserBySearch(serArgs, "CreateData"); //按创建时间排序       model.addAttribute("resultMap",resultMap);     } catch (Exception e) {       e.printStackTrace();     }          return "datatable";   } } 

<%@ page language="java" contentType="text/html; charset=utf-8"   pageEncoding="utf-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <c:set var="ctx" value="${pageContext.request.contextPath}"/> <!DOCTYPE html> <html lang="zh-CN">  <head>   <meta charset="utf-8">   <meta http-equiv="X-UA-Compatible" content="IE=edge">   <meta name="viewport" content="width=device-width, initial-scale=1">   <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->   <title>Spring Data JPA分页示例</title>    <!-- Bootstrap -->   <link href="${ctx}/css/bootstrap.min.css" rel="external nofollow" rel="stylesheet">      <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->   <script src="${ctx}/js/jquery-1.10.2.min.js"></script>         <!-- Include all compiled plugins (below), or include individual files as needed -->   <script src="${ctx}/js/bootstrap.min.js"></script>      <script type="text/javascript" src="${ctx}/js/kkpager.min.js"></script>   <link rel="stylesheet" type="text/css" href="${ctx}/css/kkpager_blue.css" rel="external nofollow" />  </head>  <body>       <div class="container">      <div style="text-align:center">      <h2>Spring Data JPA分页示例</h2>     </div>            <div class="panel panel-primary">           <div class="panel-heading">       <h3 class="panel-title">数据表格</h3>      </div>                  <div class="panel-body" >          <form class="form-inline" id="searchForm" method="post" action="${ctx}/DataTable/home_list">          <div class="row">                    <div class="form-group col-sm-3">       <input type="checkbox" id="inlineCheckbox1" value="option1">       <label>选择所有</label>      </div>             <div class="form-group col-sm-3">       <label>家庭名:</label>       <input type="input" name="FamilyName" id="FamilyName" class="form-control" id="exampleInputName3" placeholder="用户名">      </div>                  <div class="form-group col-sm-3">       <label>手机号:</label>               <input type="input" name="Mobile" id="Mobile" class="form-control" id="exampleInputMobile3" placeholder="手机号"></input>                    </div>            <div class="col-sm-3">       <button type="submit" class="btn btn-primary">搜索</button>       <button type="button" class="btn btn-primary">删除</button>      </div>                   </div>              </form>          <table class="table table-hover" style="margin-top:2px;">    <thead>     <tr>       <th></th>       <th>顺序</th>       <th>家庭名称</th>       <th>家庭Key</th>       <th>负责人</th>       <th>手机号</th>       <th>邮箱</th>       <th>家庭地址</th>       <th>创建时间</th>       <th>状态</th>       <th>操作</th>     </tr>    </thead>    <tbody>                <c:forEach var="lise" items="${resultMap.resultList}" varStatus="status">      <tr>        <td><input type="checkbox" id="inlineCheckbox1" value="option1"></td>        <th scope="row">${status.index+1}</th>        <td>${lise.familyName}</td>        <td>${lise.id}</td>        <td>${lise.familyCharge}</td>        <td>${lise.mobile }</td>        <td>${lise.email}</td>        <td>${lise.address}</td>        <td>${lise.createData}</td>        <td>启用</td>        <td><a href="#" rel="external nofollow" >编辑</a></td>       </tr>         </c:forEach>                     </tbody>   </table>              </div>     </div>          <div style="width:800px;margin:0 auto;">          <div id="kkpager"></div>          </div>           </div>      <script>      var param = "";         $(function() {     var totalPage = "${resultMap.totalPage}";     var totalRecords = "${resultMap.totalNum}";     var pageSize = "${resultMap.pageSize}";      var pageNum = parseInt("${resultMap.pageNum}") + 1;     //初始化分页控件     //有些参数是可选的，比如lang，若不传有默认值     kkpager.init({       pno: pageNum,       //总页码       total: "${resultMap.totalPage}",       //总数据条数       totalRecords: totalRecords,       //链接前部       hrefFormer: '${ctx}/DataTable/home_list',       //链接尾部       hrefLatter: '',       getLink: function(n) {         return getInitParam() + "&pageNum=" + n + "&pageSize=" + pageSize;       },       lang: {         prePageText: '上一页',         nextPageText: '下一页',         totalPageBeforeText: '共',         totalPageAfterText: '页',         totalRecordsAfterText: '条数据',         gopageBeforeText: '转到',         gopageButtonOkText: '确定',         gopageAfterText: '页',         buttonTipBeforeText: '第',         buttonTipAfterText: '页'       }     });     //生成     kkpager.generPageHtml();      $('#mykkpagerselect').val(pageSize);   });         function getInitParam() {     var FamilyName = $('#FamilyName').val();     var Mobile = $('#Mobile').val();      var attr = "?FamilyName=" + encodeURI(encodeURI(FamilyName))          + "&Mobile=" + Mobile;     return "${ctx}/DataTable/home_list" + attr;   }    /**    * 搜索。    */   function search() {     $('#searchForm').submit();   }         </script>   </body> </html>