The Sixth------JAVA关于ssm实现模糊查询

The Sixth------JAVA关于ssm实现模糊查询

关键代码

UserMapper.xml文件

<select id="findUserByName" resultType="user">
        select * from tb_user where username like concat('%' #{username} '%') limit #{start},5
    </select>

UserService类

 @Override
    public PageInfo<User> findUserByName(int currentPage, String username) {
        PageInfo<User> pageInfo = new PageInfo<>();
        pageInfo.setSize(5);

        int tc = userDao.getTotalCount();
        pageInfo.setTotalPage(tc);
        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);
        }
        int start = (pageInfo.getCurrentPage()-1)*5;
        List<User> userList = userDao.findUserByName(start,username);
        pageInfo.setList(userList);
        return pageInfo;
    }

IUserService接口

 PageInfo<User> findUserByName(int currentPage, String username);

UserController类

    @RequestMapping("/findUserByName.do")
    public ModelAndView findUserByName(@RequestParam(defaultValue="1") int currentPage,String username){
        PageInfo<User> pageInfo = userService.findUserByName(currentPage,username);
        ModelAndView modelAndView = new ModelAndView();
        modelAndView.addObject("pageInfo",pageInfo);
        modelAndView.setViewName("user-list");
        return modelAndView;
    }