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

Great explanation and we are able to understand easily. Thanks a lot!!

thanks,vary helpful

Does anyone know if Pagination works similarly with Spring JDBC or Spring Data?

As I'm understanding the last example, PaginationAndSort first sorts all records, then paginates the result. This is what I would want and expect.

If sorting is not used in pagination will it alter the result if hit multiple times suppose say in page0 A,B came and again query hit with page1 B,C came so here B came again. Is it the possibility?

Thanks Basant !! Awesome explanation on the implementation with example

Nice explanation. But I have a question here. If in pagination, suppose the first page shows records from id 1-10 in asc order. So as per this logic will that not alter the results shown in the first page if the sorting is applied to descending?

Thank you so very much!

Thanks

Best video !!!!!!!!!!!!!!!!!!!!!

thanks very much!!

So so so helpful, sir!! Thank you very much 🙇‍♂

I have 137 data in database and when i entered api/3/50 it should show me 37 data but it shows me empty content[]. what will i do?

Good explanation on the implementation of offset pagination in Spring. However, please use query parameters in the controller end instead of path variables. Query params are meant for filtering, sorting, and pagination.

Thank you so much friend!

Just want to call out couple of things. Sorting field, page size and offset are usually accepted as query params and not the path params. Path params are used for resource ids.

i also use postconstruct
but after run the application data is not created my sql table
can u plzz explain
how to resolve this problem
or we manually insert data

good video, can you please explain about APIResponse how it works on multiple types (T)

Thanks sir for this great explaination.
But I am receiving "[ ]", when I retur the Page<> object as response.
When I pass the List of contents inside the Page as response I get the data, but when I return the object of Page<> i get "[ ]".
What could be the reason, please help.

nice explanation

Boss u r great

Thank you so very much. This was exactly what I needed.

thank you very much

Java Techie is great !!!

Thanks

可惜没有中文字幕

With findAll, we can use pagination bcos it has overloaded method but what if there is custom method? How to use pagination?

Nice video exactly what i looking for ,it will be good if you add also one more condition "sorting with multiple column" but thats fine

nice

Thank you Basant..very nicely explained the pagenation

If you have null values in db table column. Here how you will sort data in query?

How to consume all the data from paginated API via rest template

.withSort doesnot found
how to solve it?

Its really a great tutorial...... and you present very well.

how can we implement pagination and filter with dynamic JPA/native query

Me salvaste el día bro, muchísimas gracias :3

Thank you boy
You're perfect

Hi Bro,
In controller class at line "new APIResponse<>(allProducts.size(),allProducts) " I am getting below compilation error
CANNOT INFER TYPE ARGUMENTS FOR APIRESPONSE . Please help me how to resolve this

Instead of passing page size and offset, can we just see the hard coded 5 no. of elements in one page and click enter and then see other pages one by one till end?

Hi Brother,
I have tried to implement same, but not able to get PageRequest in my project. Please let me know how to add dependency in my projejct?

Thanks & Regards,
Kiran Mandarapu

can we using jQuery datatables on frontend?

How to implement UI for this server side pagination and sorting like you showed in this video? Is UI code is also shared?

thanks boss

Thanks!

Thanks awesome

Pagination will only work with predefined queries ?
Or does it work with our custom named queries as well ?

Plzzz make vedio with the same concept with the help of using criteria api means creating our own user repository and providing implement for that with the help of criteria builder , without extending jpa r crud repository

Thank you

Awesome