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:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*  ww  w  .  j  a  v a 2 s .c o  m*/
public List<Customer> getAllCustomers(final int start, final int pageSize, final String orderByFieldName,
        final boolean ascending) {
    logger.info("--> ");

    if (logger.isInfoEnabled()) {
        logger.info("get customers from record " + start + " to " + (start + pageSize - 1));
    }

    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    if (ascending) {
        criteria.addOrder(Order.asc(orderByFieldName));
    } else {
        criteria.addOrder(Order.desc(orderByFieldName));
    }
    return getHibernateTemplate().findByCriteria(criteria, start, pageSize);
}

From source file:de.forsthaus.backend.dao.impl.CustomerDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   w w w  .j a  va 2 s .  co  m*/
public List<Customer> getCustomersByBranche(Branche branche) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Customer.class);
    criteria.add(Restrictions.eq("branche", branche));
    criteria.addOrder(Order.asc("kunMatchcode")); // set the order

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecGroupDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*w w w . j  a  va 2s.c  o  m*/
public List<SecGroup> getAllGroups() {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecGroup.class);
    criteria.addOrder(Order.asc("grpShortdescription"));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecLoginlogDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from   w  ww. j a  va2s .  com
public List<SecLoginlog> getAllLogs() {
    // return getHibernateTemplate().loadAll(SecLoginlog.class);

    DetachedCriteria criteria = DetachedCriteria.forClass(SecLoginlog.class);
    criteria.addOrder(Order.desc("lglLogtime"));

    return getHibernateTemplate().findByCriteria(criteria);

}

From source file:de.forsthaus.backend.dao.impl.SecLoginlogDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from  w ww  .  j  a v  a  2  s . co  m*/
public List<SecLoginlog> getLogsByLoginname(String value) {

    DetachedCriteria criteria = DetachedCriteria.forClass(SecLoginlog.class);
    criteria.add(Restrictions.eq("lglLoginname", value));
    criteria.addOrder(Order.desc("lglLogtime"));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecLoginlogDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from ww w .  j a  va  2  s .c  om
public SecLoginlog getLoginlogById(long id) {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecLoginlog.class);
    criteria.add(Restrictions.eq("id", Long.valueOf(id)));
    criteria.addOrder(Order.desc("lglLogtime"));

    return (SecLoginlog) DataAccessUtils.uniqueResult(getHibernateTemplate().findByCriteria(criteria));
}

From source file:de.forsthaus.backend.dao.impl.SecLoginlogDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from w  w  w.j  a  va2s  .  co m*/
public List<SecLoginlog> getAllLogsForFailed() {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecLoginlog.class);
    criteria.add(Restrictions.eq("lglStatusid", Integer.valueOf(0)));
    criteria.addOrder(Order.desc("lglLogtime"));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecLoginlogDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//from  w ww .  j  av  a  2s.co  m
public List<SecLoginlog> getAllLogsForSuccess() {
    DetachedCriteria criteria = DetachedCriteria.forClass(SecLoginlog.class);
    criteria.add(Restrictions.eq("lglStatusid", Integer.valueOf(1)));
    criteria.addOrder(Order.desc("lglLogtime"));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecRightDAOImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//w  w w  .  j a va2  s  . c  om
public List<SecRight> getAllRights() {
    final DetachedCriteria criteria = DetachedCriteria.forClass(SecRight.class);
    criteria.addOrder(Order.asc("rigName"));

    return getHibernateTemplate().findByCriteria(criteria);
}

From source file:de.forsthaus.backend.dao.impl.SecRightDAOImpl.java

License:Open Source License

/**
 * Int | Type <br>//w ww. ja  v a 2s. com
 * --------------------------<br>
 * -1 | All (no filter)<br>
 * 0 | Page <br>
 * 1 | Menu Category <br>
 * 2 | Menu Item <br>
 * 3 | Method <br>
 * 4 | DomainObject/Property <br>
 * 5 | Tab <br>
 */
@SuppressWarnings("unchecked")
@Override
public List<SecRight> getAllRights(int type) {

    final DetachedCriteria criteria = DetachedCriteria.forClass(SecRight.class);
    criteria.addOrder(Order.asc("rigName"));

    if (type != -1) {
        criteria.add(Restrictions.eq("rigType", Integer.valueOf(type)));
        // criteria.add(Restrictions.or(Restrictions.eq("rigType", 2),
        // Restrictions.eq("rigType", 1)));
    }

    return getHibernateTemplate().findByCriteria(criteria);
}