Mybatis Cursor

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
easSeniorAnalresultClazzStuRankMapper.cursorRankStudentsByClazz(clazzIds, ORIGINAL_SCORE_TYPE, resultContext -> {
EasSeniorAnalresultClazzStuRank row = resultContext.getResultObject();
buffer.add(row);
if (buffer.size() >= BATCH_SIZE) {
this.saveBatch(buffer);
buffer.clear();
}
});
/**
* 根据班级ID列表查询班级排名和年级排名
* 流式查询
* @param clazzIds 班级ID列表
* @return 班级排名和年级排名列表
*/
@Options(resultSetType = ResultSetType.FORWARD_ONLY, fetchSize = 1000)
@ResultType(EasSeniorAnalresultClazzStuRank.class)
void cursorRankStudentsByClazz(@Param("clazzIds") List<Long> clazzIds, @Param("score_type") Integer scoreType, ResultHandler<EasSeniorAnalresultClazzStuRank> handler);

和分页查询有什么区别吗