Pagination Thymeleaf 3.0 Spring MVC

Question

I would like to find a complete solution to Thymeleaf pagination using Spring PagingAndSortingRepository DAO. I got a partial solution working, but I can not get the final one. I think it would be interesting for everyone else as a code snipet, so I will ask for the whole thing. I could not find a solution on the web which is kind of strange for me (since I think it could be a quite common problem).

The final solution should behave like Google's pagination: with arrows on both sides only if it makes sense; with a maximun of 10 numbers (for example), and it should move from 1..10 --> 11..20 and so on, when you click the right arrow; and move to 5..15 when you click on 10. Just like google, you know. The size controls the number of items in each page, not the number of blocks or links in the pagination bar.

I have a DAO repository in Spring that extends PagingAndSortingRepository ...

package music.bolo.domain.repository;

import org.springframework.data.repository.PagingAndSortingRepository; import org.springframework.stereotype.Repository;

import music.bolo.domain.entity.Announcement;

@Repository public interface AnnouncementDao extends PagingAndSortingRepository {

Announcement findFirstByOrderByDateDesc(); }

So my service can make a request and each page will get the totalPageNumbers (http://docs.spring.io/spring-data/commons/docs/current/api/org/springframework/data/domain/Page.html)...

private final static int PAGESIZE = 2;

.. .. @Autowired annotations...

  public Page<Announcement> readAnnouncementPage (int pageNumber){
          PageRequest request = new PageRequest(pageNumber-1, PAGESIZE, Sort.Direction.DESC, "date");
          return announcementDao.findAll(request);    }

My Controller uses the data to send all the information to Thymeleaf

  @RequestMapping(value = "/viewannouncements", method = RequestMethod.GET)   
  ModelAndView viewAnnouncements(ModelAndView modelAndView, @RequestParam(name = "p", defaultValue = "1") int  pageNumber) {

  Page<Announcement> page =  announcementService.readAnnouncementPage(pageNumber);

  modelAndView.getModel().put("page2th", page);

  modelAndView.setViewName("viewannouncements");

  return modelAndView;    }

My solution is partial, it shows all the pages all the time, no arrow control (actually useless) and without any other funcionality, but it is the most I could make it work without bugs.

	<div class="tag-box tag-box-v7 text-justify">
		 <!-- <h2>Pagination Centered</h2>-->
		<div class="text-center">
			<ul class="pagination">
				<li><a href="#">&laquo;</a></li>
				<!--<li>&laquo;</li>-->
				<li th:each="i : ${#numbers.sequence( 1, page2th.TotalPages)}">
					<a th:href="@{'/viewannouncements?p='}+${ i }" th:text="${ i }">1</a></li>
				<!--<li>&raquo;</li>-->
				<li><a href="#">&raquo;</a></li>
			</ul>
		</div>
	</div>

Did you try this approach with Pageable github.com/mtiger2k/pageableSpringBootDataJPA or this stackoverflow.com/a/23393348/643500 — Sully
You could add to your view dataTables which support pretty well pagination and is easy to implement — cralfaro
Thanks HitHam, I tried the code from stackoverflow.com/questions/18490820/… but the problem I see there is that it does not implement the Blocks. That is, if you have 100 pages of results (5000 links), you want to show them in 10 blocks (with size of 50 results in each block), and move from block to block, that is not considered. — Mike
Hitham, I could not make it work with the Github exmaple, but it looks like it uses the page size (for the number of items in each page), but not a block size (for the number of pages in each pagination bar). Same problem. — Mike
Thanks Cralfaro, but I would like to find a solution using the paging and sorting object. — Mike

karelp90 karelp90 · Accepted Answer · 2017-04-25T20:48:17

This is an example of pagination with SpringBoot and Thymeleaf templates, you can try it.
It is self-explanatory.
Following you can find link to GitHub repo - https://github.com/karelp90/control_asp

Pagination Thymeleaf 3.0 Spring MVC

2 Answers