Example usage for org.hibernate.criterion Projections property

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections property.

Prototype

public static PropertyProjection property(String propertyName)

Source Link

Document

A property value projection

Usage

From source file:br.com.sgejs.dao.DaoArquivo.java

public List getTipoDeArquivoDoAno(int ano, Curso curso) throws HibernateException {
    Criteria cri = sessao.createCriteria(classe);
    cri.add(Restrictions.eq("ano", ano)).add(Restrictions.eq("curso", curso));
    cri.setProjection(Projections.distinct(Projections.property("tipo")));
    return cri.list();
}

From source file:br.com.sgejs.dao.DaoArquivo.java

public List<Arquivo> getPropriedadesArquivo() throws HibernateException {
    Criteria cri = sessao.createCriteria(classe, "p");
    cri.addOrder(Order.asc("ano")).setProjection(Projections.projectionList()
            .add(Projections.property("p.id").as("id")).add(Projections.property("p.ano").as("ano"))
            .add(Projections.property("p.curso").as("curso")).add(Projections.property("p.tipo").as("tipo"))
            .add(Projections.property("p.caixa").as("caixa"))
            .add(Projections.property("p.criacao").as("criacao")))
            .setResultTransformer(new AliasToBeanResultTransformer(Arquivo.class));
    return cri.list();
}

From source file:br.com.sgejs.dao.DaoArquivo.java

public List filtrar(Arquivo arq) throws HibernateException {

    Criteria cri = sessao.createCriteria(classe, "p");
    /*  Example exemplo = Example.create(arq);
    cri.add(exemplo);*//*w  w  w.j ava 2  s.c  om*/

    if (arq.getAno() > 0) {
        cri.add(Restrictions.eq("ano", arq.getAno()));
    }
    if (arq.getTipo() != null) {
        cri.add(Restrictions.eq("tipo", arq.getTipo()));
    }
    if (arq.getCurso() != null) {
        cri.add(Restrictions.eq("curso", arq.getCurso()));
    }

    cri.setProjection(Projections.projectionList().add(Projections.property("p.id").as("id"))
            .add(Projections.property("p.ano").as("ano")).add(Projections.property("p.curso").as("curso"))
            .add(Projections.property("p.tipo").as("tipo")).add(Projections.property("p.caixa").as("caixa"))
            .add(Projections.property("p.criacao").as("criacao")))
            .setResultTransformer(new AliasToBeanResultTransformer(Arquivo.class));

    return cri.list();
}

From source file:br.com.sgejs.dao.DaoArquivo.java

public List<Arquivo> getArquivosDoAluno(long id) throws HibernateException {
    Criteria criArquivo = sessao.createCriteria(classe, "p");
    criArquivo.setProjection(Projections.projectionList().add(Projections.property("p.id").as("id"))
            .add(Projections.property("p.ano").as("ano")).add(Projections.property("p.curso").as("curso"))
            .add(Projections.property("p.tipo").as("tipo")).add(Projections.property("p.caixa").as("caixa"))
            .add(Projections.property("p.criacao").as("criacao")))
            .setResultTransformer(new AliasToBeanResultTransformer(Arquivo.class));
    criArquivo.createCriteria("alunos").add(Restrictions.eq("id", id));
    return criArquivo.list();
}

From source file:br.com.sgejs.dao.DaoServidor.java

public List<Servidor> listPropriedades() {
    Criteria cri = sessao.createCriteria(classe, "s");
    cri.addOrder(Order.asc("nome"))
            .setProjection(Projections.projectionList().add(Projections.property("s.id").as("id"))
                    .add(Projections.property("s.nome").as("nome"))
                    .add(Projections.property("s.sexo").as("sexo"))
                    .add(Projections.property("s.contato").as("contato")))
            .setResultTransformer(new AliasToBeanResultTransformer(Servidor.class));
    return cri.list();
}

From source file:br.com.sgejs.dao.DaoServidor.java

public Servidor getEscolaridade(Long id) {
    Criteria cri = sessao.createCriteria(classe, "s");
    cri.add(Restrictions.eq("s.id", id));
    cri.setProjection(Projections.projectionList().add(Projections.property("s.nome").as("nome"))
            .add(Projections.property("s.instrucao").as("instrucao"))
            .add(Projections.property("s.posGraduacao").as("posGraduacao")))
            .setResultTransformer(new AliasToBeanResultTransformer(Servidor.class));
    Servidor u = (Servidor) cri.uniqueResult();

    SQLQuery q1 = sessao.createSQLQuery("select * from graduacao where servidor_id=" + id)
            .addEntity(Graduacao.class);
    List list = q1.list();/*w w w  .  jav  a 2s  .c om*/
    System.out.println("Graduacoes: " + list);
    u.setGraduacoes(list);
    return u;
}

From source file:br.com.sgejs.dao.DaoServidor.java

public Servidor getInformacoesBasicas(long id) {
    Criteria cri = sessao.createCriteria(classe, "s");
    cri.add(Restrictions.eq("s.id", id));
    cri.setProjection(Projections.projectionList().add(Projections.property("s.nome").as("nome"))
            .add(Projections.property("s.nascimento").as("nascimento"))
            .add(Projections.property("s.cidadeNascimento").as("cidadeNascimento"))
            .add(Projections.property("s.ufNascimento").as("ufNascimento"))
            .add(Projections.property("s.sexo").as("sexo")).add(Projections.property("s.raca").as("raca"))
            .add(Projections.property("s.grupoSanguineo").as("grupoSanguineo"))
            .add(Projections.property("s.estadoCivil").as("estadoCivil"))
            .add(Projections.property("s.filiacao").as("filiacao")))
            .setResultTransformer(new AliasToBeanResultTransformer(Servidor.class));
    return (Servidor) cri.uniqueResult();
}

From source file:br.com.sgejs.dao.DaoServidor.java

public Servidor getDocumentos(long id) throws HibernateException {
    Criteria cri = sessao.createCriteria(classe, "s");
    cri.add(Restrictions.eq("s.id", id));
    cri.setProjection(Projections.projectionList().add(Projections.property("s.nome").as("nome"))
            .add(Projections.property("s.documento").as("documento")))
            .setResultTransformer(new AliasToBeanResultTransformer(classe));
    return (Servidor) cri.uniqueResult();
}

From source file:br.com.webbudget.domain.model.repository.entries.VehicleRepository.java

License:Open Source License

/**
 *
 * @param vehicle/*w  w  w .ja v  a 2s  .co  m*/
 * @return
 */
@Override
public int findLastOdometer(Vehicle vehicle) {

    final Criteria criteria = this.createCriteria();

    criteria.add(Restrictions.eq("id", vehicle.getId()));
    criteria.setProjection(Projections.property("odometer"));

    return (int) criteria.uniqueResult();
}

From source file:br.gov.mdarte.controleacesso.cd.PerfilDAOImpl.java

@Override
protected Object handleRecuperarSuperPerfil(Session session, String sistema, Integer paginacao, Integer linhas,
        Integer paginas) throws DAOException {
    ProjectionList projectionList = Projections.projectionList();

    projectionList.add(Projections.property("id"));

    Criteria criterios = session.createCriteria(PerfilImpl.class);
    criterios.createAlias("sistema", "sistema");

    criterios.add(Restrictions.eq("superUsuario", Boolean.TRUE));

    criterios.setProjection(projectionList);

    if (sistema != null)
        criterios.add(Restrictions.eq("sistema.nome", sistema));

    ResultTransformer resultTransformer = new ResultTransformer() {

        public Object transformTuple(Object[] result, String[] arg1) {
            return result;
        }/*from ww  w .j  a  v a  2  s .  c  o m*/

        public List transformList(List resultado) {
            List idPerfis = new ArrayList<Long>();

            for (Object[] result : (List<Object[]>) resultado) {
                Collection rows = Arrays.asList(result);
                Iterator iteratorRow = rows.iterator();

                idPerfis.add((Long) iteratorRow.next());
            }

            return idPerfis;
        }
    };

    criterios.setResultTransformer(resultTransformer);

    return criterios;
}