Examples of asc()

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

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

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

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

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

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

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

95
96
97
98
99
100
101
102
103
104
105
        }
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<UserHD> z = cq.from(UserHD.class);
        cq.where(cb.equal(z.get(UserHD_.organization), o));
        cq.orderBy(cb.asc(z.get(UserHD_.name)));
        cq.select(z);
       
        return getEntityManager().createQuery(cq).getResultList();
       
    }
View Full Code Here

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

30
31
32
33
34
35
36
37
38
39
40
   
    public List<Priority> findAll() {
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<Priority> h = cq.from(Priority.class);
        cq.orderBy(cb.asc(h.get(Priority_.id)));
        return getEntityManager().createQuery(cq).getResultList();
    }

  
  
View Full Code Here

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

35
36
37
38
39
40
41
42
43
44
45
        CriteriaQuery cq = cb.createQuery();
        Root<ServiceObject> s = cq.from(ServiceObject.class);
       
        cq.where(cb.equal(s.get(ServiceObject_.organization), curUser.getOrganization()));
       
        cq.orderBy(cb.asc(s.get(ServiceObject_.id)));
        cq.select(s);
       
        return getEntityManager().createQuery(cq).getResultList();

       
View Full Code Here

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

574
575
576
577
578
579
580
581
582
583
584
            {
                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()

638
639
640
641
642
643
644
645
646
647
648
                }
                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()

366
367
368
369
370
371
372
373
374
375
376
        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

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

100
101
102
103
104
105
106
107
108
109
110
            switch (constraint.getColumnSort())
            {

                case ASCENDING:

                    criteria.orderBy(builder.asc(propertyPath));
                    break;

                case DESCENDING:
                    criteria.orderBy(builder.desc(propertyPath));
                    break;
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.