Не получаю указанный интервал страниц во время работы Spring Data Jpa Pagination

  • entity
@Table(name = "EMPLOYEES_VIEW")
@Entity
public class EmployeeView {

       /**
     * вторичный ключ к таблице employees
     */
    @Id
    @Column(name = "EMPLOYEEID")
    private Long employeeId;

    @Column(name = "ADDRESS")
    private String address;

    @Column(name = "FIRST_NAME")
    private String firstName;

    @Column(name = "LAST_NAME")
    private String lastName;

    @Column(name = "SALARY")
    private Double salary;
  • repository
public interface EmployeeViewPaginationRepository extends PagingAndSortingRepository<EmployeeView, Long> {
    List<EmployeeView> findAllBySalary(Double Salary, Pageable pageable);

}
  • service

    /**
     *
     * @param salary value of field that is done an query
     * @param numberPage start number of the page to get the requested list from
     * @param amountPage the number of pages received per request
     * @return
     */
    @Override
    public Iterable<EmployeeViewDto> getAllBySalary(Double salary, Integer numberPage, Integer amountPage) {

        PageRequest pageRequest = PageRequest.of(numberPage, amountPage);

        Iterable<EmployeeView> employeeViews = findEmployeesFromViewPagination(salary, pageRequest);

        Iterable<EmployeeViewDto> listDto = transformViewPagToListDto(employeeViews);

        return listDto;
    }


    private Iterable<EmployeeView> findEmployeesFromViewPagination(Double salary, Pageable pageable){

        Iterable<EmployeeView> allEmployees = this.paginationRepository.findAllBySalary(salary, pageable);

        return allEmployees;
    }

Я передаю вот такие параметры для pagination:

  • Integer numberPage = 0;

  • Integer amountPage = 5;

Я получаю результат

Я передаю вот такие параметры pagination:

  • Integer numberPage = 1;

  • Integer amountPage = 5;

Я получаю 0 записей.

Почему ?


Ответы (0 шт):