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

晋西岭

2023-03-14

本文向大家介绍Spring Data JPA+kkpager实现分页功能实例，包括了Spring Data JPA+kkpager实现分页功能实例的使用技巧和注意事项，需要的朋友参考一下

一、spring Data JPA分页

分页效果如下:

前台表格用的是: Bootstrap

分页插件用的是: kkpager

kkpager是一个js分页展示控件，传入简单参数就能使用的分页效果控件,github地址:https://github.com/pgkk/kkpager

项目结构:

FamilyMember实体类:

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; 
  } 
 
   
}

FamilyDao接口类:

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>{ 
 
 
}

FamilyService服务接口类:

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; 
 
}

FamilyService服务接口实现类:

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); 
  } 
 
}

Controller类:

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"; 
  } 
}

首页datatable.jsp

<%@ 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>

完整示例: SpringData-JPA_jb51.rar

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

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

相关阅读

相关文章

相关问答

相关工具

相关文档