本文实例为大家分享了PageHelper插件实现服务器端分页功能,供大家参考,具体内容如下
一、添加依赖
在.pom文件中添加
com.github.pagehelper
pagehelper
3.5.1
二、添加配置/strong>
在spring-mybaits.xml文件中添加插件
dialect=mysql
reasonable=true
三、controller代码
//分页展示用户
@RequestMapping(value = "/user.do")
public ModelAndView test1(HttpServletRequest request, HttpServletResponse response, ModelMap mode) throws Exception {
ModelAndView modelAndView = new ModelAndView();
int pageNumber = 1;
try{
if(request.getParameter("pageNow").equals(null)){
System.out.println("参数空");
}else {
pageNumber = Integer.parseInt(request.getParameter("pageNow"));
}
}catch (Exception e){
//处理空针错误
}
System.out.println("请求参数"+request.getParameter("pageNow"));
PageInfo pageInfo = userService.selectUserByPage(pageNumber,5);
// Map map = new HashMap();
// List data = new ArrayList();
// for(user admin : pageInfo.getList()){
// Map obj = new HashMap();
// obj.put("id", admin.getId());
// obj.put("username", admin.getUsername());
// obj.put("password", admin.getPassword());
// obj.put("enable", admin.getEnable());
// obj.put("id_card", admin.getIdCard());
// obj.put("phone", admin.getPhone());
// obj.put("address", admin.getAddress());
// obj.put("nick_name", admin.getAddress());
// data.add(obj);
// }
modelAndView.addObject("pageInfo",pageInfo); //jsp 根据users来传递信息
System.out.println("成功啦");
modelAndView.setViewName("/test/user");
return modelAndView;
}
四、Service方法
//分页获取用户信息
public PageInfo selectUserByPage(Integer pageNum, Integer pageSize) {
PageHelper.startPage(pageNum, pageSize);
// 所有用户信息
List authAdmins = userMapper.selectUsers();
if(authAdmins == null){
return null;
}
PageInfo pageInfo = new PageInfo(authAdmins);
return pageInfo;
}
五、jsp显示
Created by IntelliJ IDEA.
User: Administrator
Date: 2017/12/2 0002
Time: 11:10
To change this template use File | Settings | File Templates.
--%>
userUser
${u.id} | ${u.username} | ${u.password} | ${u.enable} | ${u.idCard} | ${u.phone} | ${u.address} | ${u.nickName} |
--%>
${data.username}--%>
${data.password}--%>
--%>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。