本文整理汇总了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);
}
}
示例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());
}
示例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;
}
示例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;
}
示例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;
}
示例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;
}
示例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);
}
示例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;
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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;
}
示例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);
}
示例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);
}
示例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;
}