Advertisement
Guest User

Untitled

a guest
Sep 1st, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. public List findAll(Class type, Integer pageNumber, Integer pageSize) {
  2. CriteriaBuilder criteriaBuilder = this.em.getCriteriaBuilder();
  3.  
  4. CriteriaQuery<Long> countQuery = criteriaBuilder
  5. .createQuery(Long.class);
  6. countQuery.select(criteriaBuilder.count(countQuery.from(type)));
  7. Long count = this.em.createQuery(countQuery).getSingleResult();
  8.  
  9. CriteriaQuery<Class> criteriaQuery = criteriaBuilder.createQuery(type);
  10. Root<Class> from = criteriaQuery.from(type);
  11. CriteriaQuery<Class> select = criteriaQuery.select(from);
  12.  
  13. TypedQuery<Class> typedQuery = this.em .createQuery(select);
  14. while (pageNumber < count.intValue()) {
  15. typedQuery.setFirstResult(pageNumber - 1);
  16. typedQuery.setMaxResults(pageSize);
  17. System.out.println("Current page: " + typedQuery.getResultList());
  18. pageNumber += pageSize;
  19. }
  20.  
  21. return null;
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement