Spring MVC结合Spring Data JPA如何实现按条件查询和分页功能
短信预约 -IT技能 免费直播动态提醒
这篇文章主要为大家展示了“Spring MVC结合Spring Data JPA如何实现按条件查询和分页功能”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“Spring MVC结合Spring Data JPA如何实现按条件查询和分页功能”这篇文章吧。
具体内容如下
后台代码：在DAO层继承Spring Data JPA的PagingAndSortingRepository接口实现的 （实现方法主要在SbglServiceImpl.java类中）
前台表现：用kkpaper表现出来
实现效果：
实体类
package com.jinhetech.yogurt.sbgl.entity;import java.io.Serializable;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.Id;import javax.persistence.PrimaryKeyJoinColumn;import javax.persistence.SequenceGenerator;import javax.persistence.Table;import org.hibernate.annotations.GenericGenerator;import org.springframework.cache.annotation.Cacheable;@Entity@Table(name="SYS_SBGL")@PrimaryKeyJoinColumn(name = "SBBM")@Cacheable(value = "baseCache")public class Sbgl implements Serializable{ private static final long serialVersionUID = -1423899016746755470L; @Id private String sbbm; private String sbmc; private String sblx; private String sssx; private String ssjd; private String azsj; private String azry; private String sbzt; private String sbjd; private String sbwd; private String wxlxr; private String wxlxdh; private String sbywxcs; private String jzpylyz; private String mqsbcyr; private String bzsm; //setter、getter方法省略 }jsp页面，看最下面的分页组件（kkpaper）
resultMap集合是下面Controller中最后查询和分页后获得的所有数据信息，resultMap.resultList：resultList是Map集合的属性，里面存着<key,value>数据
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %><%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %><%@ taglib prefix="shiro" uri="http://shiro.apache.org/tags" %><!doctype html><c:set var="ctx" value="${pageContext.request.contextPath}" scope="session"/><html><head> <title>设备管理</title> <!-- zTree需要的样式和js --> <link rel="stylesheet" href="${ctx }/yogurtResource/assembly/ztree/css/zTreeStyle.css" rel="external nofollow" type="text/css"> <script type="text/javascript" class="lazy" data-src="${ctx }/yogurtResource/assembly/ztree/jquery.ztree.core-3.5.js"></script> <script type="text/javascript" class="lazy" data-src="${ctx }/yogurtResource/assembly/ztree/jquery.ztree.excheck-3.5.js"></script> <!-- 验证框架 --> <script type="text/javascript" class="lazy" data-src="${ctx }/yogurtResource/assembly/yogurt/user/formValidate.js"></script> <!-- 修改表单验证错误提示样式 --> <style type="text/css"> .table-bordered-ul li{ margin:0 5px; float:left} label.error { padding-left: 16px; padding-bottom: 2px; font-weight: bold; color: #F00; } </style> <script type="text/javascript"> function console(consoleTag, userId, stateTag) { // 添加用户。 if("add" == consoleTag) { $('#formid').prop("action", "${ctx}/sbgl/sbgl_add_list"); } } function search() { $('#searchForm').submit(); } </script> </head><body> <div class="clear"> <div class="panel panel-default yogurt_route" id="yogurt_route"> <a href="${ctx }/home/home_list" rel="external nofollow" >首页</a> > <a href="javascript:void(0);" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="navigate();">设备管理</a> > 设备列表 </div> </div> <ul id="bqnum"> <li><a href="javascript:void(0);" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="navigate();">导航</a> </li> <li><a href="javascript:void(0);" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="orgTree();">机构</a> </li> </ul> <!-- 根据条件查询 --> <div class="clear ppd10" > <form action="${ctx }/sbgl/sbgl_list" method="post" id="searchForm"> <div > 设备名称： <input type="text" name="serSbmc" id="serSbmc" > </div> <div class="floatleft"> 设备类型： <input type="text" name="serSblx" id="serSblx" > </div> <div class="floatleft"> 所属市县： <input type="text" name="serSssx" id="serSssx" > </div> <div class="floatleft"> 基地名称： <input type="text" name="serJdmc" id="serJdmc" > </div> <div class="floatleft"> 设备状态： <select class="form-control" name="serSbzt" id="serSbzt"> <option value="">全部</option> <option value="Y">正常</option> <option value="N">异常</option> </select> </div> <button type="submit" class="btn btn-success yogurt_search_button" onclick="search();"> <img class="lazy" data-src="${ctx }/yogurtResource/images/Panel/search.png" width="18" height="18" /> </button> </form> </div> <!-- 新增、删除 --> <div class="panel panel-default" > <div class="yogurt_panel_title_core"> <span class="state_bold">共查询出数据结果：<span class="state_red">${resultMap.totalNum}</span>条</span> </div> <div class="more_core3"> <!-- <button type="button" class="btn btn-success yogurt_search_button2" onclick="console('add','');">新增设备</button> --> <button type="button" class="btn btn-success yogurt_search_button2" onclick="window.location.href='${ctx }/sbgl/sbgl_add_list' ">新增设备</button> <button type="button" class="btn btn-success yogurt_search_button2" onclick="console('delete','');">删除设备</button> </div> </div> <!-- 列表 --> <div class="yogurt_elementsbox_core clear"> <div class="yogurt_elementsbox_table_article" id="yogurt_elementsbox_table_article"> <table id="tableBody" border="0" cellspacing="0" cellpadding="0" class="table yogurt_elementsbox_table"> <thead> <tr class="yogurt_tab_back" onmouseover="this.className='yogurt_tab_trhover'" onmouseout="this.className='yogurt_tab_back'"> <th width="3%"><input type="checkbox" onClick="allchecked(this)"></th> <th width="10%">设备名称</th> <th width="10%">设备类型</th> <th width="10%">所属市县</th> <th width="10%">基地名称</th> <th width="10%">设备状态</th> <th width="10%">维修联系人</th> <th width="10%">联系电话</th> <th width="10%">设备持有人</th> <th width="17%" >操作</th> </tr> </thead> <tbody id="userTb"> <c:forEach var="sbgl" items="${resultMap.resultList}" varStatus="status"> <tr> <td><input type="checkbox" ></td> <td>${sbgl.sbmc }</td> <td>${sbgl.sblx }</td> <td>${sbgl.sssx }</td> <td>${sbgl.ssjd }</td> <td>${sbgl.sbzt }</td> <td>${sbgl.wxlxr }</td> <td>${sbgl.wxlxdh }</td> <td>${sbgl.mqsbcyr }</td> <td > <a href="javascript:void(0);" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="console('update', '${user.userId}')"> 修改</a> <a href="javascript:void(0);" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="showRoles('${user.userId}')">| 查看</a> </td> </tr> </c:forEach> </tbody> </table> </div> </div> <!--分页--> <div > <!--加载分页组件--> <div id="kkpager"></div> <script type="text/javascript"> 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: 'sbgl_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 returnoption(pageSize) { window.location.href = getInitParam() + "&pageNum=1&pageSize=" + pageSize; } function getInitParam() { var serSbmc = $('#serSbmc').val(); var serSblx = $('#serSblx').val(); var serSssx = $('#serSssx').val(); var serJdmc = $('#serJdmc').val(); var serSbzt = $('#serSbzt').val(); var attr = "?serSbmc=" + encodeURI(encodeURI(serSbmc)) + "&serSblx=" + serSblx + "&serSssx=" + serSssx + "&serJdmc=" + serJdmc+ "&serSbzt=" + serSbzt; return "${ctx}/sbgl/sbgl_list" + attr; } </script> <!--分页结束--> </div> <!--分页end--> </body></html>Controller（看红色字体下面那个处理方法）
package com.jinhetech.yogurt.sbgl.controller;import java.util.ArrayList;import java.util.HashMap;import java.util.LinkedHashSet;import java.util.List;import java.util.Map;import java.util.Set;import javax.annotation.Resource;import org.apache.shiro.authz.annotation.RequiresPermissions;import org.apache.shiro.authz.annotation.RequiresRoles;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.ModelAttribute;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.RequestParam;import org.springframework.web.bind.annotation.ResponseBody;import org.springframework.web.servlet.ModelAndView;import org.springframework.web.servlet.mvc.support.RedirectAttributes;import org.springframework.web.servlet.view.RedirectView;import com.jinhetech.yogurt.dictionary.crop.service.impl.CropServiceImpl;import com.jinhetech.yogurt.func.entity.Func;import com.jinhetech.yogurt.func.service.FuncService;import com.jinhetech.yogurt.menu.entity.Menu;import com.jinhetech.yogurt.menu.service.MenuService;import com.jinhetech.yogurt.menu.util.MenuUtil;import com.jinhetech.yogurt.organization.entity.OrgTable;import com.jinhetech.yogurt.organization.service.OrgService;import com.jinhetech.yogurt.organization.util.OrgUtil;import com.jinhetech.yogurt.role.entity.Role;import com.jinhetech.yogurt.role.service.RoleService;import com.jinhetech.yogurt.sbgl.dao.SbglDao;import com.jinhetech.yogurt.sbgl.entity.Sbgl;import com.jinhetech.yogurt.sbgl.service.SbglService;import com.jinhetech.yogurt.sbgl.util.SbglUtil;import com.jinhetech.yogurt.user.entity.User;import com.jinhetech.yogurt.user.entity.UserInfo;import com.jinhetech.yogurt.user.service.UserService;import com.jinhetech.yogurt.user.util.UserUtil;import com.jinhetech.yogurt.util.base.BaseController;import com.jinhetech.yogurt.util.base.Constants;import com.jinhetech.yogurt.util.common.TextUtils;import com.jinhetech.yogurt.util.common.UUIDHexGenerator;@Controller("sbglController")@RequestMapping("/sbgl")public class SbglController extends BaseController {// @Resource(name = "sbglDao")// private SbglDao sbglDao; @Resource(name = "sbglService") private SbglService sbglService; @RequestMapping("/home_list") public ModelAndView home() { return new ModelAndView("iot/permis/permis_home"); } @RequestMapping("sbgl_list") @RequiresRoles("sbgl/sbgl_list") public String getUserList(Model model) throws Exception { //显示设备列表// List<Sbgl> lst=new ArrayList<Sbgl>();// lst=(List<Sbgl>) sbglService.getAll(); Map<String, Object> resultMap = null; // 查询表单或分页保持请求时 请求参数的接收 Map<String, String> serArgs = new HashMap<String, String>(); serArgs = SbglUtil.getSelArgsToMap(request);//这个类在下面给出 resultMap = sbglService.getUserBySearch(serArgs, "wxlxdh"); model.addAttribute("resultMap", resultMap);// model.addAttribute("lst", lst); return "sbgl/sbgl_list"; } @RequestMapping("sbgl_add_list") @RequiresRoles("sbgl/sbgl_add_list") public String getAddList(Model model) throws Exception { System.out.println("aaa"); model.addAttribute("aaa","aaa"); model.addAttribute("resultMap", "hello world"); return "sbgl/sbgl_add_list"; } @RequestMapping("sbgl_save_list") @RequiresRoles("sbgl/sbgl_save_list") public ModelAndView SaveSbgl(Sbgl sbgl) throws Exception { String sbmc=request.getParameter("sbmc"); String sblx=request.getParameter("sblx"); String sssx=request.getParameter("sssx"); String ssjd=request.getParameter("ssjd"); String azsj=request.getParameter("azsj"); String azry=request.getParameter("azry"); String sbzt=request.getParameter("sbzt"); String sbjd=request.getParameter("sbjd"); String sbwd=request.getParameter("sbwd"); String wxlxr=request.getParameter("wxlxr"); String wxlxdh=request.getParameter("wxlxdh"); String sbywxcs=request.getParameter("sbywxcs"); String jzpylyz=request.getParameter("jzpylyz"); String mqsbcyr=request.getParameter("mqsbcyr"); String bzsm=request.getParameter("bzsm"); sbgl.setSbbm(UUIDHexGenerator.generate()); sbgl.setSbmc(sbmc); sbgl.setSblx(sblx); sbgl.setSssx(sssx); sbgl.setSsjd(ssjd); sbgl.setAzsj(azsj); sbgl.setAzry(azry); sbgl.setSbzt(sbzt); sbgl.setSbjd(sbjd); sbgl.setSbwd(sbwd); sbgl.setWxlxr(wxlxr); sbgl.setWxlxdh(wxlxdh); sbgl.setSbywxcs(sbywxcs); sbgl.setJzpylyz(jzpylyz); sbgl.setMqsbcyr(mqsbcyr); sbgl.setBzsm(bzsm); sbglService.save(sbgl); return new ModelAndView(new RedirectView("sbgl_list")); }}2、SbglUtil.java
封装从前台传递过来的查询参数、前台传递过来的分页参数，都放到Map集合serArgs中
package com.jinhetech.yogurt.sbgl.util;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import java.util.Map.Entry;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpSession;import org.springframework.web.context.request.RequestContextHolder;import org.springframework.web.context.request.ServletRequestAttributes;import com.jinhetech.yogurt.organization.entity.OrgTable;import com.jinhetech.yogurt.report.entity.Report;import com.jinhetech.yogurt.role.entity.Role;import com.jinhetech.yogurt.user.entity.User;import com.jinhetech.yogurt.user.entity.UserInfo;import com.jinhetech.yogurt.util.common.JSONUtils;import com.jinhetech.yogurt.util.common.TextUtils;public class SbglUtil { public static Map<String, String> getSelArgsToMap(HttpServletRequest request) throws Exception { Map<String, String> serArgs = new HashMap<String, String>(); String serSbmc = request.getParameter("serSbmc"); String serSblx = request.getParameter("serSblx"); String serSssx = request.getParameter("serSssx"); String serJdmc = request.getParameter("serJdmc"); String serSbzt = request.getParameter("serSbzt"); String pageNum = request.getParameter("pageNum") == null ? "1" : request.getParameter("pageNum"); String pageSize = request.getParameter("pageSize") == null ? "10" : request.getParameter("pageSize"); //serArgs.put("serUserName", java.net.URLDecoder.decode(serUserName == null ? "" : serUserName, "UTF-8")); serArgs.put("serSbmc", serSbmc); serArgs.put("serSblx", serSblx); serArgs.put("serSssx", serSssx); serArgs.put("serJdmc", serJdmc); serArgs.put("serSbzt", serSbzt); serArgs.put("pageNum", pageNum); serArgs.put("pageSize", pageSize); return serArgs; }}3、SbglService.java
package com.jinhetech.yogurt.sbgl.service;import java.util.List;import java.util.Map;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import com.jinhetech.yogurt.sbgl.entity.Sbgl;public interface SbglService { public List<Sbgl> getAll() throws Exception; public Sbgl save(Sbgl sbgl) throws Exception; public Map<String, Object> getUserBySearch(Map<String, String> serArgs, final String sortType) throws Exception; }4、SbglServiceImpl.java (根据前台传递来的查询参数进行查询，获得的结果数据放到Page objPage参数)
package com.jinhetech.yogurt.sbgl.service.impl;import java.util.ArrayList;import java.util.List;import java.util.Map;import javax.annotation.Resource;import javax.persistence.criteria.CriteriaBuilder;import javax.persistence.criteria.CriteriaQuery;import javax.persistence.criteria.JoinType;import javax.persistence.criteria.ListJoin;import javax.persistence.criteria.Predicate;import javax.persistence.criteria.Root;import org.springframework.data.domain.Page;import org.springframework.data.domain.Pageable;import org.springframework.data.jpa.domain.Specification;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import com.jinhetech.yogurt.role.entity.Role;import com.jinhetech.yogurt.sbgl.dao.SbglDao;import com.jinhetech.yogurt.sbgl.entity.Sbgl;import com.jinhetech.yogurt.sbgl.service.SbglService;import com.jinhetech.yogurt.user.entity.UserInfo;import com.jinhetech.yogurt.util.common.PageUtils;import com.jinhetech.yogurt.util.common.TextUtils;@Service("sbglService")@Transactionalpublic class SbglServiceImpl implements SbglService{ @Resource(name = "sbglDao") private SbglDao sbglDao; public List<Sbgl> getAll() throws Exception{ return (List<Sbgl>) this.sbglDao.findAll(); } public Sbgl save(Sbgl sbgl) throws Exception { return sbglDao.save(sbgl); } public Map<String, Object> getUserBySearch(final Map<String, String> serArgs, final String sortType) throws Exception { // 获得分页对象pageable，并且在pageable中页码是从0开始，设定按照sortType升序排列 Pageable pageable = PageUtils.buildPageRequest(Integer.valueOf(serArgs.get("pageNum")), Integer.valueOf(serArgs.get("pageSize")), sortType); Page<Sbgl> objPage = sbglDao.findAll(new Specification<Sbgl>() { public Predicate toPredicate(Root<Sbgl> root, CriteriaQuery<?> query, CriteriaBuilder cb) { List<Predicate> lstPredicates = new ArrayList<Predicate>(); if (TextUtils.isNotBlank(serArgs.get("serSbmc"))) { lstPredicates.add(cb.like(root.get("sbmc").as(String.class), "%" + serArgs.get("serSbmc") + "%")); } if (TextUtils.isNotBlank(serArgs.get("serSblx"))) { lstPredicates.add(cb.like(root.get("sblx").as(String.class), "%" + serArgs.get("serSblx") + "%")); } if (TextUtils.isNotBlank(serArgs.get("serSssx"))) { lstPredicates.add(cb.like(root.get("sssx").as(String.class), "%" + serArgs.get("serSssx") + "%")); } if (TextUtils.isNotBlank(serArgs.get("serJdmc"))) { lstPredicates.add(cb.like(root.get("jdmc").as(String.class), "%" + serArgs.get("serJdmc") + "%")); } if (TextUtils.isNotBlank(serArgs.get("serSbzt"))) { lstPredicates.add(cb.equal(root.get("sbzt"), serArgs.get("serSbzt"))); } Predicate[] arrayPredicates = new Predicate[lstPredicates.size()]; return cb.and(lstPredicates.toArray(arrayPredicates)); } }, pageable); return PageUtils.getPageMap(objPage); } }1、PageUtils.java(分页数据工具类)
package com.jinhetech.yogurt.util.common;import java.util.HashMap;import java.util.Map;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;import com.jinhetech.yogurt.util.base.Constants;public class PageUtils { public static Map<String, Object> getPageMap(Page<?> objPage) { Map<String, Object> resultMap = new HashMap<String, Object>(); resultMap.put(Constants.PAGE_RESULT_LIST, objPage.getContent()); // 数据集合 resultMap.put(Constants.PAGE_TOTAL_NUM, objPage.getTotalElements()); // 总记录数 resultMap.put(Constants.PAGE_TOTAL_PAGE, objPage.getTotalPages()); // 总页数 resultMap.put(Constants.PAGE_NUM, objPage.getNumber()); // 当前页码 resultMap.put(Constants.PAGE_SIZE, objPage.getSize()); // 每页显示数量 return resultMap; } public static PageRequest buildPageRequest(int pageNum, int pageSize, String sortType, String direction) { Sort sort = null; if (!TextUtils.isNotBlank(sortType)) { return new PageRequest(pageNum - 1, pageSize); } else if (TextUtils.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); } } public static PageRequest buildPageRequest(int pageNum, int pageSize, String sortType) { return buildPageRequest(pageNum, pageSize, sortType, null); } public static PageRequest buildPageRequest(int pageNum, int pageSize, Sort sort) { return new PageRequest(pageNum - 1, pageSize, sort); } public static PageRequest buildPageRequest(int pageNum, int pageSize) { return buildPageRequest(pageNum, pageSize, null, null); }}4、DAO（SbglDao.java）,对，只需要继承Spring Data JPA的PagingAndSortingRepository接口，Controller中调用其findAll()方法
package com.jinhetech.yogurt.sbgl.dao;import org.springframework.data.jpa.repository.JpaSpecificationExecutor;import org.springframework.data.repository.CrudRepository;import org.springframework.data.repository.PagingAndSortingRepository;import org.springframework.stereotype.Repository;import com.jinhetech.yogurt.sbgl.entity.Sbgl;import com.jinhetech.yogurt.user.entity.UserInfo;@Repository("sbglDao")public interface SbglDao extends PagingAndSortingRepository<Sbgl, String>, JpaSpecificationExecutor<Sbgl> { }以上是“Spring MVC结合Spring Data JPA如何实现按条件查询和分页功能”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注编程网行业资讯频道！
免责声明：
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
