1.查询一列的和

detachedCriteria.setProjection(Projections.sum("payAmount"));

2.查询两列积的和

detachedCriteria.setProjection(Projections.sqlProjection("sum(amount*price) as result", new String[] { "result" }, new Type[] { new DoubleType() }));