List of notEqual() Examples

Examples of notEqual()

com.google.code.lightssh.common.dao.SearchCondition.notEqual()
不等查询
javax.persistence.criteria.CriteriaBuilder.notEqual()
Create a predicate for testing the arguments for inequality. @param x expression @param y expression @return inequality predicate
org.opengis.filter.FilterFactory.notEqual()
Checks that the first sub-expression is not equal to the second subexpression.
org.opengis.filter.FilterFactory2.notEqual()

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


     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();

View Full Code Here

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

       
//       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);

View Full Code Here

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

   //  cq.select(r.get("intId"));
     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

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

//        cq.where(predicate);
        
          List<Predicate> filters = new LinkedList<>();
          filters.add(cb.equal(r.get("taskId"), taskId));
//          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<EntDbFltJobTask> resultList = em.createQuery(cq).getResultList();
        
        if (resultList != null && resultList.size() > 0){
          result = resultList.get(0);

View Full Code Here

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

    cq.select(r);
//    Predicate predicate = cb.equal(r.get("idFltJobTask"), idFltJobTask);
//    cq.where(predicate);
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("idFltJobTask"), idFltJobTask));
      filters.add(cb.notEqual(r.get("recStatus"),"X"));
//      filters.add(cb.not(cb.in(r.get("recStatus")).value('X')));
    cq.where(cb.and(filters.toArray(new Predicate[0])));
//      List<Predicate> filters = new LinkedList<>();
//      filters.add(cb.equal(r.get("shiftId"), shiftId));
//      filters.add(cb.equal(r.get("idFltJobTask"), idFltJobTask));

View Full Code Here

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

//    Predicate predicate = cb.equal(r.get("shiftId"), shiftId);
//    cq.where(predicate);
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("shiftId"), shiftId));
//      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<Predicate> filters = new LinkedList<>();
//      filters.add(cb.equal(r.get("shiftId"), shiftId));
////      filters.add(cb.equal(r.get("intRefNumber"), paxRefNum));

View Full Code Here

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

//    cq.where(predicate);
    
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("shiftId"), shiftId));
//      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<EntDbStaffShift> resultList = em.createQuery(cq).getResultList();
    
    if (resultList != null && resultList.size() > 0){

View Full Code Here

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

//    cq.where(predicate);  
    
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("idFltJobTask"), idFltJobTask));
//      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])));


    resultList = em.createQuery(cq).getResultList();
    
//    if (resultList != null && resultList.size() > 0){

View Full Code Here

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

      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("pKId").get("intFlId"), pKId.getIntflid()));
      filters.add(cb.equal(r.get("pKId").get("intRefNumber"), pKId.getIntrefnumber()));
//      filters.add(cb.equal(r.get("intRefNumber"), paxRefNum));  
//      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<EntDbLoadPax> resultList = em.createQuery(cq).getResultList();
    
    if (resultList != null && resultList.size() > 0){
      result = resultList.get(0);

View Full Code Here

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

            Predicate subPredicate1 = criteriaBuilder.equal(from.get("oid"), f.get("oid"));
            Predicate subPredicate2 = criteriaBuilder.equal(f.get("isDeleted"), Boolean.TRUE);
            Predicate subPredicate3 = criteriaBuilder.gt(from.get("timestamp"), f.get("timestamp"));
            sub.where(criteriaBuilder.and(subPredicate1, subPredicate2, subPredicate3));


            Predicate predicate1 = criteriaBuilder.notEqual(from.get("isDeleted"), Boolean.TRUE);
            Predicate predicate2 = criteriaBuilder.exists(sub);
            query.where(predicate1, predicate2);


            TypedQuery<String> typedQuery = entityManager.createQuery(query);
            return typedQuery.getResultList();

View Full Code Here

0 1 2 3 4

TOP

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.