java - 使用 hibernate 计算行或记录

Question

我一直在尝试使用 hibernate 来计算行数，但我不断收到“0”记录。这是我的代码

public static Integer getLastDrugId(){
    Integer result = 0;
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = null;
    try{
        tx = session.beginTransaction();
        String hql = "SELECT count(*) FROM Drug";
        Query query = session.createQuery(hql);
        Integer e = (Integer) query.iterate().next();
        if (e != null) {
            result = 1;
        }

    } catch (Exception ex) {
        if (tx != null) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return result;
}

我是不是哪里搞错了？

Answer 1

替换这一行:

Integer e = (Integer) query.iterate().next();

这样:

Long e = (Long) query.iterate().next();