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;
}