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

Class javax.persistence.criteria.CriteriaBuilder

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

javax.persistence.criteria.CriteriaBuilder.lt()
Create a predicate for testing whether the first argument is less than the second. @param x expression @param y expression @return less-than predicate


    CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
    CriteriaQuery<Order> criteria = criteriaBuilder.createQuery( Order.class );
    Root<Order> orderRoot = criteria.from( Order.class );
    Join<Order, LineItem> lineItemsJoin = orderRoot.join( Order_.lineItems );
    criteria.where( criteriaBuilder.lt( lineItemsJoin.get( LineItem_.quantity ), 2 ) );
    criteria.select( orderRoot ).distinct( true );
    TypedQuery<Order> query = em.createQuery( criteria );
    query.getResultList();


    em.getTransaction().commit();

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.gt((Expression) from.get("age"), Integer.parseInt(minVal)),
                criteriaBuilder.lt((Expression) from.get("age"), Integer.parseInt(maxVal))));


        // // // find by name, age clause
        TypedQuery<E> q = em.createQuery(query);
        List<E> results = q.getResultList();
        Assert.assertNotNull(results);

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.or(criteriaBuilder.equal(from.get("personName"), "vivek"),
                criteriaBuilder.lt((Expression) from.get("age"), new Integer(32))));
        String actual = CriteriaQueryTranslator.translate(personQuery);
        Assert.assertEquals(expected.trim(), actual.trim());
    }


    @Test

View Full Code Here

          if (t == Filter.EQUAL) {
            predicates.add(builder.equal(numPath, numVal));
          } else if (t == Filter.NOT_EQUAL) {
            predicates.add(builder.notEqual(numPath, numVal));
          } else if (t == Filter.LESS_THAN) {
            predicates.add(builder.lt(numPath, numVal));
          } else if (t == Filter.LESS_THAN_EQUAL) {
            predicates.add(builder.le(numPath, numVal));
          } else if (t == Filter.GREATER_THAN) {
            predicates.add(builder.gt(numPath, numVal));
          } else if (t == Filter.GREATER_THAN_EQUAL) {

View Full Code Here

          if (t == Filter.EQUAL) {
            predicates.add(builder.equal(numPath, numVal));
          } else if (t == Filter.NOT_EQUAL) {
            predicates.add(builder.notEqual(numPath, numVal));
          } else if (t == Filter.LESS_THAN) {
            predicates.add(builder.lt(numPath, numVal));
          } else if (t == Filter.LESS_THAN_EQUAL) {
            predicates.add(builder.le(numPath, numVal));
          } else if (t == Filter.GREATER_THAN) {
            predicates.add(builder.gt(numPath, numVal));
          } else if (t == Filter.GREATER_THAN_EQUAL) {

View Full Code Here

        {
          predicate = cb.ge(propertyExpression, obtainNumber(value, beanClass, property));
        }
        else if (PersistenceCriterion.OPERATOR_LT.equals(operator))
        {
          predicate = cb.lt(propertyExpression, obtainNumber(value, beanClass, property));
        }
        else if (PersistenceCriterion.OPERATOR_LTE.equals(operator))
        {
          predicate = cb.le(propertyExpression, obtainNumber(value, beanClass, property));
        }

View Full Code Here

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.