Spring Data JPA+kkpager实现分页功能

约定不等于承诺〃 2022-06-13 21:14 301阅读 0赞

**一、Spring Data JPA分页**

分页效果如下:

![20170611173452757][]

前台表格用的是: Bootstrap

分页插件用的是: kkpager

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

项目结构:

![20170611173826638][]

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">
        
        <title>Spring Data JPA分页示例</title>
    
        
        <link href="${ctx}/css/bootstrap.min.css" rel="stylesheet">
        
        
        <script src="${ctx}/js/jquery-1.10.2.min.js"></script>
        
       
        
        <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" />
      </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="#">编辑</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>

完整示例: [ http://download.csdn.net/detail/u011781521/9867328][http_download.csdn.net_detail_u011781521_9867328]

[20170611173452757]: /images/20220614/878c628f2db949b1b7ee239340b3e7a8.png
[https_github.com_pgkk_kkpager]: https://github.com/pgkk/kkpager
[20170611173826638]: /images/20220614/ccde7708857c4f2d9e6c895b7d8a270d.png
[http_download.csdn.net_detail_u011781521_9867328]: http://download.csdn.net/detail/u011781521/9867328