求助hibernate的动态查询

[kunmingkunlun]

DetachedCriteria query = DetachedCriteria.forClass(MoviePlayItem.class);
query.setProjection(Projections.projectionList()
.add(Projections.alias(Projections.groupProperty("movie"),"movie"))
.add(Projections.alias(Projections.rowCount(), "rowcount")));
//query.add(Restrictions.gt("rowcount", new Integer(0)));这样写有错误
query.addOrder(Order.desc("rowcount"));

请问要求rowcount>0该怎么写？ 类似于sql语句中的having

[zl3450341]

干脆用hibernate执行原生sql
效率也高

[superboy20071207]

这种情况下最好用原生SQL，调试也方便

[zhang_yu_QIN]

SF..

什么rowcount>0该怎么写？

说明一下你想达到的结果 和需求..

[kunmingkunlun]

hql语句是这样的：select mpi.movie as movie,count(*) as rowcount from MoviePlayItem mpi
group by mpi.movie having count(*)>0 order by count(*) desc

[guoyang100]

就是调用createSQLQuery("select mpi.movie as movie,count(*) as rowcount from MoviePlayItem mpi
group by mpi.movie having count(*)>0 order by count(*) desc").这样就可以了。

[kunmingkunlun]

难道没有人会吗？

[Landor2004]

hibernate的Criteria是不支持having的，不过有个人写了一个扩展Projections，叫做CustomProjections

地址：
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1700，楼主不妨下载测试一下

[kunmingkunlun]

那只能用hql语句了，将就了！

[zhang_yu_QIN]

[Quote=引用 8 楼 kunmingkunlun 的回复:]
那只能用hql语句了，将就了！
[/Quote]

OK了没?

[kunmingkunlun]

ok

[aaxuelian]

顶!!

[街头小贩]

MS已经解决了