java count rows_Java Hibernate Count Rows

我使用Java8与Hibernate5和JPA2.我想计算结果集中的行数.我有以下代码可行,但是,我想知道是否有更有效的方法吗？我认为下面的代码首先查询整个结果集并计算行数.

final EntityManagerFactory entityManagerFactory = entityManager.getEntityManagerFactory();

final CriteriaBuilder criteriaBuilder = entityManagerFactory.getCriteriaBuilder();

CriteriaQuery criteria = criteriaBuilder.createQuery(Rating.class);

Root root = criteria.from(Rating.class);

ParameterExpression param = criteriaBuilder.parameter(Job.class);

TypedQuery queryRating = entityManager.createQuery(criteria);

queryRating.setParameter(param, job);

int results = queryRating.getResultList().size();

有没有办法让SQL做一个计数(*)？

UPDATE

感谢下面的@chsdk,我有一个修改后的代码版本：

CriteriaBuilder qb = entityManager.getCriteriaBuilder();

CriteriaQuery cq = qb.createQuery(Long.class);

cq.select(qb.count(cq.from(Rating.class)));

cq.where(/*your stuff*/);

return entityManager.createQuery(cq).getSingleResult();

题

如何使用Job参数设置where子句？

更多信息：

+--------+ +------------+ +-----+

| rating | | rating_job | | job |

+--------+ +------------+ +-----+

| ID | | RAT_ID | | ID |

| | | JOB_ID | | |

+--------+ +------------+ +-----+

Rating.java

@ManyToOne(fetch=FetchType.EAGER)

@JoinTable

(

name="rating_job",

joinColumns={ @JoinColumn(name="RAT_ID", referencedColumnName="ID") },

inverseJoinColumns={ @JoinColumn(name="JOB_ID", referencedColumnName="ID") }

)

private Job job;

UPDATE

感谢@chsdk,这是我的版本：

final EntityManagerFactory entityManagerFactory = entityManager.getEntityManagerFactory();

final CriteriaBuilder criteriaBuilder = entityManagerFactory.getCriteriaBuilder();

CriteriaQuery criteria = criteriaBuilder.createQuery(Long.class);

Root root = criteria.from(Rating.class);

ParameterExpression param = criteriaBuilder.parameter(Job.class);

criteria.select(criteriaBuilder.count(root)).where(criteriaBuilder.equal(root.get("job"), param));

TypedQuery queryRating = entityManager.createQuery(criteria);

queryRating.setParameter(param, job);

Long results = queryRating.getSingleResult();

return results;