Package javax.persistence.criteria

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

56
57
58
59
60
61
62
63
64
65
66
        CriteriaQuery<Movie> cq = qb.createQuery(Movie.class);
        Root<Movie> root = cq.from(Movie.class);
        EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);
        if (field != null && searchTerm != null && !"".equals(field.trim()) && !"".equals(searchTerm.trim())) {
            Path<String> path = root.get(type.getDeclaredSingularAttribute(field.trim(), String.class));
            Predicate condition = qb.like(path, "%" + searchTerm.trim() + "%");
            cq.where(condition);
        }
        TypedQuery<Movie> q = entityManager.createQuery(cq);
        if (maxResults != null) {
            q.setMaxResults(maxResults);
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
        Root<Movie> root = cq.from(Movie.class);
        EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);
        cq.select(qb.count(root));
        if (field != null && searchTerm != null && !"".equals(field.trim()) && !"".equals(searchTerm.trim())) {
            Path<String> path = root.get(type.getDeclaredSingularAttribute(field.trim(), String.class));
            Predicate condition = qb.like(path, "%" + searchTerm.trim() + "%");
            cq.where(condition);
        }
        return entityManager.createQuery(cq).getSingleResult().intValue();
    }
View Full Code Here
365
366
367
368
369
370
371
372
373
374
375
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<User> cq = cb.createQuery(User.class);
        Root<User> c = cq.from(User.class);
        Expression<String> literal = cb.literal("%" + searchstring + "%");
        Path<String> path = c.get(searchcriteria);
        Predicate predicate = cb.like(path, literal);
        Predicate condition = cb.notEqual(c.get("deleted"), true);
        cq.where(condition, predicate);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
            //Select Products containing the letter "I" in their name
            System.out.println("*** SELECT PRODUCTS CONTAINING THE LETTER 'I' IN THEIR NAME");
            criteriaQuery = criteriaBuilder.createQuery(Product.class);
            product = criteriaQuery.from(Product.class);
            criteriaQuery.select(product).where(criteriaBuilder.like(product.<String>get("name"), "%I%"));
            products = em.createQuery(criteriaQuery).getResultList();
            for (Product p : products) {
                System.out.printf("[%s] : %s, %s\n", p.getId(), p.getName(), p.getDescription());
            }

View Full Code Here
364
365
366
367
368
369
370
371
372
373
374
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<User> cq = cb.createQuery(User.class);
        Root<User> c = cq.from(User.class);
        Expression<String> literal = cb.literal("%" + searchstring + "%");
        Path<String> path = c.get(searchcriteria);
        Predicate predicate = cb.like(path, literal);
        Predicate condition = cb.notEqual(c.get("deleted"), true);
        cq.where(condition, predicate);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
        }
        if (codeFragment.getLanguage() != null) {
            predicates.add(builder.equal(root.get(CodeFragment_.language), codeFragment.getLanguage()));
        }
        if (!isEmpty(codeFragment.getText())) {
            predicates.add(builder.like(root.get(CodeFragment_.text), "%" + codeFragment.getText().toLowerCase().trim() + "%"));
        }
        if (codeFragment.getDatetime() != null) {
            predicates.add(builder.between(root.get(CodeFragment_.datetime), codeFragment.getDatetime(), new Date()));
        }
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
        }
        if (codeFragment.getLanguage() != null) {
            predicates.add(builder.equal(root.get(CodeFragment_.language), codeFragment.getLanguage()));
        }
        if (!isEmpty(codeFragment.getText())) {
            predicates.add(builder.like(root.get(CodeFragment_.text), "%" + codeFragment.getText().toLowerCase().trim() + "%"));
        }
        if (codeFragment.getDatetime() != null) {
            predicates.add(builder.between(root.get(CodeFragment_.datetime), codeFragment.getDatetime(), new Date()));
        }
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
        CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();

        CriteriaQuery<Ingredient> criteriaQuery = cb
                .createQuery(Ingredient.class);
        Root<Ingredient> i = criteriaQuery.from(Ingredient.class);
        criteriaQuery.where(cb.like(i.<String> get("label"),
                cb.parameter(String.class, "label")));
        TypedQuery<Ingredient> tq = getEntityManager().createQuery(
                criteriaQuery);
        tq.setParameter("label", label);
View Full Code Here
221
222
223
224
225
226
227
228
229
230
231
        // We only want results that match the search query
        List<Predicate> restrictions = new ArrayList<Predicate>();
        String lq = query.toLowerCase();
        restrictions.add(
            builder.or(
                builder.like(builder.lower(sku.get("name").as(String.class)), '%' + lq + '%'),
                builder.like(builder.lower(sku.get("longDescription").as(String.class)), '%' + lq + '%')
            )
        );
               
        attachProductSearchCriteria(searchCriteria, product, sku, restrictions);
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
        List<Predicate> restrictions = new ArrayList<Predicate>();
        String lq = query.toLowerCase();
        restrictions.add(
            builder.or(
                builder.like(builder.lower(sku.get("name").as(String.class)), '%' + lq + '%'),
                builder.like(builder.lower(sku.get("longDescription").as(String.class)), '%' + lq + '%')
            )
        );
               
        attachProductSearchCriteria(searchCriteria, product, sku, restrictions);
       
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.