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:com.cristian.tareask.daoImpl.TaskDaoImpl.java

@Override
public Task getTaskByName(String TaskName) {
    s = HibernateUtil.getSessionFactory().openSession();
    return (Task) s.createCriteria(Task.class).add(Restrictions.like("name", TaskName)).uniqueResult();
}

From source file:com.cristian.tareask.daoImpl.TaskDaoImpl.java

@Override
public List getTasksByUserId(int UserId) {
    s = HibernateUtil.getSessionFactory().openSession();
    s.beginTransaction();//from   w  w w .ja  v a 2  s  .  co  m
    Criteria c = s.createCriteria(Task.class, "task").createAlias("task.user", "user")
            .add(Restrictions.like("user.id", UserId));
    List l = c.list();
    //s.getTransaction().commit();
    return l;
}

From source file:com.cristian.tareask.daoImpl.TaskDaoImpl.java

@Override
public List getTasksGroupByUserId(int UserId) {
    s = HibernateUtil.getSessionFactory().openSession();
    s.beginTransaction();/*w  ww . j  a v  a  2  s.  c  o  m*/
    Criteria c = s.createCriteria(Task.class, "task").createAlias("task.group", "group")
            .createAlias("group.groupUserses", "groupuser").createAlias("groupuser.user", "user")
            .add(Restrictions.like("user.id", UserId));
    List l = c.list();
    return l;
}

From source file:com.cristian.tareask.daoImpl.TaskReportDaoImpl.java

@Override
public TaskReport getTaskReportByName(String TaskReportName) {
    s = HibernateUtil.getSessionFactory().openSession();
    return (TaskReport) s.createCriteria(TaskReport.class).add(Restrictions.like("name", TaskReportName))
            .uniqueResult();//from  w w  w. j a  va2 s.c  o m
}

From source file:com.cristian.tareask.daoImpl.TaskReportDaoImpl.java

@Override
public List<TaskReport> getReportsByTask(int TaskId) {
    s = HibernateUtil.getSessionFactory().openSession();
    s.beginTransaction();/*from   w w w  . ja va 2  s .  com*/
    Criteria c = s.createCriteria(TaskReport.class).add(Restrictions.like("task.id", TaskId))
            .addOrder(Order.desc("date"));
    return c.list();
}

From source file:com.cristian.tareask.daoImpl.UserDaoImpl.java

@Override
public User getUserByName(String UserName) {
    User u = new User();
    s = HibernateUtil.getSessionFactory().getCurrentSession();
    s.beginTransaction();//from   w ww .j a v  a 2s  .  c  o m
    u = (User) s.createCriteria(User.class).add(Restrictions.like("name", UserName)).uniqueResult();
    s.getTransaction().commit();
    return u;
}

From source file:com.cristian.tareask.daoImpl.UserDaoImpl.java

@Override
public User getUserByEmail(String email) {
    User u = new User();
    s = HibernateUtil.getSessionFactory().getCurrentSession();

    try {/*  ww  w.ja  v a  2s. co  m*/
        s.beginTransaction();
        u = (User) s.createCriteria(User.class).add(Restrictions.like("email", email)).uniqueResult();
        s.getTransaction().commit();
    } catch (Exception e) {
        e.printStackTrace();
        s.getTransaction().rollback();
    }
    return u;
}

From source file:com.db.dao.AbstractFacade.java

public List<T> findByName(String name) {
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(entityClass)
            .add(Restrictions.eq("retired", false)).add(Restrictions.like("name", "%" + name + "%"));
    return (List<T>) getHibernateTemplate().findByCriteria(detachedCriteria);
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateApplicationDao.java

License:Mozilla Public License

private Criteria getSearchAppCriteria(Integer orgId, String searchString) {
    Criteria criteria = getActiveAppCriteria();

    criteria.add(Restrictions.eq("team.id", orgId));
    if (searchString != null && !searchString.isEmpty()) {
        criteria.add(Restrictions.like("name", "%" + searchString + "%"));
    }//from  w  w w .j  a  va  2s. co m

    return criteria;
}

From source file:com.denimgroup.threadfix.data.dao.hibernate.HibernateUserDao.java

License:Mozilla Public License

@Override
public Long countUsers(String searchString) {
    Criteria criteria = getActiveUserCriteria().setProjection(Projections.rowCount());

    if (searchString != null) {
        criteria.add(Restrictions.or(Restrictions.like("name", "%" + searchString + "%"),
                Restrictions.like("displayName", "%" + searchString + "%")));
    }//from w w  w .ja va 2  s  . c o m

    return (Long) criteria.uniqueResult();
}