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

Class javax.persistence.criteria.CriteriaBuilder

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

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

        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.le((Expression) from.get("age"), new Integer(32))));
        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.gt((Expression)from.get("age"), 32),criteriaBuilder.le((Expression)from.get("salary"), 3200.01)));
        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.gt((Expression)from.get("age"), 32),criteriaBuilder.le((Expression)from.get("salary"), 3200.01)));
        personQuery.orderBy(criteriaBuilder.desc(from.get("personName")));
        String actual = CriteriaQueryTranslator.translate(personQuery);
        Assert.assertEquals(expected.trim(), actual.trim());
    }

View Full Code Here

          } 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) {
            predicates.add(builder.ge(numPath, numVal));
          }

View Full Code Here

            continue;
          } else if (t == Filter.NOT_EQUAL) {
            log.warn("Adaptrex Store Error: Filter: Float inequality not implemented: " + val);
            continue;
          } else if (t == Filter.LESS_THAN || t == Filter.LESS_THAN_EQUAL) {
            predicates.add(builder.le(numPath, numVal));
          } else if (t == Filter.GREATER_THAN || t == Filter.GREATER_THAN_EQUAL) {
            predicates.add(builder.ge(numPath, numVal));
          }          
          
        /*

View Full Code Here

          } 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) {
            predicates.add(builder.ge(numPath, numVal));
          }

View Full Code Here

            continue;
          } else if (t == Filter.NOT_EQUAL) {
            log.warn("Adaptrex Store Error: Filter: Float inequality not implemented: " + val);
            continue;
          } else if (t == Filter.LESS_THAN || t == Filter.LESS_THAN_EQUAL) {
            predicates.add(builder.le(numPath, numVal));
          } else if (t == Filter.GREATER_THAN || t == Filter.GREATER_THAN_EQUAL) {
            predicates.add(builder.ge(numPath, numVal));
          }          
          
        /*

View Full Code Here

        {
          predicate = cb.lt(propertyExpression, obtainNumber(value, beanClass, property));
        }
        else if (PersistenceCriterion.OPERATOR_LTE.equals(operator))
        {
          predicate = cb.le(propertyExpression, obtainNumber(value, beanClass, property));
        }
        else if (PersistenceCriterion.OPERATOR_LIKE.equals(operator))
        {
          predicate = cb.like((Expression<String>) propertyExpression, (String) value);
        }

View Full Code Here

                        (criteriaBuilder.like(from.get("apartment"), apart)));
            } else {
                select.where(criteriaBuilder.like(from.get("firstName"), fN),
                        (criteriaBuilder.like(from.get("middleName"), mN)),
                        (criteriaBuilder.like(from.get("lastName"), lN)),
                        (criteriaBuilder.le(from.get("dateOfBirth"), date)),
                        (criteriaBuilder.like(from.get("email"), mail)),
                        (criteriaBuilder.like(from.get("city"), city)),
                        (criteriaBuilder.like(from.get("street"), str)),
                        (criteriaBuilder.like(from.get("house"), house)),
                        (criteriaBuilder.like(from.get("apartment"), apart)));

View Full Code Here

0 1

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.