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

Class javax.persistence.criteria.CriteriaBuilder

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

javax.persistence.criteria.CriteriaBuilder.between()
Create a predicate for testing whether the first argument is between the second and third arguments in value. @param v expression @param x expression @param y expression @return between predicate

        if (ADID.A.equals(adid)) {
          filters.add(cb.between(root.<String> get("stoa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        } else {
          filters.add(cb.between(root.<String> get("stod"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        }


      }

View Full Code Here

      if (HpUfisUtils.isNotEmptyStr(params.getSTOD())) {
        filters.add(cb.equal(
            cb.trim(Trimspec.BOTH, ' ', root.<String> get("stod")),
            params.getSTOD().trim()));
      }
      filters.add(cb.between(root.<String> get("tifd"),
          ufisCalendarFrom.getCedaString(),
          ufisCalendarTo.getCedaString()));
      filters.add(cb.not(cb.in(root.get("ftyp")).value('T').value('G')));


      cq.where(cb.and(filters.toArray(new Predicate[0])));

View Full Code Here


            Subquery<JPAObject> subquery = query.subquery(JPAObject.class);
            Root fromJPAObject = subquery.from(JPAObject.class);
            subquery.select(fromJPAObject.get("timestamp"));
            Predicate predicate1 = criteriaBuilder.equal(fromJPAObject.get("oid"), oid);
            Predicate predicate2 = criteriaBuilder.between(fromJPAObject.get("timestamp"), from, to);
            subquery.where(criteriaBuilder.and(predicate1, predicate2));


            query.where(criteriaBuilder.in(f.get("timestamp")).value(subquery));
            query.orderBy(criteriaBuilder.asc(f.get("timestamp")));

View Full Code Here

            CriteriaQuery<JPAObject> query = criteriaBuilder.createQuery(JPAObject.class);
            Root f = query.from(JPAObject.class);
            query.select(f);


            Predicate predicate1 = criteriaBuilder.equal(f.get("oid"), oid);
            Predicate predicate2 = criteriaBuilder.between(f.get("timestamp"), from, to);
            query.where(criteriaBuilder.and(predicate1, predicate2));
            query.orderBy(criteriaBuilder.asc(f.get("timestamp")));


            TypedQuery<JPAObject> typedQuery = entityManager.createQuery(query);
            return typedQuery.getResultList();

View Full Code Here

        CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
        Root<E> from = query.from(clazz);
        query.select(from.alias("p"));
        query.where(criteriaBuilder.and(
                criteriaBuilder.equal(from.get(fieldName), name),
                criteriaBuilder.between((Expression) from.get("age"), Integer.parseInt(minVal),
                        Integer.parseInt(maxVal))));


        TypedQuery<E> q = em.createQuery(query);
        List<E> results = q.getResultList();

View Full Code Here

    {
        CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
        CriteriaQuery<E> query = criteriaBuilder.createQuery(clazz);
        Root<E> from = query.from(clazz);
        query.select(from.alias("p"));
        query.where(criteriaBuilder.between((Expression) from.get(fieldName), Integer.parseInt(minVal),
                Integer.parseInt(maxVal)));


        TypedQuery<E> q = em.createQuery(query);
        List<E> results = q.getResultList();

View Full Code Here

        String expected = "Select p from Person p where p.age BETWEEN 10 AND 20";
        CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
        CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
        Root<Person> from = personQuery.from(Person.class);
        personQuery.select(from.alias("p"));
        personQuery.where(criteriaBuilder.between((Expression) from.get("age"), 10, 20));
        String actual = CriteriaQueryTranslator.translate(personQuery);
        Assert.assertEquals(expected.trim(), actual.trim());
    }


    @Test

View Full Code Here

        CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
        CriteriaQuery<Person> personQuery = criteriaBuilder.createQuery(Person.class);
        Root<Person> from = personQuery.from(Person.class);
        personQuery.select(from.alias("p"));
        personQuery.where(criteriaBuilder.and(criteriaBuilder.equal(from.get("personName"), "'vivek'"),
                criteriaBuilder.between((Expression) from.get("age"), 10, 20)));
        String actual = CriteriaQueryTranslator.translate(personQuery);
        Assert.assertEquals(expected.trim(), actual.trim());
    }


    @Test

View Full Code Here

0 1 2

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.