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

Class javax.persistence.criteria.CriteriaBuilder

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

javax.persistence.criteria.CriteriaBuilder.like()
Create a predicate for testing whether the expression satisfies the given pattern. @param x string expression @param pattern string expression @return like predicate

    CriteriaQuery<Movie> cq = qb.createQuery(Movie.class);
    Root<Movie> root = cq.from(Movie.class);
        EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);


        Path<String> path = root.get(type.getDeclaredSingularAttribute(field, String.class));
        Predicate condition = qb.like(path, "%" + searchTerm + "%");
        
        cq.where(condition);
        TypedQuery<Movie> q = entityManager.createQuery(cq);
        q.setMaxResults(maxResults);
        q.setFirstResult(firstResult);

View Full Code Here

        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

        Expression<String> literal = cb.literal("%" + searchstring
            + "%");
        // crit.add(Restrictions.ilike(searchcriteria, "%" +
        // 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

        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

        } else {
            query.orderBy(cb.desc(product.get("price")));
        }


        if(filter != null && filter.length() > 0) {
            query.where(cb.like(product.<String>get("name"), filter + "%"));
        }


        return em.createQuery(query).getResultList();


    }

View Full Code Here

    @Override
    public List<User> findByNamePattern(String namepattern) {
        CriteriaBuilder builder = em.getCriteriaBuilder();
        CriteriaQuery<User> query = builder.createQuery(User.class);
        Root<User> userquery = query.from(User.class);
        return em.createQuery(query.where(builder.like(userquery.get(User_.username), namepattern))).getResultList();
    }


    @Override
    public int count() {
        CriteriaQuery<Long> cq = em.getCriteriaBuilder().createQuery(Long.class);

View Full Code Here

           */
          } else if (filter.getAnyMatch()) {
            if (stringOrParts != null) {
              List<Predicate> orParts = new ArrayList<Predicate>();
              for (String orPart : stringOrParts) {
                orParts.add(builder.like((Expression<String>) path, "%" + orPart + "%"));
              }
              predicates.add(builder.or(orParts.toArray(new Predicate[orParts.size()])));
            } else {
              predicates.add(builder.like((Expression<String>) path, "%" + stringVal + "%"));
            }

View Full Code Here

              for (String orPart : stringOrParts) {
                orParts.add(builder.like((Expression<String>) path, "%" + orPart + "%"));
              }
              predicates.add(builder.or(orParts.toArray(new Predicate[orParts.size()])));
            } else {
              predicates.add(builder.like((Expression<String>) path, "%" + stringVal + "%"));
            }
            
          /*
           * Otherwise match just the beginning of the string
           */

View Full Code Here

           */
          } else {
            if (stringOrParts != null) {
              List<Predicate> orParts = new ArrayList<Predicate>();
              for (String orPart : stringOrParts) {
                orParts.add(builder.like((Expression<String>) path, orPart + "%"));
              }
              predicates.add(builder.or(orParts.toArray(new Predicate[orParts.size()])));
            } else {
              predicates.add(builder.like((Expression<String>) path, stringVal + "%"));
            }

View Full Code Here

              for (String orPart : stringOrParts) {
                orParts.add(builder.like((Expression<String>) path, orPart + "%"));
              }
              predicates.add(builder.or(orParts.toArray(new Predicate[orParts.size()])));
            } else {
              predicates.add(builder.like((Expression<String>) path, stringVal + "%"));
            }
            
            
          }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

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.