Java Criteria.addBetween方法代码示例

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);
    }
}
 

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;
}
 

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);
}
 

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");
}
 

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");

}
 

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;
}
 

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));
    }
}
 

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);
      }
  }
 

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);
    }
}
 

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;
}
 

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();
}
 

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();
}
 

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();
}
 

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();
}
 

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();
}