吖v天堂网2021,天天插天天干天天操,另类欧美范

Hibernate中如何使用count(*)取得表中記錄總數(shù)

2007.10.10

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();

本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請點(diǎn)擊舉報(bào)。

免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版