Java – hibernate separates queries as part of conditional queries
•
Java
Java experts can help me write separate queries as part of the conditional queries in the following SQL statements
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
Solution
You need to write a correlated subquery Assume that the attribute / class name matches the column / table name above:
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);
The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
二维码