Hibernate 分离查询作为条件查询的一部分

java专家可以帮我编写分离查询作为以下SQL语句的条件查询的一部分吗？

select A.*
FROM AETABLE A
where not exists
(
    select entryid
    FROM AETABLE B
    where B.classpk = A.classpk
    and B.userid = A.userid
    and B.modifiedDate > A.modifiedDate
)
and userid = 10146

你需要写一个相关子查询 http://docs.jboss.org/hibernate/stable/core/reference/en/html/querycriteria.html#querycriteria-detachedqueries。假设属性/类名称与上面的列/表名称匹配：

DetachedCriteria subquery = DetachedCriteria.forClass(AETable.class, "b")
 .add(Property.forName("b.classpk").eqProperty("a.classpk"))
 .add(Property.forName("b.userid").eqProperty("a.userid"))
 .add(Property.forName("b.modifiedDate").gtProperty("a.modifiedDate"));

Criteria criteria = session.createCriteria(AETable.class, "a")
 .add(Property.forName("userid").eq(new Integer(10146)))
 .add(Subqueries.notExists(subquery);