Example usage for org.hibernate.criterion Restrictions and

List of usage examples for org.hibernate.criterion Restrictions and

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. and

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions and.

Prototype

public static Conjunction and(Criterion... predicates)

Source Link

Document

Return the conjuction of multiple expressions

Usage

From source file:com.apt.facade.SubjectFacade.java

public int getNumberSubject(SubjectFinder finder) {
    List<Subject> lst = new ArrayList<>();

    Session session = null;//w ww. ja  v a2  s.  com
    Transaction trans = null;

    try {
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        trans = session.beginTransaction();

        Criteria crit = session.createCriteria(Subject.class);
        crit.add(Restrictions.sqlRestriction("1=1"));
        if (finder.getSubjectId() != null) {
            crit.add(Restrictions.and(Restrictions.eq("subjectId", finder.getSubjectId())));
        }
        if (finder.getSubjectName() != null) {
            crit.add(Restrictions.and(Restrictions.ilike("subjectName", "%" + finder.getSubjectName() + "%")));
        }
        lst = crit.list();
        trans.commit();

    } catch (Exception e) {
        e.printStackTrace();
        if (trans != null) {
            trans.rollback();
        }
    } finally {
        if (session != null && session.isConnected()) {
            session.close();
        }
    }

    return lst.size();
}

From source file:com.bean.PropertyViewBean.java

public void init() {
    Criterion cType = null;/*from   w  w  w.  ja  va  2  s. c  o m*/
    Criterion cCat = null;
    title = "Real estate | Buy, sell, rent out real estate";
    if (type == 1) {
        title = "Property for sale";
        ExchangeType e = new ExchangeType(type);
        cType = Restrictions.eq("exchangeType", e);
    } else if (type == 2) {
        title = "Property for rent";
        ExchangeType e = new ExchangeType(type);
        cType = Restrictions.eq("exchangeType", e);
    } else {
        cType = Restrictions.isNotNull("exchangeType");
    }

    if (cat != 0) {
        PropertyType t = new PropertyType(cat);
        cCat = Restrictions.eq("propertyType", t);
    } else {
        cCat = Restrictions.isNotNull("propertyType");
    }
    Dao dao = new Dao();
    Criterion stt = Restrictions.eq("proStatus", 0);
    Criterion cpub = Restrictions.eq("proPublish", true);
    Conjunction logic = Restrictions.and(new Criterion[] { cCat, cType, stt, cpub });
    Order o = Order.desc("proPublishDate");
    listProperty = dao.getByCondition(Property.class, logic, o);
}

From source file:com.bean.SuggestedBean.java

public void init(long id) {
    Dao dao = new Dao();
    Property p = (Property) dao.getById(Property.class, id);
    Province prov = (Province) dao.getById(Province.class, p.getDistrict().getProvince().getProvId());
    Criterion d = Restrictions.in("district", prov.getDistricts());
    Criterion cat = Restrictions.eq("propertyType", p.getPropertyType());
    Criterion type = Restrictions.eq("exchangeType", p.getExchangeType());
    Criterion status = Restrictions.eq("proStatus", 0);
    Order o = Order.desc("proCreateDate");
    Conjunction logic = Restrictions.and(new Criterion[] { d, cat, type, status });
    listSuggested = dao.getByCondition(Property.class, logic, o, 0, 6);
}

From source file:com.bean.SuggestedBean.java

public List<Property> getSpecialProperty() {
    Dao dao = new Dao();
    Order o = Order.desc("proPublishDate");
    Order o1 = Order.asc("proHit");
    Criterion stt = Restrictions.eq("proStatus", 0);
    Criterion cpub = Restrictions.eq("proPublish", true);
    Conjunction logic = Restrictions.and(new Criterion[] { stt, cpub });
    List<Property> list = dao.getByCondition(Property.class, logic, new Order[] { o, o1 }, 0, 2);
    return list;//from   www  .ja va  2  s.co  m
}

From source file:com.bean.SuggestedBean.java

public List<Property> getLastestProperty() {
    Dao dao = new Dao();
    Order o = Order.desc("proPublishDate");
    Criterion stt = Restrictions.eq("proStatus", 0);
    Criterion cpub = Restrictions.eq("proPublish", true);
    Conjunction logic = Restrictions.and(new Criterion[] { stt, cpub });
    List<Property> list = dao.getByCondition(Property.class, logic, o, 0, 6);
    return list;//from ww  w .java 2  s.co m
}

From source file:com.bean.SuggestedBean.java

public List<Property> getMostViewProperty() {
    Dao dao = new Dao();
    Order o = Order.desc("proHit");
    Criterion stt = Restrictions.eq("proStatus", 0);
    Criterion cpub = Restrictions.eq("proPublish", true);
    Conjunction logic = Restrictions.and(new Criterion[] { stt, cpub });
    List<Property> list = dao.getByCondition(Property.class, logic, o, 0, 6);
    return list;//from   w w  w  .  j a va  2s.  com
}

From source file:com.eucalyptus.compute.common.internal.vm.VmInstances.java

License:Open Source License

public static <T> List<T> listWithProjection(@Nonnull final InstanceProjection<T> projection,
        final Criterion... criterions) {
    try (final TransactionResource db = Entities.readOnlyDistinctTransactionFor(VmInstance.class)) {
        final Criteria query = Entities.createCriteria(VmInstance.class).setReadOnly(true).setFetchSize(25_000)
                .add(Restrictions.and(criterions)).setProjection(projection.getProjection());
        return projection.results(query.list());
    }/*from  w  ww . j  a  va 2s  .c om*/
}

From source file:com.evolveum.midpoint.repo.sql.query.restriction.ItemRestriction.java

License:Apache License

private Criterion andCriterions(List<Criterion> criterions) {
    switch (criterions.size()) {
    case 0://ww w  . ja va2 s. c om
        return null;
    case 1:
        return criterions.get(0);
    default:
        return Restrictions.and(criterions.toArray(new Criterion[criterions.size()]));
    }
}

From source file:com.evolveum.midpoint.repo.sql.QueryInterpreterTest.java

License:Apache License

@Test
public void test390queryObjectypeByTypeAndReference() throws Exception {
    Session session = open();// w w  w.  j  a v  a  2 s . c o m
    try {
        Criteria main = session.createCriteria(RObject.class, "o");
        ProjectionList projections = Projections.projectionList();
        addFullObjectProjectionList("o", projections, false);
        main.setProjection(projections);

        Conjunction c = Restrictions.conjunction();
        main.add(c);
        c.add(Restrictions.eq("o." + RObject.F_OBJECT_TYPE_CLASS, RObjectType.USER));

        Criteria refs = main.createCriteria("linkRef", "l", JoinType.LEFT_OUTER_JOIN);
        c.add(Restrictions.and(Restrictions.eq("l.targetOid", "123")));

        String expected = HibernateToSqlTranslator.toSql(main);

        RefFilter ref = RefFilter.createReferenceEqual(UserType.F_LINK_REF, UserType.class, prismContext,
                "123");
        TypeFilter type = TypeFilter.createType(UserType.COMPLEX_TYPE, ref);

        String real = getInterpretedQuery(session, ObjectType.class, ObjectQuery.createObjectQuery(type));

        LOGGER.info("exp. query>\n{}\nreal query>\n{}", new Object[] { expected, real });
        AssertJUnit.assertEquals(expected, real);
    } finally {
        close(session);
    }
}

From source file:com.puertobahia.iceberg.dao.impl.ZonaDAOImpl.java

@Override
public Zona getById(Long id) {
    Criteria crit = getSession().createCriteria(Zona.class);
    crit.add(Restrictions.idEq(id));/*from w  w w .  j a  va2 s . co m*/
    crit.setFetchMode("usuario", FetchMode.JOIN);
    crit.setFetchMode("usuario.empleado", FetchMode.JOIN);
    crit.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    crit.setFetchMode("consejos_comunitario", FetchMode.JOIN);
    crit.createAlias("consejos_comunitario", "consejo", JoinType.LEFT_OUTER_JOIN);
    crit.add(Restrictions.or(Restrictions.and(Restrictions.eq("consejo.estado", 0)),
            Restrictions.isNull("consejo.estado")));
    return (Zona) crit.uniqueResult();
    /*Criteria crit = getSession().createCriteria(Zona.class);
     crit.add(Restrictions.idEq(id));
     crit.setFetchMode("usuario", FetchMode.JOIN);
     crit.setFetchMode("usuario.empleado", FetchMode.JOIN);
     crit.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
     Zona zona = (Zona) crit.uniqueResult();
     Criteria crit2 = getSession().createCriteria(ConsejoComunitario.class);
     zona.setConsejos_comunitario(crit2.add(Restrictions.and(Restrictions.idEq(zona.getId()),Restrictions.eq("estado", 0))).list());
     return zona;*/
}