Example usage for org.hibernate.criterion Restrictions lt

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions lt.

Prototype

public static SimpleExpression lt(String propertyName, Object value) 

Source Link

Document

Apply a "less than" constraint to the named property

Usage

From source file:com.blue.ssh.core.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ??Criterion,./*  ww  w  . j  av  a 2  s  . c  o m*/
 */
protected Criterion buildCriterion(final String propertyName, final Object propertyValue,
        final MatchType matchType) {
    Assert.hasText(propertyName, "propertyName?");
    Criterion criterion = null;
    // ?MatchTypecriterion
    switch (matchType) {
    case EQ:
        criterion = Restrictions.eq(propertyName, propertyValue);
        break;
    case LIKE:
        criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE);
        break;

    case LE:
        criterion = Restrictions.le(propertyName, propertyValue);
        break;
    case LT:
        criterion = Restrictions.lt(propertyName, propertyValue);
        break;
    case GE:
        criterion = Restrictions.ge(propertyName, propertyValue);
        break;
    case GT:
        criterion = Restrictions.gt(propertyName, propertyValue);
    case NE:
        criterion = Restrictions.ne(propertyName, propertyValue);
    }
    return criterion;
}

---

From source file:com.cai310.lottery.service.lottery.keno.impl.KenoServiceImpl.java

@Transactional(readOnly = true)
public List<I> getCanOpenResults() {
    DetachedCriteria criteria = DetachedCriteria.forClass(issueDataDao.getEntityClass());
    criteria.add(Restrictions.lt("endedTime", new Date()));
    criteria.add(Restrictions.gt("endedTime", DateUtils.addDays(new Date(), -1)));
    criteria.add(Restrictions.eq("state", IssueState.ISSUE_SATE_END));
    criteria.addOrder(Order.desc("id"));
    return issueDataDao.findByDetachedCriteria(criteria, true);
}

---

From source file:com.cai310.lottery.web.controller.lottery.keno.KenoController.java

/**
 * ?//from ww w.  j a va 2s  .  com
 * 
 * @return
 */
public String result() {
    try {
        Class<I> cls = kenoService.getIssueDataClass();
        DetachedCriteria criteria = DetachedCriteria.forClass(cls);
        criteria.add(Restrictions.isNotNull("results"));
        if (StringUtils.isBlank(resultDate)) {
            resultDate = DateUtil.getTodaySixStr();
        }
        criteria.add(Restrictions.gt("prizeTime", DateUtil.getTodaySixDate(resultDate)));
        criteria.add(
                Restrictions.lt("prizeTime", DateUtil.getNextdaySixDate(DateUtil.getTodaySixDate(resultDate))));
        criteria.addOrder(Order.desc("id"));
        periods = kenoService.findKenoPeriodByCriteria(criteria, null);
        resultDates = DateUtil.getSixList();
        return "result-info";
    } catch (ServiceException e) {
        addActionMessage(e.getMessage());
    } catch (Exception e) {
        addActionMessage(e.getMessage());
        logger.warn(e.getMessage(), e);
    }

    return error();
}

---

From source file:com.cai310.lottery.web.controller.lottery.SchemeBaseController.java

/**
 * ?/* www .j ava2s  . c  om*/
 */
protected XDetachedCriteria buildWonListQueryCriteria() {
    this.preparePeriodsOfList(10);
    String periodId = Struts2Utils.getParameter("periodId");
    if (StringUtils.isNotBlank(periodId)) {
        Period periodTemp = periodEntityManager.getPeriod(Long.valueOf(periodId));
        if (null != periodTemp)
            this.period = periodTemp;
    } else if (this.periods != null && !this.periods.isEmpty()) {
        this.period = this.periods.get(0);
    }

    XDetachedCriteria criteria = new XDetachedCriteria(this.schemeClass, "m");

    String sponsorNameOrSchemeNum = Struts2Utils.getParameter("sponsorNameOrSchemeNum");
    Lottery lotteryType = this.getLotteryType();
    if (StringUtils.isNotBlank(sponsorNameOrSchemeNum)
            && Lottery.isSchemeNumber(sponsorNameOrSchemeNum, lotteryType)) {
        Long schemeId = lotteryType.getSchemeId(sponsorNameOrSchemeNum);
        criteria.add(Restrictions.eq("m.id", schemeId));
    } else {
        if (StringUtils.isNotBlank(sponsorNameOrSchemeNum)) {
            criteria.add(Restrictions.eq("m.sponsorName", sponsorNameOrSchemeNum));
        }
        criteria.add(Restrictions.eq("m.periodId", this.period.getId()));

        Calendar c = Calendar.getInstance();
        c.add(Calendar.HOUR_OF_DAY, 0);
        c.add(Calendar.MINUTE, 0);
        c.add(Calendar.SECOND, 0);
        if (timeFrame != 7) {
            c.add(Calendar.DAY_OF_MONTH, -timeFrame);

            Date date = c.getTime();
            String dateStr = com.cai310.utils.DateUtil.dateToStr(date, "yyyy-MM-dd");
            Date startDate = com.cai310.utils.DateUtil.strToDate(dateStr + " 00:00");
            Date endDate = com.cai310.utils.DateUtil.strToDate(dateStr + " 23:59");

            criteria.add(Restrictions.gt("m.prizeSendTime", startDate));
            criteria.add(Restrictions.lt("m.prizeSendTime", endDate));
        }
        criteria.add(Restrictions.eq("m.prizeSended", true));
        criteria.addOrder(Order.desc("prizeSendTime"));
    }
    return criteria;
}

---

From source file:com.codefupanda.persistor.util.HibernateUtil.java

License:Open Source License

private static Criterion convert(PropertyValueExpressionCriteria criteria) {
    Criterion criterion = null;//from   w  w  w .j a v  a 2s .c om
    String property = criteria.getProperty();
    Object value = criteria.getValue();

    if (criteria.getOp().equals("=")) {
        criterion = Restrictions.eq(property, value);
    } else if (criteria.getOp().equals(">")) {
        criterion = Restrictions.gt(property, value);
    } else if (criteria.getOp().equals("<")) {
        criterion = Restrictions.lt(property, value);
    } else if (criteria.getOp().equals(">=")) {
        criterion = Restrictions.ge(property, value);
    } else if (criteria.getOp().equals("<=")) {
        criterion = Restrictions.le(property, value);
    } else if (criteria.getOp().equals("in")) {
        criterion = Restrictions.in(property, (Object[]) value);
    } else if (criteria.getOp().equals("like")) {
        criterion = Restrictions.like(property, value);
    } else if (criteria.getOp().equals("ilike")) {
        criterion = Restrictions.ilike(property, value);
    }
    return criterion;
}

---

From source file:com.dalamar.model.LateTrainDaoImpl.java

private Conjunction createDateCriterion(Date d) {
    d.setHours(0);// w  ww  .java2s.  c o  m
    d.setMinutes(0);
    d.setSeconds(0);
    Date beginDate = d;
    Date endDate = new Date(beginDate.getTime() + TimeUnit.DAYS.toMillis(1));
    Conjunction andOperator = Restrictions.conjunction();
    andOperator.add(Restrictions.ge("dateCaptured", beginDate));
    andOperator.add(Restrictions.lt("dateCaptured", endDate));
    return andOperator;
}

---

From source file:com.dalamar.model.LateTrainDaoImpl.java

private Conjunction createDateCriterion(Date begin, Date end) {
    begin.setHours(0);//from w w  w .  ja va 2 s  .  co  m
    begin.setMinutes(0);
    begin.setSeconds(0);
    end.setHours(0);
    end.setMinutes(0);
    end.setSeconds(0);
    Date beginDate = begin;
    Date endDate = new Date(end.getTime() + TimeUnit.DAYS.toMillis(1));
    Conjunction andOperator = Restrictions.conjunction();
    andOperator.add(Restrictions.ge("dateCaptured", beginDate));
    andOperator.add(Restrictions.lt("dateCaptured", endDate));
    return andOperator;
}

---

From source file:com.db4o.drs.hibernate.impl.HibernateReplicationProvider.java

License:Open Source License

private Collection getChangedObjectsSinceLastReplication(PersistentClass persistentClass) {
    Criteria criteria = getSession().createCriteria(ObjectReference.class);
    long lastReplicationVersion = getLastReplicationVersion();
    criteria.add(Restrictions.gt(ObjectReference.Fields.VERSION, lastReplicationVersion));
    criteria.add(Restrictions.lt(ObjectReference.Fields.VERSION, _commitTimestamp));
    Disjunction disjunction = Restrictions.disjunction();

    List<String> names = new ArrayList<String>();
    names.add(persistentClass.getClassName());
    if (persistentClass.hasSubclasses()) {
        final Iterator it = persistentClass.getSubclassClosureIterator();
        while (it.hasNext()) {
            PersistentClass subC = (PersistentClass) it.next();
            names.add(subC.getClassName());
        }/*from www  . j a  va 2 s  .c o m*/
    }

    for (String s : names)
        disjunction.add(Restrictions.eq(ObjectReference.Fields.CLASS_NAME, s));

    criteria.add(disjunction);

    Set out = new HashSet();
    for (Object o : criteria.list()) {
        ObjectReference ref = (ObjectReference) o;
        out.add(getSession().load(persistentClass.getRootClass().getClassName(), ref.getTypedId()));
    }
    return out;
}

---

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

License:Mozilla Public License

private Criteria getEventCriteria(List<String> eventActions, User user, Date startTime, Date stopTime,
        Set<Integer> appIds, Set<Integer> teamIds, Set<Integer> vulnIds, Set<Integer> defectIds) {
    Criteria criteria = getSession().createCriteria(getClassReference()).add(Restrictions.eq("active", true));

    criteria.createAlias("scan", "scan", Criteria.LEFT_JOIN);
    criteria.createAlias("application", "application", Criteria.LEFT_JOIN);
    criteria.createAlias("application.organization", "application.organization", Criteria.LEFT_JOIN);
    criteria.createAlias("vulnerability", "vulnerability", Criteria.LEFT_JOIN);
    criteria.createAlias("defect", "defect", Criteria.LEFT_JOIN);

    if ((eventActions != null) && (!eventActions.isEmpty())) {
        criteria.add(Restrictions.in("eventAction", eventActions));
    }//from w w w . ja  v  a2s . c  o m

    if (user != null) {
        criteria.add(Restrictions.eq("user", user));
    }

    if (startTime != null) {
        criteria.add(Restrictions.ge("date", startTime));
    }
    if (stopTime != null) {
        criteria.add(Restrictions.lt("date", stopTime));
    }

    Criterion associationRestrictions = null;
    if ((appIds != null) && (!appIds.isEmpty())) {
        associationRestrictions = disjoinRestrictions(associationRestrictions,
                Restrictions.in("application.id", appIds));
    }
    if ((teamIds != null) && (!teamIds.isEmpty())) {
        associationRestrictions = disjoinRestrictions(associationRestrictions,
                Restrictions.in("application.organization.id", teamIds));
    }
    if ((vulnIds != null) && (!vulnIds.isEmpty())) {
        associationRestrictions = disjoinRestrictions(associationRestrictions,
                Restrictions.in("vulnerability.id", vulnIds));
        if ((defectIds != null) && (!defectIds.isEmpty())) {
            associationRestrictions = disjoinRestrictions(associationRestrictions, Restrictions
                    .and(Restrictions.in("defect.id", defectIds), Restrictions.isNull("vulnerability.id")));
        }
    } else if ((defectIds != null) && (!defectIds.isEmpty())) {
        associationRestrictions = disjoinRestrictions(associationRestrictions,
                Restrictions.in("defect.id", defectIds));
    }
    if (associationRestrictions != null) {
        criteria.add(associationRestrictions);
    }

    Order order = getOrder();
    if (order != null) {
        criteria.addOrder(order);
    }

    return criteria;
}

---

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

License:Mozilla Public License

private void addDateRangeRestrictions() {
    if (parameters.getStartDate() != null || parameters.getEndDate() != null) {

        if (parameters.getStartDate() != null) {
            Calendar targetDate = Calendar.getInstance();
            targetDate.setTime(parameters.getStartDate());

            LOG.debug("Adding start date " + targetDate);
            criteria.add(Restrictions.gt("openTime", targetDate));
        }/*from   w  ww . j a v  a2  s  .com*/

        if (parameters.getEndDate() != null) {
            Calendar targetDate = Calendar.getInstance();
            targetDate.setTime(parameters.getEndDate());

            LOG.debug("Adding end date " + targetDate);
            criteria.add(Restrictions.lt("openTime", targetDate));
        }
    }

    if (parameters.getStartCloseDate() != null || parameters.getEndCloseDate() != null) {

        if (parameters.getStartCloseDate() != null) {
            Calendar targetDate = Calendar.getInstance();
            targetDate.setTime(parameters.getStartCloseDate());

            LOG.debug("Adding start close date " + targetDate);
            criteria.add(Restrictions.or(Restrictions.eq("closeTime", null),
                    Restrictions.gt("closeTime", targetDate)));
        }

        if (parameters.getEndCloseDate() != null) {
            Calendar targetDate = Calendar.getInstance();
            targetDate.setTime(parameters.getEndCloseDate());

            LOG.debug("Adding end close date " + targetDate);
            criteria.add(Restrictions.or(Restrictions.eq("closeTime", null),
                    Restrictions.lt("closeTime", targetDate)));
        }
    }
}

---

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