Package javax.persistence.criteria

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
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
111
112
113
114
115
116
117
118
119
120
121
122
    public List<Form> findFormEntities(int maxResults, int firstResult) {
        return findFormEntities(false, maxResults, firstResult);
    }

    private List<Form> findFormEntities(boolean all, int maxResults, int firstResult) {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(Form.class));
        Query q = em.createQuery(cq);
        if (!all) {
            q.setMaxResults(maxResults);
            q.setFirstResult(firstResult);
        }
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
    public Form findForm(Long id) {
        return em.find(Form.class, id);
    }

    public int getFormCount() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<Form> rt = cq.from(Form.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
    public List<FormData> findFormDataEntities(int maxResults, int firstResult) {
        return findFormDataEntities(false, maxResults, firstResult);
    }

    private List<FormData> findFormDataEntities(boolean all, int maxResults, int firstResult) {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(FormData.class));
        Query q = em.createQuery(cq);
        if (!all) {
            q.setMaxResults(maxResults);
            q.setFirstResult(firstResult);
        }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
    public FormData findFormData(Long id) {
        return em.find(FormData.class, id);
    }

    public int getFormDataCount() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        Root<FormData> rt = cq.from(FormData.class);
        cq.select(em.getCriteriaBuilder().count(rt));
        Query q = em.createQuery(cq);
        return ((Long) q.getSingleResult()).intValue();
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
    public List<FormBuilderItemData> findFormDataEntities(int maxResults, int firstResult) {
        return findFormDataEntities(false, maxResults, firstResult);
    }

    private List<FormBuilderItemData> findFormDataEntities(boolean all, int maxResults, int firstResult) {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(FormBuilderItemData.class));
        Query q = em.createQuery(cq);
        if (!all) {
            q.setMaxResults(maxResults);
            q.setFirstResult(firstResult);
        }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
143
    }

    private List<Tagrates> findTagratesEntities(boolean all, int maxResults, int firstResult) {
        EntityManager em = getEntityManager();
        try {
            CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
            cq.select(cq.from(Tagrates.class));
            Query q = em.createQuery(cq);
            if (!all) {
                q.setMaxResults(maxResults);
                q.setFirstResult(firstResult);
            }
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
168
169
    }

    public int getTagratesCount() {
        EntityManager em = getEntityManager();
        try {
            CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
            Root<Tagrates> rt = cq.from(Tagrates.class);
            cq.select(em.getCriteriaBuilder().count(rt));
            Query q = em.createQuery(cq);
            return ((Long) q.getSingleResult()).intValue();
        } finally {
            em.close();
        }
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
285
    }

    private List<Tag> findTagEntities(boolean all, int maxResults, int firstResult) {
        EntityManager em = getEntityManager();
        try {
            CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
            cq.select(cq.from(Tag.class));
            Query q = em.createQuery(cq);
            if (!all) {
                q.setMaxResults(maxResults);
                q.setFirstResult(firstResult);
            }
View Full Code Here
TOP

Related Classes of javax.persistence.criteria.CriteriaQuery

  • at.reppeitsolutions.formbuilder.model.controller.FormDataItemJpaController
  • at.reppeitsolutions.formbuilder.model.controller.FormDataJpaController
  • at.reppeitsolutions.formbuilder.model.controller.FormJpaController
  • br.edu.utfpr.cm.JGitMinerWeb.dao.GenericBichoDAO
  • br.edu.utfpr.cm.JGitMinerWeb.dao.GenericDao
  • com.google.appengine.datanucleus.jpa.JPACriteriaTest
  • com.intel.mtwilson.as.controller.MwCertificateX509JpaController
  • com.intel.mtwilson.as.controller.MwKeystoreJpaController
  • com.intel.mtwilson.as.controller.MwMleSourceJpaController
  • com.intel.mtwilson.as.controller.TblHostsJpaController
    • 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.