Example usage for org.hibernate.criterion Restrictions ilike

List of usage examples for org.hibernate.criterion Restrictions ilike

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ilike

Introduction

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

Prototype

public static Criterion ilike(String propertyName, String value, MatchMode matchMode)

Source Link

Document

A case-insensitive "like" (similar to Postgres ilike operator) using the provided match mode

Usage

From source file:br.os.rh.turno.TurnoDAO.java

public List<Turno> pesquisaDescricao(String Descricao) {
    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    List<Turno> turnos = (List<Turno>) getSessao().createCriteria(Turno.class)
            .add(Restrictions.ilike("descricao", Descricao, MatchMode.ANYWHERE))
            .addOrder(Order.asc("descricao")).list();

    getSessao().close();//w  w  w. ja  v  a2 s.  c  o m
    return turnos;
}

From source file:br.os.rh.usuario.UsuarioDAO.java

public List<Usuario> pesquisaDescricao(String Login) {
    setSessao(HibernateUtil.getSessionFactory().openSession());
    setTransacao(getSessao().beginTransaction());

    List<Usuario> usuarios = (List<Usuario>) getSessao().createCriteria(Usuario.class)
            .add(Restrictions.ilike("login", Login, MatchMode.ANYWHERE)).addOrder(Order.asc("login")).list();

    getSessao().close();/*from   w  w  w.  ja  v  a 2s . c  o  m*/
    return usuarios;

}

From source file:br.ufac.sion.dao.CandidatoFacade.java

private Criteria criarCriteriaParaFiltro(FiltroCandidatos filtro) {
    Session session = em.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Candidato.class);

    criteria.createAlias("usuario", "u");

    if (StringUtils.isNotEmpty(filtro.getNome())) {
        criteria.add(Restrictions.ilike("nome", filtro.getNome(), MatchMode.ANYWHERE));
    }//from  w  w  w  . j ava  2s .c  o m
    if (StringUtils.isNotEmpty(filtro.getCpf())) {
        criteria.add(Restrictions.ilike("cpf", filtro.getCpf(), MatchMode.EXACT));
    }
    if (StringUtils.isNotEmpty(filtro.getEmail())) {
        criteria.add(Restrictions.ilike("u.email", filtro.getEmail(), MatchMode.START));
    }

    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return criteria;
}

From source file:br.ufac.sion.dao.CargoFacade.java

@Override
public List<Cargo> findByDescricaoAndNivel(Cargo filtro) {
    Session session = em.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Cargo.class);

    if (StringUtils.isNotBlank(filtro.getDescricao())) {
        criteria.add(Restrictions.ilike("descricao", filtro.getDescricao(), MatchMode.ANYWHERE));
    }/*from w  w w.  ja v a  2s  . c  o m*/

    if (filtro.getNivel() != null) {
        criteria.add(Restrictions.eq("nivel", filtro.getNivel()));
    }

    return criteria.addOrder(Order.asc("descricao")).list();
}

From source file:br.ufac.sion.dao.CidadeFacade.java

private Criteria criarCriteriaParaFiltro(FiltroCidades filtro) {

    Session session = em.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Cidade.class);

    if (StringUtils.isNotEmpty(filtro.getNome())) {
        criteria.add(Restrictions.ilike("nome", filtro.getNome(), MatchMode.ANYWHERE));
    }/*from  w  w w  .  jav  a2s. c  o  m*/
    if (filtro.getEstado() != null && filtro.getEstado().getId() != null) {
        criteria.add(Restrictions.eq("estado", filtro.getEstado()));
    }

    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return criteria;
}

From source file:br.ufac.sion.dao.InscricaoFacade.java

private Criteria criarCriteriaParaFiltro(FiltroInscritos filtro) {
    Session session = em.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Inscricao.class);

    criteria.createAlias("cargoConcurso", "cc").add(Restrictions.eq("cc.concurso", filtro.getConcurso()));
    criteria.createAlias("candidato", "c");

    if (filtro.getCargo() != null && filtro.getCargo().getId() != null) {
        criteria.add(Restrictions.eq("cargoConcurso", filtro.getCargo()));
    }//from  w  ww  .j av  a  2 s  .  c om

    if (StringUtils.isNotEmpty(filtro.getNome())) {
        criteria.add(Restrictions.ilike("c.nome", filtro.getNome(), MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotEmpty(filtro.getCpf())) {
        criteria.add(Restrictions.ilike("c.cpf", filtro.getCpf(), MatchMode.EXACT));
    }
    if (StringUtils.isNotEmpty(filtro.getNumeroInscricao())) {
        criteria.add(Restrictions.ilike("numero", filtro.getNumeroInscricao(), MatchMode.START));
    }

    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    return criteria;
}

From source file:br.ufac.sion.dao.OrgaoExpedidorFacade.java

@Override
public List<OrgaoExpedidor> findByNomeAndSigla(FiltroOrgaoExpedidor filtro) {
    Session session = em.unwrap(Session.class);
    Criteria criteria = session.createCriteria(OrgaoExpedidor.class);

    if (StringUtils.isNotBlank(filtro.getNome())) {
        criteria.add(Restrictions.ilike("nome", filtro.getNome(), MatchMode.ANYWHERE));
    }//w  ww  . j a v a  2  s .  c o m

    if (StringUtils.isNotBlank(filtro.getSigla())) {
        criteria.add(Restrictions.ilike("sigla", filtro.getSigla(), MatchMode.ANYWHERE));
    }

    return criteria.addOrder(Order.asc("nome")).list();
}

From source file:br.ufmg.hc.telessaude.diagnostico.dominio.dao.ExameDAOLocal.java

public List<Exame> consultar(Integer id, String nomePaciente, Date inicio, Date fim) throws DAOException {
    ArrayList<Criterion> restrict = new ArrayList();
    if (id != null) {
        restrict.add(Restrictions.eq("id", id));
    } else {/*from   ww w.ja v  a  2  s . co m*/
        if (nomePaciente != null && !nomePaciente.isEmpty()) {
            restrict.add(Restrictions.ilike("pc.nome", nomePaciente, MatchMode.ANYWHERE));
        }
        if (inicio != null) {
            restrict.add(Restrictions.ge("datainclusao", inicio));
        }
        if (fim != null) {
            restrict.add(Restrictions.le("datainclusao", fim));
        }
    }
    try {
        final DetachedCriteria crit = DetachedCriteria.forClass(c);
        final Criteria criteria = crit.getExecutableCriteria(HibernateUtil.currentSession());

        crit.createAlias("paciente", "pc");
        crit.createAlias("status", "st");

        criteria.setProjection(Projections.projectionList().add(Projections.property("id"))
                .add(Projections.property("pc.nome")).add(Projections.property("pc.datanascimento"))
                .add(Projections.property("datainclusao")).add(Projections.property("st.nome")));

        criteria.addOrder(Order.desc("datainclusao"));

        for (final Criterion cri : restrict) {
            criteria.add(cri);
        }

        final List<Object[]> arrays = criteria.list();
        final List<Exame> exames = new ArrayList<>();

        for (Object[] array : arrays) {
            final Exame exame = new Exame(Integer.parseInt(String.valueOf(array[0])));
            exame.setPaciente(new Paciente());
            exame.getPaciente().setNome(String.valueOf(array[1]));
            exame.getPaciente().setDatanascimento((Date) array[2]);
            exame.setDatainclusao((Date) array[3]);
            exame.setStatus(new Status());
            exame.getStatus().setNome(String.valueOf(array[4]));

            exames.add(exame);
        }

        return exames;

    } catch (HibernateException ex) {
        throw new DAOException(ex.getMessage());
    }

}

From source file:chiron.maxscore.service.impl.ClassServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Class.class);

    if (condition == null) {
        return criteria;
    }/*ww  w .  jav  a 2s  .c o  m*/

    criteria.createAlias("grade", "g");
    criteria.createAlias("g.specialty", "s");
    criteria.createAlias("s.college", "c");

    if (condition.containsKey("college_id")) {
        criteria.add(Restrictions.eq("c.id", condition.get("college_id")));
    } else if (condition.containsKey("specialty_id")) {
        criteria.add(Restrictions.eq("s.id", condition.get("specialty_id")));
    } else if (condition.containsKey("grade_id")) {
        criteria.add(Restrictions.eq("g.id", condition.get("grade_id")));
    }

    if (condition.containsKey("class_name")) {
        criteria.add(
                Restrictions.ilike("className", condition.get("class_name").toString(), MatchMode.ANYWHERE));
    }

    return criteria;
}

From source file:chiron.maxscore.service.impl.CollegeServiceImpl.java

private DetachedCriteria makeCriteria(Map<String, Object> condition) {
    DetachedCriteria criteria = DetachedCriteria.forClass(College.class);

    if (condition == null) {
        return criteria;
    }/*from w w w  . ja  v a  2s .c o m*/

    if (condition.containsKey("college_name")) {
        criteria.add(Restrictions.ilike("collegeName", condition.get("college_name").toString(),
                MatchMode.ANYWHERE));
    }

    return criteria;
}