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

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


            public Object doInHibernate(Session session)
                throws HibernateException {
              Criteria crit = session
                  .createCriteria(Deviation.class);
                            if(deviation.getInitiatedBy()!=null){
                                crit.add(Restrictions.eq("initiatedBy",
                                        deviation.getInitiatedBy()));
                            }
              if (deviation.getDeviationId() != null) {
                crit.add(Restrictions.eq("deviationId",
                    deviation.getDeviationId()));
              }
              if (deviation.getUserName() != null) {
                crit.add(Restrictions.ilike("userName",
                    deviation.getUserName()));
              }
              if (deviation.getResponsible() != null) {
                crit.add(Restrictions.ilike("responsible",
                    deviation.getResponsible()));
              }
              if (deviation.getOrderNr() != null) {
                crit.add(Restrictions.eq("orderNr", deviation
                    .getOrderNr()));
              }
                            if (deviation.getProjectNr() != null) {
                                crit.add(Restrictions.eq("projectNr",
                                        deviation.getProjectNr()));
                            }
              if (deviation.getCustomerNr() != null) {
                crit.add(Restrictions.eq("customerNr",
                    deviation.getCustomerNr()));
              }
                            
              if (deviation.getCustomerName() != null) {
                crit.add(Restrictions.ilike("customerName",
                    deviation.getCustomerName()));
              }
                            if (deviation.getPreventiveAction() != null) {
                                crit.add(Restrictions.ilike("preventiveAction",
                                        deviation.getPreventiveAction()));
                            }
              if (deviation.getProductArea() != null) {
                crit.add(Restrictions.eq("productArea",
                    deviation.getProductArea()));
              }
              if (deviation.getProductName() != null) {
                crit.add(Restrictions.ilike("productName",
                    deviation.getProductName()));
              }
              
              if (deviation.getIsPostShipment().equalsIgnoreCase(
                  "Ja")) {
                crit
                    .add(Restrictions
                        .isNotNull("postShipment"));
              }
              if (deviation.getDoAssembly() != null) {
                crit.add(Restrictions.eq("doAssembly",
                    deviation.getDoAssembly()));
              }
              if (deviation.getOwnFunction() != null) {
                crit.add(Restrictions.eq("ownFunction",
                    deviation.getOwnFunction()));
              }
              if (deviation.getDeviationFunction() != null) {
                crit.add(Restrictions.eq("deviationFunction",
                    deviation.getDeviationFunction()));
              }
              if (deviation.getFunctionCategory() != null) {
                crit.add(Restrictions.eq("functionCategory",
                    deviation.getFunctionCategory()));
              }
              if (deviation.getDeviationStatus() != null) {
                crit.add(Restrictions.eq("deviationStatus",
                    deviation.getDeviationStatus()));
              }
              if (deviation.getDateClosed() != null) {
                crit.add(Restrictions.eq("dateClosed",
                    deviation.getDateClosed()));
              }
              if (deviation.getChecked() != null) {
                crit.add(Restrictions.eq("checked", deviation
                    .getChecked()));
              }


              if (deviation.getDateFrom() != null
                  && deviation.getDateTo() == null) {
                crit.add(Restrictions.gt("registrationDate",
                    Util.getShortDate(deviation
                        .getDateFrom())));
              }
              if (deviation.getDateFrom() == null
                  && deviation.getDateTo() != null) {
                crit.add(Restrictions.lt("registrationDate",
                    Util.getShortDateLast(deviation
                        .getDateTo())));
              }
              if (deviation.getDateFrom() != null
                  && deviation.getDateTo() != null) {
                crit.add(Restrictions.between(
                    "registrationDate", Util
                        .getShortDate(deviation
                            .getDateFrom()), Util
                        .getShortDateLast(deviation
                            .getDateTo())));
              }


              return crit.list();
            }


          });
    }
    return null;

View Full Code Here

    @SuppressWarnings("unchecked")
    public final List<ApplicationUser> findByUserNameAndPassword(final String userName, final String password) {
        return (List<ApplicationUser>) getHibernateTemplate().execute(new HibernateCallback() {


            public Object doInHibernate(final Session session) {
                Criteria crit = session.createCriteria(ApplicationUser.class).add(
                        Restrictions.ilike("userName", userName));


                if (password != null) {
                    crit.add(Restrictions.eq("password", password));
                }
                return crit.list();
            }


        });
    }

View Full Code Here

    @SuppressWarnings("unchecked")
    public List<String> findAllPackers(final ProductAreaGroup productAreaGroup) {
        return (List<String>) getHibernateTemplate().execute(new HibernateCallback() {


            public Object doInHibernate(Session session) throws HibernateException {
                Criteria criteria = session.createCriteria(ApplicationUser.class).add(
                        Restrictions.eq("groupUser", "Nei"));


                ProductAreaGroupSelector selector = ProductAreaGroupSelector.valueOf(StringUtils
                        .upperCase(productAreaGroup.getProductAreaGroupName()));
                selector.setRestriction(criteria, productAreaGroup);


                criteria = criteria.createCriteria("userRoles").createCriteria("userType").add(
                        Restrictions.eq("description", ApplicationParamUtil
                                .findParamByName("user_type_package")));


                List<ApplicationUser> users = criteria.list();


                List<String> initialsList = new ArrayList<String>();
                for (ApplicationUser user : users) {
                    initialsList.add(user.getUserName());
                }

View Full Code Here

      final Integer customerNr, final ProductAreaGroup productAreaGroup) {
    return (List<FaktureringV>) getHibernateTemplate().execute(
                new HibernateCallback() {


                    public Object doInHibernate(final Session session) {
                        Criteria criteria= session.createCriteria(FaktureringV.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<FaktureringV>) getHibernateTemplate().execute(
                  new HibernateCallback() {


                      public Object doInHibernate(Session session)
                              throws HibernateException {
                        Criteria criteria= session.createCriteria(FaktureringV.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

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


          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria= session.createCriteria(GavlProductionV.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<Produceable>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria=  session.createCriteria(


            GavlProductionV.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 final List<Order> getAllNewOrders() {
    return (List<Order>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(final Session session) {
            Criteria crit = session.createCriteria(Order.class)
                .add(Restrictions.isNull("transport"));
            crit.setFetchMode("assembly", FetchMode.JOIN);
            crit.setFetchMode("assembly.assemblyTeam",
                FetchMode.JOIN);
            return crit.list();
          }


        });
  }

View Full Code Here

            Example example = Example.create(order);
            example.enableLike(MatchMode.ANYWHERE);
            example.ignoreCase();
            example.excludeZeroes();


            Criteria crit = session.createCriteria(Order.class)
                .add(example);


            if (order.getCustomer() != null) {
              Customer customer = order.getCustomer();
              crit = crit.createCriteria("customer");
              if (customer.getCustomerNr() != null) {
                crit.add(Restrictions.eq("customerNr",
                    customer.getCustomerNr()));
              }
              if (customer.getFirstName() != null) {
                crit.add(Restrictions.ilike("firstName",
                    customer.getFirstName()));
              }
              if (customer.getLastName() != null) {
                crit.add(Restrictions.ilike("lastName",
                    customer.getLastName()));
              }
            }
            if (order.getConstructionType() != null) {
              crit.add(Restrictions.eq("constructionType",
                  order.getConstructionType()));
            }
            if (order.getTransport() != null) {
              crit.add(Restrictions.eq("transport",
                  order.getTransport()));
            }
            return crit.list();
          }


        });
  }

View Full Code Here

      final String orderBy) {
    return (List<Order>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(final Session session) {
            Criteria crit = session.createCriteria(Order.class)
                .add(Restrictions.isNull("sent"));


            if (criteria != null) {
              crit = crit.createCriteria(criteria);
            }
            if (orderBy != null) {
              crit.addOrder(org.hibernate.criterion.Order
                  .asc(orderBy));
            }
            return crit.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.