Package javax.persistence

Examples of javax.persistence.Query

514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
      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();
        }
        tx.commit();
        PersistenceSessionUtil.closeSession(idf);
        //Todo: Set user
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
     
      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) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session
          .createQuery("select c from States as c where c.state_id = :state_id AND c.deleted <> :deleted");
      query.setParameter("state_id", state_id);
      query.setParameter("deleted", "true");
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      if (ll.size() > 0) {
        return (States) ll.get(0);
      }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
     
      PrivateMessageFolder privateMessageFolder = null;
      try {
        privateMessageFolder = (PrivateMessageFolder) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
121
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      List<PrivateMessageFolder> privateMessageFolders = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return privateMessageFolders;
    } catch (Exception e) {
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
110
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session
          .createQuery("select c from States as c where c.deleted <> :deleted");
      query.setParameter("deleted", "true");
      List<States> ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return ll;
    } catch (Exception ex2) {
      log.error("getStates",ex2);
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
167
168
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("userId", userId);
     
      List<PrivateMessageFolder> privateMessageFolders = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return privateMessageFolders;
    } catch (Exception e) {
View Full Code Here
415
416
417
418
419
420
421
422
423
424
425
426
427
428
      log.debug("checkUserMail: " + email);
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select c from Adresses as c where c.email LIKE :email AND c.deleted <> :deleted");
      query.setParameter("email", email);
      query.setParameter("deleted", "true");
      int count = query.getResultList().size();
      log.debug("size: " + count);
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      if (count > 0) {
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
111
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      List<PrivateMessages> privateMessages = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return privateMessages;
     
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageId", privateMessageId);
     
      PrivateMessages privateMessage = null;
      try {
        privateMessage = (PrivateMessages) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
View Full Code Here
TOP

Related Classes of javax.persistence.Query

  • $.IndexAndSearchTest
  • ch.hortis.sonar.core.MeasuresCalculatorJob
  • ch.hortis.sonar.core.MeasuresPurgeJob
  • com.dyuproject.ext.jpa.DefaultDao
  • com.emc.plants.service.impl.BackOrderStockBean
  • com.emc.plants.service.impl.CatalogBean
  • com.mobius.controllers.PatientController
  • com.mobius.controllers.PatientListController
  • com.mobius.controllers.TemplateController
  • com.oltpbenchmark.benchmarks.jpab.tests.Test
    • Copyright © 2018 www.massapicom. 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.