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

    CriteriaQuery<ImageContent> cq = cb.createQuery(ImageContent.class);


    Root<ImageContent> imageContent = cq.from(ImageContent.class);
    cq.select(imageContent);


    ParameterExpression<String> p = cb.parameter(String.class);
    if (!(category == null || category.equals(ALL_CATEGORY))) {
      cq.where(cb.equal(imageContent.get("category"), p));
    }
    cq.orderBy(cb.desc(imageContent.get("createAt")));

View Full Code Here

    CriteriaQuery<ImageContent> cq = cb.createQuery(ImageContent.class);


    Root<ImageContent> imageContent = cq.from(ImageContent.class);
    cq.select(imageContent);


    ParameterExpression<String> p = cb.parameter(String.class);
    if (!(category == null || category.equals(ALL_CATEGORY))) {
      //cb.equal(imageContent.get("category"), p);
    }
    ParameterExpression<Date> pDate = cb.parameter(Date.class);
    cq.where(cb.lessThanOrEqualTo(

View Full Code Here


    ParameterExpression<String> p = cb.parameter(String.class);
    if (!(category == null || category.equals(ALL_CATEGORY))) {
      //cb.equal(imageContent.get("category"), p);
    }
    ParameterExpression<Date> pDate = cb.parameter(Date.class);
    cq.where(cb.lessThanOrEqualTo(
        imageContent.<Date> get("createAt"), pDate));
    
    cq.orderBy(cb.desc(imageContent.get("createAt")));

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

            (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

        
        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


            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(Long[].class)));


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

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.