List of usage examples for org.hibernate.criterion Restrictions like
public static SimpleExpression like(String propertyName, Object value)
From source file:com.contpatri.restful.inventario.jerseyspring.persistence.dao.hibernate.InventarioDAO.java
License:GNU General Public License
@SuppressWarnings("unchecked") public List<Inventario> findByName(String name) { log.debug("findByName: " + name); Criteria c = super.getSession().createCriteria(Inventario.class); c.add(Restrictions.like("name", "%" + name + "%")); return c.list(); }
From source file:com.core.controller.Kimera.java
public <T> T entityWithRestrictionsLike(Map<String, Object> restrictions, Class type) { Session s = sf.openSession();/*from www . j a v a 2 s .c o m*/ Criteria cri = s.createCriteria(type); for (Map.Entry<String, Object> entry : restrictions.entrySet()) { cri.add(Restrictions.like(entry.getKey(), "%" + entry.getValue() + "%")); } List<T> output = cri.list(); Hibernate.initialize(output); s.close(); return (T) output; }
From source file:com.core.controller.Kimera.java
public <T> T entityByIdLike(String key, String value, Class type) { Session s = sf.openSession();/*from www. j a v a2s. co m*/ Criteria cri = s.createCriteria(type); cri.add(Restrictions.like(key, "%" + value + "%")); List<T> output = cri.list(); Hibernate.initialize(output); s.close(); return (T) output; }
From source file:com.creativity.repository.LancamentosFinanceiros.java
public List<Financeiro> financeiroAbertoPorGestor() { Long usuarioGestorLogado = null; UsuarioSistema usuarioLogado = getUsuarioLogado(); if (usuarioLogado != null) { usuarioGestorLogado = usuarioLogado.getUsuario().getId(); }// w ww . j a va 2s .co m Session session = this.manager.unwrap(Session.class); Criteria criteria = session.createCriteria(Financeiro.class) // fazemos uma associao (join) com cliente e nomeamos como "c" // fazemos uma associao (join) com vendedor e nomeamos como "v" .createAlias("ficha", "f").add(Restrictions.eq("f.gestor.id", usuarioGestorLogado)) .add(Restrictions.like("statusFinanceiro", StatusFinanceiro.ABERTO)); return criteria.addOrder(Order.asc("id")).list(); }
From source file:com.cristian.tareask.daoImpl.GroupMessageDaoImpl.java
@Override public GroupMessage getGroupMessageByName(String GroupMessageName) { s = HibernateUtil.getSessionFactory().openSession(); return (GroupMessage) s.createCriteria(GroupMessage.class).add(Restrictions.like("name", GroupMessageName)) .uniqueResult();//from w w w . ja v a 2s . c om }
From source file:com.cristian.tareask.daoImpl.GroupMessageDaoImpl.java
@Override public List<GroupMessage> getGroupMessagesByTask(int TaskId) { s = HibernateUtil.getSessionFactory().openSession(); s.beginTransaction();//from ww w. ja v a2 s.co m Criteria c = s.createCriteria(GroupMessage.class, "groupmessage").createAlias("groupmessage.group", "group") .createAlias("group.tasks", "task").add(Restrictions.like("task.id", TaskId)) .addOrder(Order.desc("date")); return c.list(); }
From source file:com.cristian.tareask.daoImpl.IncidenceDaoImpl.java
@Override public List<Incidence> getIncidencesByTaskId(int TaskId) { s = HibernateUtil.getSessionFactory().openSession(); s.beginTransaction();/*from w ww .jav a 2 s .co m*/ Criteria c = s.createCriteria(Incidence.class).add(Restrictions.like("task.id", TaskId)) .addOrder(Order.desc("date")); //s.getTransaction().commit(); return c.list(); }
From source file:com.cristian.tareask.daoImpl.MessageReceptorDaoImpl.java
@Override public MessageReceptor getMessageReceptorByName(String MessageReceptorName) { s = HibernateUtil.getSessionFactory().openSession(); return (MessageReceptor) s.createCriteria(MessageReceptor.class) .add(Restrictions.like("name", MessageReceptorName)).uniqueResult(); }
From source file:com.cristian.tareask.daoImpl.MilestoneDaoImpl.java
@Override public Milestone getMilestoneByName(String MilestoneName) { s = HibernateUtil.getSessionFactory().openSession(); return (Milestone) s.createCriteria(Milestone.class).add(Restrictions.like("name", MilestoneName)) .uniqueResult();//from www . j ava 2s. c o m }
From source file:com.cristian.tareask.daoImpl.MilestoneDaoImpl.java
@Override public List<Milestone> getMilestonesByTask(int TaskId) { s = HibernateUtil.getSessionFactory().openSession(); s.beginTransaction();/*from ww w . j a va 2 s .c o m*/ Criteria c = s.createCriteria(Milestone.class).add(Restrictions.like("task.id", TaskId)) .addOrder(Order.asc("order")); //s.getTransaction().commit(); return c.list(); }