@Override
public Result queryAllEmp(Integer current, Integer pageSize, EmpVo empVo) {
Page<Emp> page = new Page<>(current, pageSize);
System.out.println(current);
System.out.println(pageSize);
Page<Emp> empPage = empDao.selectPage(page, null);
List<Emp> records = empPage.getRecords();
for (Emp record : records) {
Integer deptno = record.getDeptno();
QueryWrapper<Dept> wrapper1 = new QueryWrapper<>();
wrapper1.eq("deptno",record.getDeptno());
Dept dept = deptDao.selectOne(wrapper1);
record.setDname(dept.getDname());
record.setLoc(dept.getLoc());
}
if(ObjectUtil.isNotEmpty(empPage)){
return new Result<>(200,"查询成功",empPage);
}
return new Result<>(500,"查询失败");
}
前端传入current为1,pageSize为5;但查询出来为全部数据 这里断点显示到records时总是显示全部数据
@Configuration
@MapperScan("com.aaa.dao")
public class MyInterceptorConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
需要新建配置类 注入
运行正常
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
这里用的是3.5.1
不同的版本有不同的解决配置