Example usage for org.hibernate.criterion Projections property

List of usage examples 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)

Document

A property value projection

Usage

From source file:br.com.hrstatus.dao.impl.UsersDAO.java

License:Open Source License

public String getRole(String user) {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getUniqUser(String user)[" + user + "]");
    final Criteria criteria = session().createCriteria(Users.class);
    criteria.add(Restrictions.eq("username", user));
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("authority"));
    criteria.setProjection(proList);//www.j  av  a 2 s .c om
    return criteria.uniqueResult().toString();
}

From source file:br.com.hrstatus.dao.impl.UsersDAO.java

License:Open Source License

public boolean getFirstLogin(String username) {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getFirstLogin(String username)[" + username + "]");
    final Criteria criteria = session().createCriteria(Users.class);
    criteria.add(Restrictions.eq("username", username));
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("firstLogin"));
    criteria.setProjection(proList);/*from  w w  w. j  a v  a 2 s . c o m*/
    return (Boolean) criteria.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.UsersDAO.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Integer> getIds_access_server(String user) {

    log.fine("[ " + userInfo.getLoggedUsername()
            + " ] getIds_access_server() -> Listing the id servers of the user " + user + " can access.");
    final Criteria criteria = session().createCriteria(Users.class);
    criteria.add(Restrictions.eq("username", user));
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("access_server"));
    return criteria.list();
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Aluno> ListarNomeId() {
    Criteria criteria = getSession().createCriteria(Aluno.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idAluno"), "idAluno");
    projList.add(Projections.property("nome"), "nome");

    criteria.setProjection(projList);/*from w w w  .j  a  v a  2 s  .c o  m*/

    criteria.setResultTransformer(Transformers.aliasToBean(Aluno.class));
    List<Aluno> results = criteria.list();

    return results;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Chamada> dataPresencaAtual(int id, Date data) {
    Criteria criteria = getSession().createCriteria(Chamada.class);

    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("presenca"), "presenca");

    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", id));
    criteria.add(Restrictions.eq("data", data));

    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Chamada.class));

    List<Chamada> result = criteria.list();

    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Compensacao> compensacaoAluno(int idAluno) {
    Criteria criteria = getSession().createCriteria(Chamada.class);
    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", idAluno));
    criteria.add(Restrictions.isNotNull("compensacao"));
    criteria.setProjection(Projections.distinct(Projections.property("compensacao")));
    return criteria.list();
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Objetivo> listAllTeste() {

    Criteria criteria = getSession().createCriteria(Objetivo.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("descricao"), "descricao");
    criteria.createAlias("roteiro", "roteiro");
    projList.add(Projections.property("roteiro.idroteiro"));
    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Objetivo.class));

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

    return results;

}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<ProfessorFuncionario> listAll() {

    Criteria criteria = getSession().createCriteria(ProfessorFuncionario.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idprofessorFuncionario"), "idprofessorFuncionario");
    projList.add(Projections.property("nome"), "nome");
    criteria.setProjection(projList);//  www. j  av  a 2s .c  om

    criteria.setResultTransformer(Transformers.aliasToBean(ProfessorFuncionario.class));
    List<ProfessorFuncionario> results = criteria.list();

    return results;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<ProfessorFuncionario> listarIdNome() {
    Criteria criteria = getSession().createCriteria(ProfessorFuncionario.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idprofessorFuncionario"), "idprofessorFuncionario");
    projList.add(Projections.property("nome"), "nome");
    criteria.add(Restrictions.eq("ativo", "s"));
    criteria.setProjection(projList);//  ww w.j  a va 2s  .c om
    criteria.setResultTransformer(Transformers.aliasToBean(ProfessorFuncionario.class));
    List<ProfessorFuncionario> results = criteria.list();

    return results;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Roteiro> listRoteiroRange(int primeiro, int ultimo) {
    Criteria criteria = getSession().createCriteria(Roteiro.class);
    ProjectionList projList = Projections.projectionList();

    criteria.setFirstResult(primeiro);/*from w  w  w .jav a 2  s .c o  m*/
    criteria.setMaxResults(ultimo);
    projList.add(Projections.property("idroteiro"), "idroteiro");
    projList.add(Projections.property("nome"), "nome");

    criteria.setProjection(projList).setCacheable(true);
    criteria.setResultTransformer(Transformers.aliasToBean(Roteiro.class));

    criteria.addOrder(Order.asc("nome"));
    List<Roteiro> result = criteria.list();

    return result;
}