Package javax.persistence.criteria

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

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
141
142
143
144
145
146
147
148
149
150
151
               
        Root<Game> game = criteria.from(Game.class);
        criteria.select(game);
        // TIP: If you don't want to use the JPA 2 Metamodel,
        // you can change the get() method call to get("id")
        criteria.orderBy(builder.asc(game.get(Game_.id)));
        // No WHERE clause, which implies select all

        // when
        System.out.println("Selecting (using Criteria)...");
        List<Game> games = em.createQuery(criteria).getResultList();
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
    public Metadata findOneOldestByChangeDate() {
        final CriteriaBuilder cb = _entityManager.getCriteriaBuilder();
        final CriteriaQuery<Metadata> query = cb.createQuery(Metadata.class);
        final Root<Metadata> metadataRoot = query.from(Metadata.class);
        final Path<ISODate> changeDate = metadataRoot.get(Metadata_.dataInfo).get(MetadataDataInfo_.changeDate);
        query.orderBy(cb.asc(changeDate));
        return _entityManager.createQuery(query).setMaxResults(1).getSingleResult();
    }

    @Override
    public Map<Integer, MetadataSourceInfo> findAllSourceInfo(Specification<Metadata> spec) {
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
        switch (direction) {
            case DESC:
                order = cb.desc(path);
                break;
            case ASC:
                order = cb.asc(path);
                break;
            default:
                throw new IllegalArgumentException("Not a valid value: " + direction);
        }
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
85
86
87
88
89
90
91
92
93
94
95
        CriteriaBuilder cb = getCriteriaBuilder();
       
        List<Order> orders = new ArrayList<Order>();
        for (SingularAttribute<T, ?> attribute : attributes) {
            Path<?> selection = getRoot().get(attribute);
            Order order = asc ? cb.asc(selection) : cb.desc(selection);
            orders.add(order);
        }
        return getCriteriaQuery().orderBy(orders);
    }
   
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
        Root<PageImpl> page = criteria.from(PageImpl.class);
        criteria.select(page);
        criteria.where(builder.and(
                builder.or(builder.isFalse(page.get("offlineFlag").as(Boolean.class)), builder.isNull(page.get("offlineFlag").as(Boolean.class))),
                builder.or(builder.isFalse(page.get("excludeFromSiteMap").as(Boolean.class)), builder.isNull(page.get("excludeFromSiteMap").as(Boolean.class)))));
        criteria.orderBy(builder.asc(page.get(sortBy)));
        TypedQuery<Page> query = em.createQuery(criteria);
        query.setFirstResult(offset);
        query.setMaxResults(limit);

        return query.getResultList();
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
                Map<String, Object> idMetaData = dynamicEntityDao.getIdMetadata(ceilingClass);
                if (idMetaData != null) {
                    Object idFldName = idMetaData.get("name");
                    Object type = idMetaData.get("type");
                    if ((idFldName instanceof String) && (type instanceof SingleColumnType)) {
                        criteria.orderBy(criteriaBuilder.asc(original.get((String) idFldName)));
                    }
                }
            }
        }
        TypedQuery<Serializable> response = dynamicEntityDao.getStandardEntityManager().createQuery(criteria);
View Full Code Here
336
337
338
339
340
341
342
343
344
345
346
                        // to attach search facet to any query parameter
                        continue;
                    }
                   
                    if (asc) {
                        sorts.add(builder.asc(pathToUse.get(key)));
                    } else {
                        sorts.add(builder.desc(pathToUse.get(key)));
                    }
                }
            }
View Full Code Here
634
635
636
637
638
639
640
641
642
       
        // Add the restrictions to the criteria query
        criteria.where(restrictions.toArray(new Predicate[restrictions.size()]));

        //Add ordering so that paginated queries are consistent
        criteria.orderBy(builder.asc(product.get("id")));
        return criteria;
    }
}
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.