Example usage for org.hibernate Criteria uniqueResult

Introduction

In this page you can find the example usage for org.hibernate Criteria uniqueResult.

Prototype

public Object uniqueResult() throws HibernateException;

Source Link

Document

Convenience method to return a single instance that matches the query, or null if the query returns no results.

Usage

From source file:br.com.pfood.dao.imp.GenericDAOImp.java

@Override
public int buscaProximoCodigo(Class classe) throws Exception {

    Field[] fields = classe.getDeclaredFields();
    Criteria c = getSession().createCriteria(classe);
    for (Field f : fields) {
        f.setAccessible(true);/*  ww w .j  a  va2s .com*/
        if (f.isAnnotationPresent(Id.class)) {
            c.setProjection(Projections.max(f.getName()));
            break;
        }
    }
    c.setResultTransformer(c.DISTINCT_ROOT_ENTITY);
    Integer maximo = (Integer) c.uniqueResult();

    if (maximo == null || maximo == 0) {
        return 1;
    } else {
        return maximo + 1;
    }
}

From source file:br.com.progolden.dneutils.abstractions.GenericDAO.java

License:Apache License

public <E> E uniqueByCriteria(Criteria criteria, Class<E> clazz) {
    return clazz.cast(criteria.uniqueResult());
}

From source file:br.com.projetoweb.util.Autentication.java

public boolean userAutentication(Usuario usuario) {
    Session session = factory.openSession();
    Criteria criteria = session.createCriteria(Usuario.class);
    criteria.add(Restrictions.eq("login", usuario.getLogin()));
    criteria.add(Restrictions.eq("senha", usuario.getPass()));

    return criteria.uniqueResult() != null;
}

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

public Curso getCursoEscolhido(String cod) {
    if (sessao.isConnected()) {
        sessao.close();//from   w  w  w .  j a  v a 2  s .  c  o m
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Curso.class);
    Criterion _cod = Restrictions.like("codigo", cod, MatchMode.EXACT);
    cri.add(_cod);

    cri.setMaxResults(1);
    Object result = cri.uniqueResult();
    Curso c = new Curso();
    if (result != null) {
        c = (Curso) result;
    }
    return c;
}

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

public Disciplina getDisciplina(String codigo) { //codigo usado para retornar a disciplina cujo codigo e passado por parametro
    if (sessao.isConnected()) {
        sessao.close();// w  w  w  . j  a  va2 s.  c  om
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Disciplina.class);
    Criterion _cod = Restrictions.like("codigo", codigo, MatchMode.EXACT);
    cri.add(_cod);
    cri.setMaxResults(1);
    Object result = cri.uniqueResult();
    Disciplina d = new Disciplina();
    if (result != null) {
        d = (Disciplina) result;
    }
    return d;
}

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

public Horario getHorarioEscolhido(String dia, String aula) {
    if (sessao.isConnected()) {
        sessao.close();//from ww w  .j  a va  2  s.  co m
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Horario.class);
    Criterion _nome = Restrictions.like("nomeDia", dia, MatchMode.EXACT);
    cri.add(_nome);
    Criterion _aula = Restrictions.like("aula", aula, MatchMode.EXACT);
    cri.add(_aula);
    return (Horario) cri.uniqueResult();
}

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

public Preferencia getPreferencia(String prof) {
    if (sessao.isConnected()) {
        sessao.close();/*w ww .java 2 s  .  co  m*/
    }
    sessao = HibernateUtil.getSessionFactory().openSession();
    trans = sessao.beginTransaction();

    Criteria cri = sessao.createCriteria(Preferencia.class);
    Criterion _nome = Restrictions.like("registroProfessor", prof, MatchMode.ANYWHERE);
    cri.add(_nome);
    return (Preferencia) cri.uniqueResult();
}

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

public Professor getProfessor(String codigo) { //codigo usado para retornar a disciplina cujo codigo e passado por parametro
    if (sessao.isConnected()) {
        sessao.close();/*from   w w  w.  j  a  v  a2  s.c  om*/
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Professor.class);
    Criterion _cod = Restrictions.like("registro", codigo, MatchMode.EXACT);
    cri.add(_cod);
    cri.setMaxResults(1);
    Object result = cri.uniqueResult();
    Professor p = new Professor();
    if (result != null) {
        p = (Professor) result;
    }
    return p;
}

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

public Turma getTurma(String codigo) {
    if (sessao.isConnected()) {
        sessao.close();//  w  ww . j a v  a2s .  co m
    }
    sessao = HibernateUtil.getSessionFactory().openSession();

    Criteria cri = sessao.createCriteria(Turma.class);
    Criterion _cod = Restrictions.like("codigo", codigo, MatchMode.EXACT);
    cri.add(_cod);
    cri.setMaxResults(1);
    Object result = cri.uniqueResult();
    Turma turma = new Turma();
    if (result != null) {
        turma = (Turma) result;
    }
    return turma;
}

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

public String addUSuarioProfessor(Usuario u, String reg) {
    String retorno = null;//w  ww  .j  ava  2s .  c om
    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;
    }
}