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, Object value)

Source Link

Document

Apply a "like" constraint to the named property

Usage

From source file:ar.com.zauber.commons.repository.query.visitor.CriteriaFilterVisitor.java

License:Apache License

/** calculate a criterion */
private Criterion createCriterion(final BinaryPropertyFilter binaryPropertyFilter, final Object value) {
    final String fieldName = getFieldName(binaryPropertyFilter.getProperty());
    final Criterion ret;

    if (binaryPropertyFilter instanceof EqualsPropertyFilter) {
        ret = Restrictions.eq(fieldName, value);
    } else if (binaryPropertyFilter instanceof LessThanPropertyFilter) {
        ret = Restrictions.lt(fieldName, value);
    } else if (binaryPropertyFilter instanceof LessThanEqualsPropertyFilter) {
        ret = Restrictions.le(fieldName, value);
    } else if (binaryPropertyFilter instanceof GreaterThanPropertyFilter) {
        ret = Restrictions.gt(fieldName, value);
    } else if (binaryPropertyFilter instanceof GreaterThanEqualsPropertyFilter) {
        ret = Restrictions.ge(fieldName, value);
    } else if (binaryPropertyFilter instanceof LikePropertyFilter) {
        if (((LikePropertyFilter) binaryPropertyFilter).getCaseSensitive()) {
            ret = Restrictions.like(fieldName, value);
        } else {//from  w  ww. j  a v a 2  s .  co m
            ret = Restrictions.ilike(fieldName, value);
        }
    } else {
        throw new IllegalStateException("Unable to process filter" + binaryPropertyFilter);
    }

    return ret;
}

From source file:ar.edu.unju.fi.apu.dao.impl.FacturaDetalleDAOImpl.java

@Override
public FacturaDetalle obtenerFacturaDetalle(int codigo) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(FacturaDetalle.class);

    criteria.add(Restrictions.like("codigo", codigo));
    return (FacturaDetalle) criteria.list().get(0);
}

From source file:benedict.zhang.addon.persistence.PersistenceManager.java

public List loadRolePlaying(String name) {
    if (StringUtils.isNullOrEmpty(name)) {
        return loadRolePlaying();
    }//from   w  ww . ja  va2  s. com
    session = sessionFactory.openSession();
    session.beginTransaction();
    Criteria criteria = session.createCriteria(RolePlayingConfiguration.class);
    criteria.add(Restrictions.like("addonName", "%" + name + "%"));
    List resultList = criteria.list();
    session.getTransaction().commit();
    session.close();
    return resultList;
}

From source file:benedict.zhang.addon.persistence.PersistenceManager.java

public List querySounds(String soundName, String actor) {
    session = sessionFactory.openSession();
    session.beginTransaction();//from   w  w w. ja  va 2 s .  c  o m
    Criteria criteria = session.createCriteria(Sound.class);
    if (soundName != null || !"".equals(soundName)) {
        criteria.add(Restrictions.like("soundName", "%" + soundName + "%"));
    }
    if (actor != null || !"".equals(actor)) {
        criteria.add(Restrictions.like("actor", "%" + actor + "%"));
    }
    List sounds = criteria.list();
    session.getTransaction().commit();
    session.close();
    return sounds;
}

From source file:br.com.bb.intranet.supermt.governo.repository.Funcionarios.java

public Funcionario porChave(String chave) {
    Criteria criteria = criarCriteria();

    criteria.add(Restrictions.like("chave", chave));

    return (Funcionario) criteria.uniqueResult();
}

From source file:br.com.cary.dao.FornecedorDAO.java

public List<Fornecedor> listar(String nome) {
    Session s = null;/*from w w  w. ja  v a2s.  c  o m*/
    try {
        s = ConectaDB.getSessionFactory().openSession();
        Criteria c = s.createCriteria(Fornecedor.class);
        c.add(Restrictions.like("nomeFantasia", nome + "%"));
        return c.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return null;
}

From source file:br.com.cary.dao.TabelaPrecoDAO.java

public List<TabelaPreco> listar(String nome) throws Exception {
    Session s = ConectaDB.getSessionFactory().openSession();
    Criteria c = s.createCriteria(TabelaPreco.class);
    c.add(Restrictions.like("nomeTabela", nome + "%"));
    return c.list();
}

From source file:br.com.cary.dao.UsuarioDAO.java

public List<Usuario> listar(String nomeUsuario) {
    List<Usuario> lista = null;
    try {//from   w ww.  jav a 2 s .com
        s = ConectaDB.getSessionFactory().openSession();
        Criteria crit = s.createCriteria(Usuario.class);
        crit.add(Restrictions.like("nomeUsuario", nomeUsuario + "%"));
        lista = crit.list();
    } catch (Exception e) {
        Alertas.mensagemErro(e.getMessage() + "\nErro ao tentar consultar os dados!");
    } finally {
        s.close();
    }
    return lista;
}

From source file:br.com.crescer.aula4.mapeamentoBaseNunes.DAO.CidadeDAO.java

@Override
public Cidade findById(Long id) {
    Criteria crit = session.createCriteria(Cidade.class);
    crit.add(Restrictions.like("idCidade", id));
    return (Cidade) (crit.uniqueResult());
}

From source file:br.com.crescer.aula4.mapeamentoBaseNunes.DAO.ClienteDAO.java

@Override
public Cliente findById(Long id) {
    Criteria crit = session.createCriteria(Cliente.class);
    crit.add(Restrictions.like("idCliente", id));
    return (Cliente) (crit.uniqueResult());
}