Example usage for org.hibernate.criterion Projections projectionList

List of usage examples for org.hibernate.criterion Projections projectionList

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Projections
  6. projectionList

Introduction

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

Prototype

public static ProjectionList projectionList()

Source Link

Document

Create a new projection list.

Usage

From source file:br.com.muranodesign.dao.impl.RoteiroDAOImpl.java

License:Creative Commons License

@Override
@SuppressWarnings("unchecked")
public List<Roteiro> listarAnoEstudoLazy(int anoEstudo) {
    Criteria criteria = getSession().createCriteria(Roteiro.class);
    ProjectionList projList = Projections.projectionList();

    criteria.createAlias("anoEstudo", "anoEstudo");
    criteria.add(Restrictions.eq("anoEstudo.idanoEstudo", anoEstudo));
    criteria.add(Restrictions.eqOrIsNull("ativo", 1));
    projList.add(Projections.property("idroteiro"), "idroteiro");
    projList.add(Projections.property("nome"), "nome");
    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Roteiro.class));
    List<Roteiro> result = criteria.list();

    return result;

}

From source file:br.com.muranodesign.dao.impl.TutoriaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Tutoria> listarDadosPertinentes() {

    Criteria criteria = getSession().createCriteria(Tutoria.class);

    ProjectionList projList = Projections.projectionList();

    projList.add(Projections.property("idtutoria"), "idtutoria");
    projList.add(Projections.property("tutoria"), "tutoria");

    criteria.setProjection(projList).setCacheable(true);

    criteria.setResultTransformer(Transformers.aliasToBean(Tutoria.class));

    List<Tutoria> results = criteria.list();

    return results;
}

From source file:br.com.prototipo.dao.CursoDao.java

public List<String> getListParaTurmas() {
    if (sessao.isConnected()) {
        sessao.close();/*from  w  w w. j  a  v a 2 s.c  o m*/
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Curso.class);
    Criteria cri2 = sessao.createCriteria(Curso.class);
    cri.addOrder(Order.asc("codigo"));
    cri2.addOrder(Order.asc("codigo"));

    ProjectionList projection = Projections.projectionList();
    projection.add(Projections.property("codigo"));

    ProjectionList projection2 = Projections.projectionList();
    projection2.add(Projections.property("nome"));

    cri.setProjection(projection);
    cri2.setProjection(projection2);

    List<String> l1 = cri.list();
    List<String> l2 = cri2.list();
    List<String> l3 = new ArrayList<>();
    Iterator<String> it1 = l1.iterator();
    Iterator<String> it2 = l2.iterator();

    while (it1.hasNext()) {
        String aux1 = it1.next();
        String aux2 = it2.next();
        String aux3 = aux1 + " - " + aux2;
        l3.add(aux3);
    }
    return l3;
}

From source file:br.com.prototipo.dao.DisciplinaDao.java

public List<String> getListParaTurmas() {
    if (sessao.isConnected()) {
        sessao.close();//from   w  w  w  . j  av  a2s .c om
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Disciplina.class);
    cri.addOrder(Order.asc("codigo"));
    ProjectionList projection = Projections.projectionList();
    projection.add(Projections.property("codigo"));
    cri.setProjection(projection);
    listaParaTurmas = cri.list();
    return listaParaTurmas;
}

From source file:br.com.prototipo.dao.DisciplinaDao.java

public List<String> getListDisciplinasString() {
    if (sessao.isConnected()) {
        sessao.close();/*from w  w  w .j a v  a 2 s  .  co m*/
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Disciplina.class);
    Criteria cri2 = sessao.createCriteria(Disciplina.class);
    cri.addOrder(Order.asc("codigo"));
    cri2.addOrder(Order.asc("codigo"));

    ProjectionList projection = Projections.projectionList();
    projection.add(Projections.property("codigo"));

    ProjectionList projection2 = Projections.projectionList();
    projection2.add(Projections.property("nome"));

    cri.setProjection(projection);
    cri2.setProjection(projection2);

    List<String> l1 = cri.list();
    List<String> l2 = cri2.list();
    List<String> l3 = new ArrayList<>();
    Iterator<String> it1 = l1.iterator();
    Iterator<String> it2 = l2.iterator();

    while (it1.hasNext()) {
        String aux1 = it1.next();
        String aux2 = it2.next();
        String aux3 = aux1 + " - " + aux2;
        l3.add(aux3);
    }
    return l3;
}

From source file:br.com.prototipo.dao.HorarioDao.java

public List<String> getListParaDisciplinas(String dia) {
    if (sessao.isConnected()) {
        sessao.close();/*from   ww  w  .jav  a  2s .c o m*/
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Horario.class);
    Criterion _nome = Restrictions.like("nomeDia", dia, MatchMode.ANYWHERE);
    cri.add(_nome);
    ProjectionList projection = Projections.projectionList();
    projection.add(Projections.property("aula"));
    cri.setProjection(projection);
    return cri.list();
}

From source file:br.com.prototipo.dao.ProfessorDao.java

public List<String> getListProfessoresString() {
    if (sessao.isConnected()) {
        sessao.close();// www  .  ja va  2  s  .  c  o m
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Professor.class);
    Criteria cri2 = sessao.createCriteria(Professor.class);
    cri.addOrder(Order.asc("registro"));
    cri2.addOrder(Order.asc("registro"));

    ProjectionList projection = Projections.projectionList();
    projection.add(Projections.property("registro"));

    ProjectionList projection2 = Projections.projectionList();
    projection2.add(Projections.property("nome"));

    cri.setProjection(projection);
    cri2.setProjection(projection2);

    List<String> l1 = cri.list();
    List<String> l2 = cri2.list();
    List<String> l3 = new ArrayList<>();
    Iterator<String> it1 = l1.iterator();
    Iterator<String> it2 = l2.iterator();

    while (it1.hasNext()) {
        String aux1 = it1.next();
        String aux2 = it2.next();
        String aux3 = aux1 + " - " + aux2;
        l3.add(aux3);
    }

    return l3;
}

From source file:br.com.prototipo.dao.TurmaDao.java

public List<String> getListTurmasString() {
    if (sessao.isConnected()) {
        sessao.close();//ww  w  .  j a  va 2 s  . co m
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Turma.class);
    cri.addOrder(Order.asc("codigo"));

    Criteria cri2 = sessao.createCriteria(Turma.class);
    cri2.addOrder(Order.asc("codigo"));

    ProjectionList projection = Projections.projectionList();
    projection.add(Projections.property("codigo"));
    cri.setProjection(projection);

    ProjectionList projection2 = Projections.projectionList();
    projection2.add(Projections.property("nomeDisciplina"));
    cri2.setProjection(projection2);

    List<String> l1 = cri.list();
    List<String> l2 = cri2.list();
    List<String> l3 = new ArrayList<>();
    Iterator<String> it1 = l1.iterator();
    Iterator<String> it2 = l2.iterator();
    while (it1.hasNext()) {
        String aux1 = it1.next();
        String aux2 = it2.next();
        String aux3 = aux1 + " - " + aux2;
        l3.add(aux3);
    }

    return l3;
}

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);*///from w ww  . j  ava 2 s  . co m

    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();
}