LambdaQueryWrapper<ProductEntity> queryWrapper = new LambdaQueryWrapper<ProductEntity>()
.eq(ObjectUtils.isNotEmpty(productQueryRequest.getProductCode()), ProductEntity::getProductCode, productQueryRequest.getProductCode())
.like(ObjectUtils.isNotEmpty(productQueryRequest.getProductName()), ProductEntity::getProductName, productQueryRequest.getProductName())
.orderByDesc(ProductEntity::getCreateTime);
PageInfo<ProductEntity> pageInfo = PageHelper.<ProductEntity>startPage(productQueryRequest.getPageNum(), productQueryRequest.getPageSize())
.doSelectPageInfo(() -> productMapper.selectList(queryWrapper));
单表查询 分页查询LambdaQueryWrapper筛选条件
于 2024-09-12 14:44:36 首次发布