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.hrstatus.dao.impl.UsersDAO.java

License:Open Source License

public String getMailNotLogged(String username) {

    log.fine("[ System ] getMail(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("mail"));
    criteria.setProjection(proList);//from w w w  .j  a v a  2  s  .  c o m
    return criteria.uniqueResult().toString();
}

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);/*from w ww .  ja v  a  2s. co m*/
    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);/*w  ww  . j a  va  2  s.  c om*/
    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);//w  w w  .  j  av a2s .c  om

    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.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);//from  w  ww  .  ja va  2 s  .com

    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);//  w  w  w . jav  a  2 s.c o  m
    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   www.  j a v  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;
}