Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

List of usage examples for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. CriteriaSpecification
  6. DISTINCT_ROOT_ENTITY

Introduction

In this page you can find the example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY.

Prototype

ResultTransformer DISTINCT_ROOT_ENTITY

To view the source code for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY.

Click Source Link

Document

Each row of results is a distinct instance of the root entity

Usage

From source file:net.purnama.pureff.dao.UomDao.java

public List<UomEntity> getParentUomList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UomEntity.class);
    c.add(Restrictions.isNull("parent"));
    c.addOrder(Order.asc("name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UomDao.java

public List<UomEntity> getActiveParentUomList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UomEntity.class);
    c.add(Restrictions.isNull("parent"));
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UomDao.java

public List<UomEntity> getUomList(UomEntity parent) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UomEntity.class);
    c.add(Restrictions.eq("parent", parent));
    c.addOrder(Order.asc("name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UomDao.java

public List<UomEntity> getUomList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UomEntity.class);
    c.addOrder(Order.asc("name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UomDao.java

public List<UomEntity> getActiveUomList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UomEntity.class);
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UomDao.java

public List getUomList(int itemperpage, int page, String sort, String keyword, UomEntity parent) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UomEntity.class);
    if (parent == null) {
        c.add(Restrictions.isNull("parent"));
    } else {/*from   w  w w.j ava2s .  com*/
        c.add(Restrictions.eq("parent", parent));
    }
    c.add(Restrictions.like("name", "%" + keyword + "%"));

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

From source file:net.purnama.pureff.dao.UserDao.java

public List<UserEntity> getActiveUserList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UserEntity.class);
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("username"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UserDao.java

public List<UserEntity> getActiveUserList(RoleEntity role) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UserEntity.class);
    c.add(Restrictions.eq("role", role));
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("username"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UserDao.java

public List<UserEntity> getUserList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UserEntity.class);
    c.addOrder(Order.asc("username"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.UserDao.java

public List getUserList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(UserEntity.class);
    Criterion username = Restrictions.like("username", "%" + keyword + "%");
    Criterion name = Restrictions.like("name", "%" + keyword + "%");
    LogicalExpression orExp = Restrictions.or(username, name);
    c.add(orExp);/*ww w. ja  v a2  s  . co m*/

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }

    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}