Spring数据JPA规范调用

Question

我按照本教程获得了Spring Data JPA规范：https://dzone.com/articles/using-spring-data-jpa-specification

它为我实现了这一点，但我不能调用规范方法来搜索它们。我想把它们放在我的SearchController中：

public static Specification<Telefonbuch> hasVorname(String vorname) {
    return (root, query, cb) -> {
        return cb.equal(root.get(Telefonbuch_.vorname), "%"+vorname.toLowerCase()+"%");
    };
}

现在我想在我的SearchController（比如Controller）中调用这个方法，但我不知道如何调用。目前，该方法如下所示：SucheController：

   public void search(String vorname, String nachname, String telefonnummer, String handynummer) {  
    telefonbuch.setVorname(vorname);
    telefonbuch.setNachname(nachname);
    telefonbuch.setTelefonnummer(telefonnummer);
    telefonbuch.setHandynummer(handynummer);

    CriteriaBuilder builder = em.getCriteriaBuilder();
    CriteriaQuery<Telefonbuch> query = builder.createQuery(Telefonbuch.class);
    Root<Telefonbuch> root = query.from(Telefonbuch.class);
    List<Predicate> predicates = new ArrayList<Predicate>();



    if (!vorname.isEmpty()) {   
        //eintraege = telefonbuchRepository.findAll(hasVorname()); -> does not work
        Predicate condition = builder.like(builder.lower(root.get(Telefonbuch_.vorname)), "%"+vorname.toLowerCase()+"%");
        predicates.add(condition);
    }
...
query.select(root).where(predicates.toArray(new Predicate[predicates.size()]));

Answer 1

您需要有一个Telefonbuch存储库接口，它实现JpaRepository和JpaSpecificationExecutor。后者为您提供了方法，您可以将规范传递给这些方法：

 - long     count(Specification<T> spec) 
 - List<T>  findAll(Specification<T> spec) 
 - Page<T>  findAll(Specification<T> spec, Pageable pageable)
 - List<T>  findAll(Specification<T> spec, Sort sort) 
 - Optional<T> findOne(Specification<T> spec)

编辑：我的规范：

public class MyEntitySpecification implements Specification<MyEntity> {

   private final String searchText;

   public MyEntitySpecification(String searchText) {
      this.searchText = searchText;
   }

   @Override
   public Predicate toPredicate(Root<MyEntity> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
      List<Predicate> predicates = new ArrayList<>();
      Optional.ofNullable(searchText).ifPresent(
         s -> predicates.add(cb.like(cb.lower(root.get(MyEntity_.searchString)), "%" + s.toLowerCase() + "%"))
      );
      return cb.and(predicates.toArray(new Predicate[predicates.size()]));
   }
}