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.headstrong.teevra.services.useradmin.dao.impl.RoleDAOImpl.java

License:Open Source License

public void saveRole(RoleEO roleToSave) throws UserAdminServiceException {
    DetachedCriteria criteria = DetachedCriteria.forClass(RoleEO.class);
    criteria.add(Restrictions.eq("roleName", roleToSave.getRoleName()));
    if (roleToSave.getRoleId() != null) {
        criteria.add(Restrictions.ne("roleId", roleToSave.getRoleId()));
    }//from   w w  w  .  j av  a2  s.c o m
    List<RoleEO> roleList = super.getByCriteria(criteria);

    if (!roleList.isEmpty()) {
        logger.error("Couldn't save role: " + roleToSave.getRoleName()
                + " A role with the same name already exists in the system");
        throw new UniqueRoleException("A role with the name " + "'" + roleToSave.getRoleName() + "'"
                + " already exists in the system");
    } else {
        super.saveOrUpdate(roleToSave);
    }

}

---

From source file:com.headstrong.teevra.services.useradmin.dao.impl.UserDAOImpl.java

License:Open Source License

public void saveUser(UserEO userToSave) throws UserAdminServiceException {

    DetachedCriteria criteria = DetachedCriteria.forClass(UserEO.class);
    criteria.add(Restrictions.eq("userName", userToSave.getUserName()));
    if (userToSave.getUserId() != null) {
        criteria.add(Restrictions.ne("userId", userToSave.getUserId()));
    }//from   www. j av a2s  . c o m
    List<UserEO> userList = super.getByCriteria(criteria);

    if (!userList.isEmpty()) {
        logger.error("Couldn't register user: " + userToSave.getUserName()
                + "A user with the same name already exists in the system");
        throw new UniqueUserException("A user with the name " + "'" + userToSave.getUserName() + "'"
                + " already exists in the system");
    } else {
        super.saveOrUpdate(userToSave);
    }
}

---

From source file:com.headstrong.teevra.services.useradmin.dao.impl.UserDAOImpl.java

License:Open Source License

public UserEO getUser(String userName) throws UserAdminServiceException {
    DetachedCriteria criteria = DetachedCriteria.forClass(UserEO.class);
    criteria.add(Restrictions.eq("userName", userName));
    //criteria.add(Restrictions.eq("userStatus", UserEO.STATUS_ACTIVE));
    List<UserEO> userList = super.getByCriteria(criteria);
    if (!userList.isEmpty()) {
        return userList.get(0);
    }// w ww.  java 2 s. c o m
    return null;
}

---

From source file:com.heimaide.server.service.sys.DictService.java

License:Open Source License

public Page<Dict> find(Page<Dict> page, Dict dict) {
    // MyBatis /*  ww  w. ja  va  2  s .c  o  m*/
    // dict.setPage(page);
    // page.setList(myBatisDictDao.find(dict));
    // return page;

    // Hibernate 
    DetachedCriteria dc = dictDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(dict.getType())) {
        dc.add(Restrictions.eq("type", dict.getType()));
    }
    if (StringUtils.isNotEmpty(dict.getDescription())) {
        dc.add(Restrictions.like("description", "%" + dict.getDescription() + "%"));
    }
    dc.add(Restrictions.eq(Dict.FIELD_DEL_FLAG, Dict.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("type")).addOrder(Order.asc("sort")).addOrder(Order.desc("id"));
    return dictDao.find(page, dc);
}

---

From source file:com.heimaide.server.service.sys.SysLogService.java

License:Open Source License

public Page<SysLog> find(Page<SysLog> page, Map<String, Object> paramMap) {
    DetachedCriteria dc = logDao.createDetachedCriteria();

    String createById = (String) paramMap.get("createById");
    if (StringUtils.isNotBlank(createById)) {
        dc.add(Restrictions.eq("createBy.id", createById));
    }/*from  w  w  w.  ja v a  2  s  . c  om*/

    String requestUri = (String) (paramMap.get("requestUri"));
    if (StringUtils.isNotBlank(requestUri)) {
        dc.add(Restrictions.like("requestUri", "%" + requestUri + "%"));
    }

    String exception = (String) (paramMap.get("exception"));
    if (StringUtils.isNotBlank(exception)) {
        dc.add(Restrictions.eq("type", SysLog.TYPE_EXCEPTION));
    }

    Date beginDate = DateUtils.parseDate(paramMap.get("beginDate"));
    if (beginDate == null) {
        beginDate = DateUtils.setDays(new Date(), 1);
        paramMap.put("beginDate", DateUtils.formatDate(beginDate, "yyyy-MM-dd"));
    }
    Date endDate = DateUtils.parseDate(paramMap.get("endDate"));
    if (endDate == null) {
        endDate = DateUtils.addDays(DateUtils.addMonths(beginDate, 1), -1);
        paramMap.put("endDate", DateUtils.formatDate(endDate, "yyyy-MM-dd"));
    }
    dc.add(Restrictions.between("createDate", beginDate, endDate));

    dc.addOrder(Order.desc("id"));
    return logDao.find(page, dc);
}

---

From source file:com.heimaide.server.service.sys.SystemService.java

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    User currentUser = UserUtils.getUser();
    DetachedCriteria dc = userDao.createDetachedCriteria();

    dc.createAlias("company", "company");
    if (user.getCompany() != null && StringUtils.isNotBlank(user.getCompany().getId())) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()),
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%")));
    }/*from  w w  w . j  ava2  s . c o m*/

    dc.createAlias("office", "office");
    if (user.getOffice() != null && StringUtils.isNotBlank(user.getOffice().getId())) {
        dc.add(Restrictions.or(Restrictions.eq("office.id", user.getOffice().getId()),
                Restrictions.like("office.parentIds", "%," + user.getOffice().getId() + ",%")));
    }
    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", "1"));
    }
    dc.add(dataScopeFilter(currentUser, "office", ""));

    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + user.getName() + "%"));
    }

    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.eq(User.FIELD_DEL_FLAG, User.DEL_FLAG_NORMAL));
    }
    if (!StringUtils.isNotEmpty(page.getOrderBy())) {
        dc.addOrder(Order.asc("company.code")).addOrder(Order.asc("office.code")).addOrder(Order.desc("name"));
    }
    return userDao.find(page, dc);
}

---

From source file:com.hod.pro.web.action.LoginAction.java

public String doLogin() {
    int usernumber = 0;
    request = ServletActionContext.getRequest();
    try {//  w  w w  . ja va2s .c  o m
        log.info("UserCounter.userSession.size=" + UserCounter.userSession.size());
        int onlinecount = 0;
        for (int i = 0; i < UserCounter.userSession.size(); i++) {
            UserSession obj = (UserSession) UserCounter.userSession.get(i);
            log.info("obj.sid=" + obj.sid);
            log.info("obj.lastonlinetime=" + obj.lastonlinetime);
            log.info("obj.lastonlinetime11=" + (System.currentTimeMillis() - obj.lastonlinetime));
            if (System.currentTimeMillis() - obj.lastonlinetime > UserCounter.offtime
                    && (!(request.getSession().getId()).equals(obj.sid))) {
                // UserCounter.userSession.remove(i);
                log.info("" + obj.sid);
                UserCounter.decrementUserCounter(obj.sid);
                i--;
            } else {
                onlinecount++;
            }
        }
        log.info("UserCounter.userSession.size=" + onlinecount);
        // todo code this
        //  onlinecount >= +1return message
        String file = InitServlet.localpath + "licenseFile1.a";

        String content = encryptData.decrypt(file);
        if (content != null && content.length() > 0) {
            String[] contents = content.split("\n");

            String sequence = contents[1];// 
            String dateuser = info.xuyj.util.License.decodeKey(sequence);// +_
            usernumber = Integer.parseInt(dateuser.substring(10).split("_")[1]);
            log.info("" + onlinecount + "" + usernumber);
            if (onlinecount > usernumber) {
                //throw new HodExecption("");
                msg.setError1("");
                msg.setLink(0, "<a href='" + request.getContextPath() + "/login.jsp'></a>");
                msg.setJump(false);
                request.setAttribute("message", msg);
                return "message";

            } else {
                this.checklicenseFile1(onlinecount);
            }
        }
        log.info("UserCounter.userSession.size=" + onlinecount);
        String userName = request.getParameter("username");
        String userPassWord = request.getParameter("userpassword");
        // 
        DetachedCriteria dc = DetachedCriteria.forClass(Hod2000Operator.class);
        dc.add(Restrictions.eq("loginName", userName));
        List list = hod2000OperatorService.findByCriteria(dc);
        if (list.size() > 0) {
            hod2000Operator = (Hod2000Operator) list.get(0);
            // 
            String pass = MD5.getMd5(userPassWord);
            if (pass.equals(hod2000Operator.getOperPassword())) {
                // 
                if (1 != hod2000Operator.getOperEnable()) {
                    //throw new HodExecption("");
                    msg.setError1("!");
                    msg.setLink(0, "<a href='" + request.getContextPath() + "/login.jsp'></a>");
                    msg.setJump(false);
                    request.setAttribute("message", msg);
                    return "message";
                }
            } else {
                //throw new HodExecption("");
                msg.setError1("!");
                msg.setLink(0, "<a href='" + request.getContextPath() + "/login.jsp'></a>");
                msg.setJump(false);
                request.setAttribute("message", msg);
                return "message";
            }
        } else {
            //throw new HodExecption("");
            msg.setError1("!");
            msg.setLink(0, "<a href='" + request.getContextPath() + "/login.jsp'></a>");
            msg.setJump(false);
            request.setAttribute("message", msg);
            return "message";
        }
        request.getSession().setAttribute("user", hod2000Operator);
        log.info(request.getSession().getId());
        UserCounter.updateUserCounter(request.getSession().getId(), Utils.dateToStrLong(new Date()),
                request.getRemoteHost(), hod2000Operator.getLoginName());
        request.getSession().setMaxInactiveInterval(-1);
        //1idid 2id
        String rolePermission = hod2000RoleService.findByOperatorId(hod2000Operator.getOperId());
        if (rolePermission != null && !"".equals(rolePermission)) {
            String permission = hod2000PermissionService.findByRolePermission(rolePermission);
            request.getSession().setAttribute("permission", permission);
        }
        OperatorLog.addOperatorLog("");
    } catch (Exception e) {
        // 
        msg.setError1("" + e.toString());
        msg.setLink(0, "<a href='" + request.getContextPath() + "/login.jsp'></a>");
        msg.setJump(false);
        log.error("LoginAction-->doLogin", e);
        request.setAttribute("message", msg);
        return "message";
    }
    return "login";
}

---

From source file:com.hongqiang.shop.modules.cms.service.ArticleService.java

License:Open Source License

public Page<Article> find(Page<Article> page, Article article, boolean isDataScopeFilter) {
    // ??6??//w ww  . j a  va2s  .co m
    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", "%" + 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.hongqiang.shop.modules.cms.service.CategoryService.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Category> findByUser(boolean isCurrentSite, String module) {

    List<Category> list = (List<Category>) UserUtils.getCache(CACHE_CATEGORY_LIST);
    if (list == null) {
        User user = UserUtils.getUser();
        DetachedCriteria dc = categoryDao.createDetachedCriteria();
        dc.createAlias("office", "office").createAlias("createBy", "user");
        dc.add(dataScopeFilter(user, "office", "user"));
        //         dc.add(Restrictions.or(Restrictions.isNull("href"),Restrictions.eq("href", "")));
        dc.add(Restrictions.eq("delFlag", Category.DEL_FLAG_NORMAL));
        dc.addOrder(Order.asc("site.id")).addOrder(Order.asc("sort"));
        list = categoryDao.find(dc);//from  w w  w  .  j  a v  a2 s  . com
        // 
        Set<Long> parentIdSet = Sets.newHashSet();
        for (Category e : list) {
            if (e.getParent() != null && e.getParent().getId() != null) {
                boolean isExistParent = false;
                for (Category e2 : list) {
                    if (e.getParent().getId().longValue() == e2.getId().longValue()) {
                        isExistParent = true;
                        break;
                    }
                }
                if (!isExistParent) {
                    parentIdSet.add(e.getParent().getId());
                }
            }
        }
        if (parentIdSet.size() > 0) {
            dc = categoryDao.createDetachedCriteria();
            dc.add(Restrictions.in("id", parentIdSet));
            dc.add(Restrictions.eq("delFlag", Category.DEL_FLAG_NORMAL));
            dc.addOrder(Order.asc("site.id")).addOrder(Order.asc("sort"));
            list.addAll(0, categoryDao.find(dc));
        }
        UserUtils.putCache(CACHE_CATEGORY_LIST, list);
    }

    if (isCurrentSite) {
        List<Category> categoryList = Lists.newArrayList();
        for (Category e : list) {
            if (Category.isRoot(e.getId()) || (e.getSite() != null && e.getSite().getId() != null
                    && e.getSite().getId().longValue() == Site.getCurrentSiteId())) {
                if (StringUtils.isNotEmpty(module)) {
                    if (module.equals(e.getModule()) || "".equals(e.getModule())) {
                        categoryList.add(e);
                    }
                } else {
                    categoryList.add(e);
                }
            }
        }
        return categoryList;
    }
    return list;
}

---

From source file:com.hongqiang.shop.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()));
    }//  www . jav  a 2s  .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()) && Category.SHOW.equals(category.getInMenu())) {
        dc.add(Restrictions.eq("inMenu", category.getInMenu()));
    }
    dc.add(Restrictions.eq(Category.DEL_FLAG, 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;
}

---

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