Package javax.persistence.criteria

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

214
215
216
217
218
219
220
221
222
223
224
     List<Predicate> filters = new LinkedList<>();
     filters.add(cb.equal(r.get("paxConnPK").get("interfaceFltid"), intFlId));
     filters.add(cb.equal(r.get("paxConnPK").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<EntDbLoadPaxConn> resultList = null;
      try {
        resultList = getEntityManager().createQuery(cq).getResultList();
      }catch(Exception e){
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
     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])));
   
      List<EntDbLoadPaxConn> resultList = null;
      try {
        resultList = getEntityManager().createQuery(cq).getResultList();
      }catch(Exception e){
View Full Code Here
281
282
283
284
285
286
287
288
289
290
291
     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
64
65
66
67
68
69
70
71
72
73
74
//       filters.add(cb.equal(r.get("intId"), intId));
       filters.add(cb.equal(r.get("intFlId"), 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<EntDbServiceRequestX> resultList = getEntityManager().createQuery(cq).getResultList();
    
     if (resultList != null && resultList.size() > 0){
      result = resultList.get(0);
        if (resultList.size() > 1){
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
     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
123
124
125
126
127
128
129
130
131
132
133
     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])));
   
      List<EntDbLoadPaxConnX> resultList = null;
      try {
        resultList = getEntityManager().createQuery(cq).getResultList();
      }catch(Exception e){
View Full Code Here
2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
2101
    CriteriaBuilder cb = em.getCriteriaBuilder();
    CriteriaQuery cq = cb.createQuery();
    Root r = cq.from(entityClass);
    cq.select(r.get(x));
    Predicate predicate = cb.equal(r.get("staffTypeCode"), staffType);
    cq.where(predicate);
    return em.createQuery(cq).getResultList();
  }

  private List<Object> findAllByColumnList(Class entityClass,
      List<String> colsToSelect, Map<String, String> whereClauseCriteria) {
View Full Code Here
284
285
286
287
288
289
290
291
292
293
294
    CriteriaBuilder builder = em.getCriteriaBuilder();
    CriteriaQuery criteriaQuery = builder.createQuery(clazz.getClass());
    Root root = criteriaQuery.from(clazz.getClass());
   
    Predicate predicate = spec.toPredicate(root, criteriaQuery, builder);
    criteriaQuery.where(predicate);
   
    List<Object> objects = em.createQuery(criteriaQuery).getResultList();
    if (ids != null) {
      if (objects.size() == ids.length) {
        return true;
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
        String jpql = "SELECT d FROM Department d LEFT JOIN FETCH d.employees "
                + "WHERE d.deptNo = 1";
        CriteriaQuery q = cb.createQuery();
        Root<Department> d = q.from(Department.class);
        d.fetch(department_.getSet("employees", Employee.class), JoinType.LEFT);
        q.where(
                cb.equal(d.get(department_
                        .getSingularAttribute("deptNo", Integer.class)), 1)).select(d);

        assertEquivalence(q, jpql);
    }
View Full Code Here
266
267
268
269
270
271
272
273
274
275
276
        Root<Order> o = q.from(Order.class);
        Join<Order, LineItem> i = o.join(order_.getList("lineItems",
                LineItem.class));
        Join<Order, Customer> c = o.join(order_.getSingularAttribute("customer",
                Customer.class));
        q.where(cb.equal(c.get(customer_.getSingularAttribute("lastName", String.class)), "Smith"),
                cb.equal(c.get(customer_.getSingularAttribute("firstName", String.class)), "John"));
        q.select(cb.sum(i.get(lineItem_.getSingularAttribute("price", Double.class))));

        assertEquivalence(q, jpql);
    }
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.