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; }