Hibernete 离线查找排序问题???
.....
DetachedCriteria criteria = DetachedCriteria.forClass(getBetSchemeClass());
ProjectionList proList = Projections.projectionList();
proList.add(Projections.groupProperty("organigerId"), "userId");
proList.add(Projections.min("organigerName"), "userName");
proList.add(Projections.count("id"), "schemeWonCont");
proList.add(Projections.sum("totalPrize"), "prize");
proList.add(Projections.sum("betCost"), "schemeCost");
proList.add(Projections.sqlProjection("sum(totalPrize- betCost) as gain ", new String[] { "gain" },
new Type[] { Hibernate.BIG_DECIMAL }));
criteria.setProjection(proList);
criteria.add(Restrictions.eq("platformId", Byte.valueOf(getPlatform().getPlatformId())));
criteria.add(Restrictions.eq("status", Byte.valueOf("9")));
criteria.add(Restrictions.eq("cut", true));
topTime2(criteria);
criteria.addOrder(Order.desc("gain"));
criteria.setResultTransformer(DetachedCriteria.ALIAS_TO_ENTITY_MAP);
......
写了这样一个查询,我想对sum(totalPrize- betCost) as gain 这一结果进行排序
criteria.addOrder(Order.desc("gain"));
这样做是错误的,请各位JAVA 高手?如何实现?????