Package javax.persistence.criteria

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

63
64
65
66
67
68
69
70
71
72
73
     */
    public int getAvailableRows()
    {
        final CriteriaBuilder builder = entityManager.getCriteriaBuilder();

        CriteriaQuery<Long> criteria = builder.createQuery(Long.class);

        final Root<E> root = criteria.from(entityType);

        criteria = criteria.select(builder.count(root));

View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    public void prepare(final int startIndex, final int endIndex,
            final List<SortConstraint> sortConstraints)
    {
        final CriteriaBuilder builder = entityManager.getCriteriaBuilder();

        final CriteriaQuery<E> criteria = builder.createQuery(entityType);

        final Root<E> root = criteria.from(entityType);

        applyAdditionalConstraints(criteria.select(root), root, builder);
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
    }

    @GET
    public List<Snapshot> all() {
        CriteriaBuilder cb = this.em.getCriteriaBuilder();
        CriteriaQuery q = cb.createQuery();
        CriteriaQuery<Snapshot> select = q.select(q.from(Snapshot.class));
        return this.em.createQuery(select)
                .getResultList();

    }
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
    }


    public Course findCourse(int id) {
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<Course> cq = cb.createQuery(Course.class);
        Root<Course> course = cq.from(Course.class);
        cq.select(course).where(cb.equal(course.get("cid"), id));
        Query query = em.createQuery(cq);
        Course result = (Course) query.getSingleResult();
        if (result != null) {
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
        return em.createQuery(cq).getResultList();
    }

    public Course findCourseByName(String cname) {
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<Course> cq = cb.createQuery(Course.class);
        Root<Course> course = cq.from(Course.class);
        cq.select(course).where(cb.equal(course.get("cname"), cname));
        Query query = em.createQuery(cq);
        Course result = (Course) query.getSingleResult();
        if (result != null) {
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
    }


    public Course findCourse(int id) {
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<Course> cq = cb.createQuery(Course.class);
        Root<Course> course = cq.from(Course.class);
        cq.select(course).where(cb.equal(course.get("cid"), id));
        Query query = em.createQuery(cq);
        Course result = (Course) query.getSingleResult();
        if (result != null) {
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
        return em.createQuery(cq).getResultList();
    }

    public Course findCourseByName(String cname) {
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<Course> cq = cb.createQuery(Course.class);
        Root<Course> course = cq.from(Course.class);
        cq.select(course).where(cb.equal(course.get("cname"), cname));
        Query query = em.createQuery(cq);
        Course result = (Course) query.getSingleResult();
        if (result != null) {
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
    @Override
    public int getAvailableRows()
    {
        final CriteriaBuilder builder = entityManager.getCriteriaBuilder();

        CriteriaQuery<Long> criteria = builder.createQuery(Long.class);

        final Root<E> root = criteria.from(entityType);

        criteria = criteria.select(builder.count(root));
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    public void prepare(final int startIndex, final int endIndex,
            final List<SortConstraint> sortConstraints)
    {
        final CriteriaBuilder builder = entityManager.getCriteriaBuilder();

        final CriteriaQuery<E> criteria = builder.createQuery(entityType);

        final Root<E> root = criteria.from(entityType);

        applyAdditionalConstraints(criteria.select(root), root, builder);
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
        return em.find(Member.class, id);
    }

    public Member findByEmail(String email) {
        CriteriaBuilder cb = em.getCriteriaBuilder();
        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).where(cb.equal(member.get(Member_.name), email));
        criteria.select(member).where(cb.equal(member.get("email"), email));
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.