Package javax.persistence

Examples of javax.persistence.Query

185
186
187
188
189
190
191
192
193
194
195
196
197
    if (search == null)
      return null;

    List<Object> paramList = new ArrayList<Object>();
    String ql = generateQL(entityClass, search, paramList);
    Query query = entityManager.createQuery(ql);
    addParams(query, paramList);
    try {
      return transformResult(query.getSingleResult(), search);
    } catch (NoResultException ex) {
      return transformResult(null, search);
    }
  }
View Full Code Here
49
50
51
52
53
54
55
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 as c where c.user_id = :user_id");
        query.setParameter("user_id", user_id);
       
        session.flush();
       
        Users users = null;
        try {
          users = (Users) query.getSingleResult();
          } catch (NoResultException ex) {
          }
        session.refresh(users);
       
        tx.commit();
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
169
      //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);       
    } catch (Exception ex2) {
View Full Code Here
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
     
      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);
      //query
           
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
     
      //log.error((Long)ll.get(0));
View Full Code Here
290
291
292
293
294
295
296
297
298
299
300
301
302
303
    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();
      PersistenceSessionUtil.closeSession(idf);
      if (count != 0) {
        return false;
View Full Code Here
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
          " 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();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return us;     
View Full Code Here
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
          " 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();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return us;     
View Full Code Here
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
          " 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();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      if (us!=null) {
View Full Code Here
428
429
430
431
432
433
434
435
436
437
438
439
440
      //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));
      return (Long)ll.get(0);       
    } catch (Exception ex2) {
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
      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) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return addr;
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.