初试mybatis plus使用

依赖

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.0</version>
        </dependency>

分页

    /**
     * mybatisplus分页配置
     * @return
     */
    @Bean
    public PaginationInterceptor paginationInterceptor(){
        return new PaginationInterceptor();
    }

分页查询controller

    @GetMapping("/getCollectionByPageAndUser")
    @ApiOperation(value = "根据用户获取收藏信息")
    public ResponseEntity<IPage<CdrCollectionEntity>> getCollectionByPageAndUser(
            @RequestParam(value = "page",defaultValue = "1") Integer page, @RequestParam(value = "rows" ,defaultValue = "10") Integer rows)  {

        IPage<CdrCollectionEntity> cdrCollectionEntityIPage = cdrCollectionService.getCollectionByPageAndUser(page,rows);
        return ResponseEntity.ok(cdrCollectionEntityIPage);
    }

分页查询serivice

    @Override
    public IPage<CdrCollectionEntity> getCollectionByPageAndUser(Integer page, Integer rows) {

        String userName = UserInterceptor.getUserName();
        Page<CdrCollectionEntity> pageEntity = new Page<>(page,rows);
        IPage<CdrCollectionEntity> collectionIPage= cdrCollectionDao.selectPage(pageEntity, Wrappers.<CdrCollectionEntity>query().lambda()
                .eq(CdrCollectionEntity::getCreateBy,userName).eq(CdrCollectionEntity::getDeleteFlag,0));
        return collectionIPage;
    }

根据前端传入实体类中参数直接查询数据(为null的不做查询条件，为null数据库中有默认值的使用默认值作为查询条件)

List<CdrCollectionEntity> cdrCollectionEntities = cdrCollectionDao.selectList(Wrappers.lambdaQuery(cdrCollectionEntity));