Package javax.persistence.criteria

Examples of javax.persistence.criteria.CriteriaQuery.where()

618
619
620
621
622
623
624
625
626
627
628
         */
        if (filters != null && !filters.isEmpty()) {
            addSimpleFilter (cq, builder, from, filters, predicates);
        }
       
        cq.where(predicates.toArray(new Predicate[predicates.size()]));

        Query q = getEntityManager().createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }

View Full Code Here
648
649
650
651
652
653
654
655
656
657
658
    public int countChildren(T parent)
    {
        CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery(entityClass);
        Root<T> from = cq.from(entityClass);
        cq.select(getEntityManager().getCriteriaBuilder().count(from));
        cq.where(getEntityManager().getCriteriaBuilder().equal(from.get(NamingConstants.PARENT), parent));
        Query q = getEntityManager().createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
   
    public boolean beginTransaction () throws SystemException, NotSupportedException
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
//       filters.add(cb.equal(r.get("intId"), intId));
       filters.add(cb.equal(r.get("serviceRequestPK").get("intFlId"), intFlId));
       filters.add(cb.equal(r.get("serviceRequestPK").get("intRefNumber"), intRefNumber));
//       filters.add(cb.not(cb.in(r.get("_recStatus")).value("X")));
      filters.add(cb.notEqual(r.get("_recStatus"),"X"));
     cq.where(cb.and(filters.toArray(new Predicate[0])));
     List<EntDbServiceRequest> resultList = getEntityManager().createQuery(cq).getResultList();
    
     if (resultList != null && resultList.size() > 0){
      result = resultList.get(0);
        if (resultList.size() > 1){
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
     cq.select(r);
       List<Predicate> filters = new LinkedList<>();
       filters.add(cb.equal(r.get("idLoadPax"), idLoadPax));
//       filters.add(cb.not(cb.in(r.get("_recStatus")).value("X")));
      filters.add(cb.notEqual(r.get("_recStatus"),"X"));
     cq.where(cb.and(filters.toArray(new Predicate[0])));
     result = getEntityManager().createQuery(cq).getResultList();
    
    
     return result;
       }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
     List<Predicate> filters = new LinkedList<>();
     filters.add(cb.equal(r.get("interfaceFltid"), intFlId));
     filters.add(cb.equal(r.get("intRefNumber"),intRefNumber));
//     filters.add(cb.not(cb.in(r.get("_recStatus")).value("X")));
      filters.add(cb.notEqual(r.get("_recStatus"),"X"));
      cq.where(cb.and(filters.toArray(new Predicate[0])));
   
      List<EntDbLoadPaxConnX> resultList = null;
      try {
        resultList = getEntityManager().createQuery(cq).getResultList();
      }catch(Exception e){
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
     List<Predicate> filters = new LinkedList<>();
     filters.add(cb.equal(r.get("paxConxFlno"), paxConxFlno));
     filters.add(cb.equal(r.get("conxFltDate"), conxFltDate));
//     filters.add(cb.not(cb.in(r.get("_recStatus")).value("X")));
      filters.add(cb.notEqual(r.get("_recStatus"),"X"));
      cq.where(cb.and(filters.toArray(new Predicate[0])));
   
        result = getEntityManager().createQuery(cq).getResultList();
   
   
    return result; 
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    CriteriaQuery cq = cb.createQuery();
    Root<EntDbLoadPax> r = cq.from(EntDbLoadPax.class);
//    cq.select(r.get("intId"));
    cq.select(r);
    Predicate predicate = cb.equal(r.get("idFlight"), idFlight);
    cq.where(predicate);
    result= em.createQuery(cq).getResultList();
   
    return result;
    }
   
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
    CriteriaQuery cq = cb.createQuery();
    Root<EntDbLoadPax> r = cq.from(EntDbLoadPax.class);
//    cq.select(r.get("intId"));
    cq.select(r);
    Predicate predicate = cb.equal(r.get("intId"), intId);
    cq.where(predicate);
    List<EntDbLoadPax> resultList = em.createQuery(cq).getResultList();
   
    if (resultList != null && resultList.size() > 0){
      result = resultList.get(0);
    }
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
      filters.add(cb.equal(r.get("intFlId"), intFlId));
      filters.add(cb.equal(r.get("airlineCode"), airlineCode));
      filters.add(cb.equal(r.get("flightNumber"), flightNumber));
      filters.add(cb.equal(r.get("flightNumberSuffice"), flightNumberSuffice));
      filters.add(cb.equal(r.get("scheduledFlightDateTime"), scheduledFlightDateTime));
    cq.where(cb.and(filters.toArray(new Predicate[0])));
    result = getEntityManager().createQuery(cq).getResultList();
     
    return result; 
    }
   
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
      CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
      CriteriaQuery cq = cb.createQuery();
      Root<EntDbLoadPaxConn> r = cq.from(EntDbLoadPaxConn.class);
      cq.select(r);
      Predicate predicate = cb.equal(r.get("idFlight"), idFlight);
      cq.where(predicate);
      result = getEntityManager().createQuery(cq).getResultList();
     
//      if (resultList != null && resultList.size() > 0){
//        result = resultList.get(0);
//      }
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.