Package javax.persistence

Examples of javax.persistence.EntityManager.createQuery()

369
370
371
372
373
374
375
376
377
378
379
          " 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("resethash", hash);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("search", StringUtils.lowerCase(search));
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      log.info("selectMaxFromUsers"+(Long)ll.get(0));
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Salutations> cq = cb.createQuery(Salutations.class);
      Root<Salutations> from = cq.from(Salutations.class);
      CriteriaQuery<Salutations> select = cq.select(from);
      TypedQuery<Salutations> q = session.createQuery(select);
      List<Salutations> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      for (Iterator it4 = ll.iterator(); it4.hasNext();) {
        Salutations ti = (Salutations) it4.next();
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
      String hql = "select c from Adresses as c where c.adresses_id = :adresses_id";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("adresses_id", new Long(adresses_id));
      Adresses addr = null;
      try {
        addr = (Adresses) query.getSingleResult();
        } catch (NoResultException ex) {
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        //"and c.deleted <> :deleted";
    Object idf = PersistenceSessionUtil.createSession();
    EntityManager session = PersistenceSessionUtil.getSession();
    EntityTransaction tx = session.getTransaction();
      tx.begin();
    Query query = session.createQuery(hql);
    query.setParameter("email", email);
    //query.setParameter("deleted", "true");
   
    List<Adresses> addr = query.getResultList();
   
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session
          .createQuery("select c from Users_Usergroups as c where c.user_id = :user_id");
      query.setParameter("user_id", USER_ID.longValue());
      int count = query.getResultList().size();
      usersusergroups = new Users_Usergroups[count];
      int k = 0;
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("userSipDataId", userSipDataId);
      UserSipData userSipData = null;
      try {
        userSipData = (UserSipData) query.getSingleResult();
        } catch (NoResultException ex) {
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session
          .createQuery("select c from Users_Usergroups as c where c.user_id = :user_id");
      query.setParameter("user_id", USER_ID);
      for (Iterator it2 = query.getResultList().iterator(); it2.hasNext();) {
        usersusergroups = (Users_Usergroups) it2.next();
      }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
      tx.begin();
        String hqlUpdate = " UPDATE Users_Usergroups set "
            + " usergroup_id = :usergroup_id, user_id = :user_id, "
            + " updatetime = :updatetime, comment = :comment "
            + " where users_usergroups_id= :users_usergroups_id";
        int updatedEntities = session.createQuery(hqlUpdate).setParameter(
            "usergroup_id", usergroup_id.longValue()).setParameter(
            "user_id", user_id.longValue()).setParameter("updatetime",
            new Long(-1)).setParameter(
            "comment", comment).setParameter("users_usergroups_id",
            users_usergroups_id.longValue()).executeUpdate();
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
        Object idf = PersistenceSessionUtil.createSession();
        EntityManager session = PersistenceSessionUtil.getSession();
        EntityTransaction tx = session.getTransaction();
      tx.begin();
        String hqlUpdate = "delete users_usergroups where users_usergroups_id= :users_usergroups_id";
        int updatedEntities = session.createQuery(hqlUpdate).setParameter(
            "UID", users_usergroups_id.longValue()).executeUpdate();
        res = "Success" + updatedEntities;
        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.