hibernate使用hql和sql查询总记录数和注意事项
1.使用sql进行查询
String sql = "select count(*) from student";
Query query = session.createSQLQuery(sql);
List<BigInteger> list = query.list();
int count = list.get(0).intValue();
2.使用hql进行查询
String hql = "select count(*) from Student ";
Query query = session.createQuery(hql);
int count = ((Long) query.iterate().next()).intValue();
3.Hql获取记录条数:
int count = (int) this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session) {
Query query = session.createQuery(fHql);
if (params != null && params.length > 0) {
// 设置Hql需要的参数
setParamter(query, params);
}
return ((Long) query.iterate().next()).intValue();
}
});
return count;