Examples of javax.persistence.EntityManager.createQuery()

javax.persistence.EntityManager.createQuery()
Create an instance of Query for executing an EJB QL statement. @param ejbqlString an EJB QL query string @return the new query instance @throws IllegalStateException if this EntityManager has been closed @throws IllegalArgumentException if query string is not valid

      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        Query query = session
            .createQuery("select c from usergroup_id as c where c.level_id = :level_id");
        query.setParameter("level_id", 1);
        int count = query.getResultList().size();
        groups = new Usergroups[count];
        int k = 0;

View Full Code Here

      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        Query query = session
            .createQuery("select c from Usergroups as c where c.usergroup_id = :usergroup_id AND c.level_id = :level_id");
        query.setParameter("usergroup_id", usergroup_id.longValue());
        query.setParameter("level_id", 1);
        for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
          groups = (Usergroups) it2.next();

View Full Code Here

      try {
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        Query query = session.createQuery("select c from Users as c where c.user_id = :user_id");
        query.setParameter("user_id", user_id);
        
        session.flush();
        
        Users users = null;

View Full Code Here

      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select count(c.user_id) from Users c where c.deleted = 'false'"); 
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      log.info("selectMaxFromUsers"+(Long)ll.get(0));
      return (Long)ll.get(0);

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");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return ll;

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");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return ll;

View Full Code Here

      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      
      //log.debug("id: "+folderId);
      
      //query.setParameter("macomUserId", userId);
      //query.setParameter("messageFolder", folderId);

View Full Code Here

    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select c from Users as c where c.login = :DataValue AND c.deleted <> :deleted");
      query.setParameter("DataValue", DataValue);
      query.setParameter("deleted", "true");
      int count = query.getResultList().size();


      tx.commit();

View Full Code Here

          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("login", login);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();

View Full Code Here

          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("adresses_id", adresses_id);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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.