Package javax.persistence.criteria

Examples of javax.persistence.criteria.Predicate

97
98
99
100
101
102
103
104
105
106
107
        EntityTransaction tx = session.getTransaction();
        tx.begin();
        CriteriaBuilder cb = session.getCriteriaBuilder();
        CriteriaQuery<Users> cq = cb.createQuery(Users.class);
        Root<Users> c = cq.from(Users.class);
        Predicate condition = cb.equal(c.get("deleted"), "false");
        cq.where(condition);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
        } else {
View Full Code Here
397
398
399
400
401
402
403
404
405
406
407
408
        Expression<String> literal = cb.literal((String) "%"
            + searchstring + "%");
        // crit.add(Restrictions.ilike(searchcriteria, "%" +
        // searchstring + "%"));
        Path<String> path = c.get(searchcriteria);
        Predicate predicate = cb.like(path, literal);
        Predicate condition = cb.notEqual(c.get("deleted"), "true");
        cq.where(condition, predicate);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
        } else {
View Full Code Here
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
    tx.begin();

    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Users> cq = cb.createQuery(Users.class);
    Root<Users> c = cq.from(Users.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    Predicate subCondition = cb.equal(c.get("user_id"), id);
    cq.where(condition, subCondition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();
View Full Code Here
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
    tx.begin();

    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Users> cq = cb.createQuery(Users.class);
    Root<Users> c = cq.from(Users.class);
    Predicate condition = cb.equal(c.get("user_id"), id);
    cq.where(condition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();
View Full Code Here
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
    tx.begin();

    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Users> cq = cb.createQuery(Users.class);
    Root<Users> c = cq.from(Users.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    Predicate subCondition = cb.equal(c.get("login"), login);
    cq.where(condition, subCondition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();
View Full Code Here
430
431
432
433
434
435
436
437
438
439
440
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Rooms> cq = cb.createQuery(Rooms.class);
      Root<Rooms> c = cq.from(Rooms.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      cq.distinct(asc);
      if (asc){
        cq.orderBy(cb.asc(c.get(orderby)));
      } else {
View Full Code Here
510
511
512
513
514
515
516
517
518
519
520
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Rooms> cq = cb.createQuery(Rooms.class);
      Root<Rooms> c = cq.from(Rooms.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Rooms> q = session.createQuery(cq);
      List<Rooms> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
View Full Code Here
551
552
553
554
555
556
557
558
559
560
561
562
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Rooms> cq = cb.createQuery(Rooms.class);
      Root<Rooms> c = cq.from(Rooms.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      Predicate subCondition = cb.equal(c.get("externalRoomType"), externalRoomType);
      cq.where(condition, subCondition);
      cq.distinct(asc);
      if (asc){
        cq.orderBy(cb.asc(c.get(orderby)));
      } else {
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Organisation> cq = cb.createQuery(Organisation.class);
      Root<Organisation> c = cq.from(Organisation.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      cq.distinct(asc);
      if (asc) {
        cq.orderBy(cb.asc(c.get(orderby)));
      } else {
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
        tx.begin();
        CriteriaBuilder cb = session.getCriteriaBuilder();
        CriteriaQuery<Organisation> cq = cb
            .createQuery(Organisation.class);
        Root<Organisation> c = cq.from(Organisation.class);
        Predicate condition = cb.equal(c.get("deleted"), "false");
        cq.where(condition);
        TypedQuery<Organisation> q = session.createQuery(cq);
        List<Organisation> ll = q.getResultList();
        tx.commit();
        PersistenceSessionUtil.closeSession(idf);
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.