Example usage for org.hibernate.criterion DetachedCriteria forClass

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria forClass.

Prototype

public static DetachedCriteria forClass(Class clazz)

Source Link

Document

Static builder to create a DetachedCriteria for the given entity, by its Class.

Usage

From source file:com.callcenter.controller.command.SearchCommand.java

License:Apache License

public DetachedCriteria getCriteria() {
    final DetachedCriteria criteria = DetachedCriteria.forClass(CallRecord.class);
    if (type == Type.FREE_FORM) {
        return criteria;
    }/*  ww  w .  j  av  a  2 s .c  o  m*/
    from.addSearchFilter(criteria);
    till.addSearchFilter(criteria);
    find.addSearchFilter(criteria);
    howLong.addSearchFilter(criteria);
    whom.addSearchFilter(criteria);
    return criteria;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

/**
 * //from   www .ja  va  2 s  .  c  o m
 * @param filter
 * @return
 */
@SuppressWarnings(value = { "unchecked", "deprecation" })
public List<T> getListByFilter(final T filter) {
    List<T> resultList = null;
    resultList = (List<T>) this.getHibernateTemplate().executeFind(new HibernateCallback() {
        @Override
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);
            buildCriteria(criteria, filter);
            return getHibernateTemplate().findByCriteria(criteria);
        }

    });
    return resultList;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

@SuppressWarnings({ "unchecked", "rawtypes" })
public T getByFilter(final T filter) {
    T resultList = null;/*from  w w w .  j  a v  a2s .co  m*/
    resultList = (T) this.getHibernateTemplate().execute(new HibernateCallback() {

        @Override
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);
            buildCriteria(criteria, filter);
            return getHibernateTemplate().findByCriteria(criteria);
        }

    });
    return resultList;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

@SuppressWarnings({ "unchecked", "rawtypes" })
public T getByFilterUnicValue(final T filter) {
    T resultList = null;/*  w  w w  .  jav a2 s.  com*/
    resultList = (T) this.getHibernateTemplate().execute(new HibernateCallback() {

        @Override
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);
            buildCriteria(criteria, filter);
            List<?> list = getHibernateTemplate().findByCriteria(criteria);
            if (list != null && !list.isEmpty())
                return getHibernateTemplate().findByCriteria(criteria).get(0);
            else
                return null;
        }

    });
    return resultList;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

@SuppressWarnings(value = "unchecked")
public List<T> getListByFilter(final T filter, final Integer id, final int firstResult, final int maxResults,
        final String sortColumn, final boolean ascending) {
    List<T> resultList = null;
    resultList = this.getHibernateTemplate().execute(new HibernateCallback<List<T>>() {

        public List<T> doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);

            if (!(sortColumn == null || sortColumn.isEmpty()))
                for (String sort : sortColumn.split("\\s*,\\s*"))
                    criteria.addOrder(ascending ? Order.asc(sort) : Order.desc(sort));

            buildCriteria(criteria, filter, id);

            return (List<T>) getHibernateTemplate().findByCriteria(criteria, firstResult, maxResults);
        }//from  www  . ja va  2s. c  om

    });
    return resultList;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

public Integer getListByFilterTotal(final T filter, final Integer id) {
    Integer numResults = null;/*from ww  w  .  jav  a2s  . c  o m*/
    numResults = this.getHibernateTemplate().execute(new HibernateCallback<Integer>() {
        @Override
        public Integer doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);
            buildCriteria(criteria, filter, id);
            criteria.setProjection(Projections.rowCount());
            return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
        }

    });
    return numResults;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

public Integer getTotalRowsByFilter(final T filter, final Integer id) {
    Integer resultList = this.getHibernateTemplate().execute(new HibernateCallback<Integer>() {
        @Override/*  ww w  .j  a va 2 s.co m*/
        public Integer doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);
            buildCriteria(criteria, filter, id);
            criteria.setProjection(Projections.rowCount());
            Object obj = getHibernateTemplate().findByCriteria(criteria).get(0);
            if (obj instanceof Long)
                return ((Long) getHibernateTemplate().findByCriteria(criteria).get(0)).intValue();
            else if (obj instanceof Integer)
                return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
            else
                return 0;
        }
    });
    return resultList;
}

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

public Integer getListByFilterTotalLong(final T filter, final Integer id) {
    Integer numResults = null;// www.j  a v  a2 s .c  om
    numResults = this.getHibernateTemplate().execute(new HibernateCallback<Integer>() {
        @Override
        public Integer doInHibernate(Session session) throws HibernateException, SQLException {
            DetachedCriteria criteria = DetachedCriteria.forClass(type);
            buildCriteria(criteria, filter);
            criteria.setProjection(Projections.rowCount());
            Object obj = getHibernateTemplate().findByCriteria(criteria).get(0);
            if (obj instanceof Long)
                return ((Long) getHibernateTemplate().findByCriteria(criteria).get(0)).intValue();
            else if (obj instanceof Integer)
                return (Integer) getHibernateTemplate().findByCriteria(criteria).get(0);
            else
                return 0;
        }

    });
    return numResults;
}

From source file:com.cimmyt.model.dao.impl.SampleDetailDAOImpl.java

License:Apache License

/**
 * Gets a list of samples from a Study by it ID, excluding samples selected
 * for SENT to external company and excluding samples in excluedSamples
 * parameter/* w  w w  .  ja v  a  2s . co m*/
 * 
 * @param labStudyId
 *            Study ID
 * @param excludedSamples
 *            list of samples to exclude
 * @return List of samples with matching ID, empty list if not matching ID
 *         or all samples are in excluedSamples
 */
@Override
@SuppressWarnings("unchecked")
public List<SampleDetail> getSamplesByStudy(final Integer labStudyId, final List<Integer> excludedSamples) {
    List<SampleDetail> sampleDetails = null;
    DetachedCriteria criteria = DetachedCriteria.forClass(SampleDetail.class);
    criteria.add(Restrictions.eq("labstudyid.labstudyid", labStudyId));
    criteria.add(Restrictions.ne("selforsend", ShipmentStatus.FOR_SEND.getId()));
    if (excludedSamples.size() > 0) {
        criteria.add(Restrictions.not(Restrictions.in("studysampleid", excludedSamples)));
    }
    sampleDetails = (List<SampleDetail>) getHibernateTemplate().findByCriteria(criteria);
    return sampleDetails;
}

From source file:com.cimmyt.model.dao.impl.SampleDetailDAOImpl.java

License:Apache License

@SuppressWarnings("unchecked")
public List<SampleDetail> getSamplesByStudyUsedInStorageLocation(final Integer labStudyId,
        final List<Integer> excludedSamples, int firstResult, int maxResults) {
    List<SampleDetail> sampleDetails = null;
    DetachedCriteria criteria = DetachedCriteria.forClass(SampleDetail.class);
    criteria.add(Restrictions.eq("labstudyid.labstudyid", labStudyId));
    criteria.add(Restrictions.eq("selforsend", ShipmentStatus.NO_SELECTED.getId()));
    if (excludedSamples.size() > 0) {
        criteria.add(Restrictions.not(Restrictions.in("studysampleid", excludedSamples)));
    }//from   www.j av a 2 s  . co  m

    sampleDetails = (List<SampleDetail>) getHibernateTemplate().findByCriteria(criteria, firstResult,
            maxResults);
    return sampleDetails;
}