Example usage for org.hibernate.criterion DetachedCriteria addOrder

Introduction

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

Prototype

public DetachedCriteria addOrder(Order order)

Source Link

Document

Adds an ordering

Usage

From source file:org.mvnsearch.snippet.domain.manager.impl.CategoryManagerImpl.java

License:Open Source License

/**
 * find root categories/*from   w w w  .  ja va 2s .c  om*/
 *
 * @return category list
 */
@Cacheable(modelId = "root_categories")
public List<Category> findRootCategories() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Category.class);
    criteria.add(Restrictions.isNull("parentId"));
    criteria.addOrder(Order.asc("name"));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.mvnsearch.snippet.domain.manager.impl.SnippetManagerImpl.java

License:Open Source License

/**
 * get recent added snippets//from   w  ww .j  av a  2 s  . com
 *
 * @param maxNum max number
 * @return snippet list
 */
@SuppressWarnings({ "unchecked" })
public List<Snippet> findRecentAddedSnippets(int maxNum) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
    criteria.addOrder(Order.desc("modifiedAt"));
    return getHibernateTemplate().findByCriteria(criteria, 0, maxNum);
}

From source file:org.mvnsearch.snippet.domain.manager.impl.SnippetManagerImpl.java

License:Open Source License

/**
 * find snippets according to tag/*from ww  w . j a  va 2s. c om*/
 *
 * @param tag tag
 * @return snippet list
 */
public List<Snippet> findSnippetsByTag(String tag) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
    criteria.add(Restrictions.like("tag", "%" + tag + "%"));
    criteria.addOrder(Order.desc("level"));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.mvnsearch.snippet.domain.manager.impl.SnippetManagerImpl.java

License:Open Source License

/**
 * find snippets according to word/*from   w w w .j  a  v a2 s .  com*/
 *
 * @param word word
 * @return snippet list
 */
public List<Snippet> findSnippetsByWord(String word) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getEntityClass());
    criteria.add(Restrictions.or(Restrictions.like("name", "%" + word + "%"),
            Restrictions.like("keywords", "%" + word + "%")));
    criteria.addOrder(Order.desc("level"));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.mvnsearch.snippet.domain.manager.impl.SnippetManagerImpl.java

License:Open Source License

/**
 * find recent added comment//  w  w w.  ja v  a 2s .  c  o  m
 *
 * @param count count
 * @return comment list
 */
public List<Comment> findRecentAddedComments(int count) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Comment.class);
    criteria.addOrder(Order.desc("id"));
    return getHibernateTemplate().findByCriteria(criteria, 0, count);
}

From source file:org.mvnsearch.snippet.domain.Snippet.java

License:Open Source License

/**
 * find comments for snippet/* w w w  . j ava 2s.  c o  m*/
 *
 * @return comment list
 */
public List<Comment> findComments() {
    DetachedCriteria criteria = DetachedCriteria.forClass(Comment.class);
    criteria.add(Restrictions.eq("snippetId", this.id));
    criteria.addOrder(Order.desc("id"));
    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:org.nema.medical.mint.server.domain.ChangeDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Change> findChanges(final Date since, int first, int max) {
    if (since != null) {
        final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Change.class);
        detachedCriteria.add(Restrictions.gt("dateTime", since));
        detachedCriteria.addOrder(Order.desc("dateTime"));
        final List<Change> list = getHibernateTemplate().findByCriteria(detachedCriteria, first, max);
        return list;
    }/*w  w w. j  a va2 s.c o m*/
    return null;
}

From source file:org.nema.medical.mint.server.domain.ChangeDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<Change> findChanges(final int first, final int max) {
    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Change.class);
    detachedCriteria.addOrder(Order.desc("dateTime"));

    final List<Change> list = getHibernateTemplate().findByCriteria(detachedCriteria, first, max);
    return list;/*from   www.ja  v  a2s  .c  o  m*/
}

From source file:org.nema.medical.mint.server.domain.StudyDAO.java

License:Apache License

@SuppressWarnings("unchecked")
public List<MINTStudy> findStudies(final String studyInstanceUID, final String accessionNumber,
        final String accessionNumberIssuer, final String patientID, final String patientIDIssuer,
        final Date minStudyDateTime, final Date minStudyDate, final Date maxStudyDateTime,
        final Date maxStudyDate, final int limit, final int offset) throws DateTimeParseException {

    final DetachedCriteria detachedCriteria = DetachedCriteria.forClass(MINTStudy.class);
    detachedCriteria.addOrder(Order.desc("lastModified"));

    if (studyInstanceUID != null && StringUtils.isNotBlank(studyInstanceUID)) {
        detachedCriteria.add(Restrictions.eq("studyInstanceUID", studyInstanceUID));
    }//w ww  . j a  va2s. c  o  m
    if (accessionNumber != null && StringUtils.isNotBlank(accessionNumber)) {
        detachedCriteria.add(Restrictions.eq("accessionNumber", accessionNumber));
    }
    if (accessionNumberIssuer != null && StringUtils.isNotBlank(accessionNumberIssuer)) {
        detachedCriteria.add(Restrictions.eq("issuerOfAccessionNumber", accessionNumberIssuer));
    }
    if (patientID != null && StringUtils.isNotBlank(patientID)) {
        detachedCriteria.add(Restrictions.eq("patientID", patientID));
    }
    if (patientIDIssuer != null && StringUtils.isNotBlank(patientIDIssuer)) {
        detachedCriteria.add(Restrictions.eq("issuerOfPatientID", patientIDIssuer));
    }
    if (minStudyDateTime != null) {
        detachedCriteria.add(Restrictions.ge("dateTime", minStudyDateTime));
    }
    if (minStudyDate != null) {
        detachedCriteria.add(Restrictions.ge("dateTime", minStudyDate));
    }
    if (maxStudyDateTime != null) {
        detachedCriteria.add(Restrictions.le("dateTime", maxStudyDateTime));
    }
    if (maxStudyDate != null) {
        detachedCriteria.add(Restrictions.lt("dateTime", maxStudyDate));
    }

    //Eliminate deleted studies from search results
    detachedCriteria.add(Restrictions.ne("studyVersion", -1));

    int firstResult = (offset - 1) * limit;
    final List<MINTStudy> list = (List<MINTStudy>) getHibernateTemplate().findByCriteria(detachedCriteria,
            firstResult, limit);
    return list;
}

From source file:org.onebusaway.gtfs_realtime.archiver.service.VehiclePositionDaoImpl.java

License:Apache License

@Override
public List<VehiclePositionModel> getVehiclePositions(String vehicleId, Date startDate, Date endDate) {

    if (endDate == null)
        endDate = new Date();

    if (startDate == null) // 1 hr = 3600000 millisec
        startDate = new Date(endDate.getTime() - 3600000);

    // from VehiclePositionModel where vehicleId=:vehicleId and timestamp >=
    // :startDate and timestamp < :endDate order by timestamp

    DetachedCriteria criteria = DetachedCriteria.forClass(VehiclePositionModel.class);

    if (!StringUtils.isEmpty(vehicleId)) {
        criteria.add(Restrictions.eq("vehicleId", vehicleId));
    }/*from w  ww.  j av  a  2 s . co  m*/
    criteria.add(Restrictions.between("timestamp", startDate, endDate));
    criteria.addOrder(Order.asc("timestamp"));

    return _template.findByCriteria(criteria);
}