Spring Data JPA+kkpager实现分页功能

最新推荐文章于 2024-08-12 08:17:17 发布

码农致富

最新推荐文章于 2024-08-12 08:17:17 发布

阅读量1.5k

点赞数 1

分类专栏： WEB开发

本文链接：https://blog.csdn.net/u011781521/article/details/73050552

版权

WEB开发专栏收录该内容

64 篇文章 2 订阅

订阅专栏

一、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="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" />
  </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