本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addBetween方法的典型用法代码示例。如果您正苦于以下问题:Java Criteria.addBetween方法的具体用法?Java Criteria.addBetween怎么用?Java Criteria.addBetween使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria
的用法示例。
在下文中一共展示了Criteria.addBetween方法的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: getDeliverNotices
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public Collection<Object> getDeliverNotices(String noticeType) {
Criteria criteria = new Criteria();
Date fromDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), -1);
Date toDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), 1);
if (noticeType.equals(OLEConstants.NOTICE_OVERDUE)) {
List<String> noticeTypes = new ArrayList<>();
noticeTypes.add(noticeType);
noticeTypes.add(OLEConstants.NOTICE_LOST);
criteria.addIn("noticeType", noticeTypes);
criteria.addLessOrEqualThan("noticeToBeSendDate", new Timestamp(new Date().getTime()));
} else {
criteria.addEqualTo("noticeType", noticeType);
criteria.addBetween("noticeToBeSendDate", fromDate, toDate);
}
QueryByCriteria query = QueryFactory.newQuery(OLEDeliverNotice.class, criteria);
query.addOrderBy("patronId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return results;
}
示例3: testBetweenCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* test Between Criteria
*/
public void testBetweenCriteria()
{
Criteria crit = new Criteria();
crit.addBetween("id", new Integer(1), new Integer(5));
Query q = QueryFactory.newQuery(Person.class, crit);
Collection results = broker.getCollectionByQuery(q);
assertNotNull(results);
assertTrue(results.size() == 5);
// compare with count
int count = broker.getCount(q);
assertEquals(results.size(), count);
}
示例4: readArticlesByCursor
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* read in all the PerformanceArticles from the RDBMS that have
* been inserted by <code>insertNewArticles()</code>.
* The lookup is done with a cursor fetch,
* that is: a between Statement is used to select all inserted PerformanceArticles
* and Objects are read in by fetching from the cursor (JDBC ResultSet).
*/
protected void readArticlesByCursor() throws Exception
{
// clear the cache
_conn.invalidateAll();
Transaction tx = _kit.getTransaction(_conn);
Criteria c = new Criteria();
c.addBetween("articleId", new Integer(offsetId), new Integer(offsetId + articleCount));
Query q = new QueryByCriteria(PerformanceArticle.class, c);
long start = System.currentTimeMillis();
tx.begin();
Iterator iter = _conn.getIteratorByQuery(q, LockType.NO_LOCK);
int fetchCount = 0;
while(iter.hasNext())
{
fetchCount++;
iter.next();
}
tx.commit();
long stop = System.currentTimeMillis();
logger.info("fetching " + fetchCount + " Objects: " + (stop - start) + " msec");
}
示例5: readArticlesByCursor
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* read in all the PerformanceArticles from the RDBMS that have
* been inserted by <code>insertNewArticles()</code>.
* The lookup is done with a cursor fetch,
* that is: a between Statement is used to select all inserted PerformanceArticles
* and Objects are read in by fetching from the cursor (JDBC ResultSet).
*/
protected void readArticlesByCursor() throws PersistenceBrokerException
{
broker.clearCache();
Criteria c = new Criteria();
c.addBetween("articleId", new Integer(offsetId), new Integer(offsetId + articleCount));
Query q = new QueryByCriteria(PerformanceArticle.class, c);
long start = System.currentTimeMillis();
Iterator iter = broker.getIteratorByQuery(q);
int fetchCount = 0;
while(iter.hasNext())
{
fetchCount++;
iter.next();
}
long stop = System.currentTimeMillis();
logger.info("fetching " + fetchCount + " Objects: " + (stop - start) + " msec");
}
示例6: getIntersectingTimeBlocks
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<TimeBlockBo> getIntersectingTimeBlocks(String principalId, Interval interval) {
Criteria rootCriteria = new Criteria();
rootCriteria.addEqualTo("principalId", principalId);
Criteria orCriteria = new Criteria();
Criteria beginCriteria = new Criteria();
Criteria endCriteria = new Criteria();
Timestamp intervalStart = new Timestamp(interval.getStartMillis());
Timestamp intervalEnd = new Timestamp(interval.getEndMillis());
beginCriteria.addBetween("beginTimestamp", intervalStart, intervalEnd);
endCriteria.addBetween("endTimestamp", intervalStart, intervalEnd);
orCriteria.addOrCriteria(beginCriteria);
orCriteria.addOrCriteria(endCriteria);
rootCriteria.addAndCriteria(orCriteria);
Query query = QueryFactory.newQuery(TimeBlockBo.class, rootCriteria);
List<TimeBlockBo> timeBlocks = (List<TimeBlockBo>) this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
return timeBlocks == null || timeBlocks.isEmpty() ? new ArrayList<TimeBlockBo>() : timeBlocks;
}
示例7: addNumericCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public static void addNumericCriteria(Criteria criteria, String propertyName, String propertyValue) {
if (StringUtils.contains(propertyValue, SearchOperator.BETWEEN.op())) {
String[] rangeValues = StringUtils.split(propertyValue, SearchOperator.BETWEEN.op());
criteria.addBetween(propertyName, TKUtils.cleanNumeric(rangeValues[0]), TKUtils.cleanNumeric( rangeValues[1] ));
} else if (propertyValue.startsWith(SearchOperator.GREATER_THAN_EQUAL.op())) {
criteria.addGreaterOrEqualThan(propertyName, TKUtils.cleanNumeric(propertyValue));
} else if (propertyValue.startsWith(SearchOperator.LESS_THAN_EQUAL.op())) {
criteria.addLessOrEqualThan(propertyName, TKUtils.cleanNumeric(propertyValue));
} else if (propertyValue.startsWith(SearchOperator.GREATER_THAN.op())) {
criteria.addGreaterThan(propertyName, TKUtils.cleanNumeric( propertyValue ) );
} else if (propertyValue.startsWith(SearchOperator.LESS_THAN.op())) {
criteria.addLessThan(propertyName, TKUtils.cleanNumeric(propertyValue));
} else {
criteria.addEqualTo(propertyName, TKUtils.cleanNumeric(propertyValue));
}
}
示例8: 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);
}
}
示例9: 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);
}
}
示例10: getCourtesyLoanDocument
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public Collection<Object> getCourtesyLoanDocument(Integer interval) {
Criteria criteria = new Criteria();
criteria.addEqualTo("courtesyNoticeFlag", "N");
Date formDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), interval - 1);
Date toDate = DateUtil.addDays(new Timestamp(System.currentTimeMillis()), interval + 1);
criteria.addBetween("loanDueDate", new Timestamp(formDate.getTime()), new Timestamp(toDate.getTime()));
QueryByCriteria query = QueryFactory.newQuery(OleLoanDocument.class, criteria);
query.addOrderBy("patronId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return results;
}
示例11: clearBothYearsBudgetConstructionAppointmentFundingReason
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected void clearBothYearsBudgetConstructionAppointmentFundingReason(Integer BaseYear) {
Integer RequestYear = BaseYear + 1;
Criteria criteriaId = new Criteria();
criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear);
QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionAppointmentFundingReason.class, criteriaId);
getPersistenceBrokerTemplate().deleteByQuery(queryId);
getPersistenceBrokerTemplate().clearCache();
}
示例12: clearBothYearsBCSF
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected void clearBothYearsBCSF(Integer BaseYear) {
Integer RequestYear = BaseYear + 1;
Criteria criteriaId = new Criteria();
criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear);
QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionCalculatedSalaryFoundationTracker.class, criteriaId);
getPersistenceBrokerTemplate().deleteByQuery(queryId);
getPersistenceBrokerTemplate().clearCache();
}
示例13: clearBothYearsBCPosition
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected void clearBothYearsBCPosition(Integer BaseYear) {
Integer RequestYear = BaseYear + 1;
Criteria criteriaId = new Criteria();
criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear);
QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionPosition.class, criteriaId);
getPersistenceBrokerTemplate().deleteByQuery(queryId);
getPersistenceBrokerTemplate().clearCache();
}
示例14: clearBothYearsHeaders
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected void clearBothYearsHeaders(Integer BaseYear) {
Integer RequestYear = BaseYear + 1;
Criteria criteriaId = new Criteria();
criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear);
QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionHeader.class, criteriaId);
getPersistenceBrokerTemplate().deleteByQuery(queryId);
getPersistenceBrokerTemplate().clearCache();
}
示例15: clearBothYearsPendingApptFunding
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
protected void clearBothYearsPendingApptFunding(Integer BaseYear) {
Integer RequestYear = BaseYear + 1;
Criteria criteriaId = new Criteria();
criteriaId.addBetween(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear, RequestYear);
QueryByCriteria queryId = new QueryByCriteria(PendingBudgetConstructionAppointmentFunding.class, criteriaId);
getPersistenceBrokerTemplate().deleteByQuery(queryId);
getPersistenceBrokerTemplate().clearCache();
}