Hibernate DetachedCriteria Projections

[color=darkred]DetachedCriteria criteria = DetachedCriteria.forClass/color

criteria.setProjection(Projections.projectionList()
.add(Property.forName("id"))
.add(Projections.groupProperty("username"))
.add(Property.forName("incometime"))
.add(Projections.sum("submoney")));

[color=darkred]若在sum("submoney")的基础上附加一个“除以30”的筛选条件该如何写?[/color]

使用sqlProjection,类似这样

[code="java"]criteria.setProjection(Projections.projectionList()
.add(Property.forName("id"))
.add(Projections.groupProperty("username"))
.add(Property.forName("incometime"))
.add(Projections.sqlProjection(
"sum(submoney) / 30 as total",
new String[] { "total" },
new Type[] { Hibernate.DOUBLE }
)
));[/code]