Example usage for org.hibernate.criterion Projections property

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Projections
  6. 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.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  ww. ja  v a2s . 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();//  www . ja  v a2s .  com
    }
    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  . ja v  a  2 s .  c  om
    }
    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   w  ww. j  a v  a2s  . 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();//from  ww w . j  a va 2s .co 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();/*from www  .j a  v a 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 getAnos() throws HibernateException {
    Criteria cri = sessao.createCriteria(classe);
    cri.setProjection(Projections.distinct(Projections.property("ano")));
    cri.addOrder(Order.asc("ano"));
    return cri.list();
}

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

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