Package javax.persistence

Examples of javax.persistence.Query


  
   private void internalCleanup()
   { 
      if (manager != null)
      {
         Query query = manager.createQuery("select account from Account as account");
         List accts = query.getResultList();
         if (accts != null)
         {
            for (Iterator it = accts.iterator(); it.hasNext();)
            {
               try
View Full Code Here


    */
   private String getBranchViaNamedQuery(AccountHolderPK pk, boolean useRegion)
   {
      String queryName = useRegion ? "account.branch.namedregion"
                                   : "account.branch.default";
      Query query = manager.createNamedQuery(queryName);
      query.setParameter(1, pk);
      return (String) query.getResultList().get(0);
   }
View Full Code Here

      return useNamed ? getTotalBalanceViaNamedQuery(pk, useRegion) : getTotalBalanceViaLocalQuery(pk, useRegion);
   }
  
   private int getTotalBalanceViaLocalQuery(AccountHolderPK pk, boolean useRegion)
   {
      Query query = manager.createQuery("select account.balance from Account as account where account.accountHolder = ?1");
      query.setParameter(1, pk);
      query.setHint("org.hibernate.cacheable", Boolean.TRUE);
      return totalBalances(query);
   }
View Full Code Here

  
   private int getTotalBalanceViaNamedQuery(AccountHolderPK pk, boolean useRegion)
   {
      String queryName = useRegion ? "account.totalbalance.namedregion"
                                   : "account.totalbalance.default";
      Query query = manager.createNamedQuery(queryName);
      query.setParameter(1, pk);
      return totalBalances(query);
   }
View Full Code Here

  
   private void internalCleanup()
   { 
      if (manager != null)
      {
         Query query = manager.createQuery("select account from Account as account");
         List<?> accts = query.getResultList();
         for (Object acct: accts)
         {
            try
            {
               log.info("Removing " + acct);
View Full Code Here

      return useNamed ? getCountForBranchViaNamedQuery(branch, useRegion) : getCountForBranchViaLocalQuery(branch, useRegion);
   }
  
   private int getCountForBranchViaLocalQuery(String branch, boolean useRegion)
   {
      Query query = manager.createQuery("select account from Account as account where account.branch = ?1");
      query.setParameter(1, branch);
      if (useRegion)
      {
         query.setHint("org.hibernate.cacheRegion", "AccountRegion");
      }
      query.setHint("org.hibernate.cacheable", Boolean.TRUE);
      return query.getResultList().size();
     
   }
View Full Code Here

  
   private int getCountForBranchViaNamedQuery(String branch, boolean useRegion)
   {
      String queryName = useRegion ? "account.bybranch.namedregion"
                                   : "account.bybranch.default";
      Query query = manager.createNamedQuery(queryName);
      query.setParameter(1, branch);
      return query.getResultList().size();     
   }
View Full Code Here

      return useNamed ? getBranchViaNamedQuery(pk, useRegion) : getBranchViaLocalQuery(pk, useRegion);
   }
  
   private String getBranchViaLocalQuery(AccountHolderPK pk, boolean useRegion)
   {
      Query query = manager.createQuery("select account.branch from Account as account where account.accountHolder = ?1");
      query.setParameter(1, pk);
      if (useRegion)
      {
         query.setHint("org.hibernate.cacheRegion", "AccountRegion");
      }
      query.setHint("org.hibernate.cacheable", Boolean.TRUE);
      return (String) query.getResultList().get(0);
   }
View Full Code Here

   public List<MusicianPK> getMusiciansForInstrument(String instrument, boolean useNamedRegion)
   {
      String queryName = useNamedRegion ? "musician.byinstrument.namedregion"
                                        : "musician.byinstrument.default";
      Query query = manager.createNamedQuery(queryName);
      query.setParameter(1, instrument);
      @SuppressWarnings("unchecked")
      List<Musician> musicians = query.getResultList();
      List<MusicianPK> result = new ArrayList<MusicianPK>(musicians.size());
      for (Musician musician: musicians)
      {
         result.add(musician.getId());
      }
View Full Code Here

  
   private void internalCleanup()
   {
      if (manager != null)
      {
         Query query = manager.createQuery("select musician from Musician as musician");
         @SuppressWarnings("unchecked")
         List<Musician> musicians = query.getResultList();
         for (Musician musician: musicians)
         {
            try
            {
               log.info("Removing " + musician);
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.