Package javax.persistence.criteria

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

44
45
46
47
48
49
50
51
52
53
54
        CriteriaQuery<Member> criteria = cb.createQuery(Member.class);
        Root<Member> member = criteria.from(Member.class);
        // Swap criteria statements if you would like to try out type-safe criteria queries, a new
        // feature in JPA 2.0
        // criteria.select(member).where(cb.equal(member.get(Member_.name), email));
        criteria.select(member).where(cb.equal(member.get("email"), email));
        return em.createQuery(criteria).getSingleResult();
    }

    public List<Member> findAllOrderedByName() {
        CriteriaBuilder cb = em.getCriteriaBuilder();
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
      criteriaQuery.from(Evento.class);
   
    criteriaQuery.select(root)
      .where(
        criteriaBuilder.and(
            criteriaBuilder.equal(root.get("agenda").get("colaborador"), colaborador ),
            criteriaBuilder.between(root.get("dataIncial").as(Date.class), dataInicial, dataFinal)
          )
      );
   
    return entityManager
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
   
   
    criteriaQuery.select(root)
      .where(
          criteriaBuilder.and(
            criteriaBuilder.equal(root.get("dataTransacao").as(Date.class),date ),
            criteriaBuilder.equal(root.get("conta"),conta)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataTransacao").as(Date.class))
          );
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
   
    criteriaQuery.select(root)
      .where(
          criteriaBuilder.and(
            criteriaBuilder.equal(root.get("dataTransacao").as(Date.class),date ),
            criteriaBuilder.equal(root.get("conta"),conta)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataTransacao").as(Date.class))
          );
   
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
   
    criteriaQuery.select(root)
      .where(
          criteriaBuilder.and(
              criteriaBuilder.between(root.get("dataTransacao").as(Date.class), dataInicial, dataFinal),
              criteriaBuilder.equal(root.get("conta"),conta)
            )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataTransacao").as(Date.class))
          );
   
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    criteriaQuery.select(root)
      .where(
          criteriaBuilder.and(
            criteriaBuilder.between(root.get("dataLancamento").as(Date.class), dataInicial, dataFinal),
            criteriaBuilder.equal(root.get("colaborador"), colaborador)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataLancamento").as(Date.class))
          );
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    criteriaQuery.select(root)
      .where(
          criteriaBuilder.and(
            criteriaBuilder.between(root.get("dataLancamento").as(Date.class), dataInicial, dataFinal),
            criteriaBuilder.equal(root.get("cliente"), cliente)
          )
        ).orderBy(
            criteriaBuilder.asc(root.get("dataLancamento").as(Date.class))
          );
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
    Root<Lancamento> root =
        criteriaQuery.from(Lancamento.class);

    criteriaQuery.select(root)
      .where(criteriaBuilder.equal(root.get("cliente"), cliente));

    return entityManager
        .createQuery(criteriaQuery)
        .getResultList();
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        criteriaQuery.from(Sprint.class);


    criteriaQuery
      .select(root)
      .where(criteriaBuilder.equal(root.get("sprintStatus"), sprintStatus));


    try {
      // FIXME:3 the same about fixme above.
      return entityManager
View Full Code Here
533
534
535
536
537
538
539
540
541
542
543
            CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
            CriteriaQuery<? extends IBean> criteriaQuery = criteriaBuilder.createQuery(beanClass);
            Root<? extends IBean> beanRoot = criteriaQuery.from(beanClass);
            if (name != null)
            {
                criteriaQuery.where((value != null) ? criteriaBuilder.equal(beanRoot.get(name), value) : criteriaBuilder.isNull(beanRoot.get(name)));
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
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.