假设您的login表由LoginClass类Map，其中包含emailid和password示例变量。然后你将执行类似于：

Query query = session.createQuery(
        "select count(*) from LoginClass login where login.emailid=:email and login.password=:password");
query.setString("email", "something");
query.setString("password", "password");
Long count = (Long)query.uniqueResult();

它应该在count中返回您要查找的结果。你只需要调整你的类和参数的名字。

结果返回BigDecimal，您需要将其从Bigdecimal（java.math.BigDecimal）转换为Long，以便没有错误，解决方案如下：

Query query = session.createSQLQuery(
        "select count(*) from login where login.emailid=:email and login.password=:password");
query.setString("email", "something");
query.setString("password", "password");
Long count = ((BigDecimal) query.uniqueResult()).longValue();

你可以在Hibernate 6中这样查询：

public int getCount() {
    int result = 0;
    try {
        session.beginTransaction();

        result = session.createNativeQuery("select count(*) from user", Integer.class).uniqueResult();

        session.getTransaction().commit();

    } catch (Exception exception) {
        exception.printStackTrace();
    }

    return result;
}