hibernate criteria where exists查询
使用的方法是sqlRestriction
criteria.add(Restrictions.sqlRestriction(" exists (select 1 from xxx as r where r.xxx = {alias}.xxx)")
{alias}会替换成entity创建criteria的alias.
使用的方法是sqlRestriction
criteria.add(Restrictions.sqlRestriction(" exists (select 1 from xxx as r where r.xxx = {alias}.xxx)")
{alias}会替换成entity创建criteria的alias.