员工信息查询（含分页查询）

分页查询：原始方法

用@RequestParam可以为属性设置默认值

@Service public class EmpServiceimpl implements EmpService { @Autowired private EmpMapper empMapper; @Override public PageResult page(Integer page, Integer pageSize) { //1.调用mapper查询总记录数 Long total = empMapper.count(); //2.调用mapper查询结果列表 List<Emp> rows = empMapper.list((page - 1) * pageSize, pageSize); //3.封装结果 PageResult return new PageResult(total,rows); }

public interface EmpMapper { @Select("select count(*) from emp e left join dept d on e.dept_id = d.id") public Long count(); /* * 这里的d.name封装不到Emp对象中，所以需要使用别名解决 * */ @Select("select e.*,d.name deptName from emp e left join dept d on e.dept_id = d.id " + "order by e.update_time desc limit #{start},#{pageSize}") public List<Emp> list(Integer start, Integer pageSize);

public class EmpController { @Autowired private EmpService empService; /* * 分页查询 * */ @GetMapping public Result page(@RequestParam(defaultValue = "1") Integer page, @RequestParam (defaultValue = "10") Integer pageSize){ log.info("分页查询:{},{}",page,pageSize); PageResult pageResult = empService.page(page,pageSize); return Result.success(pageResult); }