List of usage examples for org.hibernate.criterion Restrictions like
public static SimpleExpression like(String propertyName, String value, MatchMode matchMode)
From source file:br.com.prototipo.dao.DisciplinaDao.java
public List<Disciplina> getList(Disciplina d) { if (sessao.isConnected()) { sessao.close();/*w w w . jav a 2 s . c om*/ } sessao = HibernateUtil.getSessionFactory().openSession(); Criteria cri = sessao.createCriteria(Disciplina.class); Criterion _nome = Restrictions.like("nome", d.getNome(), MatchMode.ANYWHERE); cri.add(_nome); cri.addOrder(Order.asc("nome")); this.list = cri.list(); return list; }
From source file:br.com.prototipo.dao.HorarioDao.java
public List<Horario> getList(String h) { if (sessao.isConnected()) { sessao.close();/* w w w. j a va2 s. c o m*/ } sessao = HibernateUtil.getSessionFactory().openSession(); trans = sessao.beginTransaction(); Criteria cri = sessao.createCriteria(Horario.class); Criterion _nome = Restrictions.like("nomeDia", h, MatchMode.ANYWHERE); cri.add(_nome); this.list = cri.list(); return list; }
From source file:br.com.prototipo.dao.HorarioDao.java
public List<String> getListParaDisciplinas(String dia) { if (sessao.isConnected()) { sessao.close();//from w ww.j ava2 s . c om } sessao = HibernateUtil.getSessionFactory().openSession(); Criteria cri = sessao.createCriteria(Horario.class); Criterion _nome = Restrictions.like("nomeDia", dia, MatchMode.ANYWHERE); cri.add(_nome); ProjectionList projection = Projections.projectionList(); projection.add(Projections.property("aula")); cri.setProjection(projection); return cri.list(); }
From source file:br.com.prototipo.dao.HorarioDao.java
public Horario getHorarioEscolhido(String dia, String aula) { if (sessao.isConnected()) { sessao.close();/* ww w .j a v a 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();//from www . j a v a 2 s. c o 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 List<Professor> getList(String p) { if (sessao.isConnected()) { sessao.close();//from w w w. ja v a 2 s. c om } sessao = HibernateUtil.getSessionFactory().openSession(); trans = sessao.beginTransaction(); Criteria cri = sessao.createCriteria(Professor.class); Criterion _nome = Restrictions.like("nome", p, MatchMode.ANYWHERE); cri.add(_nome); cri.addOrder(Order.asc("nome")); this.list = cri.list(); return this.list; }
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 ww w.j a v a 2s . co m } 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 List<Turma> getList(String busca) { if (sessao.isConnected()) { sessao.close();//from ww w . j a va 2 s. c o m } sessao = HibernateUtil.getSessionFactory().openSession(); Criteria cri = sessao.createCriteria(Turma.class); Criterion _codigo = Restrictions.like("codigo", busca, MatchMode.START); cri.add(_codigo); cri.addOrder(Order.asc("codigo")); this.lista = cri.list(); return this.lista; }
From source file:br.com.prototipo.dao.TurmaDao.java
public Turma getTurma(String codigo) { if (sessao.isConnected()) { sessao.close();/*from w w w . j ava2 s . c o 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.TurmaDao.java
public List<HorarioTurma> getList(String turma, String busca) { if (sessao.isConnected()) { sessao.close();//from www.j ava2s . c o m } sessao = HibernateUtil.getSessionFactory().openSession(); Criteria cri = sessao.createCriteria(HorarioTurma.class); Criterion _codigo = Restrictions.like("codigoTurma", turma, MatchMode.ANYWHERE); cri.add(_codigo); Criterion _ano = Restrictions.like("nomeDia", busca, MatchMode.ANYWHERE); cri.add(_ano); this.list2 = cri.list(); return list2; }