以下 HQL 的条件表示形式

Question

我有以下 HQL 为你遵循 sql..

的 SQL ....

SELECT * FROM POS_took WHERE DELETEDDATE IS NOT NULL 

它对应的HQL是...

session.createQuery("from postook where deleted is not null")

而 java 实体类是...

class postook
{
//all the properties defined here 
private DateTime deleted;
//and it corresponding setters and getters is defined.

现在请告知上述 HQL 的等效标准表示

Answer 1

Criteria criteria = getSession().createCriteria(postook.class);
criteria.add(Restrictions.isNotNull("deleted"));

查看更多详细信息 http://docs.jboss.org/hibernate/orm/4.2/devguide/en-US/html/ch12.html