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.aes.dao.impl.BusinessUnitDaoImpl.java

@Override
public List searchName(String name) {
    Criteria criteria = session.getCurrentSession().createCriteria(BusinessUnit.class);
    Criterion condition = Restrictions.like("businessUnit", "%" + name + "%");
    criteria.add(condition);/*from  w  w w.  ja v a  2  s. c  om*/
    return criteria.list();
}

From source file:com.aes.dao.impl.ChapterDaoImpl.java

@Override
public List searchName(String name) {

    return session.getCurrentSession().createCriteria(Chapter.class)
            .add(Restrictions.like("chapterTitle", "%" + name + "%")).addOrder(Order.asc("chapterName")).list();
}

From source file:com.aes.dao.impl.CourseCategoryDaoImpl.java

@Override
public List searchName(String name) {
    return session.getCurrentSession().createCriteria(CourseCategory.class)
            .add(Restrictions.like("courseCategory", "%" + name + "%")).list();
}

From source file:com.aes.dao.impl.CourseDaoImpl.java

@Override
public List searchName(String name) {
    return session.getCurrentSession().createCriteria(Course.class)
            .add(Restrictions.like("courseTitle", "%" + name + "%")).list();
}

From source file:com.aes.dao.impl.ExamDaoImpl.java

@Override
public List searchName(String name) {
    return session.getCurrentSession().createCriteria(Exam.class)
            .add(Restrictions.like("examTitle", "%" + name + "%")).list();
}

From source file:com.aes.dao.impl.PresentationDaoImpl.java

@Override
public List searchName(String name) {
    return session.getCurrentSession().createCriteria(Presentation.class)
            .add(Restrictions.like("fileName", "%" + name + "%")).list();
}

From source file:com.aes.dao.impl.UserTypeDaoImpl.java

@Override
public List searchName(String name) {
    return session.getCurrentSession().createCriteria(UserType.class)
            .add(Restrictions.like("userType", "%" + name + "%")).list();
}

From source file:com.aistor.modules.cms.service.ArticleService.java

License:Open Source License

public Page<Article> find(Page<Article> page, Article article) {
    DetachedCriteria dc = articleDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (article.getCategory() != null && article.getCategory().getId() != null
            && !Category.isRoot(article.getCategory().getId())) {
        Category category = categoryDao.findOne(article.getCategory().getId());
        if (category != null) {
            dc.add(Restrictions.or(Restrictions.eq("category.id", category.getId()),
                    Restrictions.eq("category.parent.id", category.getId()),
                    Restrictions.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            article.setCategory(category);
        } else {//  w  w w.j  a v  a2s . c  om
            dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
        }
    } else {
        dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
    }
    if (StringUtils.isNotEmpty(article.getTitle())) {
        dc.add(Restrictions.like("title", "%" + article.getTitle() + "%"));
    }
    if (StringUtils.isNotEmpty(article.getPosid())) {
        dc.add(Restrictions.like("posid", "%," + article.getPosid() + ",%"));
    }
    if (StringUtils.isNotEmpty(article.getThumb()) && "1".equals(article.getThumb())) {
        dc.add(Restrictions.and(Restrictions.isNotNull("thumb"), Restrictions.ne("thumb", "")));
    }
    if (article.getUser() != null && article.getUser().getId() > 0) {
        dc.add(Restrictions.eq("user.id", article.getUser().getId()));
    }
    dc.add(Restrictions.eq("status", article.getStatus()));
    dc.addOrder(Order.desc("weight"));
    dc.addOrder(Order.desc("updateDate"));
    return articleDao.find(page, dc);
}

From source file:com.aistor.modules.cms.service.CommentService.java

License:Open Source License

public Page<Comment> find(Page<Comment> page, Comment comment) {
    DetachedCriteria dc = commentDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(comment.getModule())) {
        dc.add(Restrictions.eq("module", comment.getModule()));
    }/*  w  w w.  j  av  a  2 s. c  om*/
    if (comment.getContentId() != null && comment.getContentId() > 0) {
        dc.add(Restrictions.eq("contentId", comment.getContentId()));
    }
    if (StringUtils.isNotEmpty(comment.getTitle())) {
        dc.add(Restrictions.like("title", "%" + comment.getTitle() + "%"));
    }
    dc.add(Restrictions.eq("status", comment.getStatus()));
    dc.addOrder(Order.desc("id"));
    return commentDao.find(page, dc);
}

From source file:com.aistor.modules.cms.service.GuestbookService.java

License:Open Source License

public Page<Guestbook> find(Page<Guestbook> page, Guestbook guestbook) {
    DetachedCriteria dc = guestbookDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(guestbook.getType())) {
        dc.add(Restrictions.eq("type", guestbook.getType()));
    }//from   w w  w.j a  v a2s .c  o  m
    if (StringUtils.isNotEmpty(guestbook.getContent())) {
        dc.add(Restrictions.like("content", "%" + guestbook.getContent() + "%"));
    }
    dc.add(Restrictions.eq("status", guestbook.getStatus()));
    dc.addOrder(Order.desc("id"));
    return guestbookDao.find(page, dc);
}