Hibernate 如何使用count(*)

Java代码

1. public int getCount(String emailGroupId, String emailBatchId)
2. throws HibernateException {
4. Session session = HibernateUtil.currentSession();
5. Transaction tx = session.beginTransaction();
7. String hql = "select count(*) from EmailSendInfo where email_group_id = :emailGroupId and batch_id = :batchId";
8. Query query = session.createQuery(hql);
10. query.setString("emailGroupId", emailGroupId);
11. query.setString("batchId", emailBatchId);
12. /*
13. * for (Iterator it = query.iterate(); it.hasNext();) { return
14. * ((Integer) it.next()).intValue(); }
15. */
16. try {
17. return ((Integer) query.iterate().next()).intValue();
18. } catch (Exception e) {
19. throw new HibernateException("");
20. } finally {
21. tx.commit();
22. HibernateUtil.closeSession();
23. }
24. }

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:

Java代码

1. //第一种方法：
2. String hql = "select count(*) from User as user";
3. Integer count = (Integer)getHibernateTemplate().find(hql).listIterator().next();
4. return count.intValue();
6. //第二种方法：
7. String hql = "select count(*) from User as user";
8. return ((Integer)getHibernateTemplate().iterate(hql).next()).intValue();
10. //第三种方法：
11. String hql = "select count(*) from User as user";
12. Query query = getHibernateTemplate().createQuery( getSession(),hql);
13. return ((Integer)query.uniqueResult()).intValue();