Package org.hibernate

Examples of org.hibernate.Criteria


     
     
      if(user.getUserType()==UserType.Administrator)
      {
        Criteria criteria = session.createCriteria(BOCompany.class);
        return criteria.list();
      }
     
      else
      {
        ArrayList<BOCompany> companyList = new ArrayList<BOCompany>();
View Full Code Here


     
     
      if(user.getUserType()==UserType.Administrator)
      {
        Criteria criteria = session.createCriteria(BODepartment.class);
        return criteria.list();
      }
     
      else
      {
        ArrayList<BODepartment> departmentList = new ArrayList<BODepartment>();
View Full Code Here

    Session session = null;
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();

      Criteria criteria = session.createCriteria(BOUser.class);
      session.flush();
     
      return criteria.list();
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
      close(sessionFactory, session);
    }
View Full Code Here

    Session session = null;
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();

      Criteria criteria = session.createCriteria(BOUser.class);
     
      criteria.add(Restrictions.in("userID", ids));
      return criteria.list();
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
      close(sessionFactory, session);
    }
View Full Code Here

     
     
      if(user.getUserType()==UserType.Administrator)
      {
        Criteria criteria = session.createCriteria(BOCompany.class);
        return criteria.list();
      }
     
      else
      {
        ArrayList<BOCompany> companyList = new ArrayList<BOCompany>();
View Full Code Here

    Session session = null;
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();

      Criteria criteria = session.createCriteria(BOFile.class);
      criteria.add(Restrictions.eq("taskID", taskID));
      criteria.add(Restrictions.sqlRestriction(" file_id in(select max(fl.file_id) from files as fl group by fl.file_version_id) "));
      return criteria.list();
     
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
      close(sessionFactory, session);
View Full Code Here

    SessionFactory sessionFactory = null;
    Session session = null;
    try {
      sessionFactory = HibernateSessionFactory.getInstance();
      session = sessionFactory.openSession();
      Criteria criteria = session.createCriteria(BOFile.class);
      criteria.add(Restrictions.eq("project", project));
      criteria.add(Restrictions.sqlRestriction(" file_id in(select max(fl.file_id) from files as fl group by fl.file_version_id) "));
      return criteria.list();
    } catch (Exception a_th) {
      throw new RuntimeException(a_th);
    } finally {
      close(sessionFactory, session);
    }
View Full Code Here

    public ArticleType findByProdCatNoAndProdCatNo2(final Integer prCatNo, final Integer prCatNo2) {
        return (ArticleType) getHibernateTemplate().execute(new HibernateCallback() {

            @SuppressWarnings("unchecked")
            public Object doInHibernate(final Session session) {
                Criteria criteria = session.createCriteria(ArticleType.class);
               
                criteria = prCatNo!=null?criteria.add(Restrictions.eq("prodCatNo", prCatNo)):criteria.add(Restrictions.isNull("prodCatNo"));
                criteria = prCatNo2!=null?criteria.add(Restrictions.eq("prodCatNo2", prCatNo2)):criteria.add(Restrictions.isNull("prodCatNo2"));
               
                List<ArticleType> list =criteria.list();
                if (list != null && list.size() == 1) {
                    return list.get(0);
                }
                return ArticleType.UNKNOWN;
            }
View Full Code Here

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

          public Object doInHibernate(final Session session) {
            Criteria crit = session.createCriteria(Supplier.class);

            if (orderBy != null) {
              crit.addOrder(Order.asc(orderBy));
            }

            crit = crit.createCriteria("supplierType").add(
                Restrictions.ilike("supplierTypeName",
                    typeString));

            return crit.list();
          }

        });
  }
View Full Code Here

      final String orderBy, final ProductAreaGroup productAreaGroup) {
    return (List<Supplier>) getHibernateTemplate().execute(
        new HibernateCallback() {

          public Object doInHibernate(final Session session) {
            Criteria crit = session
                .createCriteria(Supplier.class)
                .add(
                    Restrictions.or(Restrictions
                        .isNull("inactive"),
                        Restrictions.eq("inactive", 0)));

            if (orderBy != null) {
              crit.addOrder(Order.asc(orderBy));
            }
           
            crit.createAlias("supplierType", "supplierType");
            crit.add(Restrictions.ilike("supplierType.supplierTypeName", typeString));

            if (productAreaGroup != null&&!productAreaGroup.getProductAreaGroupName().equalsIgnoreCase("Alle")) {

              crit = crit
                  .createCriteria("supplierProductAreaGroups")
                  .add(
                      Restrictions
                          .eq(
                              "productAreaGroup",
                              productAreaGroup));
            }


            return crit.list();
          }

        });
  }
View Full Code Here

TOP

Related Classes of org.hibernate.Criteria

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.