面向Java开发者的复习指南，SSM框架下分页功能的实现，字节跳动Java岗面试题

2.Mapper.xml配置

select *

from users limit #{startPos},#{pageSize}

select count(*) from users

3.mapper接口

/*

• 查询用户记录总数

• */

Long Count();

/*

• 分页操作，调用findByPage limit分页方法

• */

public List selectUserByPage(@Param(value=“startPos”) Integer startPos,

@Param(value=“pageSize”) Integer pageSize);

4.service接口

void showUserByPage(HttpServletRequest request, Model model);

Long Count();

5.ServiceImpl实现类

@Service

public class UserServiceImpl implements UserService {

@Autowired

private UserMapper userMapper;

/*

• 分页

• */

public void showUserByPage(HttpServletRequest request, Model model) {

String pageNow = request.getParameter(“pageNow”);

Page page = null;

List user =new ArrayList();

//查询用户总数

int totalCount = userMapper.Count().intValue();//注：这里需要强转，long类型转换成int类型

if (pageNow != null) {

page = new Page(totalCount, Integer.parseInt(pageNow));

user = this.userMapper.selectUserByPage(page.getStartPos(), page.getPageSize());

} else {

page = new Page(totalCount, 1);

user = this.userMapper.selectUserByPage(page.getStartPos(), page.getPageSize());

}

model.addAttribute(“user”, user);

model.addAttribute(“page”, page);

}

/*

• 总记录数查询

• */

public Long Count() {

return userMapper.Count();

}

6.controller

@RequestMapping(“/page”)

public String Page(HttpServletRequest request, Model model){

userService.showUserByPage(request, model);

return “user/index”;

}

7.jsp页面