java - 如何使用条件在 Hibernate 中实现选择和计数

Question

我是 hibernate 的新手，我有这样的查询:

select count(1) from (
SELECT COUNT (1)
FROM USR_BASE
WHERE ST_CD = 1
group by USR_NO)

如何使用条件在 Hibernate 中实现该查询？

因为，我已经用方法实现了:

public int totalUser(UsrBase usrBase) {
    Criteria criteria = createCriteria();
    String stCd = usrBase.getStCd();
    criteria.setProjection(Projections.projectionList())
            .add(Projections.property("usrNo"))
            .add(Projections.property(stCd))
            .add(Projections.groupProperty("usrNo")));

    return((Long)criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();

}

结果与我的查询不一样...请帮助我。

Answer 1

select count(1) from (
SELECT COUNT (1)
FROM USR_BASE
WHERE ST_CD = 1
group by USR_NO)

我认为这会更容易

select count(distinct(USR_NO)) from USR_BASE WHERE ST_CD = 1