如何使用JPA Criteria Query重写此查询？
public class Entity {
private boolean suspended;
private String code;
@Type(type = "org.jadira.usertype.dateandtime.joda.PersistentDateTime")
@DateTimeFormat(style = "")
private DateTime validFrom;
@Type(type = "org.jadira.usertype.dateandtime.joda.PersistentDateTime")
@DateTimeFormat(style = "")
private DateTime validTill;
}
select count(o) from Entity o
where o <> :this and o.code = :code and (
(o.validFrom between :validFrom and :validTill and not o.suspended) or
(o.validTill between :validFrom and :validTill and not o.suspended) or
(:validFrom between o.validFrom and o.validTill and not o.suspended)
)
没有找到相关结果
已邀请:
1 个回复
素汞读
CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery<Entity> cQuery = builder.createQuery(Entity.class); Root<Entity> root = cQuery.from(Entity.class); Predicate pValid1 = builder.between(root.get("ValidFrom"), validFrom, validTill); Predicate pValid2 = builder.between(root.get("ValidTill"), validFrom, validTill); Predicate pValid3 = builder.and(builder.lessThan(root.get("validTill"), balidFrom),builder.greaterThan(root.get("ValidFrom",validfrom))); Predicate pSuspend = builder.not(root.get("Suspended"),true); ExecutableQuery qFinal = em.createQuery(cQuery.select(root).where(builder.and(pSuspend,builder.or(pValid1,pvalid2,pvalid3))))