Examples of org.hibernate.Criteria

org.hibernate.Criteria
Criteria is a simplified API for retrieving entities by composing Criterion objects. This is a very convenient approach for functionality like "search" screens where there is a variable number of conditions to be placed upon the result set.

The Session is a factory for Criteria. Criterion instances are usually obtained via the factory methods on Restrictions. eg.
```
 List cats = session.createCriteria(Cat.class) .add( Restrictions.like("name", "Iz%") ) .add( Restrictions.gt( "weight", new Float(minWeight) ) ) .addOrder( Order.asc("age") ) .list(); 
```
You may navigate associations using createAlias() or createCriteria().
```
 List cats = session.createCriteria(Cat.class) .createCriteria("kittens") .add( Restrictions.like("name", "Iz%") ) .list(); 
```
```
 List cats = session.createCriteria(Cat.class) .createAlias("kittens", "kit") .add( Restrictions.like("kit.name", "Iz%") ) .list(); 
```
You may specify projection and aggregation using Projection instances obtained via the factory methods on Projections.
```
 List cats = session.createCriteria(Cat.class) .setProjection( Projections.projectionList() .add( Projections.rowCount() ) .add( Projections.avg("weight") ) .add( Projections.max("weight") ) .add( Projections.min("weight") ) .add( Projections.groupProperty("color") ) ) .addOrder( Order.asc("color") ) .list(); 
```
@see Session#createCriteria(java.lang.Class) @see org.hibernate.criterion.Restrictions @see org.hibernate.criterion.Projections @see org.hibernate.criterion.Order @see org.hibernate.criterion.Criterion @see org.hibernate.criterion.Projection @see org.hibernate.criterion.DetachedCriteria a disconnected version of this API @author Gavin King

        new HibernateCallback() {


          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(VeggProductionV.class)
                .add(Restrictions.eq("customerNr", customerNr));
            
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

        new HibernateCallback() {


          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(VeggProductionV.class)
                .add(Restrictions.eq("orderNr", orderNr));
            
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

        new HibernateCallback() {


          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(TaksteinSkarpnesV.class)
                .add(Restrictions.eq("customerNr", customerNr));
            
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

        new HibernateCallback() {


          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(


            TaksteinSkarpnesV.class).add(
                Restrictions.eq("orderNr", orderNr));
            
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

  public List<OwnProductionV> findByParams(final ExcelReportSetting params) {
    return (List) getHibernateTemplate().execute(new HibernateCallback() {


      public Object doInHibernate(Session session)
          throws HibernateException {
        Criteria criteria = session
            .createCriteria(OwnProductionV.class)
            .add(Restrictions.eq("orderReadyYear", params.getYear()))
            .add(Restrictions.eq("orderReadyWeek",
                params.getWeekFrom()));


        String productAreaGroupName = ((ExcelReportSettingOwnProduction) params)
            .getProductAreaGroupName();
        if (!productAreaGroupName.equalsIgnoreCase("Alle")) {
          criteria.add(Restrictions.eq("productAreaGroupName",
              productAreaGroupName));
        }
        criteria.addOrder(Order.desc("productArea")).addOrder(
            Order.asc("orderReadyDay"));
        return criteria.list();
      }


    });
  }

View Full Code Here

      final String productAreaName, final String productAreaGroupName) {
    return (List) getHibernateTemplate().execute(new HibernateCallback() {


      public Object doInHibernate(Session session)
          throws HibernateException {
        Criteria criteria = session
            .createCriteria(OwnProductionV.class)
            .add(Restrictions.isNull("sent"))
            .add(Restrictions.isNull("packlistReady"))
            .add(Restrictions.isNull("orderReadyDay"));
        if (productAreaName != null) {
          criteria.add(Restrictions
              .eq("productArea", productAreaName));
        }
        if (productAreaGroupName != null) {
          criteria.add(Restrictions.eq("productAreaGroupName",
              productAreaGroupName));
        }
        criteria.addOrder(Order.asc("productArea"))
            .addOrder(Order.asc("transportYear"))
            .addOrder(Order.asc("transportWeek")).list();
        return criteria.list();
      }


    });
  }

View Full Code Here

    return (List<PackableListItem>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria=  session.createCriteria(GulvsponPackageV.class)
                .add(Restrictions.eq("customerNr", customerNr));
            
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

    return (List<PackableListItem>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria=   session.createCriteria(GulvsponPackageV.class)
                .add(Restrictions.eq("orderNr", orderNr));
            
            
            if(productAreaGroup!=null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")){
              criteria.add(Restrictions.eq("productAreaGroupName", productAreaGroup.getProductAreaGroupName()));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

      final ProductArea productArea, final BudgetType budgetType) {
    return (List<Budget>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(final Session session) {
            Criteria crit = session.createCriteria(Budget.class)
                .add(
                    Restrictions.eq("productArea",
                        productArea)).add(
                    Restrictions.eq("budgetYear", year))
                .add(Restrictions.eq("budgetWeek", week)).add(
                    Restrictions.eq("budgetType",
                        budgetType.ordinal()));


            if (notId != null) {
              crit.add(Restrictions.ne("budgetId", notId));
            }


            return crit.list();
          }


        });
  }

View Full Code Here

    public List<SaleStatusV> findByProbabilitesAndProductArea(
            final List<Integer> probabilities, final ProductArea productArea) {
        return (List<SaleStatusV>) getHibernateTemplate().execute(new HibernateCallback() {


            public Object doInHibernate(final Session session) {
                Criteria criteria = session.createCriteria(SaleStatusV.class).add(
                        Restrictions.in("probability", probabilities));


                
                criteria = productArea != null ? criteria.add(Restrictions.eq("deptno", Integer.valueOf(productArea
                        .getProductAreaNr()))) : criteria;
                return criteria.list();
            }
        });
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hibernate.Criteria

br.com.flexait.core.AbstractDao

br.facet.tcc.impl.dao.DaoConfiguration

calendar.dao.Dao

com.abiquo.server.core.appslibrary.VirtualImageConversionDAO

com.abiquo.server.core.appslibrary.VirtualMachineTemplateDAO

com.abiquo.server.core.cloud.NodeVirtualImageDAO

com.abiquo.server.core.cloud.VirtualDatacenterDAO

com.abiquo.server.core.cloud.VirtualMachineDAO

com.abiquo.server.core.common.persistence.DefaultDAOBase

com.abiquo.server.core.config.SystemPropertyDAO

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.