英文:
What is the 'default' sort of Paging and Sorting Repository in Spring JPA?
问题
我正在尝试理解Spring Data JPA分页。
当我调用任何仅带有分页而没有任何排序的findAll时，数据是如何进行排序的。
以下是我尝试从存储库获取第1页（大小为100）的内容。我想知道我得到的结果如何在没有任何隐含排序的情况下进行排序。这种“默认”排序是否取决于从数据库接收到的实际结果顺序。
Pageable pageRequest = PageRequest.of(1, 100);
List<Citizen> citizens = citizenRepository.findAll(pageRequest).getContent();
英文:
I'm trying to understand Spring Data JPA paging.
How is the data sorted when I call any findAll with Paging only, without any Sorting.
Below I try to fetch the 1st Page(of size 100) from the repository. I want to know how the result I get is sorted without any implied sorting. Is this 'default' sorting dependent on the actual order of results received from the database.
Pageable pageRequest = PageRequest.of(1, 100);
List<Citizen> citizens = citizenRepository.findAll(pageRequest).getContent();
答案1
得分: 0
如果您不传递排序对象，则会应用默认的数据库排序。
对于某些数据库，它是按照主键（ID）进行升序排序，但这不在ANSI规范中，所以我不会依赖于这一点。
英文:
If you don't pass the sort object - then default database sorting is applied.
For some databases it's by primary key (ID) with ASC but this is not in ANSI specification so I wouldn't rely on this.
专注分享java语言的经验与见解，让所有开发者获益！
评论