Package javax.persistence

Examples of javax.persistence.Query


        getEntityManager().remove( processInstanceInfo );
    }

    @SuppressWarnings("unchecked")
    public List<Long> getProcessInstancesWaitingForEvent(String type) {
        Query processInstancesForEvent = getEntityManager().createNamedQuery( "ProcessInstancesWaitingForEvent" );
        processInstancesForEvent.setFlushMode(FlushModeType.COMMIT);
        processInstancesForEvent.setParameter( "type",
                                               type );
        return (List<Long>) processInstancesForEvent.getResultList();
    }
View Full Code Here


        entityManager.getTransaction().begin();
        hi = entityManager.find(I18nText.class, pk);
        assertNotNull("Record was saved", hi.getId());
        assertTrue("Collection was saved", hi.getValues().size() == 2);
        assertNotNull("Sub records were saved", hi.getValues().iterator().next().getId());
        Query q = entityManager.createNamedQuery("Locale.count");
        Long c = (Long) q.getSingleResult();
        assertTrue("Two locales", c == 2);
        entityManager.getTransaction().rollback();
    }
View Full Code Here

    if (named == null)
      return em.find(getMethodReturnType(), parameters[0]);
    else {
      String ejbql = "from " + getMethodReturnType().getSimpleName() + " entity where entity." + named.value()
              + "=?";
      Query query = em.createQuery(ejbql);
      query.setParameter(1, parameters[0]);
      return query.getSingleResult();
    }
  }
View Full Code Here

   * @param parameters 参数
   * @return
   */
  private Object queryResult(Object[] parameters) {
    Retrieve retrieve = getAnnotation();
    Query query = getQuery();
    QueryParameter queryPara = new QueryParameter(parameters, method.getParameterAnnotations());
    QueryUtils.fittingQuery(query, queryPara);
    if (!retrieve.resultClass().equals(void.class) && !retrieve.nativeQuery())
      return toProjectionalObject(retrieve.resultClass(), query.getSingleResult());
    else
      return query.getSingleResult();
  }
View Full Code Here

  protected final static Log log = LogFactory.getLog(FindAction.class);
 
  @SuppressWarnings("unchecked")
  @Override
  public Object execute(Object[] parameters) {
    Query query = getQuery();
    QueryParameter queryPara = new QueryParameter(parameters, method.getParameterAnnotations());
    fittingQuery(query, queryPara);
    Find find = getAnnotation();
    if (!find.resultClass().equals(void.class) && !find.nativeQuery())
      return toProjectionalList(find.resultClass(), query.getResultList());
    return query.getResultList();
  }
View Full Code Here

    }

    @SuppressWarnings("unchecked")
    @Transactional(propagation = Propagation.REQUIRED, readOnly = true)
    public List<RoleImpl> findAuthorities() {
        Query query = entityManager.createNamedQuery(RoleImpl.FIND_ALL_ROLES);
        return query.getResultList();
    }
View Full Code Here

    }

    @SuppressWarnings("unchecked")
    @Transactional(propagation = Propagation.REQUIRED, readOnly = true)
    public UserImpl findUser(String userName) {
        Query query = entityManager.createNamedQuery(UserImpl.FIND_BY_USERNAME);
        query.setParameter("username", userName);
        return (UserImpl) query.getSingleResult();
    }
View Full Code Here

        }
        if (StringUtils.hasText(role)) {
            queryString += queryString.indexOf("WHERE") < 0 ? " WHERE " : " AND ";
            queryString += " :role IN ELEMENTS(u.roles)";
        }
        Query query = entityManager.createQuery(queryString);
        query.setFirstResult(offset > 0 ? offset : 0);
        query.setMaxResults(number > 0 ? number : 0);
        if (StringUtils.hasText(name)) query.setParameter("name", name + "%");
        if (StringUtils.hasText(username)) query.setParameter("username", username + "%");
        if (StringUtils.hasText(role)) query.setParameter("role", role);
        return query.getResultList();
    }
View Full Code Here

    @Override
    @SuppressWarnings("unchecked")
    @Transactional(readOnly = true)
    public List<Object[]> executeQuery(String query, int offset, int max, Map<String, Object> parameters) {
        Assert.hasText(query);
        Query q = getEntityManager().createQuery(query);
        prepareQuery(q, offset, max, parameters);
        return q.getResultList();
    }
View Full Code Here

      return new JpaQueryable<T>(_em, type, e);
    }

    @SuppressWarnings("unchecked")
    public Iterable<E> iterable() {
      final Query q = execute();
      return (Iterable<E>) q.getResultList();
      // return new Iterable<E>() {
      // @SuppressWarnings("unchecked")
      // public Iterator<E> iterator() {
      // // TODO apply parameters!
      // return (Iterator<E>)q.getResultList().iterator();
View Full Code Here

TOP

Related Classes of javax.persistence.Query

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.