mybatis-plus分页查询

service接口

public interface UserService extends IService<User> {
    /**
     * 分页查询
     * @param current:当前页　
     * @param size:每页几条
     */
     List<User>queryByPage(Integer current,Integer size);
}

service接口实现类

/**
 * @author YuelongZhou
 * @date 2022/2/17
 */
@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
    @Autowired
    private UserMapper mapper;
    @Override
    public List<User> queryByPage(Integer current, Integer size) {
        Page<User> userPage=new Page<>(current,size);
        IPage<User>page=mapper.selectPage(userPage,null);
        return page.getRecords();
    }
}

配置类

/**
 * @author YuelongZhou
 * @date 2022/2/7
 */
@Configuration
@MapperScan("com.zyl.mapper")
public class DaoConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
        return interceptor;
    }
}

测试类

@SpringBootTest
@RunWith(SpringRunner.class)
public class ConsumerTest {
    @Reference
    private UserService service;
    @Test
    public void testQueryPage(){
        List<User> users = service.queryByPage(1, 3);
        users.forEach(System.out::println);
    }
}