mybatis流式查询

@MyBatisRepository
public interface ItemWideTableMapper extends WideTableMapperbase {
    String SQL = "";

    @Select(SQL )
    @Options(resultSetType = ResultSetType.FORWARD_ONLY, fetchSize = 100)
    @ResultType(ItemWideTable.class)
    void wideItems(ResultHandler handler, @Param("sharding_province_code") String shardingProvinceCode);
}

itemWideTableMapper.wideItems(resultContext -> {
                       // 业务处理...... 
                       ItemWideTable obj = resultContext.getResultObject();
                    },
                     "BEIJING");

void scroll(ResultHandler iPassInfoResultHandler);

  
    select
    
      distinct
    
    
    from res_item_attr
  

mapper.wideItems(scroll-> {
                       // 业务处理......  resultContext.getResultObject();
                    });