英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论