public int getCount(String emailGroupId, String emailBatchId)
throws HibernateException ...{
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
String hql = "select count(*) from EmailSendInfo where email_group_id = :emailGroupId and batch_id = :batchId";
Query query = session.createQuery(hql);
query.setString("emailGroupId", emailGroupId);
query.setString("batchId", emailBatchId);
/**//*
* for (Iterator it = query.iterate(); it.hasNext();) { return
* ((Integer) it.next()).intValue(); }
*/
try ...{
return ((Integer) query.iterate().next()).intValue();
} catch (Exception e) ...{
throw new HibernateException("");
} finally ...{
tx.commit();
HibernateUtil.closeSession();
}
}Strings + Hibernate:
//第一种方法:
String hql = "select count(*) from User as user";
Integer count = (Integer)getHibernateTemplate().find(hql).listIterator().next();
return count.intValue();
//第二种方法:
String hql = "select count(*) from User as user";
return ((Integer)getHibernateTemplate().iterate(hql).next()).intValue();
//第三种方法:
String hql = "select count(*) from User as user";
Query query = getHibernateTemplate().createQuery( getSession(),hql);
return ((Integer)query.uniqueResult()).intValue();
使用Hibernate查询记录数
本文介绍了使用Hibernate框架通过三种不同的方法来查询数据库中特定条件下的记录总数,包括直接使用Hibernate API构建查询、利用Hibernate Template进行查询等方法。
3697





