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

Class javax.persistence.criteria.CriteriaBuilder

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

javax.persistence.criteria.CriteriaBuilder.parameter()
Create a parameter expression. @param paramClass parameter class @return parameter expression


            CriteriaBuilder builder = em.getCriteriaBuilder();


            CriteriaQuery<User2018> criteria = builder.createQuery(User2018.class);
            Root<User2018> root = criteria.from(User2018.class);
            criteria.where(root.get("id").in(builder.parameter(Collection.class)));


            TypedQuery<User2018> query = em.createQuery(criteria);
            for (ParameterExpression parameter : criteria.getParameters()) {
                query.setParameter(parameter, Arrays.asList(user.id, 123456789L));
            }

View Full Code Here

        
        CriteriaBuilder cb = em.getCriteriaBuilder();
        CriteriaQuery<Customer> q = cb.createQuery(Customer.class);
        Customer customer = null;
        Root<Customer> root = q.from(Customer.class);
        ParameterExpression<String> pName = cb.parameter(String.class);
        q.where(cb.equal(root.get(Customer_.name), pName));
        List<Customer> customers = em.createQuery(q)
          .setParameter(pName, name)
          .getResultList();
        if (customers.isEmpty()) {

View Full Code Here


        CriteriaQuery<Ingredient> criteriaQuery = cb
                .createQuery(Ingredient.class);
        Root<Ingredient> i = criteriaQuery.from(Ingredient.class);
        criteriaQuery.where(cb.like(i.<String> get("label"),
                cb.parameter(String.class, "label")));
        TypedQuery<Ingredient> tq = getEntityManager().createQuery(
                criteriaQuery);
        tq.setParameter("label", label);


        Ingredient ingredient = null;

View Full Code Here

            (SingularAttribute<SimpleEntity, String>)entity.getSingularAttribute("name");
        
        CriteriaBuilder cb = oemf.getCriteriaBuilder();
        CriteriaQuery<SimpleEntity> c = cb.createQuery(SimpleEntity.class);
        Root<SimpleEntity> root = c.from(SimpleEntity.class);
        ParameterExpression<Long> param1 = cb.parameter(long.class, "id");
        ParameterExpression<String> param2 = cb.parameter(String.class, "name");
        Predicate p1 = cb.equal(root.get(id), param1);
        Predicate p2 = cb.equal(root.get(name), param2);
        c.where(cb.and(p1,p2));

View Full Code Here

        
        CriteriaBuilder cb = oemf.getCriteriaBuilder();
        CriteriaQuery<SimpleEntity> c = cb.createQuery(SimpleEntity.class);
        Root<SimpleEntity> root = c.from(SimpleEntity.class);
        ParameterExpression<Long> param1 = cb.parameter(long.class, "id");
        ParameterExpression<String> param2 = cb.parameter(String.class, "name");
        Predicate p1 = cb.equal(root.get(id), param1);
        Predicate p2 = cb.equal(root.get(name), param2);
        c.where(cb.and(p1,p2));
        
        Query q = em.createQuery(c);

View Full Code Here

            (SingularAttribute<SimpleEntity, String>)entity.getSingularAttribute("name");
        
        CriteriaBuilder cb = oemf.getCriteriaBuilder();
        CriteriaQuery<SimpleEntity> c = cb.createQuery(SimpleEntity.class);
        Root<SimpleEntity> root = c.from(SimpleEntity.class);
        ParameterExpression<Long> param1 = cb.parameter(long.class);
        ParameterExpression<String> param2 = cb.parameter(String.class);
        Predicate p1 = cb.equal(root.get(id), param1);
        Predicate p2 = cb.equal(root.get(name), param2);
        c.where(cb.and(p1,p2));

View Full Code Here

        
        CriteriaBuilder cb = oemf.getCriteriaBuilder();
        CriteriaQuery<SimpleEntity> c = cb.createQuery(SimpleEntity.class);
        Root<SimpleEntity> root = c.from(SimpleEntity.class);
        ParameterExpression<Long> param1 = cb.parameter(long.class);
        ParameterExpression<String> param2 = cb.parameter(String.class);
        Predicate p1 = cb.equal(root.get(id), param1);
        Predicate p2 = cb.equal(root.get(name), param2);
        c.where(cb.and(p1,p2));
        
        Query q = em.createQuery(c);

View Full Code Here

        assertEquals(N_ORDERS / 2, typedJpqlResults.size());


        CriteriaBuilder qb = em.getCriteriaBuilder();
        CriteriaQuery<Order> criteriaQuery = qb.createQuery(Order.class);
        Root<Order> order = criteriaQuery.from(Order.class);
        criteriaQuery.select(order).where(qb.lessThan(order.get(Order_.date), qb.parameter(Date.class, "maxDate")));
        TypedQuery<Order> tq = em.createQuery(criteriaQuery);
        tq.setParameter("maxDate", maxDate);
        List<Order> criteriaResults = tq.getResultList();
        assertEquals(N_ORDERS / 2, criteriaResults.size());

View Full Code Here


    CriteriaBuilder builder = em.getCriteriaBuilder();


    CriteriaQuery<User> criteriaQuery = builder.createQuery(User.class);
    Root<User> root = criteriaQuery.from(User.class);
    ParameterExpression<Collection> parameter = builder.parameter(Collection.class);
    criteriaQuery.where(root.<Integer> get("id").in(parameter));


    TypedQuery<User> query = em.createQuery(criteriaQuery);
    query.setParameter(parameter, Arrays.asList(1, 2));

View Full Code Here


    CriteriaBuilder builder = em.getCriteriaBuilder();


    CriteriaQuery<User> criteria = builder.createQuery(User.class);
    Root<User> root = criteria.from(User.class);
    ParameterExpression<String[]> parameter = builder.parameter(String[].class);
    criteria.where(root.get("firstname").in(parameter));


    TypedQuery<User> query = em.createQuery(criteria);
    query.setParameter(parameter, new String[] { "Dave", "Carter" });

View Full Code Here

0 1 2 3

TOP

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.