Example usage for org.hibernate.criterion Restrictions like

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions like.

Prototype

public static SimpleExpression like(String propertyName, String value, MatchMode matchMode)

Source Link

Document

Apply a "like" constraint to the named property using the provided match mode

Usage

From source file:br.com.magmadoctor.modelo.email.EmailDAOHibernate.java

@Override
public List<Email> listarPorNome(String nome) {
    return this.session.createCriteria(Email.class)
            .add(Restrictions.like("logradouro", nome, MatchMode.ANYWHERE)).addOrder(Order.asc("logradouro"))
            .list();/*from   w  ww .  j av  a  2 s.  c o  m*/
}

From source file:br.com.magmadoctor.modelo.empresa.EmpresaDAOHibernate.java

@Override
public List<Empresa> listarPorNome(String nome) {
    List<Empresa> lista;/*from   w ww  .jav  a  2 s .c o  m*/
    Criteria resultado = this.session.createCriteria(Empresa.class)
            .add(Restrictions.like("nomeFantasia", nome, MatchMode.ANYWHERE))
            .addOrder(Order.asc("nomeFantasia"));
    lista = resultado.list();
    return lista;
}

From source file:br.com.magmadoctor.modelo.endereco.EnderecoDAOHibernate.java

@Override
public List<Endereco> listarPorNome(String nome) {
    return this.session.createCriteria(Endereco.class)
            .add(Restrictions.like("logradouro", nome, MatchMode.ANYWHERE)).addOrder(Order.asc("logradouro"))
            .list();/* w  w w  .  jav a  2  s. c o  m*/
}

From source file:br.com.magmadoctor.modelo.profissional.ProfissionalDAOHibernate.java

@Override
public List<Profissional> listarPorNome(String nome) {
    return this.session.createCriteria(Profissional.class)
            .add(Restrictions.like("nome", nome, MatchMode.ANYWHERE)).addOrder(Order.asc("nome")).list();
}

From source file:br.com.magmadoctor.modelo.profissional.ProfissionalDAOHibernate.java

@Override
public List<Profissional> listarPorEspecilizacao(String especializacao) {
    return this.session.createCriteria(Profissional.class)
            .add(Restrictions.like("nome", especializacao, MatchMode.ANYWHERE)).addOrder(Order.asc("nome"))
            .list();/*  www.  j a  va2 s  .  c  o m*/
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Aluno> listAllLike(String letra) {
    Criteria criteria = getSession().createCriteria(Aluno.class);
    criteria.add(Restrictions.eq("ativo", "s"));
    criteria.add(Restrictions.like("nome", letra, MatchMode.ANYWHERE));
    List<Aluno> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<AlunoVariavel> ListarNomeSemGrupo(String nome, int idPeriodo, List<Integer> anos) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);

    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));

    criteria.createAlias("aluno", "aluno");
    if (idPeriodo != 0) {
        criteria.createAlias("periodo", "periodo");
        criteria.add(Restrictions.eq("periodo.idperiodo", idPeriodo));
    }/*from w w w  .j  a  v a 2 s .  c o  m*/
    if (!anos.isEmpty()) {
        criteria.createAlias("anoEstudo", "anoEstudo");
        criteria.add(Restrictions.in("anoEstudo.idanoEstudo", anos));
    }
    criteria.add(Restrictions.like("aluno.nome", nome, MatchMode.ANYWHERE));
    criteria.createAlias("grupo", "grupo", Criteria.LEFT_JOIN);
    criteria.add(Restrictions.or(Restrictions.isNull("grupo"), Restrictions.eq("grupo.status", "1")));
    List<AlunoVariavel> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@Override
public List<AlunoVariavel> listarNomeAluno(String like) {
    Criteria criteria = getSession().createCriteria(AlunoVariavel.class);
    String ano = Integer.toString(Calendar.getInstance().get(Calendar.YEAR));
    AnoLetivo anoLetivo = new AnoLetivoService().listarAnoLetivo(ano).get(0);
    criteria.add(Restrictions.eq("anoLetivo", anoLetivo));
    criteria.add(Restrictions.eq("ativo", 1));
    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.like("aluno.nome", like, MatchMode.ANYWHERE));
    List<AlunoVariavel> result = criteria.list();
    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<ForumQuestao> ListaLikeRoteiro(String letra) {
    Criteria criteria = getSession().createCriteria(ForumQuestao.class);
    criteria.createAlias("roteiro", "roteiro");
    criteria.add(Restrictions.like("roteiro.nome", letra, MatchMode.START));
    criteria.addOrder(Order.desc("data"));
    List<ForumQuestao> result = criteria.list();

    return result;
}

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

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Grupo> listarUltimo(String ano, String periodo) {
    Criteria criteria = getSession().createCriteria(Grupo.class);
    criteria.add(Restrictions.eq("status", "0"));
    criteria.add(Restrictions.like("nomeGrupo", ano, MatchMode.START));
    criteria.add(Restrictions.like("nomeGrupo", periodo, MatchMode.ANYWHERE));
    criteria.addOrder(Order.desc("nomeGrupo"));
    criteria.setMaxResults(1);// ww w .  j  ava2 s  .  c o m
    List<Grupo> result = criteria.list();
    return result;
}