Guest User

Untitled

a guest
Jun 21st, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. @Repository
  2. public interface MyEntityRepository extends JpaRepository<MyEntity, Integer>, JpaSpecificationExecutor<MyEntity> {
  3.  
  4. @Query(value =
  5. "SELECT e "
  6. + " FROM MyEntity e "
  7. + " WHERE e.flg = :flg "
  8. + "";)
  9. Page<MyEntity> findByFlg(
  10. Pageable pageable
  11. );
  12. }
  13.  
  14. public class Service {
  15.  
  16. //This method return full result.
  17. //If field dept.someField is null MyEntity obj still exists in page
  18. public Page<MyEntity> findDataSpec(Pageable pageable) { //sort[dept.someField:ASC]
  19. Specification<MyEntity> specification = (root, criteriaQuery, criteriaBuilder) -> {
  20. Path flg = root.get("flg");
  21. return criteriaBuilder.equal(flg, "1");
  22. };
  23. Page<MyEntity> page = myEntityRepository.findByDeptAndTpAndKnd(specification, pageable);
  24. return page;
  25. }
  26.  
  27. //This method return wrong result.
  28. //If field dept.someField is null MyEntity obj escape from page
  29. public Page<MyEntity> findDataJpql(Pageable pageable) {//sort[dept.someField:ASC]
  30. Page<MyEntity> page = myEntityRepository.findByFlg("1", pageable);
  31. return page;
  32. }
  33. }
Add Comment
Please, Sign In to add comment