java - 查询游标如何工作

Question

try (QueryCursor<List<?>> cursor = cache.query(sql)) {
  for (List<?> row : cursor)
    System.out.println("ROW :: " + row.get(0));
}

光标是否转到数据库并按列表获取列表，或者它是否包含整个数据。

QueryCursor<List<?>> cursor = cache.query(sqlQuery))

Answer 1

根据 the documentation由 Joakim 指出:

QueryCursor represents query result set and allows for transparent page-by-page iteration. Whenever user starts iterating over the last page, it will automatically request the next page in the background. For cases when pagination is not needed, you can use QueryCursor.getAll() method which will fetch the whole query result and store it in a collection.