【例】雇员信息表
统计雇员人数(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);
运行结果: