java 8 call an method pagination untill next page key is not null code example

Example: sql paging query

SELECT * FROM SampleFruits
ORDER BY Id
OFFSET 0 ROWS 
FETCH NEXT 7 ROWS ONLY