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.iqtb.validacion.dao.DaoSociosComerciales.java

@Override
public List<SociosComerciales> listaSociosCriteria(Integer idEmpresa, Integer inicio, Integer fin,
        String sortField, SortOrder sortOrder, Map<String, String> filters) throws Exception {
    List<SociosComerciales> lista = null;
    Session session = HibernateUtil.getSessionFactory().openSession();
    Transaction tx = session.beginTransaction();

    Criteria cr = session.createCriteria(SociosComerciales.class);
    cr.add(Restrictions.eq("idEmpresa", idEmpresa));

    if (sortField != null && !sortField.isEmpty()) {
        if (sortOrder.equals(SortOrder.ASCENDING)) {
            cr.addOrder(Order.asc(sortField));
        } else {/*from ww w.  j  av a2  s. com*/
            cr.addOrder(Order.desc(sortField));
        }
    }
    if (!filters.isEmpty()) {
        Iterator it = filters.keySet().iterator();
        while (it.hasNext()) {
            String key = (String) it.next();
            cr.add(Restrictions.like(key, "" + filters.get(key) + "%"));
        }
    }
    cr.setFirstResult(inicio);
    cr.setMaxResults(inicio + fin);
    lista = cr.list();

    return lista;
}

---

From source file:com.iqtb.validacion.managedbean.MbSociosComerciales.java

@PostConstruct
public void init() {
    socioDataList = new LazyDataModel<SociosComerciales>() {
        private static final long serialVersionUID = 1L;

        @Override//from w  w w.  ja va 2 s . c  o  m
        public List<SociosComerciales> load(int first, int pageSize, String sortField, SortOrder sortOrder,
                Map<String, String> filters) {
            listaSocios = new ArrayList<SociosComerciales>();
            session = HibernateUtil.getSessionFactory().openSession();
            tx = session.beginTransaction();

            Criteria cr = session.createCriteria(SociosComerciales.class);
            Criteria crCount = session.createCriteria(SociosComerciales.class);
            crCount.setProjection(Projections.rowCount());
            cr.add(Restrictions.eq("idEmpresa", empresa.getIdEmpresa()));
            crCount.add(Restrictions.eq("idEmpresa", empresa.getIdEmpresa()));

            if (sortField != null && !sortField.isEmpty()) {
                if (sortOrder.equals(SortOrder.ASCENDING)) {
                    cr.addOrder(Order.asc(sortField));
                } else {
                    cr.addOrder(Order.desc(sortField));
                }
            } else {
                cr.addOrder(Order.desc("idSocioComercial"));
            }

            if (!filters.isEmpty()) {
                Iterator it = filters.keySet().iterator();
                while (it.hasNext()) {
                    String key = (String) it.next();
                    cr.add(Restrictions.like(key, "" + filters.get(key) + "%"));
                    crCount.add(Restrictions.like(key, "" + filters.get(key) + "%"));
                }
            }
            Integer num = ((Long) crCount.uniqueResult()).intValue();
            this.setRowCount(num);
            cr.setFirstResult(first);
            cr.setMaxResults(pageSize + first);
            listaSocios = cr.list();
            if (session.isOpen()) {
                session.clear();
                session.close();
            }
            return listaSocios;
        }
    };
}

---

From source file:com.it250.projekat.dao.SongDaoImpl.java

@Override
public List<Song> findSongsByName(String name) {
    return session.createCriteria(Song.class).add(Restrictions.like("name", name)).list();
}

---

From source file:com.itrus.ca.common.service.BaseService.java

License:Open Source License

protected static Junction dataScopeFilterByWorkDealInfo(User user, String Alias, String office) {

    // ????/* www.j a  v a2s  .co m*/
    List<String> dataScope = Lists.newArrayList();
    Junction junction = Restrictions.disjunction();
    // ???
    if (!user.isAdmin()) {
        for (Role r : user.getRoleList()) {
            if (!dataScope.contains(r.getDataScope()) && StringUtils.isNotBlank(Alias)) {
                boolean isDataScopeAll = false;
                if (Role.DATA_SCOPE_ALL.equals(r.getDataScope())) {
                    isDataScopeAll = true;
                } else if (Role.DATA_SCOPE_COMPANY_AND_CHILD.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(office, user.getCompany().getId()));
                    junction.add(Restrictions.like(Alias,
                            user.getCompany().getParentIds() + user.getCompany().getId() + ",%"));
                } else if (Role.DATA_SCOPE_COMPANY.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(Alias, user.getCompany().getId()));
                    //                  junction.add(Restrictions.and(Restrictions.eq(Alias+".parent.id", user.getCompany().getId()),
                    //                        Restrictions.eq(Alias+".type", "2"))); // ?
                } else if (Role.DATA_SCOPE_OFFICE_AND_CHILD.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(office, user.getOffice().getId()));
                    junction.add(Restrictions.like(Alias,
                            user.getOffice().getParentIds() + user.getOffice().getId() + ",%"));
                } else if (Role.DATA_SCOPE_OFFICE.equals(r.getDataScope())) {
                    junction.add(Restrictions.eq(office, user.getOffice().getId()));
                } else if (Role.DATA_SCOPE_CUSTOM.equals(r.getDataScope())) {
                    junction.add(Restrictions.in(office, r.getOfficeIdList()));
                }
                //else if (Role.DATA_SCOPE_SELF.equals(r.getDataScope())){
                if (isDataScopeAll) {
                    // ?????
                    junction = Restrictions.disjunction();
                    break;
                }
                dataScope.add(r.getDataScope());
            }
        }
    }
    return junction;
}

---

From source file:com.itrus.ca.modules.cms.service.ArticleService.java

License:Open Source License

public Page<Article> find(Page<Article> page, Article article, boolean isDataScopeFilter) {
    // ??6??/*  w  w w. j  a  va2 s  . com*/
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByArticle");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        articleDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByArticle", DateUtils.addHours(new Date(), 6));
    }
    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.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            article.setCategory(category);
        } else {
            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", "%" + EscapeUtil.escapeLike(article.getTitle()) + "%"));
    }
    if (StringUtils.isNotEmpty(article.getPosid())) {
        dc.add(Restrictions.like("posid", "%," + article.getPosid() + ",%"));
    }
    if (StringUtils.isNotEmpty(article.getImage()) && Article.YES.equals(article.getImage())) {
        dc.add(Restrictions.and(Restrictions.isNotNull("image"), Restrictions.ne("image", "")));
    }
    if (article.getCreateBy() != null && article.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", article.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Article.DEL_FLAG, article.getDelFlag()));
    if (StringUtils.isBlank(page.getOrderBy())) {
        dc.addOrder(Order.desc("weight"));
        dc.addOrder(Order.desc("updateDate"));
    }
    return articleDao.find(page, dc);
}

---

From source file:com.itrus.ca.modules.cms.service.CommentService.java

License:Open Source License

public Page<Comment> find(Page<Comment> page, Comment comment) {
    DetachedCriteria dc = commentDao.createDetachedCriteria();
    if (comment.getContentId() != null && comment.getContentId() > 0) {
        dc.add(Restrictions.eq("contentId", comment.getContentId()));
    }//from  ww w . j a va2 s .c  o  m
    if (StringUtils.isNotEmpty(comment.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(comment.getTitle()) + "%"));
    }
    dc.add(Restrictions.eq(Comment.DEL_FLAG, comment.getDelFlag()));
    dc.addOrder(Order.desc("id"));
    return commentDao.find(page, dc);
}

---

From source file:com.itrus.ca.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 ww.  j  a v a  2 s  .  co  m
    if (StringUtils.isNotEmpty(guestbook.getContent())) {
        dc.add(Restrictions.like("content", "%" + EscapeUtil.escapeLike(guestbook.getContent()) + "%"));
    }
    dc.add(Restrictions.eq(Guestbook.DEL_FLAG, guestbook.getDelFlag()));
    dc.addOrder(Order.desc("id"));
    return guestbookDao.find(page, dc);
}

---

From source file:com.itrus.ca.modules.cms.service.LinkService.java

License:Open Source License

public Page<Link> find(Page<Link> page, Link link, boolean isDataScopeFilter) {
    // ??6??//  w  w  w  . j  av  a 2  s .c o m
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByLink");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        linkDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByLink", DateUtils.addHours(new Date(), 6));
    }
    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.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            link.setCategory(category);
        } 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", "%" + EscapeUtil.escapeLike(link.getTitle()) + "%"));
    }
    if (link.getCreateBy() != null && link.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", link.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Link.DEL_FLAG, link.getDelFlag()));
    dc.addOrder(Order.desc("weight"));
    dc.addOrder(Order.desc("updateDate"));
    return linkDao.find(page, dc);
}

---

From source file:com.itrus.ca.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", "%" + EscapeUtil.escapeLike(site.getName()) + "%"));
    }/*  w w w  .java 2 s.  c o  m*/
    dc.add(Restrictions.eq(Site.DEL_FLAG, site.getDelFlag()));
    //dc.addOrder(Order.asc("id"));
    return siteDao.find(page, dc);
}

---

From source file:com.itrus.ca.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 . jav a 2s  .c  o m*/
    if (StringUtils.isNotEmpty(dict.getDescription())) {
        dc.add(Restrictions.like("description", "%" + EscapeUtil.escapeLike(dict.getDescription()) + "%"));
    }
    dc.add(Restrictions.eq(Dict.DEL_FLAG, Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort")).addOrder(Order.desc("id"));
    return dictDao.find(page, dc);
}

---

• «
• 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
• »