mybatis流式查询

mybatis流式查询 基于注解的方式 Mapper.java

@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");

基于XML方式 java

void scroll(ResultHandler iPassInfoResultHandler);

xml

  
    select
    
      distinct
    
    
    from res_item_attr
  

应用

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