/** * 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 ) ); } };