Examples of CriteriaBuilder

javax.persistence.criteria.CriteriaBuilder
Interface used to build in predicates.
net.freedom.gj.beans.criteria.CriteriaBuilder
Help build complex criteria more elegantly. @author Martin Jamszolik
org.apache.openjpa.persistence.criteria.CriteriaBuilder
Factory for Criteria query expressions. Acts as an adapter to OpenJPA ExpressionFactory. @author Pinaki Poddar @author Fay Wang @since 2.0.0
org.axonframework.eventstore.management.CriteriaBuilder
stamps are stored as ISO 8601 Strings. Criteria criteria = entry.property("timeStamp").greaterThan("2011-11-12"); eventStore.visitEvents(criteria, visitor); @author Allard Buijze @since 2.0

Examples of javax.persistence.criteria.CriteriaBuilder

    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Configuration> cq = cb.createQuery(Configuration.class);
      Root<Configuration> c = cq.from(Configuration.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      cq.distinct(asc);
      if (asc){
        cq.orderBy(cb.asc(c.get(orderby)));
      } else {
        cq.orderBy(cb.desc(c.get(orderby)));
      }
      TypedQuery<Configuration> q = session.createQuery(cq);
      q.setFirstResult(start);
      q.setMaxResults(max);
      List<Configuration> ll = q.getResultList();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

  private List<Fieldvalues> getFieldsValues() throws Exception {
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();
    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Fieldvalues> cq = cb.createQuery(Fieldvalues.class);
    Root<Fieldvalues> c = cq.from(Fieldvalues.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    cq.where(condition);
    TypedQuery<Fieldvalues> q = session.createQuery(cq);
    List<Fieldvalues> ll = q.getResultList();
    tx.commit();
    PersistenceSessionUtil.closeSession(idf);

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

  private List<Fieldvalues> getFieldsValues(int start ,int max, String orderby, boolean asc) throws Exception {
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();
    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Fieldvalues> cq = cb.createQuery(Fieldvalues.class);
    Root<Fieldvalues> c = cq.from(Fieldvalues.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    cq.where(condition);
    cq.distinct(asc);
    if (asc){
      cq.orderBy(cb.asc(c.get(orderby)));
    } else {
      cq.orderBy(cb.desc(c.get(orderby)));
    }
    TypedQuery<Fieldvalues> q = session.createQuery(cq);
    q.setFirstResult(start);
    q.setMaxResults(max);
    List<Fieldvalues> ll = q.getResultList();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

        // get all users
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
        tx.begin();
        CriteriaBuilder cb = session.getCriteriaBuilder();
        CriteriaQuery<Users> cq = cb.createQuery(Users.class);
        Root<Users> c = cq.from(Users.class);
        Predicate condition = cb.equal(c.get("deleted"), "false");
        cq.where(condition);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
        } else {
          cq.orderBy(cb.desc(c.get(orderby)));
        }
        TypedQuery<Users> q = session.createQuery(cq);
        q.setFirstResult(start);
        q.setMaxResults(max);
        List<Users> ll = q.getResultList();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
        tx.begin();
        CriteriaBuilder cb = session.getCriteriaBuilder();
        CriteriaQuery<Users> cq = cb.createQuery(Users.class);
        Root<Users> c = cq.from(Users.class);
        Expression<String> literal = cb.literal((String) "%"
            + searchstring + "%");
        // crit.add(Restrictions.ilike(searchcriteria, "%" +
        // searchstring + "%"));
        Path<String> path = c.get(searchcriteria);
        Predicate predicate = cb.like(path, literal);
        Predicate condition = cb.notEqual(c.get("deleted"), "true");
        cq.where(condition, predicate);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
        } else {
          cq.orderBy(cb.desc(c.get(orderby)));
        }
        TypedQuery<Users> q = session.createQuery(cq);
        q.setFirstResult(start);
        q.setMaxResults(max);
        List<Users> contactsZ = q.getResultList();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();


    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Users> cq = cb.createQuery(Users.class);
    Root<Users> c = cq.from(Users.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    Predicate subCondition = cb.equal(c.get("user_id"), id);
    cq.where(condition, subCondition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();


    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Users> cq = cb.createQuery(Users.class);
    Root<Users> c = cq.from(Users.class);
    Predicate condition = cb.equal(c.get("user_id"), id);
    cq.where(condition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
    tx.begin();


    CriteriaBuilder cb = session.getCriteriaBuilder();
    CriteriaQuery<Users> cq = cb.createQuery(Users.class);
    Root<Users> c = cq.from(Users.class);
    Predicate condition = cb.equal(c.get("deleted"), "false");
    Predicate subCondition = cb.equal(c.get("login"), login);
    cq.where(condition, subCondition);
    TypedQuery<Users> q = session.createQuery(cq);
    Users u = null;
    try {
      u = (Users) q.getSingleResult();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Rooms> cq = cb.createQuery(Rooms.class);
      Root<Rooms> c = cq.from(Rooms.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      cq.distinct(asc);
      if (asc){
        cq.orderBy(cb.asc(c.get(orderby)));
      } else {
        cq.orderBy(cb.desc(c.get(orderby)));
      }
      TypedQuery<Rooms> q = session.createQuery(cq);
      q.setFirstResult(start);
      q.setMaxResults(max);
      List<Rooms> ll = q.getResultList();

View Full Code Here

Examples of javax.persistence.criteria.CriteriaBuilder

    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Rooms> cq = cb.createQuery(Rooms.class);
      Root<Rooms> c = cq.from(Rooms.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Rooms> q = session.createQuery(cq);
      List<Rooms> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);

View Full Code Here

0 1 2 3 4 5

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.