hibernate使用hql和sql查询总记录数语句

hql：

 String hql= "select count(*) from table"; 

try {

Query query = this.sessionFactory.getCurrentSession().createQuery(hql);

i = ((Long) query.iterate().next()).intValue();

} 

catch (Exception e) {

// TODO: handle exceptioni= 0;

} 

sql： 

String sql = "select count(*) from table";

 try {

Query query = this.sessionFactory.getCurrentSession().createSQLQuery(sql);

 List list = query.list(); 

i = list.get(0).intValue();

} catch (Exception e) {

// TODO: handle exceptioni= 0;

}