Annotation for setMaxResults in Spring Data JPA
In Spring Data JPA versions prior to 1.7.0, it was not possible to limit the number of results returned by an annotated query method using setMaxResults. However, this feature has been introduced in Spring Data JPA 1.7.0.
New Functionality in Spring Data JPA 1.7.0
As of Spring Data JPA 1.7.0 (Evans release train), you can use the newly introduced Top and First keywords to define query methods that automatically limit the results. For example:
findTop10ByLastnameOrderByFirstnameAsc(String lastname);
Spring Data will automatically limit the results to the number you defined (defaulting to 1 if omitted). Note that the ordering of the results becomes relevant here, either through an OrderBy clause as seen in the example or by handing a Sort parameter into the method.
Pagination in Previous Versions
In versions of Spring Data JPA prior to 1.7.0, pagination was handled using the Pageable interface on the requesting side and the Page abstraction on the result side. Here's an example:
public interface UserRepository extends Repository<user long> { List<user> findByUsername(String username, Pageable pageable); }</user></user>
You can use this interface like this:
Pageable topTen = new PageRequest(0, 10); List<user> result = repository.findByUsername("Matthews", topTen);</user>
If you need more information about the result (such as which page it is or how many pages there are in total), use Page as the return type:
public interface UserRepository extends Repository<user long> { Page<user> findByUsername(String username, Pageable pageable); }</user></user>
This will trigger a count projection of the query to be executed to determine the total number of elements.
The above is the detailed content of How to Limit Query Results in Spring Data JPA?. For more information, please follow other related articles on the PHP Chinese website!

This article analyzes the top four JavaScript frameworks (React, Angular, Vue, Svelte) in 2025, comparing their performance, scalability, and future prospects. While all remain dominant due to strong communities and ecosystems, their relative popul

This article addresses the CVE-2022-1471 vulnerability in SnakeYAML, a critical flaw allowing remote code execution. It details how upgrading Spring Boot applications to SnakeYAML 1.33 or later mitigates this risk, emphasizing that dependency updat

The article discusses implementing multi-level caching in Java using Caffeine and Guava Cache to enhance application performance. It covers setup, integration, and performance benefits, along with configuration and eviction policy management best pra

Node.js 20 significantly enhances performance via V8 engine improvements, notably faster garbage collection and I/O. New features include better WebAssembly support and refined debugging tools, boosting developer productivity and application speed.

Java's classloading involves loading, linking, and initializing classes using a hierarchical system with Bootstrap, Extension, and Application classloaders. The parent delegation model ensures core classes are loaded first, affecting custom class loa

This article explores methods for sharing data between Cucumber steps, comparing scenario context, global variables, argument passing, and data structures. It emphasizes best practices for maintainability, including concise context use, descriptive

Iceberg, an open table format for large analytical datasets, improves data lake performance and scalability. It addresses limitations of Parquet/ORC through internal metadata management, enabling efficient schema evolution, time travel, concurrent w

This article explores integrating functional programming into Java using lambda expressions, Streams API, method references, and Optional. It highlights benefits like improved code readability and maintainability through conciseness and immutability


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SublimeText3 Linux new version
SublimeText3 Linux latest version

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
