Hibernate聚集函数

【例】雇员信息表

统计雇员人数(count)

session=HibernateSessionFactory.getSession();
			String hql="select count(emp) from Employee emp";
			Query query=session.createQuery(hql);
			long count=(long)query.uniqueResult();									
			System.out.println("雇员人数："+count);

运行结果：

计算雇员平均薪资(avg)

session=HibernateSessionFactory.getSession();
			String hql="select avg(emp.emp_salary) from Employee emp";
			Query query=session.createQuery(hql);
			double avg=(double)query.uniqueResult();									
			System.out.println("平均薪资："+avg);

运行结果：

薪资(sum)

session=HibernateSessionFactory.getSession();
			String hql="select sum(emp.emp_salary) from Employee emp";
			Query query=session.createQuery(hql);
			double sum=(double)query.uniqueResult();									
			System.out.println("薪资："+sum);

运行结果：

最高薪资(max)

session=HibernateSessionFactory.getSession();
			String hql="select max(emp.emp_salary) from Employee emp";
			Query query=session.createQuery(hql);
			double max=(double)query.uniqueResult();									
			System.out.println("最高薪资："+max);

运行结果:

最低薪资(min)

session=HibernateSessionFactory.getSession();
			String hql="select min(emp.emp_salary) from Employee emp";
			Query query=session.createQuery(hql);
			double min=(double)query.uniqueResult();									
			System.out.println("最低薪资："+min);

运行结果：