How to use

setResultTransformer

method

in

org.hibernate.Criteria

/**
 * Set the result transformer to use.
 *
 * @param resultTransformer The result transformer to use
 *
 * @return {@code this}, for method chaining
 */
public DetachedCriteria setResultTransformer(ResultTransformer resultTransformer) {
  criteria.setResultTransformer( resultTransformer );
  return this;
}

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> loadAll(final Class<T> entityClass) throws DataAccessException {
  return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
    Criteria criteria = session.createCriteria(entityClass);
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    prepareCriteria(criteria);
    return criteria.list();
  }));
}

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
        .createAlias( "s.preferredCourse", "pc", Criteria.LEFT_JOIN  )
        .setFetchMode( "enrolments", FetchMode.JOIN )
        .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

  @Override
  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
        .createAlias( "s.addresses", "a", CriteriaSpecification.LEFT_JOIN )
            .setResultTransformer( CriteriaSpecification.ALIAS_TO_ENTITY_MAP )
        .createCriteria( "s.preferredCourse", CriteriaSpecification.INNER_JOIN )
        .addOrder( Order.asc( "s.studentNumber") );
  }
};

  @Override
  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
        .createAlias( "s.enrolments", "e", CriteriaSpecification.LEFT_JOIN )
        .createAlias( "e.course", "c", CriteriaSpecification.LEFT_JOIN )
            .setResultTransformer( CriteriaSpecification.ALIAS_TO_ENTITY_MAP )
        .addOrder( Order.asc( "s.studentNumber") );
  }
};

  @Override
  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
        .createAlias( "s.preferredCourse", "p", CriteriaSpecification.LEFT_JOIN )
        .createAlias( "s.addresses", "a", CriteriaSpecification.LEFT_JOIN )
            .setResultTransformer( CriteriaSpecification.ALIAS_TO_ENTITY_MAP )
        .addOrder( Order.asc( "s.studentNumber" ) );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
        .createAlias( "s.preferredCourse", "pc", Criteria.LEFT_JOIN  )
        .setFetchMode( "enrolments", FetchMode.JOIN )
        .addOrder( Order.asc( "s.studentNumber" ))
        .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Enrolment.class, "e" )
        .setProjection( Projections.property( "e.student" ).as( "student" ) )
        .addOrder( Order.asc( "e.studentNumber") )
        .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

protected Criteria getCriteria(Session s) throws Exception {
  return s.createCriteria( Student.class, "s" )
  .setProjection( Projections.property( "s.name" ) )
  .addOrder( Order.asc( "s.studentNumber" ) )
  .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) );
}
private Constructor getConstructor() throws NoSuchMethodException {

protected Criteria getCriteria(Session s) throws Exception {
  return s.createCriteria( Student.class, "s" )
  .setProjection( Projections.property( "s.name" ).as( "name" ))
  .addOrder( Order.asc( "s.studentNumber" ) )
  .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) );
}
private Constructor getConstructor() throws NoSuchMethodException {

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Enrolment.class )
        .setProjection(
            Projections.projectionList()
              .add( Projections.min( "studentNumber" ).as( "minStudentNumber" ) )
              .add( Projections.max( "studentNumber" ).as( "maxStudentNumber" ) )
        )
        .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Enrolment.class, "e" )
    .createAlias( "e.student", "st" )
    .createAlias( "e.course", "co" )
    .setProjection( Projections.property( "st.name" ).as( "studentName" ) )
    .addOrder( Order.asc( "st.studentNumber" ) )
    .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
    .setProjection(
        Projections.projectionList()
            .add( Property.forName( "s.studentNumber" ).as( "sNumber" ) )
            .add( Property.forName( "s.name" ).as( "sName" ) )
    )
    .addOrder( Order.asc( "s.studentNumber" ) )
    .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
    .setProjection(
        Projections.projectionList()
            .add( Property.forName( "s.studentNumber" ).as( "sNumber" ) )
            .add( Property.forName( "s.name" ).as( "sName" ) )
    )
    .addOrder( Order.asc( "s.studentNumber" ) )
    .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Student.class, "s" )
    .setProjection(
        Projections.projectionList()
            .add( Property.forName( "s.studentNumber" ).as( "studentNumber" ))
            .add( Property.forName( "s.name" ).as( "name" ) )
    )
    .addOrder( Order.asc( "s.studentNumber" ) )
    .setResultTransformer( Transformers.TO_LIST );
  }
};

protected Criteria getCriteria(Session s) throws Exception {
  return s.createCriteria( Student.class, "s" )
  .setProjection(
      Projections.projectionList()
          .add( Projections.sqlProjection( "555 as studentNumber", new String[]{ "studentNumber" }, new Type[] { StandardBasicTypes.LONG } ) )
          .add( Property.forName( "s.name" ).as( "name" ) )
  )
  .addOrder( Order.asc( "s.studentNumber" ) )
  .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) );
}
private Constructor getConstructor() throws NoSuchMethodException {

protected Criteria getCriteria(Session s) throws Exception {
  return s.createCriteria( Student.class, "s" )
  .setProjection(
      Projections.projectionList()
          .add( Property.forName( "s.studentNumber" ).as( "studentNumber" ))
          .add( Property.forName( "s.name" ).as( "name" ))
  )
  .addOrder( Order.asc( "s.studentNumber" ) )
  .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) );
}
private Constructor getConstructor() throws NoSuchMethodException {

protected Criteria getCriteria(Session s) {
  return s.createCriteria( Student.class, "s" )
  .setProjection(
      Projections.projectionList()
          .add( Property.forName( "s.studentNumber" ).as( "studentNumber" ) )
          .add( Property.forName( "s.name" ).as( "name" ) )
  )
  .addOrder( Order.asc( "s.studentNumber" ) )
  .setResultTransformer( new AliasToBeanConstructorResultTransformer( getConstructor() ) );
}
private Constructor getConstructor() {

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Enrolment.class, "e" )
        .setProjection(
            Projections.projectionList()
                .add( Property.forName( "e.student" ), "student" )
                .add( Property.forName( "e.semester" ), "semester" )
                .add( Property.forName( "e.year" ), "year" )
                .add( Property.forName( "e.course" ), "course" )
        )
        .addOrder( Order.asc( "studentNumber") )
        .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  }
};

  protected Criteria getCriteria(Session s) {
    return s.createCriteria( Enrolment.class, "e" )
    .createAlias( "e.student", "st" )
    .createAlias( "e.course", "co" )
    .setProjection(
        Projections.projectionList()
            .add( Property.forName( "st.name" ).as( "studentName" ) )
            .add( Property.forName( "co.description" ).as( "courseDescription" ) )
    )
    .addOrder( Order.asc( "e.studentNumber" ) )
    .setResultTransformer( Transformers.aliasToBean( StudentDTO.class ) );
  }
};