学步园

关于hibernate中聚合函数的用法

1.   public int countDetails() throws Exception {
 // TODO Auto-generated method stub
 Transaction trans = null;
 trans = HibernateSessionFactory.getSession().beginTransaction();
 int m =(Integer)HibernateSessionFactory.getSession().createQuery(
  "select count(*) from Details").list().get(0);
 trans.commit();
 HibernateSessionFactory.closeSession();
 return m;
    }

返回数据总行数
2.public double countDetailsMoney() throws Exception {
 Transaction trans = null;
 trans = HibernateSessionFactory.getSession().beginTransaction();
 Double m =(Double)HibernateSessionFactory.getSession().createQuery(
  "select sum(money) from Details").list().get(0);
 trans.commit();
 HibernateSessionFactory.closeSession();
 return m;
 
    }

计算总金额