Package javax.persistence.criteria

Examples of javax.persistence.criteria.CriteriaBuilder$SimpleCase

125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Configuration> cq = cb.createQuery(Configuration.class);
      Root<Configuration> c = cq.from(Configuration.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 {
        cq.orderBy(cb.desc(c.get(orderby)));
      }
      TypedQuery<Configuration> q = session.createQuery(cq);
      q.setFirstResult(start);
      q.setMaxResults(max);
      List<Configuration> ll = q.getResultList();
View Full Code Here
567
568
569
570
571
572
573
574
575
576
577
578
579
580
  private List<Fieldvalues> getFieldsValues() throws Exception {
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();
    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Fieldvalues> cq = cb.createQuery(Fieldvalues.class);
    Root<Fieldvalues> c = cq.from(Fieldvalues.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    cq.where(condition);
    TypedQuery<Fieldvalues> q = session.createQuery(cq);
    List<Fieldvalues> ll = q.getResultList();
    tx.commit();
    PersistenceSessionUtil.closeSession(idf);
View Full Code Here
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
  private List<Fieldvalues> getFieldsValues(int start ,int max, String orderby, boolean asc) throws Exception {
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();
    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Fieldvalues> cq = cb.createQuery(Fieldvalues.class);
    Root<Fieldvalues> c = cq.from(Fieldvalues.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 {
      cq.orderBy(cb.desc(c.get(orderby)));
    }
    TypedQuery<Fieldvalues> q = session.createQuery(cq);
    q.setFirstResult(start);
    q.setMaxResults(max);
    List<Fieldvalues> ll = q.getResultList();
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
        // get all users
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        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 {
          cq.orderBy(cb.desc(c.get(orderby)));
        }
        TypedQuery<Users> q = session.createQuery(cq);
        q.setFirstResult(start);
        q.setMaxResults(max);
        List<Users> ll = q.getResultList();
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
        tx.begin();
        CriteriaBuilder cb = session.getCriteriaBuilder();
        CriteriaQuery<Users> cq = cb.createQuery(Users.class);
        Root<Users> c = cq.from(Users.class);
        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 {
          cq.orderBy(cb.desc(c.get(orderby)));
        }
        TypedQuery<Users> q = session.createQuery(cq);
        q.setFirstResult(start);
        q.setMaxResults(max);
        List<Users> contactsZ = q.getResultList();
View Full Code Here
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
1701
1702
1703
1704
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    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");
    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
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    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("user_id"), id);
    cq.where(condition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();
View Full Code Here
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    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");
    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
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      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 {
        cq.orderBy(cb.desc(c.get(orderby)));
      }
      TypedQuery<Rooms> q = session.createQuery(cq);
      q.setFirstResult(start);
      q.setMaxResults(max);
      List<Rooms> ll = q.getResultList();
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
518
519
520
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      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
TOP

Related Classes of javax.persistence.criteria.CriteriaBuilder$SimpleCase

  • $.MemberDaoImpl
  • $.MemberRepository
  • br.com.lawoffice.persistencia.ejb.HistoricoContaDaoBean
  • br.com.lawoffice.persistencia.ejb.LancamentoDaoBean
  • br.com.mystudies.jpa.criteria.api.ClienteDao
  • br.com.mystudies.service.persistence.SprintDaoBean
  • br.gov.frameworkdemoiselle.template.JPACrud
  • com.ctp.cdi.query.criteria.QueryCriteria
  • com.darkhonor.rage.libs.dataaccess.CategoryDAO
  • com.darkhonor.rage.libs.dataaccess.CourseDAO
    • 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.