Examples of between()


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

            predicates.add(matchAuthor);
        }
        // for price fields, also the comparison operation changes based on whether
        // minimum or maximum price or both have been filled.
        if (minPrice != null && maxPrice != null) {
            Predicate matchPrice = cb.between(book.get(Book_.price), minPrice, maxPrice);
            predicates.add(matchPrice);
        } else if (minPrice != null && maxPrice == null) {
            Predicate matchPrice = cb.ge(book.get(Book_.price), minPrice);
            predicates.add(matchPrice);
        } else if (minPrice == null && maxPrice != null) {
View Full Code Here

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

        }
        if (!isEmpty(codeFragment.getText())) {
            predicates.add(builder.like(root.get(CodeFragment_.text), "%" + codeFragment.getText().toLowerCase().trim() + "%"));
        }
        if (codeFragment.getDatetime() != null) {
            predicates.add(builder.between(root.get(CodeFragment_.datetime), codeFragment.getDatetime(), new Date()));
        }

        criteria.where(predicates.toArray(new Predicate[0])).orderBy(builder.desc(root.get(CodeFragment_.datetime)));

        Query q = entityManager.createQuery(criteria);
View Full Code Here

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

        }
        if (!isEmpty(codeFragment.getText())) {
            predicates.add(builder.like(root.get(CodeFragment_.text), "%" + codeFragment.getText().toLowerCase().trim() + "%"));
        }
        if (codeFragment.getDatetime() != null) {
            predicates.add(builder.between(root.get(CodeFragment_.datetime), codeFragment.getDatetime(), new Date()));
        }

        criteria.where(predicates.toArray(new Predicate[predicates.size()])).orderBy(builder.desc(root.get(CodeFragment_.datetime)));

        Query q = entityManager.createQuery(criteria);
View Full Code Here

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

    if (adid != null && egdsMsgType != MSGTYPE.ROUTE) {
      if (MSGTYPE.MVT == egdsMsgType) {
        // time range
        if (ADID.A == adid) {
          filters.add(cb.between(root.<String> get("stoa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        } else {
          filters.add(cb.between(root.<String> get("stod"),
              ufisCalendarFrom.getCedaString(),
View Full Code Here

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

        if (ADID.A == 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()));
        }
      } else if (MSGTYPE.ROUTE == egdsMsgType) {
        // time range
View Full Code Here

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

              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
        }
      } else if (MSGTYPE.ROUTE == egdsMsgType) {
        // time range
        filters.add(cb.between(root.<String> get("tifd"),
            ufisCalendarFrom.getCedaString(),
            ufisCalendarTo.getCedaString()));
        // atot (actual takeo-ff time)
        // filters.add(cb.equal(root.<String>get("atot"), " "));
        filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
View Full Code Here

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

        // filters.add(cb.equal(root.<String>get("aobt"), " "));
        filters.add(cb.isNull(cb.trim(root.<String> get("aobt"))));
      } else {
        if (ADID.A == adid) {
          // time range
          filters.add(cb.between(root.<String> get("tifa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
          if (MSGTYPE.FUEL == egdsMsgType) {
            // aldt
            filters.add(cb.isNotNull(cb.trim(root
View Full Code Here

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

            filters.add(cb.isNotNull(cb.trim(root
                .<String> get("aldt"))));
          }
        } else {
          // time range
          filters.add(cb.between(root.<String> get("tifd"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
          if (MSGTYPE.FUEL == egdsMsgType) {
            filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
            filters.add(cb.isNull(cb.trim(root.<String> get("aobt"))));
View Full Code Here

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

    } else {
      // (adid = A And tifa between x and y) or (adid = D And tifd between
      // x and y)
      Predicate p = cb.and(cb.or(cb.and(
          cb.equal(root.get("adid"), HpEKConstants.ADID_A),
          cb.between(root.<String> get("tifa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString())), cb.and(
          cb.equal(root.get("adid"), HpEKConstants.ADID_D),
          cb.between(root.<String> get("tifd"),
              ufisCalendarFrom.getCedaString(),
View Full Code Here

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

          cb.equal(root.get("adid"), HpEKConstants.ADID_A),
          cb.between(root.<String> get("tifa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString())), cb.and(
          cb.equal(root.get("adid"), HpEKConstants.ADID_D),
          cb.between(root.<String> get("tifd"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()))));
      filters.add(p);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.