当前位置: 首页>>代码示例>>Java>>正文

Java Criteria.addGreaterThan方法代码示例

本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addGreaterThan方法的典型用法代码示例。如果您正苦于以下问题：Java Criteria.addGreaterThan方法的具体用法？Java Criteria.addGreaterThan怎么用？Java Criteria.addGreaterThan使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria的用法示例。


在下文中一共展示了Criteria.addGreaterThan方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: addStringRangeCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Adds to the criteria object based on query characters given
 */
private void addStringRangeCriteria(String propertyName, String propertyValue, Criteria criteria) {

    try {
        if (StringUtils.contains(propertyValue, SearchOperator.BETWEEN.op())) {
            String[] rangeValues = StringUtils.split(propertyValue, SearchOperator.BETWEEN.op());
            if (rangeValues.length < 2)
                throw new IllegalArgumentException("Improper syntax of BETWEEN operator in " + propertyName);

            criteria.addBetween(propertyName, rangeValues[0], rangeValues[1]);
        } else if (propertyValue.startsWith(SearchOperator.GREATER_THAN_EQUAL.op())) {
            criteria.addGreaterOrEqualThan(propertyName, ObjectUtils.clean(propertyValue));
        } else if (propertyValue.startsWith(SearchOperator.LESS_THAN_EQUAL.op())) {
            criteria.addLessOrEqualThan(propertyName, ObjectUtils.clean(propertyValue));
        } else if (propertyValue.startsWith(SearchOperator.GREATER_THAN.op())) {
            criteria.addGreaterThan(propertyName, ObjectUtils.clean(propertyValue));
        } else if (propertyValue.startsWith(SearchOperator.LESS_THAN.op())) {
            criteria.addLessThan(propertyName, ObjectUtils.clean(propertyValue));
        } else {
            criteria.addEqualTo(propertyName, ObjectUtils.clean(propertyValue));
        }
    } catch (IllegalArgumentException ex) {
        GlobalVariables.getMessageMap().putError("lookupCriteria[" + propertyName + "]", RiceKeyConstants.ERROR_BETWEEN_SYNTAX, propertyName);
    }
}
开发者ID:kuali，项目名称:kc-rice，代码行数:28，代码来源:LookupDaoOjb.java

示例2: testSubQuery4

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * test Subquery get all product groups with more than 10 articles
 * <p/>
 * test may fail if db does not support sub queries
 */
public void testSubQuery4()
{

    ReportQueryByCriteria subQuery;
    Criteria subCrit = new Criteria();
    Criteria crit = new Criteria();

    subCrit.addEqualToField("productGroupId", Criteria.PARENT_QUERY_PREFIX + "groupId");
    subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
    subQuery.setAttributes(new String[]{"count(productGroupId)"});

    // mkalen: if using String("10") instead of Integer below,
    // PostgreSQL will return 7 (sic!) groups
    crit.addGreaterThan(subQuery, new Integer(10)); // MORE than 10 articles
    crit.addLessThan("groupId", PGROUP_ID_HI_WATERMARK);
    Query q = QueryFactory.newQuery(ProductGroup.class, crit);

    Collection results = broker.getCollectionByQuery(q);
    assertNotNull(results);
    assertEquals(4, results.size());
}
开发者ID:KualiCo，项目名称:ojb，代码行数:27，代码来源:QueryTest.java

示例3: getNewerVersionLocation

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<LocationBo> getNewerVersionLocation(String location, LocalDate asOfDate) {
    Criteria root = new Criteria();
    root.addEqualTo("location", location);
    root.addGreaterThan("effectiveDate", asOfDate.toDate());

    Criteria activeFilter = new Criteria(); //Inner join for Activity
    activeFilter.addEqualTo("active", true);
    root.addAndCriteria(activeFilter);

    Query query = QueryFactory.newQuery(LocationBo.class, root);
    List<LocationBo> locations = (List<LocationBo>)this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    if(locations == null) {
        locations = new ArrayList<LocationBo>();
    }

    return locations;

}
开发者ID:kuali-mirror，项目名称:kpme，代码行数:20，代码来源:LocationDaoOjbImpl.java

示例4: findCreditMemoAccountRevisions

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findCreditMemoAccountHistory(org.kuali.kfs.module.cab.businessobject.BatchParameters)
 */
@Override
public Collection<CreditMemoAccountRevision> findCreditMemoAccountRevisions(BatchParameters batchParameters) {
    Criteria criteria = new Criteria();
    criteria.addGreaterThan(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_REVISION_TIMESTAMP, batchParameters.getLastRunTime());

    if (!batchParameters.getExcludedChartCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.CreditMemoAccountRevision.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
    }

    if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
        criteria.addNotIn(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
    }

    if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
        criteria.addIn(CabPropertyConstants.CreditMemoAccountRevision.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
    }

    QueryByCriteria query = new QueryByCriteria(CreditMemoAccountRevision.class, criteria);
    query.addOrderByAscending(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_REVISION_TIMESTAMP);
    Collection<CreditMemoAccountRevision> historyRecs = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return historyRecs;
}
开发者ID:kuali，项目名称:kfs，代码行数:26，代码来源:ExtractDaoOjb.java

示例5: getLeaveBlocks

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<LeaveBlockBo> getLeaveBlocks(String principalId, String leaveBlockType, String requestStatus, LocalDate currentDate) {
    List<LeaveBlockBo> leaveBlocks = new ArrayList<LeaveBlockBo>();
    Criteria root = new Criteria();
    root.addEqualTo("principalId", principalId);
    root.addEqualTo("leaveBlockType", leaveBlockType);
    root.addEqualTo("requestStatus", requestStatus);
    if(currentDate != null) {
    	root.addGreaterThan("leaveDate", currentDate.toDate());
    }
    Query query = QueryFactory.newQuery(LeaveBlockBo.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    if(c!= null) {
    	leaveBlocks.addAll(c);
    }
	return leaveBlocks;
}
开发者ID:kuali-mirror，项目名称:kpme，代码行数:18，代码来源:LeaveBlockDaoOjbImpl.java

示例6: getABELeaveBlocksSinceTime

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
  public List<LeaveBlockBo> getABELeaveBlocksSinceTime(String principalId, DateTime lastRanDateTime) {
  	List<LeaveBlockBo> leaveBlocks = new ArrayList<LeaveBlockBo>();
  	Criteria root = new Criteria();
       
root.addEqualTo("principalId", principalId);
root.addGreaterThan("timestamp", lastRanDateTime.toDate());
Query query = QueryFactory.newQuery(LeaveBlockBo.class, root);
Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
List<LeaveBlockBo> tempList = new ArrayList<LeaveBlockBo>();
if (c != null) {
	tempList.addAll(c);
}
for(LeaveBlockBo lb : tempList) {
	if(lb != null && StringUtils.isNotEmpty(lb.getEarnCode())) {
		EarnCodeContract ec = HrServiceLocator.getEarnCodeService().getEarnCode(lb.getEarnCode(), lb.getLeaveLocalDate());
		if(ec != null && ec.getEligibleForAccrual().equals("N")) {
			leaveBlocks.add(lb);
		}
	}
}
  	return leaveBlocks;
  }
开发者ID:kuali-mirror，项目名称:kpme，代码行数:24，代码来源:LeaveBlockDaoOjbImpl.java

示例7: getLeaveBlockHistories

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<LeaveBlockHistory> getLeaveBlockHistories(String principalId,String requestStatus, String action, LocalDate currentDate) {
	Criteria recordCriteria = new Criteria();
	recordCriteria.addEqualTo("principalId", principalId);
	if (requestStatus != null) {
		recordCriteria.addEqualTo("requestStatus", requestStatus);
	}
	if(currentDate != null) {
		recordCriteria.addGreaterThan("leaveDate", currentDate.toDate());
	}
	if(action != null) {
		recordCriteria.addEqualTo("action", action);
	}
	Query query = QueryFactory.newQuery(LeaveBlockHistory.class,
			recordCriteria);
	return (List<LeaveBlockHistory>) this.getPersistenceBrokerTemplate()
			.getCollectionByQuery(query);
}
开发者ID:kuali-mirror，项目名称:kpme，代码行数:19，代码来源:LeaveBlockHistoryDaoOjbImpl.java

示例8: getNextCalendarEntryByCalendarId

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public CalendarEntryBo getNextCalendarEntryByCalendarId(String hrCalendarId, CalendarEntryContract calendarEntry) {
    Criteria root = new Criteria();
    Criteria beginDate = new Criteria();
    Criteria endDate = new Criteria();

    beginDate.addEqualToField("hrCalendarId", Criteria.PARENT_QUERY_PREFIX + "hrCalendarId");
    beginDate.addGreaterThan("beginPeriodDateTime", calendarEntry.getBeginPeriodFullDateTime().toDate());
    ReportQueryByCriteria beginDateSubQuery = QueryFactory.newReportQuery(CalendarEntryBo.class, beginDate);
    beginDateSubQuery.setAttributes(new String[]{"min(beginPeriodDateTime)"});

    endDate.addEqualToField("hrCalendarId", Criteria.PARENT_QUERY_PREFIX + "hrCalendarId");
    endDate.addGreaterThan("endPeriodDateTime", calendarEntry.getEndPeriodFullDateTime().toDate());
    ReportQueryByCriteria endDateSubQuery = QueryFactory.newReportQuery(CalendarEntryBo.class, endDate);
    endDateSubQuery.setAttributes(new String[]{"min(endPeriodDateTime)"});

    root.addEqualTo("hrCalendarId", hrCalendarId);
    root.addEqualTo("beginPeriodDateTime", beginDateSubQuery);
    root.addEqualTo("endPeriodDateTime", endDateSubQuery);

    Query query = QueryFactory.newQuery(CalendarEntryBo.class, root);

    CalendarEntryBo pce = (CalendarEntryBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query);
    return pce;
}
开发者ID:kuali-mirror，项目名称:kpme，代码行数:26，代码来源:CalendarEntryDaoOjbImpl.java

示例9: addSingleValuePredicate

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/** adds a single valued predicate to a Criteria. */
private void addSingleValuePredicate(SingleValuedPredicate p, Criteria parent) {
    final Object value = getVal(p.getValue());
    final String pp = p.getPropertyPath();
    if (p instanceof EqualPredicate) {
        parent.addEqualTo(pp, value);
    } else if (p instanceof EqualIgnoreCasePredicate) {
        parent.addEqualTo(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof GreaterThanOrEqualPredicate) {
        parent.addGreaterOrEqualThan(pp, value);
    } else if (p instanceof GreaterThanPredicate) {
        parent.addGreaterThan(pp, value);
    } else if (p instanceof LessThanOrEqualPredicate) {
        parent.addLessOrEqualThan(pp, value);
    } else if (p instanceof LessThanPredicate) {
        parent.addLessThan(pp, value);
    } else if (p instanceof LikePredicate) {
        //no need to convert * or ? since ojb handles the conversion/escaping
        parent.addLike(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof NotEqualPredicate) {
        parent.addNotEqualTo(pp, value);
    } else if (p instanceof NotEqualIgnoreCasePredicate) {
        parent.addNotEqualTo(genUpperFunc(pp), ((String) value).toUpperCase());
    } else if (p instanceof NotLikePredicate) {
        parent.addNotLike(pp, value);
    } else {
        throw new UnsupportedPredicateException(p);
    }
}
开发者ID:kuali，项目名称:kc-rice，代码行数:30，代码来源:CriteriaLookupDaoOjb.java

示例10: addDateRangeCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Adds to the criteria object based on query characters given
*/
  private void addDateRangeCriteria(String propertyName, String propertyValue, boolean treatWildcardsAndOperatorsAsLiteral, Criteria criteria) {

      try {
          if (StringUtils.contains(propertyValue, SearchOperator.BETWEEN.op())) {
              if (treatWildcardsAndOperatorsAsLiteral)
                  throw new RuntimeException("Wildcards and operators are not allowed on this date field: " + propertyName);
              String[] rangeValues = StringUtils.split(propertyValue, SearchOperator.BETWEEN.op());
              if (rangeValues.length < 2)
                  throw new IllegalArgumentException("Improper syntax of BETWEEN operator in " + propertyName);

              criteria.addBetween(propertyName, parseDate( ObjectUtils.clean(rangeValues[0] ) ), parseDate( ObjectUtils.clean(rangeValues[1] ) ) );
          } else if (propertyValue.startsWith(SearchOperator.GREATER_THAN_EQUAL.op())) {
              if (treatWildcardsAndOperatorsAsLiteral)
                  throw new RuntimeException("Wildcards and operators are not allowed on this date field: " + propertyName);
              criteria.addGreaterOrEqualThan(propertyName, parseDate( ObjectUtils.clean(propertyValue) ) );
          } else if (propertyValue.startsWith(SearchOperator.LESS_THAN_EQUAL.op())) {
              if (treatWildcardsAndOperatorsAsLiteral)
                  throw new RuntimeException("Wildcards and operators are not allowed on this date field: " + propertyName);
              criteria.addLessOrEqualThan(propertyName, parseDate( ObjectUtils.clean(propertyValue) ) );
          } else if (propertyValue.startsWith(SearchOperator.GREATER_THAN.op())) {
              if (treatWildcardsAndOperatorsAsLiteral)
                  throw new RuntimeException("Wildcards and operators are not allowed on this date field: " + propertyName);
              criteria.addGreaterThan(propertyName, parseDate( ObjectUtils.clean(propertyValue) ) );
          } else if (propertyValue.startsWith(SearchOperator.LESS_THAN.op())) {
              if (treatWildcardsAndOperatorsAsLiteral)
                  throw new RuntimeException("Wildcards and operators are not allowed on this date field: " + propertyName);
              criteria.addLessThan(propertyName, parseDate( ObjectUtils.clean(propertyValue) ) );
          } else {
              criteria.addEqualTo(propertyName, parseDate( ObjectUtils.clean(propertyValue) ) );
          }
      } catch (IllegalArgumentException ex) {
          GlobalVariables.getMessageMap().putError("lookupCriteria[" + propertyName + "]", RiceKeyConstants.ERROR_BETWEEN_SYNTAX, propertyName);
      }
  }
开发者ID:kuali，项目名称:kc-rice，代码行数:38，代码来源:LookupDaoOjb.java

示例11: addNumericRangeCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Adds to the criteria object based on query characters given
 */
private void addNumericRangeCriteria(String propertyName, String propertyValue, boolean treatWildcardsAndOperatorsAsLiteral, Criteria criteria) {

    try {
        if (StringUtils.contains(propertyValue, SearchOperator.BETWEEN.op())) {
            if (treatWildcardsAndOperatorsAsLiteral)
                throw new RuntimeException("Cannot use wildcards and operators on numeric field " + propertyName);
            String[] rangeValues = StringUtils.split(propertyValue, SearchOperator.BETWEEN.op());
            if (rangeValues.length < 2)
                throw new IllegalArgumentException("Improper syntax of BETWEEN operator in " + propertyName);

            criteria.addBetween(propertyName, cleanNumeric( rangeValues[0] ), cleanNumeric( rangeValues[1] ));
        } else if (propertyValue.startsWith(SearchOperator.GREATER_THAN_EQUAL.op())) {
            if (treatWildcardsAndOperatorsAsLiteral)
                throw new RuntimeException("Cannot use wildcards and operators on numeric field " + propertyName);
            criteria.addGreaterOrEqualThan(propertyName, cleanNumeric(propertyValue));
        } else if (propertyValue.startsWith(SearchOperator.LESS_THAN_EQUAL.op())) {
            if (treatWildcardsAndOperatorsAsLiteral)
                throw new RuntimeException("Cannot use wildcards and operators on numeric field " + propertyName);
            criteria.addLessOrEqualThan(propertyName, cleanNumeric(propertyValue));
        } else if (propertyValue.startsWith(SearchOperator.GREATER_THAN.op())) {
            if (treatWildcardsAndOperatorsAsLiteral)
                throw new RuntimeException("Cannot use wildcards and operators on numeric field " + propertyName);
            criteria.addGreaterThan(propertyName, cleanNumeric( propertyValue ) );
        } else if (propertyValue.startsWith(SearchOperator.LESS_THAN.op())) {
            if (treatWildcardsAndOperatorsAsLiteral)
                throw new RuntimeException("Cannot use wildcards and operators on numeric field " + propertyName);
            criteria.addLessThan(propertyName, cleanNumeric(propertyValue));
        } else {
            criteria.addEqualTo(propertyName, cleanNumeric(propertyValue));
        }
    } catch (IllegalArgumentException ex) {
        GlobalVariables.getMessageMap().putError("lookupCriteria[" + propertyName + "]", RiceKeyConstants.ERROR_BETWEEN_SYNTAX, propertyName);
    }
}
开发者ID:kuali，项目名称:kc-rice，代码行数:38，代码来源:LookupDaoOjb.java

示例12: getAccountNotExpiredCriteria

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * Builds a criteria to find non-expired accounts
 * 
 * @return a Criteria for non-expired accounts
 */
protected Criteria getAccountNotExpiredCriteria(Date currentSqlDate) {
    Criteria criteria = new Criteria();
    criteria.addIsNull("accountExpirationDate");

    Criteria notYetExpiredCriteria = new Criteria();
    notYetExpiredCriteria.addGreaterThan("accountExpirationDate", currentSqlDate);

    criteria.addOrCriteria(notYetExpiredCriteria);
    return criteria;
}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:16，代码来源:AccountDaoOjb.java

示例13: findAboveLimit

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.module.purap.document.dataaccess.NegativeInvoiceApprovalLimitDao#findAboveLimit(org.kuali.rice.core.api.util.type.KualiDecimal)
 */
public Collection<NegativeInvoiceApprovalLimit> findAboveLimit(KualiDecimal limit) {
    LOG.debug("Entering findAboveLimit(KualiDecimal)");
    Criteria criteria = new Criteria();
    criteria.addGreaterThan("negativeInvoiceApprovalLimitAmount", limit);
    criteria.addAndCriteria(buildActiveCriteria());
    Query query = new QueryByCriteria(NegativeInvoiceApprovalLimit.class, criteria);
    LOG.debug("Leaving findAboveLimit(KualiDecimal)");

    return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:14，代码来源:NegativeInvoiceApprovalLimitDaoOjb.java

示例14: findAboveLimit

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.module.purap.document.dataaccess.NegativePaymentRequestApprovalLimitDao#findAboveLimit(org.kuali.rice.core.api.util.type.KualiDecimal)
 */
public Collection<NegativePaymentRequestApprovalLimit> findAboveLimit(KualiDecimal limit) {
    LOG.debug("Entering findAboveLimit(KualiDecimal)");
    Criteria criteria = new Criteria();
    criteria.addGreaterThan("negativePaymentRequestApprovalLimitAmount", limit);
    criteria.addAndCriteria(buildActiveCriteria());
    Query query = new QueryByCriteria(NegativePaymentRequestApprovalLimit.class, criteria);
    LOG.debug("Leaving findAboveLimit(KualiDecimal)");

    return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}
开发者ID:VU-libtech，项目名称:OLE-INST，代码行数:14，代码来源:NegativePaymentRequestApprovalLimitDaoOjb.java

示例15: getCalendarEntryByCalendarIdAndDateRange

import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
    public CalendarEntryBo getCalendarEntryByCalendarIdAndDateRange(
            String hrCalendarId, DateTime beginDate, DateTime endDate) {
        Criteria root = new Criteria();
        root.addEqualTo("hrCalendarId", hrCalendarId);
        //root.addEqualTo("beginPeriodDateTime", beginDateSubQuery);
        root.addLessOrEqualThan("beginPeriodDateTime", endDate.toDate());
        root.addGreaterThan("endPeriodDateTime", beginDate.toDate());
//		root.addEqualTo("endPeriodDateTime", endDateSubQuery);

        Query query = QueryFactory.newQuery(CalendarEntryBo.class, root);

        CalendarEntryBo pce = (CalendarEntryBo) this.getPersistenceBrokerTemplate().getObjectByQuery(query);
        return pce;
    }
开发者ID:kuali-mirror，项目名称:kpme，代码行数:16，代码来源:CalendarEntryDaoOjbImpl.java


注：本文中的org.apache.ojb.broker.query.Criteria.addGreaterThan方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。