Spring Boot | Pagination and Sorting With Spring Data JPA | JavaTechie 

Agree with you 😊

Yes. I'm also waiting for this topic.

Yes it will vary

That you need to customize in code . On click next increase offset count to +5

Please configure Lombok in your ide

it will show you the data from 151 records if it is available

You need to set pageSize and total record count to disable next button once it fetches all

It's simple right call findAll and sort by field which you want. That's what I have explained please check once

This is latest feature of spring data jpa PageRequest should be available .not sure if they introduced any new class.just check spring data official page

That's bad practice right? Why should you keep null value in db

No it won't

@@Javatechie but if data keeps getting added then?

Okay I will do that

@@Javatechie still waiting..???

Pagination, just debug the flow you will get it

RestTemplate.getForObject() will work . Did you faced any issues

Yeah I am facing issue I have paginated api which gives 500 response at a single post request this post request I need to pass query param page no and page size and header with content type,jwt token , accepted language please help how can I consume all the response data

Not sure what spring boot version you are using just check jpa official documentation they might change the method name

Yes it will work with custom query as well

I am using normal intellij font which is default one .

Yes agree 👍

​​@@Javatechie is it okay to used request param for the offset and page size instead of Pathvariable in controller?

​@@Javatechie how did you make it appear the page,sort etc on the end part of your api response in postman?

This response is part of pageable

@@Javatechie what do I do to make it appear in postman? Basically, I got the exact response even the limit but that endpart of pageable won't show in postman..😭

Use below poc public Page getProductsWithPageResponse(int offset, int limit) { return repository.findAll(PageRequest.of(offset, limit)); }

@@Javatechie I am doing the same thing, ->This is my Service method, public ResponseEntity getUserBooks(int offset, int pageSize,Long user_id) { try { User user = userRepo.getReferenceById(user_id); Pageable pageable = PageRequest.of(offset, pageSize, Sort.by(Util.SORT_BY_TIME)); Page books = bookRepo.findByUser(user,pageable).map(Util::bookToDto); return new ResponseEntity(new APIResponse((int)books.getTotalElements(),books), HttpStatus.OK); } catch (Exception e) { System.out.println("exception"+e.getMessage()); return new ResponseEntity(new APIResponse(0,Page.empty()), HttpStatus.INTERNAL_SERVER_ERROR); } } -> This is my repository method Page findByUser(User user, Pageable pageable);

Are you fetching a single object

@@Javatechie No sir, When I logged the Page object, i can see the content list with all the object of type BookDto, along with other details of the Page object. I am trying to get Page type object which i then map to Page type object. I tried to use Gson to convert the Page object to json string and pass that string, although this thing worked, i could see the content list in my json. But some of the attributes were missing from the json like, 'last','totalPages' etc. But you are getting all the attributes there, @15:47. And I think using Gson isn't the best practice. I searched through stackoverflow and found the same problem, but each time i paste the link here yt, removes my comment, so can't add that link.

Yes we can use that

Yes Sahil and was noted this

Yes that's what I explained

@@Javatechie sorry bro i meant 1, default 0 is it possible to change 1?spring.data.web.pageable.one-indexed-parameters=true. This was I tried. It works but we need to recive as Pageble in parameter. But in my case I can’t give that need to build pageble using pagerequest that time it’s not working

Not getting you man .

No UI code not shared . Did you find any difficulty while implementing

@@Javatechie Actually i am in learning phase so i am not aware of implementing rest client with Angular or React.. Can you share the same if possible? i need this in angular. Thanks in Advance

Saud cool before you learn this pagination Full stack development , i would strongly suggest you to checkout my spring boot angular crud video because you will understand how to do this frontend and backend Integration

Link for your reference ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QV7ke4a7Lvc.html

@@Javatechie Thanks Basand ji.. I appreciate your efforts.

I explain this how offset calculated