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<ItemWideTable> handler, @Param("sharding_province_code") String shardingProvinceCode);
}

应用

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

基于XML方式

java

void scroll(ResultHandler<ResItemAttr> iPassInfoResultHandler);

xml

  <select id="scroll" parameterType="cn.jhs.mysql.json.model.ResItemAttr" resultSetType="FORWARD_ONLY" fetchSize="100"
          resultMap="BaseResultMap">
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from res_item_attr
  </select>

应用

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