Package javax.persistence.criteria

Examples of javax.persistence.criteria.Predicate

1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
    log.debug("Usermanagement.getUserByLogin : " + login);

    CriteriaBuilder cb = em.getCriteriaBuilder();
    CriteriaQuery<User> cq = cb.createQuery(User.class);
    Root<User> c = cq.from(User.class);
    Predicate condition = cb.equal(c.get("deleted"), false);
    Predicate subCondition = cb.equal(c.get("login"), login);
    cq.where(condition, subCondition);
    TypedQuery<User> q = em.createQuery(cq);
    User u = null;
    try {
      u = q.getSingleResult();
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
      log.debug("updateUser User SID: " + SID);

      CriteriaBuilder cb = em.getCriteriaBuilder();
      CriteriaQuery<Sessiondata> cq = cb.createQuery(Sessiondata.class);
      Root<Sessiondata> c = cq.from(Sessiondata.class);
      Predicate condition = cb.equal(c.get("session_id"), SID);
      cq.where(condition);

      TypedQuery<Sessiondata> q = em.createQuery(cq);

      List<Sessiondata> fullList = q.getResultList();
View Full Code Here
308
309
310
311
312
313
314
315
316
317
318
      log.debug("updateUser User SID: " + SID);

      CriteriaBuilder cb = em.getCriteriaBuilder();
      CriteriaQuery<Sessiondata> cq = cb.createQuery(Sessiondata.class);
      Root<Sessiondata> c = cq.from(Sessiondata.class);
      Predicate condition = cb.equal(c.get("session_id"), SID);
      cq.where(condition);

      TypedQuery<Sessiondata> q = em.createQuery(cq);
      List<Sessiondata> fullList = q.getResultList();
View Full Code Here
348
349
350
351
352
353
354
355
356
357
358
  private void updatesession(String SID) {
    try {
      CriteriaBuilder cb = em.getCriteriaBuilder();
      CriteriaQuery<Sessiondata> cq = cb.createQuery(Sessiondata.class);
      Root<Sessiondata> c = cq.from(Sessiondata.class);
      Predicate condition = cb.equal(c.get("session_id"), SID);
      cq.where(condition);

      TypedQuery<Sessiondata> q = em.createQuery(cq);

      List<Sessiondata> fullList = q.getResultList();
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
        try
        {
            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<Section> cq = cb.createQuery(Section.class);
            Root<Section> sectionRoot = cq.from(Section.class);
            Predicate criteria = cb.conjunction();
            criteria = cb.and(criteria, cb.equal(sectionRoot.get("course").get("name"),
                    section.getCourse().getName()));
            criteria = cb.and(criteria, cb.equal(sectionRoot.get("name"), section.getName()));
            cq.where(criteria);
            TypedQuery<Section> sectionQuery = em.createQuery(cq);
View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
        try
        {
            CriteriaBuilder cb = em.getCriteriaBuilder();
            CriteriaQuery<Section> cq = cb.createQuery(Section.class);
            Root<Section> sectionRoot = cq.from(Section.class);
            Predicate criteria = cb.conjunction();
            criteria = cb.and(criteria, cb.equal(sectionRoot.get("course").get("name"),
                    course.getName()));
            criteria = cb.and(criteria, cb.equal(sectionRoot.get("instructor").get("webID"),
                    instructor.getWebID()));
            criteria = cb.and(criteria, cb.equal(sectionRoot.get("instructor").get("firstName"),
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
        CriteriaQuery<Long> cq = qb.createQuery(Long.class);
        Root<Movie> root = cq.from(Movie.class);
        EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);

        Path<String> path = root.get(type.getDeclaredSingularAttribute(field, String.class));
        Predicate condition = qb.like(path, "%" + searchTerm + "%");

        cq.select(qb.count(root));
        cq.where(condition);

        return entityManager.createQuery(cq).getSingleResult().intValue();
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
        CriteriaQuery<Movie> cq = qb.createQuery(Movie.class);
        Root<Movie> root = cq.from(Movie.class);
        EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);

        Path<String> path = root.get(type.getDeclaredSingularAttribute(field, String.class));
        Predicate condition = qb.like(path, "%" + searchTerm + "%");

        cq.where(condition);
        TypedQuery<Movie> q = entityManager.createQuery(cq);
        q.setMaxResults(maxResults);
        q.setFirstResult(firstResult);
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
        CriteriaQuery<Object> query = cb.createQuery();
        final Root<T> from = query.from(entityType);
        query = query.select(from);

        int i = 0;
        Predicate where = null;
        for (final String condition : conditions) {
            final SingularAttribute<? super T, ?> attribute = et.getSingularAttribute(condition);
            final Path<?> path = from.get(attribute);
            final Class<?> javaType = attribute.getType().getJavaType();

            final Predicate currentClause;
            if (javaType.equals(String.class)) {
                currentClause = cb.like((Expression<String>) path, (String) args[i++]);
            } else if (Number.class.isAssignableFrom(javaType) || javaType.isPrimitive()) {
                currentClause = cb.equal(path, args[i++]);
            } else {
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
        final CriteriaQuery<Movie> query = builder.createQuery(Movie.class);
        final Root<Movie> root = query.from(Movie.class);
        final EntityType<Movie> type = entityManager.getMetamodel().entity(Movie.class);

        final Path<String> path = root.get(type.getDeclaredSingularAttribute(fieldname, String.class));
        final Predicate condition = builder.like(path, "%" + param + "%");

        query.where(condition);

        return entityManager.createQuery(query).getResultList();
    }
View Full Code Here
TOP

Related Classes of javax.persistence.criteria.Predicate

  • br.gov.frameworkdemoiselle.template.JPACrud
  • com.adaptrex.core.persistence.jpa.JPAStoreData
  • com.astech.repository.support.ByRangeSpecifications
  • com.darkhonor.rage.libs.dataaccess.SectionDAO
  • com.github.dactiv.orm.core.spring.data.jpa.restriction.PredicateMultipleValueSupport
  • com.github.dactiv.orm.core.spring.data.jpa.restriction.PredicateSingleValueSupport
  • com.github.dactiv.orm.core.spring.data.jpa.specification.support.PropertySpecification
  • com.impetus.kundera.persistence.CriteriaQueryTranslator
  • com.insacosa.dataModels_JPA.JPADataModel
  • com.insacosa.interfaces.Inmoble_Impl
    • Copyright © 2018 www.massapicom. 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.