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

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      String hqlUpdate = "delete users_usergroups where user_id= :user_id";
      int updatedEntities = session.createQuery(hqlUpdate).setParameter(
          "user_id", user_id.longValue()).executeUpdate();
      res = "Success" + updatedEntities;
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
    } catch (Exception ex2) {

View Full Code Here

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      String hqlUpdate = "delete users_usergroups where usergroup_id= :usergroup_id";
      int updatedEntities = session.createQuery(hqlUpdate).setParameter(
          "usergroup_id", usergroup_id.longValue()).executeUpdate();
      res = "Success" + updatedEntities;
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);

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");
        query.setParameter("usergroup_id", usergroup_id.longValue());
        for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
          groups = (Users_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 Usergroups as c where c.usergroup_id = :usergroup_id");
      query.setParameter("usergroup_id", usergroup_id.longValue());
      int count = query.getResultList().size();
      usergroups = 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("from Usergroups");
        int count = query.getResultList().size();
        usergroups = new Usergroups[count];
        int k = 0;
        for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
          usergroups[k] = (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 Usergroups as c where c.usergroup_id = :usergroup_id");
      query.setParameter("usergroup_id", usergroup_id.longValue());
      for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
        usergroups = (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("from Usergroups");
        int count = query.getResultList().size();
        usergroups = new Usergroups[count];
        int k = 0;
        for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
          usergroups[k] = (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 Usergroups as c where c.usergroup_id = :usergroup_id");
        query.setParameter("usergroup_id", usergroup_id.longValue());
        for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
          groups = (Users_Usergroups) it2.next();
        }

View Full Code Here

        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        String hqlUpdate = "update Usergroups set user_id = :user_id,level_id = :level_id, name = :name, description = :description, updatetime = :updatetime, comment = :comment where usergroup_id= :usergroup_id";
        int updatedEntities = session.createQuery(hqlUpdate).setParameter(
            "user_id", USER_ID.longValue()).setParameter("level_id",
            level_id.longValue()).setParameter("name", name)
            .setParameter("description", description).setParameter(
                "updatetime",
                new Long(-1))

View Full Code Here

        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        String hqlUpdate = "delete Usergroups where usergroup_id= :usergroup_id";
        int updatedEntities = session.createQuery(hqlUpdate).setParameter(
            "usergroup_id", usergroup_id.longValue())
            .executeUpdate();
        res = "Success" + updatedEntities;
        tx.commit();
        PersistenceSessionUtil.closeSession(idf);

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.