hibernate 一些查询操作

查询数据得到List<Long>

List<Organization> organizationList = Lists.newArrayList();
   
CriteriaBuilder criteriaBuilder = entityManager().getCriteriaBuilder();
CriteriaQuery<Organization> query = criteriaBuilder.createQuery(Organization.class);
Root<Organization> root = query.from(Organization.class);

organizationList = entityManager().createQuery(query.select(root).where(criteriaBuilder.equal(root.get("organizationLeaderWorkNumber"), workNumber)))
                        .getResultList();

List<Long> orgList = Lists.newArrayList();
StringBuffer sbSQL = new StringBuffer(520);
sbSQL.append("select pos.org_id from HCM_OUT_POS pos,HCM_OUT_PLU plu ");
sbSQL.append("       where pos.position_id = plu.plans and plu.spernr = '000001' and pos.is_manager = 'X'");
Query querys = entityManager().createNativeQuery(sbSQL.toString());
orgList = (List<Long>)querys.getResultList();
if(orgList!=null && orgList.size()>0){//删除organizationList包含orgList 的元素对象
Iterator<Organization> iter = organizationList.iterator(); 
while(iter.hasNext()){  
Organization organization = iter.next();  
if(orgList.contains(organization.getOrganizationID())){
iter.remove();  
 }  
}  
}

查询返回条数

 Query userCounts = entityManager().createNativeQuery("select count(*) from pmp_user u1 join" +
                " pmp_user u2 on u1.SUPERVISOR_WORK_NUMBER = u2.WORK_NUMBER " +
                "and u1.WORK_NUMBER = :workNumber and u2.id = :userId");
        userCounts.setParameter("workNumber", requestUserWorkNumber);
        userCounts.setParameter("userId", currentUserId);
        try {
            Object singleResult = userCounts.getSingleResult();
            return ((BigDecimal) singleResult).longValue() > 0;
        } catch (Exception e) {
            return false;
        }