Package javax.persistence.criteria

Examples of javax.persistence.criteria.CriteriaQuery.where()

1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
        Root<Customer> customer = cquery.from(Customer.class);

        //Get Metamodel from Root
        EntityType<Customer> Customer_ = customer.getModel();

        cquery.where(cb.equal(
                customer.get(Customer_.getSingularAttribute("name", String.class)),
                cb.nullLiteral(String.class)));

        Query q = em.createQuery(cquery);
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
    CriteriaQuery cq = cb.createQuery();
    Root<Book> candidate = cq.from(Book.class);
    candidate.alias("b");
    cq.select(candidate);
    Path titleField = candidate.get("title");
    cq.where(cb.equal(titleField, "Bar Book"));

    Query q = em.createQuery(cq);
    List<Book> books = q.getResultList();
    assertNotNull(books);
    assertEquals(2, books.size());
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
    Root<Book> candidate = cq.from(Book.class);
    candidate.alias("b");
    cq.select(candidate);

    Path titleField = candidate.get("title");
    cq.where(cb.equal(titleField, "Bar Book"));

    Path isbnField = candidate.get("isbn");
    cq.orderBy(cb.desc(isbnField));

    Query q = em.createQuery(cq);
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
       
       
        if(wherePerfomer == null) {
            cq.where(whereState);
        } else {
            cq.where(cb.and(whereState, wherePerfomer));
        }

        cq.orderBy(cb.desc(z.get(Request_.id)));
        cq.select(z);
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
       
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
        CriteriaQuery cq = cb.createQuery();
        Root<Request> z = cq.from(Request.class);
       
        cq.where(cb.and(
                    cb.isNotNull(z.get(Request_.serviceObject)),
                    cb.equal(z.get(Request_.serviceObject), current.getServiceObject()))
                );
               
        cq.orderBy(cb.desc(z.get(Request_.id)));
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
             
       
//        cq.where(cb.and(where, whereCreatedByOrg));   при whereCreatedByOrg == null - NPE 
       
        if(whereCreatedByOrg == null) { // whereCreatedByOrg инициализируется только когда задана орг-ия
            cq.where(where);    
        } else {
            cq.where(cb.and(where, whereCreatedByOrg));    
        }
  
           
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
//        cq.where(cb.and(where, whereCreatedByOrg));   при whereCreatedByOrg == null - NPE 
       
        if(whereCreatedByOrg == null) { // whereCreatedByOrg инициализируется только когда задана орг-ия
            cq.where(where);    
        } else {
            cq.where(cb.and(where, whereCreatedByOrg));    
        }
  
           
        cq.orderBy(cb.desc(z.get(Request_.id)));
        cq.select(z);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    public List<UserHD> findAll() {
       
        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
64
65
66
67
68
69
70
71
72
73
74
       
        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
78
79
80
81
82
83
84
85
86
87
88
       
        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.