Question

hibernate Criteria子查询问题

怎么做才能 生成sql语句
select * from a,b where a.name =1
and exists ( select * from a,b where a.di = b.id )
主要是这句 a.di = b.id 用Criteria怎么写 才能变成这样

Answer 1

建议用hibernate离线查询方式实现，如：
Criteria criteria = createCriteria(Product.class);
DetachedCriteria dc = DetachedCriteria.forClass(Specification.class,"s");
dc.add(Restrictions.le("price", price));
criteria.add(Subqueries.notExists(dc));

Answer 2

Criteria c = session.createCriteria(A).createCriteria(B)