Examples of asc()

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

55
56
57
58
59
60
61
62
63
        CriteriaQuery<Member> criteria = cb.createQuery(Member.class);
        Root<Member> member = criteria.from(Member.class);
        // Swap criteria statements if you would like to try out type-safe criteria queries, a new
        // feature in JPA 2.0
        // criteria.select(member).orderBy(cb.asc(member.get(Member_.name)));
        criteria.select(member).orderBy(cb.asc(member.get("name")));
        return em.createQuery(criteria).getResultList();
    }
}
View Full Code Here

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

47
48
49
50
51
52
53
54
55
56
57
          criteriaBuilder.and(
            criteriaBuilder.equal(root.get("dataTransacao").as(Date.class),date ),
            criteriaBuilder.equal(root.get("conta"),conta)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataTransacao").as(Date.class))
          );
   
   
    return entityManager
        .createQuery(criteriaQuery)
View Full Code Here

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
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.