mysql - 如何在 Hibernate 中进行计数(*)？

Question

如何在 Hibernate 中统计 MySQL 表中的记录？我尝试了以下 HQL，但它不起作用。

SELECT COUNT(*) FROM MEMBERS WHERE `username` =:USERNAME OR  `email` =:EMAIL

在以下方法中使用:

public boolean checkInfos() {
    Session newSession = NewHibernateUtil.getSessionFactory().openSession();
    int count = (Integer) newSession.createSQLQuery("SELECT COUNT(*) FROM MEMBERS WHERE  `username` ='admin' OR  `email` ='admin'").uniqueResult();

    if (count >= 1) {
        return false;
    } else {
        return true;
    }
}

Answer 1

我猜你需要那个

Query q = newSession.createSQLQuery("SELECT COUNT(*) FROM MEMBERS WHERE  username = ? OR  email =?");
q.setParameter( 1, "your username");
q.setParameter(2, "your email");