Examples of CriteriaQuery

Examples of javax.persistence.criteria.CriteriaQuery

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

Examples of javax.persistence.criteria.CriteriaQuery

136
137
138
139
140
141
142
143
144
    public Student findStudent(int id) {
        return em.find(Student.class, id);
    }

    public List<Student> findAllStudent() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(Student.class));
        return em.createQuery(cq).getResultList();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

142
143
144
145
146
147
148
149
150
151
152
        cq.select(cq.from(Student.class));
        return em.createQuery(cq).getResultList();
    }

    public int countStudent() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<Student> rt = cq.from(Student.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

164
165
166
167
168
169
170
171
172
        }
        return result;
    }

    public List<Course> findAllCourse() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(Course.class));
        return em.createQuery(cq).getResultList();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

136
137
138
139
140
141
142
143
144
    public Student findStudent(int id) {
        return em.find(Student.class, id);
    }

    public List<Student> findAllStudent() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(Student.class));
        return em.createQuery(cq).getResultList();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

142
143
144
145
146
147
148
149
150
151
152
        cq.select(cq.from(Student.class));
        return em.createQuery(cq).getResultList();
    }

    public int countStudent() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<Student> rt = cq.from(Student.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

164
165
166
167
168
169
170
171
172
        }
        return result;
    }

    public List<Course> findAllCourse() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(Course.class));
        return em.createQuery(cq).getResultList();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

88
89
90
91
92
93
94
95
96
97
98
99
        em.persist(log);
    }

    public int count() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<Log> rt = cq.from(Log.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
//        System.out.println("in LogSessionBean.java, the count res is:"+((Long) q.getSingleResult()).intValue());
       return ((Long) q.getSingleResult()).intValue();
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

135
136
137
138
139
140
141
142
143
144
145
    }

    public void testEqualWithAttributeAndLiteral() {
        String jpql = "select a from Account a where a.balance=100";

        CriteriaQuery c = cb.createQuery();
        Root<Account> account = c.from(Account.class);
        c.select(account).where(cb.equal(account.get(Account_.balance), 100));

        assertEquivalence(c, jpql);
    }
View Full Code Here

Examples of javax.persistence.criteria.CriteriaQuery

1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
                cb.isTrue(cb.disjunction())));
        em.createQuery(c).getResultList();
    }
   
    public void testDefaultProjectionWithUntypedResult() {
        CriteriaQuery cquery = cb.createQuery();
        Root<Customer> customer = cquery.from(Customer.class);

        //Get Metamodel from Root
        EntityType<Customer> Customer_ = customer.getModel();

        cquery.where(cb.equal(
                customer.get(Customer_.getSingularAttribute("name", String.class)),
                cb.nullLiteral(String.class)));

        Query q = em.createQuery(cquery);
    }
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.