Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT

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.NumberingNameDao.java

public List<NumberingNameEntity> getActiveNumberingNameList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(NumberingNameEntity.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.NumberingNameDao.java

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

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

public List getNumberingNameList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(NumberingNameEntity.class);
    c.add(Restrictions.like("name", "%" + keyword + "%"));

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {/* w w w .  jav  a2  s .  com*/
        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.PartnerDao.java

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

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

public List<PartnerEntity> getPartnerList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List getPartnerList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    Criterion code = Restrictions.like("code", "%" + keyword + "%");
    Criterion desc = Restrictions.like("name", "%" + keyword + "%");
    LogicalExpression orExp = Restrictions.or(code, desc);
    c.add(orExp);/*from   w w  w .jav  a  2  s. c  o 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();
}

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

public List getVendorList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.addOrder(Order.asc("name"));
    c.createCriteria("partnertype").add(Restrictions.eq("parent", 1));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();//  ww  w . ja v a 2 s .  co m
    return ls;
}

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

public List getActiveVendorList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("name"));
    c.createCriteria("partnertype").add(Restrictions.eq("parent", 1));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();/*  ww w  .ja v  a  2s  . c  om*/
    return ls;
}

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

public List getCustomerList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.addOrder(Order.asc("name"));
    c.createCriteria("partnertype").add(Restrictions.eq("parent", 0));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();//from  w w  w . j a  v a  2 s  .c o m
    return ls;
}

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

public List getActiveCustomerList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("name"));
    c.createCriteria("partnertype").add(Restrictions.eq("parent", 0));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();/*ww w  . j  av a2 s .  c  o  m*/
    return ls;
}

Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

Introduction

Prototype

Document

Usage