Hibernate 标准限制 AND/OR 组合

Question

如何使用 Hibernate 限制来实现此目的？

(((A='X') and (B in('X',Y))) or ((A='Y') and (B='Z')))

Answer 1

思考有效

Criteria criteria = getSession().createCriteria(clazz); 
Criterion rest1= Restrictions.and(Restrictions.eq(A, "X"), 
           Restrictions.in("B", Arrays.asList("X",Y)));
Criterion rest2= Restrictions.and(Restrictions.eq(A, "Y"), 
           Restrictions.eq(B, "Z"));
criteria.add(Restrictions.or(rest1, rest2));