Package javax.persistence.criteria

Examples of javax.persistence.criteria.CriteriaBuilder.asc()

49
50
51
52
53
54
55
56
57
58
59
          criteriaBuilder.and(
            criteriaBuilder.between(root.get("dataLancamento").as(Date.class), dataInicial, dataFinal),
            criteriaBuilder.equal(root.get("colaborador"), colaborador)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataLancamento").as(Date.class))
          );

    return entityManager
        .createQuery(criteriaQuery)
        .getResultList();
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
          criteriaBuilder.and(
            criteriaBuilder.between(root.get("dataLancamento").as(Date.class), dataInicial, dataFinal),
            criteriaBuilder.equal(root.get("cliente"), cliente)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataLancamento").as(Date.class))
          );

    return entityManager
        .createQuery(criteriaQuery)
        .getResultList();
View Full Code Here
537
538
539
540
541
542
543
544
545
546
547
            {
                criteriaQuery.where((value != null) ? criteriaBuilder.equal(beanRoot.get(name), value) : criteriaBuilder.isNull(beanRoot.get(name)));
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
           
            // invoke query
            Query query = entityManager.createQuery(criteriaQuery);
            List<? extends IBean> beansList = query.getResultList();
View Full Code Here
601
602
603
604
605
606
607
608
609
610
611
                }
                criteriaQuery.where(predicate);
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
           
            // invoke query
            Query query = entityManager.createQuery(criteriaQuery);
            List<? extends IBean> beansList = query.getResultList();
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
   
    critQuery.select(root);
    if (availTaxes != null) {
      critQuery.where(root.<Double>get("value").in(availTaxes));
    }
    critQuery.orderBy(critBuilder.asc(root.<Long>get("id")));
   
    List<Tax> list = em.createQuery(critQuery).getResultList();

    logger.debug("listAllItems(Date) - end - return value=" + CollectionUtils.size(list));
    return list;
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
        // where-clause
        Predicate wherePredicate = whereClauseForFilter(critBuilder, critQuery, root, filter);
        if (wherePredicate != null) {
            critQuery.where(wherePredicate);
        }
        critQuery.orderBy(critBuilder.asc(root.get(Purchaser_.name)));
       
    TypedQuery<Purchaser> query = em.createQuery(critQuery);
   
    query.setFirstResult(filter.calculateFirstResultIndex());
    query.setMaxResults(filter.getPaginatedPageSize());
View Full Code Here
364
365
366
367
368
369
370
371
372
373
374
        Root<Inventory> inv = q.from(Inventory.class);
        q.select(inv);
        Expression<Integer> inStock = cb.diff(
                inv.get(Inventory_.supplied),
                inv.get(Inventory_.sold));
        q.orderBy(cb.asc(inStock));
       
        List<Inventory> result = em.createQuery(q)
                                   .setMaxResults(limit)
                                   .getResultList();
        commit();
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
       
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<UserHD> z = cq.from(UserHD.class);
        cq.where(cb.isNotNull(z.get(UserHD_.login))); // пустой логин - пользователь "выключен"
        cq.orderBy(cb.asc(z.get(UserHD_.id)));
        cq.select(z);
       
        return getEntityManager().createQuery(cq).getResultList();
       
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<UserHD> z = cq.from(UserHD.class);
        Join<UserHD, Role> j = z.join(UserHD_.role);
        cq.where(cb.equal(j.get(Role_.name), RoleEnum.SERVICE));
        cq.orderBy(cb.asc(z.get(UserHD_.name)));
        cq.select(z);
       
        List<UserHD> l = getEntityManager().createQuery(cq).getResultList();
        return l;
    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<UserHD> z = cq.from(UserHD.class);
        Join<UserHD, Role> j = z.join(UserHD_.role);
        cq.where(cb.equal(j.get(Role_.name), RoleEnum.CUSTOMER));
        cq.orderBy(cb.asc(z.get(UserHD_.name)));
        cq.select(z);
       
        List<UserHD> l = getEntityManager().createQuery(cq).getResultList();
        return l;
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.