我有以下方法,出于安全原因更改了对象名称:
public List listAllForIds(List ids) {
Criteria criteria = getSessionFactory().getCurrentSession().createCriteria(MyObject.class)
.createAlias("joinObject", "joinObject")
.add(Restrictions.not(Restrictions.like("name", "string1", MatchMode.END)))
.add(Restrictions.not(Restrictions.like("name", "string2", MatchMode.END)))
.add(Restrictions.in("joinObject.id", ids));
return criteria.list();
}
更改为使用:
javax.persistence.criteria.CriteriaBuilder
javax.persistence.criteria.CriteriaQuery
该查询如下所示:
public List listAllForIds(List ids) {
CriteriaBuilder builder = getSessionFactory().getCurrentSession().getCriteriaBuilder();
CriteriaQuery criteria = builder.createQuery(MyObject.class);
Root myObjectRoot = criteria.from(MyObject.class);
Join joinObject = myObjectRoot.join("joinObject");
Predicate likeRestriction = builder.and(
builder.notLike( myObjectRoot.get("name"), "%string1"),
builder.notLike( myObjectRoot.get("name"), "%string2")
);
criteria.select(myObjectRoot).where(joinObject.get("id").in(ids), likeRestriction);
TypedQuery query = getSessionFactory().getCurrentSession().createQuery(criteria);
return query.getResultList();
}
希望对其他人有所帮助,请随时提出任何更改建议以改进代码。