count number

public Integer getTotalNum(Integer cloudUserId) throws Exception {
StringBuffer hql = new StringBuffer(" select count(*) from Jobinstance as model model.status <> 'DELETED' ");
if (cloudUserId > 0)
hql.append(" and model.clouduser.cloudUserId=").append(cloudUserId);
final String count = hql.toString();
return (Integer) super.getHibernateTemplate().execute(
new HibernateCallback()
{
public Object doInHibernate(Session session)
throws HibernateException, SQLException
{
Query query = session.createQuery(count);
long i = (Long) query.list().get(0);
return Integer.parseInt(i+"");
}
});
}