Package javax.persistence.criteria

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

42
43
44
45
46
47
48
49
50
51
52
  public List<Member> findAllOrderedByName() {
    CriteriaBuilder cb = entityManager.getCriteriaBuilder();
    CriteriaQuery<Member> criteria = cb.createQuery(Member.class);
    Root<Member> member = criteria.from(Member.class);
    criteria.select(member).orderBy(cb.asc(member.get("name")));
    recordDao.logMethodCall(ThreadUtils.getCurrentMethodName(),
        ThreadUtils.getCurrentMethodSourceFileName());
    return entityManager.createQuery(criteria).getResultList();
  }
View Full Code Here
41
42
43
44
45
46
47
48
49
      CriteriaQuery<Member> criteria = cb.createQuery(Member.class);
      Root<Member> member = criteria.from(Member.class);
      // Swap criteria statements if you would like to try out type-safe criteria queries, a new
      // feature in JPA 2.0
      // criteria.select(member).orderBy(cb.asc(member.get(Member_.name)));
      criteria.select(member).orderBy(cb.asc(member.get("name")));
      members = em.createQuery(criteria).getResultList();
   }
}
View Full Code Here
40
41
42
43
44
45
46
47
48
      CriteriaQuery<Member> criteria = cb.createQuery(Member.class);
      Root<Member> member = criteria.from(Member.class);
      // Swap criteria statements if you would like to try out type-safe criteria queries, a new
      // feature in JPA 2.0
      // criteria.select(member).orderBy(cb.asc(member.get(Member_.name)));
      criteria.select(member).orderBy(cb.asc(member.get("name")));
      members = em.createQuery(criteria).getResultList();
   }
}
View Full Code Here
52
53
54
55
56
57
58
59
60
        CriteriaQuery<Member> criteria = cb.createQuery(Member.class);
        Root<Member> member = criteria.from(Member.class);
        // Swap criteria statements if you would like to try out type-safe criteria queries, a new
        // feature in JPA 2.0
        // criteria.select(member).orderBy(cb.asc(member.get(Member_.name)));
        criteria.select(member).orderBy(cb.asc(member.get("name")));
        return em.createQuery(criteria).getResultList();
    }
}
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
        if (!predicates.isEmpty()) {
            query.where(predicates.toArray(new Predicate[predicates.size()]));
        }

        query.orderBy(builder.asc(book.get("title")));
        return this.entityManager.createQuery(query).getResultList();
    }

    @Override
    public void storeBook(Book book) {
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
        CriteriaBuilder builder = entityManager.getCriteriaBuilder();
        CriteriaQuery<Booking> cquery = builder.createQuery(Booking.class);
        Root<Booking> booking = cquery.from(Booking.class);
        booking.fetch(Booking_.hotel, JoinType.INNER);
        cquery.select(booking).where(builder.equal(booking.get(Booking_.user).get(User_.username), username))
                .orderBy(builder.asc(booking.get(Booking_.checkinDate)));

        bookingsForUser = entityManager.createQuery(cquery).getResultList();
    }

}
View Full Code Here
518
519
520
521
522
523
524
525
526
527
528
            {
                criteriaQuery.where((value != null) ? criteriaBuilder.equal(beanRoot.get(name), value) : criteriaBuilder.isNull(beanRoot.get(name)));
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
           
            // invoke query
            Query query = entityManager.createQuery(criteriaQuery);
            List<? extends IBean> beansList = query.getResultList();
View Full Code Here
582
583
584
585
586
587
588
589
590
591
592
                }
                criteriaQuery.where(predicate);
            }
            if (orderBy != null)
            {
                criteriaQuery.orderBy(ascending ? criteriaBuilder.asc(beanRoot.get(orderBy)) : criteriaBuilder.desc(beanRoot.get(orderBy)));
            }
           
            // invoke query
            Query query = entityManager.createQuery(criteriaQuery);
            List<? extends IBean> beansList = query.getResultList();
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
      CriteriaBuilder builder = em.getCriteriaBuilder();
      CriteriaQuery<Game> criteria = builder.createQuery(Game.class);

      Root<Game> game = criteria.from(Game.class);
      criteria.select(game);
      criteria.orderBy(builder.asc(game.get(Game_.id)));
      System.out.println("Selecting (using Criteria)...");
      games = em.createQuery(criteria).getResultList();
      System.out.println("Found " + games.size() + " games (using Criteria)");
      assertEquals(GAME_TITLES.length, games.size());
      for (int i = 0; i < GAME_TITLES.length; i++) {
View Full Code Here
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
      filters.add(cb.not(cb.in(root.get("adid")).value('A')));
      LOG.debug("adid not in ('A')");
    }

    if (stodStoa == null) {
      cq.orderBy((cb.asc(root.get("tifd"))));
    }

    cq.where(cb.and(filters.toArray(new Predicate[0])));
    Query query = em.createQuery(cq);
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.