Example usage for org.hibernate.criterion Example create

Introduction

In this page you can find the example usage for org.hibernate.criterion Example create.

Prototype

public static Example create(Object exampleEntity)

Source Link

Document

Create a new Example criterion instance, which includes all non-null properties by default

Usage

From source file:aa.PersonDog.dao.AbstractDao.java

protected List queryByExample(Object obj) {

    List objects = null;/*from  ww w  .  ja v  a 2 s  .  c  o m*/

    try {
        startOperation();

        // https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/querycriteria.html  
        // http://blog.caelum.com.br/simplifique-suas-consultas-com-o-query-by-example-do-hibernate/

        Example ex = Example.create(obj).excludeZeroes() //exclude zero valued properties
                .ignoreCase() //perform case insensitive string comparisons
                .enableLike(MatchMode.ANYWHERE); //use like for string comparisons
        Criteria criteria = session.createCriteria(obj.getClass()).add(ex);
        objects = criteria.list();

        commit();
    } catch (HibernateException e) {
        handleException(e);
    } finally {
        HibernateFactory.close(session);
    }
    return objects;
}

From source file:abstractDao.AbstractDao.java

protected List<T> findByExample(T t) {
    List<T> objects = null;
    try {//w  ww  . java  2  s . co m
        startOperation();
        objects = session.createCriteria(t.getClass()).add(Example.create(t)).list();
        //            tx.commit();
    } catch (HibernateException e) {
        handleException(e);
    } finally {
        HibernateFactory.close(session);
    }
    return objects;
}

From source file:at.ac.tuwien.ifs.tita.dao.GenericHibernateDao.java

License:Apache License

/** {@inheritDoc} */
@SuppressWarnings("unchecked")
public List<T> findByExample(T exampleInstance, String... excludeProps) {

    List<T> myList = null;/*from w w w .ja v  a2  s .c  o m*/

    try {
        Criteria crit = getSession().createCriteria(this.persistenceClass);
        Example example = Example.create(exampleInstance);
        for (String exclude : excludeProps) {
            example.excludeProperty(exclude);
        }
        crit.add(example);
        // Tell Hibernate to remove duplicates from the result set if there
        // is a
        // OneToMany relation in the exampleInstance entity.
        crit.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

        myList = crit.list();
    } catch (Exception e) {
        throw new PersistenceException("Failure during reading entities (by example). Class="
                + this.persistenceClass.getSimpleName() + "\n" + e.getMessage(), e);
    }

    return myList;
}

From source file:au.org.theark.core.dao.ArkAuthorisationDao.java

License:Open Source License

public StudyStatus getStudyStatus(String statusName) throws StatusNotAvailableException {
    StudyStatus studyStatus = new StudyStatus();
    studyStatus.setName("Archive");
    Example studyStatusExample = Example.create(studyStatus);

    Criteria studyStatusCriteria = getSession().createCriteria(StudyStatus.class).add(studyStatusExample);
    if (studyStatusCriteria != null && studyStatusCriteria.list() != null
            && studyStatusCriteria.list().size() > 0) {
        return (StudyStatus) studyStatusCriteria.list().get(0);
    } else {/* www.  j a v  a 2 s . co m*/
        log.error("Study Status Table maybe out of synch. Please check if it has an entry for Archive status");
        throw new StatusNotAvailableException();
    }
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public SubjectStatus getSubjectStatus(String statusName) {

    SubjectStatus statusToReturn = null;

    SubjectStatus subjectStatus = new SubjectStatus();
    subjectStatus.setName(statusName);/*from ww  w  .j av  a2s .  c  o m*/
    Example example = Example.create(subjectStatus);

    Criteria criteria = getSession().createCriteria(SubjectStatus.class).add(example);

    if (criteria != null) {
        List<SubjectStatus> results = criteria.list();
        if (results != null && !results.isEmpty()) {
            statusToReturn = (SubjectStatus) results.get(0);
        }
    }

    return statusToReturn;
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

/**
 * Given a status name will return the StudyStatus object.
 *///w w  w  .  java 2  s  .co  m
@SuppressWarnings("unchecked")
public StudyStatus getStudyStatus(String statusName) throws StatusNotAvailableException {
    StudyStatus studyStatus = new StudyStatus();
    studyStatus.setName("Archive");
    Example studyStatusExample = Example.create(studyStatus);

    Criteria studyStatusCriteria = getSession().createCriteria(StudyStatus.class).add(studyStatusExample);
    if (studyStatusCriteria != null) {
        List<StudyStatus> results = studyStatusCriteria.list();
        if (results != null && results.size() > 0) {
            return (StudyStatus) results.get(0);
        }
    }

    log.error(
            "Study Status Table maybe out of synch. Please check if it has an entry for Archive status.  Cannot locate a study status with "
                    + statusName + " in the database");
    throw new StatusNotAvailableException();

}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<StudyStatus> getListOfStudyStatus() {
    Example studyStatus = Example.create(new StudyStatus());
    Criteria criteria = getSession().createCriteria(StudyStatus.class).add(studyStatus);
    return criteria.list();

}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<TitleType> getTitleType() {
    Example example = Example.create(new TitleType());
    Criteria criteria = getSession().createCriteria(TitleType.class).add(example);
    return criteria.list();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<VitalStatus> getVitalStatus() {
    Example example = Example.create(new VitalStatus());
    Criteria criteria = getSession().createCriteria(VitalStatus.class).add(example);
    return criteria.list();
}

From source file:au.org.theark.core.dao.StudyDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public Collection<GenderType> getGenderTypes() {
    Example example = Example.create(new GenderType());
    Criteria criteria = getSession().createCriteria(GenderType.class).add(example);
    return criteria.list();
}