ssm框架做模糊查询和分页

模糊查询

效果图如下

以下代码可以让模糊查询时查询出来的数据分页有效
包结构和文件如下图

UserController中代码更改如下

@Controller
public class UserController {

    @Autowired
    private IUserService userService;

    @RequestMapping("findAll.do")
    public ModelAndView findAll(@RequestParam(defaultValue="1") int pageNum, @RequestParam(defaultValue="5")int size,
                                String searchname, HttpSession session){
        ModelAndView modelAndView=new ModelAndView();
        if (searchname!=null){
            session.setAttribute("searchname",searchname);
        } else {
            searchname= (String) session.getAttribute("searchname");
        }
        List<User> users=userService.findAll(pageNum, size,searchname);
        PageInfo<User> pageInfo=new PageInfo<>(users);
        modelAndView.setViewName("allUser.jsp");
        modelAndView.addObject("pageInfo",pageInfo);
        return modelAndView;
    }

    @RequestMapping("/login.do")
    public String login(User user,HttpSession session){
        Boolean flag=userService.login(user.getUsername(),user.getPassword());
        if (flag){
            session.setAttribute("username",user.getUsername());
            return "redirect:/findAll.do";
        }else {
            return "fail.jsp";
        }
    }

    @RequestMapping("/delete.do")
    public String deleteById(int id){
        userService.deleteById(id);
        return "redirect:/findAll.do";
    }

    @RequestMapping("/add.do")
    public String add(User user){
        userService.add(user);
        return "redirect:/findAll.do";
    }


    @RequestMapping("/toupdate.do")
    public ModelAndView toupdate(int id){
        User user=userService.selectById(id);
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.addObject("user",user);
        modelAndView.setViewName("UpdateUser.jsp");
        return modelAndView;
    }

    @RequestMapping("/update.do")
    public String update(User user){
        userService.update(user);
        return "redirect:/findAll.do";
    }

}

IUserDao中代码更改如下

p