Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria add.

Prototype

public DetachedCriteria add(Criterion criterion) 

Source Link

Document

Add a restriction

Usage

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 {//from www.ja va 2s  . co m
            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.CategoryService.java

License:Open Source License

public Page<Category> find(Page<Category> page, Category category) {
    DetachedCriteria dc = categoryDao.createDetachedCriteria();
    if (category.getSite() != null && category.getSite().getId() != null) {
        dc.createAlias("site", "site");
        dc.add(Restrictions.eq("site.id", category.getSite().getId()));
    }//from  w w w  . j  a  va  2 s  .  c om
    if (category.getParent() != null && category.getParent().getId() != null) {
        dc.createAlias("parent", "parent");
        dc.add(Restrictions.eq("parent.id", category.getParent().getId()));
    }
    if (StringUtils.isNotBlank(category.getInMenu())) {
        dc.add(Restrictions.eq("inMenu", category.getInMenu()));
    }
    dc.add(Restrictions.eq("delFlag", Category.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("site.id")).addOrder(Order.asc("sort"));
    return categoryDao.find(page, dc);
    //      page.setSpringPage(categoryDao.findByParentId(category.getParent().getId(), page.getSpringPage()));
    //      return page;
}

---

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()));
    }/*from w  w  w .  j  a v  a2 s . co m*/
    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()));
    }//  w  w  w  .ja  v a  2  s .  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);
}

---

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

License:Open Source License

public Page<Link> find(Page<Link> page, Link link) {
    DetachedCriteria dc = linkDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (link.getCategory() != null && link.getCategory().getId() != null
            && !Category.isRoot(link.getCategory().getId())) {
        Category category = categoryDao.findOne(link.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()));
            link.setCategory(category);/*ww w.  j a  v  a 2s  .c  om*/
        } else {
            dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
        }
    } else {
        dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
    }
    if (StringUtils.isNotEmpty(link.getTitle())) {
        dc.add(Restrictions.like("title", "%" + link.getTitle() + "%"));
    }
    if (link.getUser() != null && link.getUser().getId() > 0) {
        dc.add(Restrictions.eq("user.id", link.getUser().getId()));
    }
    dc.add(Restrictions.eq("status", link.getStatus()));
    dc.addOrder(Order.desc("weight"));
    dc.addOrder(Order.desc("updateDate"));
    return linkDao.find(page, dc);
}

---

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

License:Open Source License

public Page<Site> find(Page<Site> page, Site site) {
    DetachedCriteria dc = siteDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(site.getName())) {
        dc.add(Restrictions.like("name", "%" + site.getName() + "%"));
    }//from  w  w  w .j  av a2 s .com
    dc.add(Restrictions.eq("delFlag", site.getDelFlag()));
    //dc.addOrder(Order.asc("id"));
    return siteDao.find(page, dc);
}

---

From source file:com.aistor.modules.sys.service.DictService.java

License:Open Source License

public Page<Dict> find(Page<Dict> page, Dict dict) {
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(dict.getType())) {
        dc.add(Restrictions.eq("type", dict.getType()));
    }/*from  ww w. j  a  v  a 2 s .com*/
    if (StringUtils.isNotEmpty(dict.getDesciption())) {
        dc.add(Restrictions.like("desciption", "%" + dict.getDesciption() + "%"));
    }
    dc.add(Restrictions.eq("delFlag", Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort"));
    return dictDao.find(page, dc);
}

---

From source file:com.aistor.modules.sys.service.SystemService.java

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    DetachedCriteria dc = userDao.createDetachedCriteria();
    User currentUser = UserUtils.getUser();
    if (!currentUser.isAdmin()) {
        if (user.getArea() == null || user.getArea().getId() == null) {
            user.setArea(currentUser.getArea());
        }//w ww. j  a  va  2  s  .  c om
        if (user.getOffice() == null || user.getOffice().getId() == null) {
            user.setOffice(currentUser.getOffice());
        }
    }
    dc.createAlias("area", "area");
    if (user.getArea() != null && user.getArea().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("area.id", user.getArea().getId()),
                Restrictions.eq("area.parent.id", user.getArea().getId()),
                Restrictions.like("area.parentIds", "%," + user.getArea().getId() + ",%")));
    }
    dc.createAlias("office", "office");
    if (user.getOffice() != null && user.getOffice().getId() != null) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.eq("office.parent.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + user.getName() + "%"));
    }
    dc.add(Restrictions.eq("delFlag", User.DEL_FLAG_NORMAL));
    if (!StringUtils.isNotEmpty(page.getOrderBy())) {
        dc.addOrder(Order.asc("area.code")).addOrder(Order.asc("office.code"));
    }
    return userDao.find(page, dc);
}

---

From source file:com.ateam.hibernate.HibernateDAOImpl.java

public UserAttr checkUser(String strUserName) throws DataAccessException, java.sql.SQLException {
    UserAttr obj = null;/* w w w. ja  v a 2  s .co  m*/
    DetachedCriteria critone = DetachedCriteria.forClass(UserAttr.class);
    critone.add(Restrictions.eq("userName", strUserName));

    List objs = getHibernateTemplate().findByCriteria(critone);
    if ((objs != null) && (objs.size() > 0)) {
        obj = (UserAttr) objs.get(0);
    }
    return obj;
}

---

From source file:com.ateam.hibernate.HibernateDAOImpl.java

public UserAttr validateUser(String strUserName, String password)
        throws DataAccessException, java.sql.SQLException {
    UserAttr obj = null;//from w  w w  .  j  a  v  a2 s  . co m
    DetachedCriteria crittwo = DetachedCriteria.forClass(UserAttr.class);
    crittwo.add(Restrictions.eq("userName", strUserName));
    crittwo.add(Restrictions.eq("userPassword", password));
    List objs = getHibernateTemplate().findByCriteria(crittwo);
    if ((objs != null) && (objs.size() > 0)) {
        obj = (UserAttr) objs.get(0);
    }
    return obj;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »