读书人

JPA查询结果总和count的使用

发布时间: 2012-11-13 10:00:51 作者: rapoo

JPA查询结果总数count的使用

CriteriaBuilder critBuilder = entityManager.getCriteriaBuilder();CriteriaQuery<Long> critQuery = criteriaBuilder.createQuery(Long.class);Root<Foo> root = critQuery.from(Foo.class);critQuery.select(critBuilder.countDistinct(root));int count = entityManager.createQuery(critQuery).getSingleResult().intValue();

?

?

?

CriteriaBuilder critBuilder = entityManager.getCriteriaBuilder();CriteriaQuery<Long> critQuery = criteriaBuilder.createQuery(Long.class);Root<Foo> root = critQuery.from(Foo.class);critQuery.select(root).distinct(true);List<Foo> result = entityManager.createQuery(critQuery).getResultList();

?

读书人网 >软件架构设计

热点推荐