Examples of javax.persistence.Query

javax.persistence.Query
@version $Rev: 107 $ $Date: 2009-02-27 16:21:04 +0200 (Fri, 27 Feb 2009) $

    }


    @Transactional(propagation = Propagation.REQUIRED, readOnly = true)
    @Override public User findUser(String userName) {
        if (StringUtils.hasText(userName)) {
            Query query = entityManager.createQuery("SELECT u FROM " + userClass.getSimpleName() + " u where LOWER(USERNAME) = :username");
            query.setParameter("username", userName.toLowerCase());
            try {
                return (User) query.getSingleResult();
            } catch (Exception e) {
                if (logger.isDebugEnabled()) logger.debug("Could not find user [" + userName + "] in database: " + e.getMessage());
            }
        }
        return null;

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.toLowerCase() + "%");
        if (StringUtils.hasText(username)) query.setParameter("username", username.toLowerCase() + "%");
        if (StringUtils.hasText(role)) query.setParameter("role", role);
        return query.getResultList();
    }

View Full Code Here

  public int execute (String queryString) {
    return this.execute(queryString, new HashMap());
  }
  
  public int executeNative (String query, Object... pars) {
    Query q = this.getStorage().createNativeQuery(query);
    for (int i=0; i<pars.length; i++) q.setParameter(i, pars[i]);
    return q.executeUpdate();
  }

View Full Code Here

  public List getNativeResults (String query, Object... pars) {
    return this.getNativeResults(query, 0, -1, pars);
  }
  
  public List getNativeResults (String query, int offset, int max, Object... pars) {
    Query q = this.getStorage().createNativeQuery(query);
    
    if (offset > -1) q.setFirstResult(offset);
    if (max > 0) q.setMaxResults(max);
    
    return q.getResultList();
  }

View Full Code Here

  public int execute (Map parameters, String queryString) {
    return this.execute(queryString, parameters);
  }
  
  public int execute (String queryString, Map parameters) {
    Query query = this.getStorage().createQuery(queryString);
    if (parameters != null) for (Object key : parameters.keySet()) {
      Object value = this.translateParameter( parameters.get(key) );
      if (queryString.contains(":" + key)) query.setParameter(key.toString(), value);
    }
    return query.executeUpdate();
  }

View Full Code Here

    return this.getSingleResult(new HashMap(), queryString);
  }
  
  public Object getSingleResult (Map parameters, String queryString) {
    try {
      Query query = this.getStorage().createQuery(queryString);
      query.setFirstResult(0);
      query.setMaxResults(1);
      if (parameters != null) for (Object key : parameters.keySet()) {
        Object value = this.translateParameter( parameters.get(key) );
        if (queryString.contains(":" + key)) query.setParameter(key.toString(), value);
      }
      return query.getSingleResult();
    }  catch (NoResultException e) {
      return null;
    }
  }

View Full Code Here

  public List getResults(Map parameters, String queryString) {
    return this.getResults(parameters, queryString, -1, -1);
  }


  public List getResults (Map parameters, String queryString, int offset, int max) {
    Query query = this.getStorage().createQuery(queryString);
    if (offset > -1) query.setFirstResult(offset);
    if (max > -1) query.setMaxResults(max);
    if (parameters != null) for (Object key : parameters.keySet()) {
      Object value =  this.translateParameter( parameters.get(key) );
      if (queryString.contains(":" + key)) query.setParameter(key.toString(), value);
    }
    return query.getResultList();
  }

View Full Code Here


  public List<Object> execute(QueryBuilderSelectJPA builder) {
    QuerySnapshot snapshot = builder.build();
    
    String queryString = snapshot.getQueryString();
    Query query = em.createQuery(queryString);
    
    if (snapshot.getArguments().size() > 0) {
      for (IQueryFragmentCriteriaParameter parameter : snapshot.getArguments()) {
        for (String name : parameter.getNamedParameters()) {
          if (queryString.contains(":" + name))
            query.setParameter(name, builder.getParameters().get(name));
        }
      }
    }
    
    if (builder.getFirstRecord() > -1) query.setFirstResult(builder.getFirstRecord());
    if (builder.getMaxRecords() > 0) query.setMaxResults(builder.getMaxRecords());
    
    return query.getResultList();
  }

View Full Code Here

    /**
     * Removes all entities cith the name in the parameter.
     * @param entityName the entity class that are removed.
     */
    public void deleteEntity(final String entityName) {
        Query queryResult = entityManager.createQuery("SELECT x FROM " + entityName+  " x");
        List lstEntity = queryResult.getResultList();
        for (Object obj : lstEntity) {
            entityManager.remove(obj);
        }
        entityManager.flush();
    }

View Full Code Here

    /**
     * Verifies if the container manages a path expression.
     */
    public void testPathExpression() {
        startup();
        Query query = entityManager
                .createQuery("SELECT o.description FROM Customer c, IN(c.orders) o WHERE o.id = :productOrderId");
        query.setParameter("productOrderId", new Long(1));
        List lstProductOrderDesc = query.getResultList();
        assertEquals(lstProductOrderDesc.size(), 1,
                "The query did not returned the correct value in a path expression.");
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.