What Spring Data jpa is?  Spring Data jpa is not a jpa provider

where
( 
ProfileSpecification.
byName
("Ali“) 
);
List
 profileList = this.profileRepository.findAll(spec);

dasturlash.uz

---

Specification – Short hand example 

public static Specification
 byName(final String name) {
return new Specification
() {
@Override
public Predicate toPredicate(Root
 root,
CriteriaQuery criteriaQuery,
CriteriaBuilder criteriaBuilder) {
return criteriaBuilder.equal(root.get("name"), name);
}
};

The same by using Function

public static Specification
 byName (final String name) {
return (r, cq, cb) -> cb.equal(root.get(“name"),name);
}

dasturlash.uz

---

Specification – Example 2

public static Specification
 bySurname(final String surname) {
return new Specification
() {
@Override
public Predicate toPredicate(Root
 root,
CriteriaQuery criteriaQuery,
CriteriaBuilder criteriaBuilder) {
return criteriaBuilder.like(root.get("surname"), "%" + surname + "%");
}
};
}

public static Specification
 byCreatedDateBetween(LocalDateTime
t1, LocalDateTime t2) {
return new Specification
() {
@Override
public Predicate toPredicate(Root
 root,
CriteriaQuery criteriaQuery,
CriteriaBuilder criteriaBuilder) {
return criteriaBuilder.between(root.get("createdDate"), t1, t2);
}
};
}

dasturlash.uz

---

Specification – Example 2

Specification
 spec = Specification.
where
(ProfileSpecification.
byName
("Ali"));
spec = spec.and(ProfileSpecification.
bySurname
("Valie"));
spec = spec.or(ProfileSpecification.
byId
(10));
spec = spec.or(ProfileSpecification.
byCreatedDateBetween
(LocalDateTime.
now
(), 
LocalDateTime.
now
()));
List
 profileList = this.profileRepository.findAll(spec);
select * from profile where name=? and surname like ? or id=10
or created_date between ? and ?

dasturlash.uz

---


dasturlash.uz