Example usage for org.hibernate.criterion Restrictions 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.com.moises.suport.MotoristaSuport.java

public List<Motorista> getPessoasByPlaca(String valor) {
    System.out.print(valor + " ->suport");
    DetachedCriteria criteria = DetachedCriteria.forClass(Motorista.class)
            .add(Restrictions.or(Restrictions.ilike("nome", valor, MatchMode.START),
                    Restrictions.ilike("placa", valor, MatchMode.START)));
    return Dao().getEntitiesByDetachetCriteria(criteria);
}

From source file:br.com.moises.suport.TransportadoraSuport.java

public List<Transportadora> transportadoraPorNome(String valor) {
    System.err.println("pA");
    DetachedCriteria criteria = DetachedCriteria.forClass(Transportadora.class)
            .add(Restrictions.ilike("nome", valor, MatchMode.START));
    return Dao().getEntitiesByDetachetCriteria(criteria);
}

From source file:br.com.Monopoly.control.dao.UsuarioDAO.java

public List<Usuario> buscarPorNome(String nome) {
    entitys = criteria.add(Restrictions.ilike("nome", nome, MatchMode.START)).list();
    closeSession();//  w w  w  . ja v a  2s. c  o  m
    return entitys;
}

From source file:br.com.PalleorrotasDePeterLund.control.dao.GlossarioDAO.java

public List<Glossario> pegarPorPesquisa(String text) {
    entitys = criteria.add(Restrictions.ilike("palavra", text, MatchMode.ANYWHERE)).list();
    closeSession();//from  w w w .  ja v  a 2 s  . c  o m
    return entitys;
}

From source file:br.com.PalleorrotasDePeterLund.control.dao.UsuarioDAO.java

public List<Usuario> pegarPorNome(String text) {
    entitys = criteria.add(Restrictions.ilike("nome", text, MatchMode.ANYWHERE)).list();
    closeSession();//from  ww w .j  a  v  a2  s .c  o m
    return entitys;
}

From source file:br.com.reindex.suri.framework.dao.DaoSupport.java

License:Open Source License

/**
 * Metodo responsavel por recuperar todos os objeto de uma tabela da base de dados
 * //w ww.  j  a  v  a  2  s .c  om
 * @param nome da propriedade, valor da propriedade(filtro), tipo de busca (comeca ou contem)
 * @return todos os objetos da classe que se adequam aos filtros
 */
public List<T> retrieveByProperty(String propertyName, String value, MatchMode matchMode) {
    if (matchMode != null) {
        return getSession().createCriteria(tipo).add(Restrictions.ilike(propertyName, value, matchMode)).list();
    } else {
        return getSession().createCriteria(tipo).add(Restrictions.ilike(propertyName, value, MatchMode.EXACT))
                .list();
    }
}

From source file:br.com.suricattus.surispring.framework.service.GenericRetrieveService.java

License:Open Source License

/**
 * Retorna a lista de entidades filtradas pelos parametros informadas.
 * // ww  w.j  a  v  a  2 s  . c  om
 * @param <T>
 * @param classe
 * @param propertyName
 * @param value
 * @param matchMode
 * @return lista de entidades.
 */
@SuppressWarnings("unchecked")
public <T> List<T> retrieveByProperty(Class<T> classe, String propertyName, String value, MatchMode matchMode) {
    if (matchMode != null) {
        return getSession().createCriteria(classe).add(Restrictions.ilike(propertyName, value, matchMode))
                .list();
    } else {
        return getSession().createCriteria(classe).add(Restrictions.ilike(propertyName, value, MatchMode.EXACT))
                .list();
    }
}

From source file:br.com.suricattus.surispring.framework.service.GenericRetrieveService.java

License:Open Source License

/**
 * Retorna a entidade filtrada pelos parametros informadas.
 * /*from www. ja  v a2  s  . c o  m*/
 * @param <T>
 * @param classe
 * @param propertyName
 * @param value
 * @param matchMode
 * @return lista de entidades.
 */
@SuppressWarnings("unchecked")
public <T> T retrieveUniqueByProperty(Class<T> classe, String propertyName, String value, MatchMode matchMode) {
    if (matchMode != null) {
        return (T) getSession().createCriteria(classe).add(Restrictions.ilike(propertyName, value, matchMode))
                .uniqueResult();
    } else {
        return (T) getSession().createCriteria(classe)
                .add(Restrictions.ilike(propertyName, value, MatchMode.EXACT)).uniqueResult();
    }
}

From source file:br.com.thiaguten.persistence.demo.hbmcore.UserDAOImpl.java

License:Apache License

@Override
public List<User> findByName(String name) {
    List<Criterion> criterions = Collections
            .singletonList(Restrictions.ilike("name", name, MatchMode.ANYWHERE));
    List<User> results = persistenceProvider.findByCriteria(getPersistenceClass(), criterions);
    if (results.isEmpty()) {
        return Collections.emptyList();
    } else {// www.j av  a  2s.  c  om
        return Collections.unmodifiableList(results);
    }
}

From source file:br.com.utfpr.edu.agenda.Dao.Entidades.Dao_Item.java

public List<Item> buscaJSon(String trecho) {
    try {/*w ww . j  a  v a2  s . co m*/
        return sessao.createCriteria(Item.class).add(Restrictions.ilike("nome", trecho, MatchMode.ANYWHERE))
                .list();
    } catch (HibernateException e) {
        return null;
    }
}