hibernate的求和怎么写?

[wer719]

hibernate的求和怎么写?
hibernate的求和怎么写?
hibernate的求和怎么写?

[me old]

求和?什么意思?

[jyq0105]

sum()??

[天外流星]

int sum =((Integer)hibsession.createQuery("select sum(a.cost) from CdrList as a").iterate().next()).intValue();   

[jishu_vip]

sum();

[ee4456]

select num(字段名) form 类名
这就是了啊?

session.createQuery(),会返回一个object,你转成int或者Integer就是了,LS的就是对的

[Landor2004]

hql方法：
 int sum =((Integer)session.createQuery("select sum(a.property1) from Xxx as a").uniqueResult();   
criteria方法：
 Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(Xxx.class);
 int sum =(Integer)criteria.setProjection(Projections.sum("property1")).uniqueResult();

[guoyunsky]

[Quote=引用 7 楼 Landor2004 的回复:]
Java codehql方法：
int sum =((Integer)session.createQuery("select sum(a.property1) from Xxx as a").uniqueResult();
criteria方法：
Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(Xxx.class);
int sum =(Integer)criteria.setProjection(Projections.sum("property1")).uniqueResult();
[/Quote]

[lx999501]

sum(xxxx)