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

Class javax.persistence.criteria.CriteriaBuilder

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

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

  public void shouldFindCustomersOlderThan40() throws Exception {
    // select c from Customer c where c.age > 40
    CriteriaBuilder builder = em.getCriteriaBuilder();
    CriteriaQuery<Customer24> query = builder.createQuery(Customer24.class);
    Root<Customer24> c = query.from(Customer24.class);
    query.select(c).where(builder.greaterThan(c.get("age").as(Integer.class), 40));
    assertEquals(4, em.createQuery(query).getResultList().size());
  }


//  @Test
//  public void shouldFindCustomersOlderThan40WithMetaModel() throws Exception {

View Full Code Here

        
        // Add the active start/end date restrictions
        restrictions.add(builder.lessThan(sku.get("activeStartDate").as(Date.class), currentDate));
        restrictions.add(builder.or(
                            builder.isNull(sku.get("activeEndDate")),
                builder.greaterThan(sku.get("activeEndDate").as(Date.class), currentDate)));
    }
    
    protected void attachOrderBy(ProductSearchCriteria searchCriteria, 
            From<?, ? extends Product> product, Path<? extends Sku> sku, CriteriaQuery<?> criteria) {
        if (StringUtils.isNotBlank(searchCriteria.getSortQuery())) {

View Full Code Here

                BigDecimal max = null;
                if (range[1] != null && !range[1].equals("null")) {
                    max = new BigDecimal(range[1]);
                }
                
                Predicate minRange = builder.greaterThan(pathToUse.get(key).as(BigDecimal.class), min);
                Predicate maxRange = null;
                if (max != null) {
                    maxRange = builder.lessThan(pathToUse.get(key).as(BigDecimal.class), max);
                    rangeRestrictions.add(builder.and(minRange, maxRange));
                } else {

View Full Code Here

          } else if (t == Filter.LESS_THAN) {
            predicates.add(builder.lessThan(datePath, dateVal));
          } else if (t == Filter.LESS_THAN_EQUAL) {
            predicates.add(builder.lessThanOrEqualTo(datePath, dateVal));
          } else if (t == Filter.GREATER_THAN) {
            predicates.add(builder.greaterThan(datePath, dateVal));
          } else if (t == Filter.GREATER_THAN_EQUAL) {
            predicates.add(builder.greaterThanOrEqualTo(datePath, dateVal));
          }
        }
      }

View Full Code Here

          } else if (t == Filter.LESS_THAN) {
            predicates.add(builder.lessThan(datePath, dateVal));
          } else if (t == Filter.LESS_THAN_EQUAL) {
            predicates.add(builder.lessThanOrEqualTo(datePath, dateVal));
          } else if (t == Filter.GREATER_THAN) {
            predicates.add(builder.greaterThan(datePath, dateVal));
          } else if (t == Filter.GREATER_THAN_EQUAL) {
            predicates.add(builder.greaterThanOrEqualTo(datePath, dateVal));
          }
        }
      }

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.