求教怎么将hql语句转为 hibernate
A小鱼A 2016-07-19 09:23:11 SELECT SUM(number) AS Number ,SUM(gkjvalue*number) AS s ,gkjvalue FROM view_statistics GROUP BY gkjView
我写的
UserModel userModel = (UserModel) ActionContext.getContext().getSession().get("userModel");
DetachedCriteria dc = DetachedCriteria.forClass(StaModel.class);
ProjectionList plist = Projections.projectionList();
plist.add(Projections.sum("number"),"Number");
plist.add(Projections.sum("gkjvalue*number"),"Money");
plist.add(Projections.groupProperty("gkjvalue"));
plist.add(Projections.property("gkjvalue"));
dc.setProjection(plist);
dc.add(Restrictions.eq("debtName", value));
if(alreadyStaQueryModel.getCashTime()!=null){
dc.add(Restrictions.ge("cashTime", alreadyStaQueryModel.getCashTime()));
}
if(alreadyStaQueryModel.getEndTime()!=null){
dc.add(Restrictions.le("cashTime", alreadyStaQueryModel.getEndTime()+86400000-1));
}
dc.add(Restrictions.in("dptID",alreadyStaQueryModel.getIntArray()));
dc.add(Restrictions.eq("isDestroy",type));
return this.getHibernateTemplate().findByCriteria(dc);