级联字段上的JPA查询过滤器

Question

我想用“name + surname”字符串作为关键字来查询我的“customers”表。

名字和姓氏存储在不同的领域。

所以我的查询将是：

SELECT 
    * 
FROM 
    customers 
WHERE 
    CONCAT(name,' ',surname) LIKE '%term%' 
    OR CONCAT(surname,' ',name) LIKE '%term%' 

但是，我不能这样做，我的查询是JPA2 条件查询。例如：

CriteriaBuilder cb = getEntityManager().getCriteriaBuilder(); 
      CriteriaQuery cq = cb.createQuery(); 
      Root<Customer> from = cq.from(Customer.class); 
      cq.select(from); 

      Predicate whereClause = cb.or(
       cb.like(from.<String>get("name"), "%"+ r +"%"), 
       cb.like(from.<String>get("surname"), "%"+ r +"%"), 
      ); 

      cq.where(whereClause);  
      TypedQuery<Customer> query = getEntityManager().createQuery(cq); 
      list = query.getResultList(); 

如何过滤我的结果集名称和姓氏的组合？

Answer 1

使用CriteriaBuilder.concat(Expression, Expression)：

Expression<String> exp1 = cb.concat(from.<String>get("name"), " "); 
exp1 = cb.concat(exp1, from.<String>get("surname")); 
Expression<String> exp2 = cb.concat(from.<String>get("surname"), " "); 
exp2 = cb.concat(exp2, from.<String>get("name")); 
Predicate whereClause = cb.or(cb.like(exp1, "%"+ r +"%"), cb.like(exp2, "%"+ r +"%"));