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.prototipo.dao.TurmaDao.java

public List<HorarioTurma> getList2(String turma) {
    if (sessao.isConnected()) {
        sessao.close();/*from  w  ww  . j  av a2 s .  c  om*/
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(HorarioTurma.class);
    Criterion _codigo = Restrictions.like("codigoTurma", turma, MatchMode.ANYWHERE);
    cri.add(_codigo);
    this.list2 = cri.list();
    return list2;
}

From source file:br.com.prototipo.dao.UsuarioDao.java

public String addUSuarioProfessor(Usuario u, String reg) {
    String retorno = null;/*from w  w w  .j a va2  s.co  m*/
    try {
        if (sessao.isConnected()) {
            sessao.close();
        }
        sessao = HibernateUtil.getSessionFactory().openSession();
        trans = sessao.beginTransaction();

        Criteria cri = sessao.createCriteria(Professor.class);
        Criterion _login = Restrictions.like("registro", reg, MatchMode.EXACT);
        cri.add(_login);
        if (cri.uniqueResult() != null) {
            u.setProfessor((Professor) cri.uniqueResult());
            u.setRegistro(u.getProfessor().getRegistro());
            Criteria cri2 = sessao.createCriteria(Usuario.class);
            _login = Restrictions.like("registro", u.getProfessor().getRegistro(), MatchMode.EXACT);
            cri2.add(_login);
            if (cri2.uniqueResult() == null) {
                sessao.save(u);
                trans.commit();
                retorno = "sucesso";
            } else {
                retorno = "jaCadastrado";
            }
        } else {
            retorno = "naoEncontrado";
        }
    } catch (Exception e) {
        e.printStackTrace();
        sessao.close();
    } finally {
        return retorno;
    }
}

From source file:br.com.prototipo.dao.UsuarioDao.java

public void addUsuario(Usuario u, String reg) {
    try {//from   w  w w  . jav a  2s  . c o  m
        if (sessao.isConnected()) {
            sessao.close();
        }
        sessao = HibernateUtil.getSessionFactory().openSession();
        trans = sessao.beginTransaction();
        Criteria cri = sessao.createCriteria(Usuario.class);
        Criterion _login = Restrictions.like("registro", reg, MatchMode.EXACT);
        cri.add(_login);
        if (cri.list().isEmpty()) {
            sessao.save(u);
            trans.commit();
        }

    } catch (Exception e) {
        e.printStackTrace();
        sessao.close();
    }
}

From source file:br.com.sgejs.dao.DaoAluno.java

public List<Aluno> buscaNomePorTrecho(String trecho) throws HibernateException {
    Criteria cri = sessao.createCriteria(classe);
    return cri.add(Restrictions.like("nome", trecho, MatchMode.START)).list();
}

From source file:br.com.SistemaOCTur.dao.ClienteDAO.java

public List<Cliente> pesquisarPorNome(String text) {
    entitys = criteria.add(Restrictions.or(Restrictions.like("nome", text, MatchMode.ANYWHERE),
            Restrictions.like("sobrenome", text, MatchMode.ANYWHERE))).list();
    session.close();//from  www  .  j  av a 2s . c o  m
    return entitys;
}

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

public List<Usuario> pegarTodosPorCargo(String nome, Cargo cargo) {
    entitys = criteria.add(Restrictions.like("nome", nome, MatchMode.START))
            .add(Restrictions.eq("cargo", cargo)).list();
    session.close();// w ww . ja v  a  2  s. co m
    return entitys;
}

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

public List<Usuario> pegarTodosPorNaoCargo(String nome, Cargo cargo) {
    entitys = criteria.add(Restrictions.like("nome", nome, MatchMode.START))
            .add(Restrictions.not(Restrictions.eq("cargo", cargo))).list();
    session.close();//from w w  w . j a v  a2  s.co m
    return entitys;
}

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

public List<Usuario> pegarTodosPorNome(String nome) {
    entitys = criteria.add(Restrictions.like("nome", nome, MatchMode.START)).list();
    session.close();// ww w  .j a va 2s .  c om
    return entitys;
}

From source file:br.edu.ifes.bd2hibernate.cgd.DAO.java

public List<?> selecionar(Class c, Field f, String value) {
    List listObj = new ArrayList();

    try {//from  www .  j  ava2 s.  c  o m
        Session s = HibernateUtil.getSession();
        HibernateUtil.begin();

        listObj = s.createCriteria(c)
                .add(Restrictions.like(c.getSimpleName() + "." + f.getName(), value, MatchMode.ANYWHERE))
                .list();

        HibernateUtil.commit();
        HibernateUtil.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return listObj;
}

From source file:br.endemics.dao.AreaDAO.java

public List<Area> pesquisarArea(String campo, String valor) {
    List<Area> lista = null;
    try {//  ww  w  . j  ava2  s . c  o  m
        this.setSessao(HibernateUtil.getSessionFactory().openSession());
        setTransacao(getSessao().beginTransaction());
        lista = this.getSessao().createCriteria(Area.class)
                .add(Restrictions.like(campo, valor, MatchMode.START))
                .add(Restrictions.eq("city", UsuarioAtivo.getUser().getCity()))
                .addOrder(Order.asc("description")).list();

    } catch (Throwable e) {
        if (getTransacao().isActive()) {
            getTransacao().rollback();
        }
        JOptionPane.showMessageDialog(null, "No foi possvel listar: " + e.getMessage());
    } finally {
        getSessao().close();
    }
    return lista;

}