Package javax.persistence.criteria

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


    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


    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 {
View Full Code Here

        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 {
View Full Code Here

    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 {
View Full Code Here

    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

    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

    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 {
View Full Code Here

    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

      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 {
View Full Code Here

      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

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.