使用Criteria实现以下SQL语句的效果(in):
select * from
BK_ProjectCard this_
where
this_.resCompanyId in (
select
this_.id as y0_
from
SYSTEM_DEPARTMENT_INFO this_
)
实现代码:
Criteria criteria = this.getSessionFactory().getCurrentSession().createCriteria(ProjectCard.class);
DetachedCriteria inCriteria = DetachedCriteria.forClass(DepartmentInfo.class);
inCriteria.setProjection(Property.forName("id"));
criteria.add(Property.forName("resCompanyId").in(inCriteria));
List<ProjectCard> projectCards = criteria.list();
使用Criteria实现以下SQL语句的效果(exists):
select * from BK_ProjectCard pc where exists in(select this_.id as y0_ from SYSTEM_DEPARTMENT_INFO this_ where this_.id = pc.resCompanyId)
Criteria criteria = this.getSessionFactory().getCurrentSession().createCriteria(ProjectCard.class, "pc");
DetachedCriteria existsCriteria = DetachedCriteria.forClass(DepartmentInfo.class, "sdi");
existsCriteria.add(Property.forName("sdi.id").eqProperty(Property.forName("pc.resCompanyId")));
existsCriteria.add(Restrictions.like("name", "%test%"));
criteria.add(Subqueries.exists(existsCriteria.setProjection(Projections.property("sdi.id"))));
List<ProjectCard> projectCards = criteria.list();
PS:实体类中并没有建立两个对象的关联关系,仅在ProjectCard对象中创建了一个resCompanyId的属性,用于存储DepartmentInfo表的ID。