Package javax.persistence.criteria

Examples of javax.persistence.criteria.Predicate

119
120
121
122
123
124
125
126
127
128
129
    // select-clause
    Root<Invoice> root = critQuery.from(Invoice.class);
    critQuery.select(root);
   
        // where-clause
        Predicate wherePredicate = whereClauseForFilter(critBuilder, critQuery, root, filter);
        if (wherePredicate != null) {
            critQuery.where(wherePredicate);
        }
       
        // order-by-clause
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
    // select-clause
    Root<Invoice> root = critQuery.from(Invoice.class);
    critQuery.select(critBuilder.count(root));
   
        // where-clause
        Predicate wherePredicate = whereClauseForFilter(critBuilder, critQuery, root, filter);
        if (wherePredicate != null) {
            critQuery.where(wherePredicate);
        }
   
    Number count = em.createQuery(critQuery).getSingleResult();
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    // select-clause
    Root<Purchaser> root = critQuery.from(Purchaser.class);
    critQuery.select(root);
   
        // where-clause
        Predicate wherePredicate = whereClauseForFilter(critBuilder, critQuery, root, filter);
        if (wherePredicate != null) {
            critQuery.where(wherePredicate);
        }
        critQuery.orderBy(critBuilder.asc(root.get(Purchaser_.name)));
       
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    // select-clause
    Root<Purchaser> root = critQuery.from(Purchaser.class);
    critQuery.select(critBuilder.count(root));
   
        // where-clause
        Predicate wherePredicate = whereClauseForFilter(critBuilder, critQuery, root, filter);
        if (wherePredicate != null) {
            critQuery.where(wherePredicate);
        }
   
    Number count = em.createQuery(critQuery).getSingleResult();
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
        CriteriaQuery<Movie> query = builder.createQuery(Movie.class);
        Root<Movie> root = query.from(Movie.class);
        EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);

        Path<String> path = root.get(type.getDeclaredSingularAttribute(fieldname, String.class));
        Predicate condition = builder.like(path, "%" + param + "%");

        query.where(condition);

        return entityManager.createQuery(query).getResultList();
    }
View Full Code Here
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
        CriteriaQuery<Object> query = cb.createQuery();
        Root<T> from = query.from(entityType);
        query = query.select(from);

        int i = 0;
        Predicate where = null;
        for (String condition : conditions) {
            SingularAttribute<? super T, ?> attribute = et.getSingularAttribute(condition);
            Path<?> path = from.get(attribute);
            Class<?> javaType = attribute.getType().getJavaType();

            Predicate currentClause;
            if (javaType.equals(String.class)) {
                currentClause = cb.like((Expression<String>) path, (String) args[i++]);
            } else if (Number.class.isAssignableFrom(javaType) || javaType.isPrimitive()) {
                currentClause = cb.equal(path, args[i++]);
            } else {
View Full Code Here
399
400
401
402
403
404
405
406
407
408
409
410
411
                "in (a.embed1s) e where e.name1 like '%1' and a.embed1s IS NOT EMPTY and " +
                " e.b IS NOT NULL order by e";
        CriteriaQuery<?> q = cb.createQuery();
        Root<EntityA_Coll_Embed_ToOne> a = q.from(EntityA_Coll_Embed_ToOne.class);
        Join<EntityA_Coll_Embed_ToOne, Embed_ToOne> e = a.join(EntityA_Coll_Embed_ToOne_.embed1s);
        Predicate p1 = cb.like(e.get(Embed_ToOne_.name1), "%1");
        Predicate p2 = cb.isEmpty(a.get(EntityA_Coll_Embed_ToOne_.embed1s)).not();
        Predicate p3 = cb.isNotNull(e.get(Embed_ToOne_.b));
        q.where(cb.and(cb.and(p1, p2), p3));
        q.orderBy(cb.asc(e));
        q.multiselect(e, e.get(Embed_ToOne_.b).get(EntityB1_.id));
       
        assertEquivalence(q, jpql);
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
439
        Subquery<EntityB1> sq2 = q.subquery(EntityB1.class);
        Root<EntityA_Coll_Embed_ToOne> a2 = sq2.correlate(a);
        Join<EntityA_Coll_Embed_ToOne, Embed_ToOne> e2 = a2.join(EntityA_Coll_Embed_ToOne_.embed1s);
        sq2.select(e2.get(Embed_ToOne_.b));
       
        Predicate p1 = cb.exists(sq1);
        Predicate p2 = cb.exists(sq2);
        q.where(cb.and(p1, p2));
        q.orderBy(cb.asc(e));
        q.multiselect(e, e.get(Embed_ToOne_.b).get(EntityB1_.id));
       
        executeExpectFail(q, jpql);
View Full Code Here
317
318
319
320
321
322
323
324
325
326
327
328
        CriteriaBuilder cb = oemf.getCriteriaBuilder();
        CriteriaQuery<SimpleEntity> c = cb.createQuery(SimpleEntity.class);
        Root<SimpleEntity> root = c.from(SimpleEntity.class);
        ParameterExpression<Long> param1 = cb.parameter(long.class, "id");
        ParameterExpression<String> param2 = cb.parameter(String.class, "name");
        Predicate p1 = cb.equal(root.get(id), param1);
        Predicate p2 = cb.equal(root.get(name), param2);
        c.where(cb.and(p1,p2));
       
        Query q = em.createQuery(c);
        assertEquals(2, q.getParameters().size());
        assertTrue(q.getParameters().contains(param1));
View Full Code Here
342
343
344
345
346
347
348
349
350
351
352
353
        CriteriaBuilder cb = oemf.getCriteriaBuilder();
        CriteriaQuery<SimpleEntity> c = cb.createQuery(SimpleEntity.class);
        Root<SimpleEntity> root = c.from(SimpleEntity.class);
        ParameterExpression<Long> param1 = cb.parameter(long.class);
        ParameterExpression<String> param2 = cb.parameter(String.class);
        Predicate p1 = cb.equal(root.get(id), param1);
        Predicate p2 = cb.equal(root.get(name), param2);
        c.where(cb.and(p1,p2));
       
        Query q = em.createQuery(c);
        assertEquals(2, q.getParameters().size());
        assertTrue(q.getParameters().contains(param1));
View Full Code Here
TOP

Related Classes of javax.persistence.criteria.Predicate

  • br.gov.frameworkdemoiselle.template.JPACrud
  • com.adaptrex.core.persistence.jpa.JPAStoreData
  • com.astech.repository.support.ByRangeSpecifications
  • com.darkhonor.rage.libs.dataaccess.SectionDAO
  • com.github.dactiv.orm.core.spring.data.jpa.restriction.PredicateMultipleValueSupport
  • com.github.dactiv.orm.core.spring.data.jpa.restriction.PredicateSingleValueSupport
  • com.github.dactiv.orm.core.spring.data.jpa.specification.support.PropertySpecification
  • com.impetus.kundera.persistence.CriteriaQueryTranslator
  • com.insacosa.dataModels_JPA.JPADataModel
  • com.insacosa.interfaces.Inmoble_Impl
    • Copyright © 2018 www.massapicom. 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.