ssm分页+搜索

构建pageInfo分页类，定义相关属性

重写findAll,实现模糊查找方法

select * from tb_user where username like concat("%",#{username},"%") limit #{start},5

@Override
public PageInfo findAll(int currentPage, String username) {
PageInfo pageInfo = new PageInfo<>();
pageInfo.setSize(5);
//tc为查询数据的总行数
int tc = userDao.getTotalCount(username);
pageInfo.setTotalCount(tc);
//tp为总行数
int tp = (int)Math.ceil(tc/5.0);
pageInfo.setTotalPage(tp);
//翻页判断
if (currentPage<1){
pageInfo.setCurrentPage(1);
}else if (currentPage>tp){
pageInfo.setCurrentPage(tp);
}else {
pageInfo.setCurrentPage(currentPage);
}
//0,5,10,15…
int start = (pageInfo.getCurrentPage()-1)*5;
List userList = userDao.findAll(start, username);
pageInfo.setList(userList);
return pageInfo;
}

在controller层注册新的findAll方法

@RequestMapping("/findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue = “1”)int currentPage, String username,
@RequestParam(defaultValue = “0”)int type, HttpSession session){
if (type==1){
session.setAttribute(“searchName”,username);
}else {
username=(String) session.getAttribute(“searchName”);
}
PageInfo pageInfo = userService.findAll(currentPage, username);
ModelAndView mv = new ModelAndView();
mv.addObject(“pageInfo”,pageInfo);
mv.setViewName(“user-list”);
return mv;
}

实现获取信息总条数方法，添加接口

select count(*) from tb_user where username like concat("%",#{username},"%")

3.在user-list界面添加上下页跳转功能

• 首页
• 上一页
• 下一页
• 尾页