pagehelper PageHelper数据库分页查询与前端layui结合

1.项目配置文件pom.xml介绍如下:

& lt依赖性>。& ltgroupId&gt。com . github . page helper & lt；/groupId&gt。& ltartifactId&gt。pagehelper&lt。/artifactId >& lt版本&gt。4.1.1&lt。/version&gt。& lt/dependency&gt。

2.在2.mybatis-config.xml中配置:

& lt插件&gt。& ltplugin interceptor = " com . github . page helper . PageHelper " >;& lt！-数据库方言->:& lt；property name= "方言" value="mysql" />& ltproperty name = " offsetapagenum " value = " true "/>& lt！-设置为true时，使用RowBounds分页时会进行计数查询，并查询总数->:& lt；property name = " RowBoundsWithCount " value = " true "/>& ltproperty name = " page SiZe zero " value = " true "/>& ltproperty name= "合理" value="true" /&gt。& lt/plugin&gt。& lt/plugins&gt。

3 .服务层:

公共页面信息&lt。产品&gt。getAllSold(整数页码，整数页面大小){ PageHelper.startPage(页码，页面大小)；//在query语句前添加这句话，查询会自动物理分页列表sold list = productmapper。选择全部售出(dict。product old)；PageInfo&lt。产品&gt。页面信息=新页面信息&lt。产品&gt。(SoldList)；返回pageInfo}

4 .控制器:

@ RequestMapping(value = "/")public String GetIndexpage(Model，@RequestParam(value = "pageNum "，required = false) Integer pageNum，@RequestParam(value = "pageSize "，required = false) Integer pageSize，@RequestParam(value = "userId "，required = false)Integer UserID){ if(PageNum = = null | | PageNum . equals(" "){ PageNum = 1；} if(PageSize = = null | | PageSize . equals(" "){ PageSize = Dict . PageSize；//显示的页数}//分页if(httpersvletrequest。getquerystring () = = null) {model。add attribute(" urlffenye "，httpservletrequest。getrequesturi ()+"？);} else { String URL = HttpServletrequest . GetRequesturi()+"？+HttpServletrequest . GetqueryString()；string[]URL = URL . split(" PageNum ")；model . AddAttribute(" urlffenye "，URLs[0])；} PageInfo PageInfo = ProductServiceImp . GetalProductInformBYUSerid(PageNum，pageSize，UserID)；model.addAttribute("infoCount "，page info . GetTotal())；model.addAttribute("pageNum "，PageNum)；model.addAttribute("pageSize "，Dict . PageSize)；model . AddAttribute(" ProducT old "，Dict . ProducT old)；model . AddAttribute(" AllProductList "，PageInfo)；返回“index”；}

5.前端

& ltdiv >& lt/div&gt。& ltsrc = "/js/lay date/lay date . js " & gt。& lt/&gt。& lttype = " text/Java " src = "http://9.com/js/layer/layer . js " & gt。& lt/&gt。& lttype = " text/Java " src = "http://9.com/js/layui/layui . js " & gt。& lt/&gt。& lttype="text/java ">。layui.use('laypage '，function(){ var lay page = layui . lay page；var url = " $ { urlForFenYe！}";//执行laypage实例laypage.render({ elem: 'page' //注意，这里的页面是ID，不带#，计数:${infoCount！}//从服务器获取的总数据，curr:${pageNum！}，限制:${pageSize！}，jump: function (obj，first) {//obj包含当前分页的所有参数，如console . log(obj . curr)；//获取当前页面，以便向服务器请求相应页面的数据。console . log(obj . limit)；//获取每页显示的项数//不要执行if(！first){ var page = obj . curr；var eveyLimit = obj.limit//alert(URL)；URL = URL+" PageNum = "+page+" & amp；page size = "+everylimit；console . log(URL)；//获取每页window.location.href=url显示的文章数；} } });});& lt/&gt。{!-PGC _列- }

版权属于作者

原文:https://my.oschina.net/u/3424784/blog/3000946