mybatis-plus wrapper用于自定义的SQL且不影响分页

mybatis-plus wrapper用于自定义的SQL且不影响分页

mapper.java

@Mapper
public interface ConsumerMapper extends BaseMapper<Consumer> {
    IPage<Consumer> findContainItemById(IPage page, @Param(Constants.WRAPPER) Wrapper wrapper);
}

mapper.xml

<select id="findContainItemById" resultMap="ContainItem">
    select <include refid="all_fields"/> from consumer ${ew.customSqlSegment}
</select>

使用

service

@Service
public class ConsumerServiceImpl extends ServiceImpl<ConsumerMapper, Consumer> implements ConsumerService {
    private ConsumerMapper consumerMapper;
    @Autowired
    public ConsumerServiceImpl(ConsumerMapper consumerMapper){
        this.consumerMapper = consumerMapper;
    }
    /*使用Wrapper且不影响分页*/
    @Override
    public IPage<Consumer> findContainItemById(IPage page,Wrapper<Consumer> wrapper) {
		// QueryWrapper<Consumer> wrapper = new QueryWrapper();
  		// wrapper.eq(true,"age",18);
        IPage<Consumer> result = consumerMapper.findContainItemById(page, wrapper);
        return result;
    }
}

Controller中调用service的代码 略