Java QueryByCriteria.addOrderByDescending方法代码示例

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.fp.document.dataaccess.TravelMileageRateDao#retrieveMostEffectiveMileageRates(java.sql.Timestamp)
 */
public Collection retrieveMostEffectiveMileageRates(Date effectiveDate) {
    Criteria criteria = new Criteria();
    criteria.addLessOrEqualThan("disbursementVoucherMileageEffectiveDate", effectiveDate);

    QueryByCriteria queryByCriteria = new QueryByCriteria(TravelMileageRate.class, criteria);
    queryByCriteria.addOrderByDescending("disbursementVoucherMileageEffectiveDate");
    queryByCriteria.addOrderByDescending("mileageLimitAmount");

    Collection mostEffectiveRates = new ArrayList();
    Collection rates = getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
    Date mostEffectiveDate = ((TravelMileageRate) rates.iterator().next()).getDisbursementVoucherMileageEffectiveDate();
    for (Iterator iter = rates.iterator(); iter.hasNext();) {
        TravelMileageRate rate = (TravelMileageRate) iter.next();
        if (rate.getDisbursementVoucherMileageEffectiveDate().compareTo(mostEffectiveDate) == 0) {
            mostEffectiveRates.add(rate);
        }
    }

    return mostEffectiveRates;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.ole.fp.document.dataaccess.CashManagementDao#selectNextAvailableCheckLineNumber(java.lang.String)
 */
public Integer selectNextAvailableCheckLineNumber(String documentNumber) {
    if (documentNumber != null) {
        // select all cashiering checks associated with document
        Criteria criteria = new Criteria();
        criteria.addEqualTo("documentNumber", documentNumber);
        criteria.addEqualTo("cashieringStatus", OLEConstants.CheckSources.CASH_MANAGEMENT);
        criteria.addEqualTo("financialDocumentTypeCode", CashieringTransaction.DETAIL_DOCUMENT_TYPE);

        QueryByCriteria cmChecksQuery = QueryFactory.newQuery(CheckBase.class, criteria);
        cmChecksQuery.addOrderByDescending("sequenceId");
        Iterator allChecksIter = getPersistenceBrokerTemplate().getIteratorByQuery(cmChecksQuery);
        if (allChecksIter.hasNext()) {
            return new Integer((((Check) TransactionalServiceUtils.retrieveFirstAndExhaustIterator(allChecksIter)).getSequenceId()).intValue() + 1);
        }
        else {
            return new Integer(1);
        }
    }
    else {
        return null;
    }
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.fp.document.dataaccess.TravelMileageRateDao#retrieveMostEffectiveMileageRates(java.sql.Timestamp)
 */
@Override
public Collection<TravelMileageRate> retrieveMostEffectiveMileageRates(Date effectiveDate) {
    Criteria criteria = new Criteria();
    criteria.addLessOrEqualThan("disbursementVoucherMileageEffectiveDate", effectiveDate);

    QueryByCriteria queryByCriteria = new QueryByCriteria(TravelMileageRate.class, criteria);
    queryByCriteria.addOrderByDescending("disbursementVoucherMileageEffectiveDate");
    queryByCriteria.addOrderByDescending("mileageLimitAmount");

    Collection mostEffectiveRates = new ArrayList();
    Collection rates = getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
    Date mostEffectiveDate = ((TravelMileageRate) rates.iterator().next()).getDisbursementVoucherMileageEffectiveDate();
    for (Iterator iter = rates.iterator(); iter.hasNext();) {
        TravelMileageRate rate = (TravelMileageRate) iter.next();
        if (rate.getDisbursementVoucherMileageEffectiveDate().compareTo(mostEffectiveDate) == 0) {
            mostEffectiveRates.add(rate);
        }
    }

    return mostEffectiveRates;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.kfs.fp.document.dataaccess.CashManagementDao#selectNextAvailableCheckLineNumber(java.lang.String)
 */
public Integer selectNextAvailableCheckLineNumber(String documentNumber) {
    if (documentNumber != null) {
        // select all cashiering checks associated with document
        Criteria criteria = new Criteria();
        criteria.addEqualTo("documentNumber", documentNumber);
        criteria.addEqualTo("cashieringStatus", KFSConstants.CheckSources.CASH_MANAGEMENT);
        criteria.addEqualTo("financialDocumentTypeCode", CashieringTransaction.DETAIL_DOCUMENT_TYPE);

        QueryByCriteria cmChecksQuery = QueryFactory.newQuery(CheckBase.class, criteria);
        cmChecksQuery.addOrderByDescending("sequenceId");
        Iterator allChecksIter = getPersistenceBrokerTemplate().getIteratorByQuery(cmChecksQuery);
        if (allChecksIter.hasNext()) {
            return new Integer((((Check) TransactionalServiceUtils.retrieveFirstAndExhaustIterator(allChecksIter)).getSequenceId()).intValue() + 1);
        }
        else {
            return new Integer(1);
        }
    }
    else {
        return null;
    }
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public EdoVoteRecordBo getVoteRecordMostCurrentRound(String edoDossierID, String edoReviewLayerDefinitionId) {
    EdoVoteRecordBo voteRecord = new EdoVoteRecordBo();

    if (ObjectUtils.isNotNull(edoDossierID) && edoReviewLayerDefinitionId != null) {
        Criteria criteria = new Criteria();
        criteria.addEqualTo("edoDossierId", edoDossierID);
        criteria.addEqualTo("edoReviewLayerDefinitionId", edoReviewLayerDefinitionId);

        QueryByCriteria query = QueryFactory.newQuery(EdoVoteRecordBo.class, criteria);
        query.addOrderByDescending("vote_round");
        query.addOrderByDescending("vote_subround");

        Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

        if (CollectionUtils.isNotEmpty(c)) {
            voteRecord = (EdoVoteRecordBo)c.toArray()[0];
        }
    }

    return voteRecord;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.rice.krad.dao.BusinessObjectDao#findAllOrderBy(java.lang.Class, java.lang.String, boolean)
 */
public <T extends BusinessObject> Collection<T> findAllOrderBy(Class<T> clazz, String sortField, boolean sortAscending) {
    QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, (Criteria) null);

    if (sortAscending) {
        queryByCriteria.addOrderByAscending(sortField);
    }
    else {
        queryByCriteria.addOrderByDescending(sortField);
    }

    return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * @see org.kuali.rice.krad.dao.BusinessObjectDao#findAllActiveOrderBy(java.lang.Class, java.lang.String, boolean)
 */
public <T extends BusinessObject> Collection<T> findAllActiveOrderBy(Class<T> clazz, String sortField, boolean sortAscending) {
    QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, buildActiveCriteria());

    if (sortAscending) {
        queryByCriteria.addOrderByAscending(sortField);
    }
    else {
        queryByCriteria.addOrderByDescending(sortField);
    }

    return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * This is the default impl that comes with Kuali - uses OJB.
 *
 * @see org.kuali.rice.krad.dao.BusinessObjectDao#findMatching(java.lang.Class, java.util.Map)
 */
public <T extends BusinessObject> Collection<T> findMatchingOrderBy(Class<T> clazz, Map<String, ?> fieldValues, String sortField, boolean sortAscending) {
    Criteria criteria = buildCriteria(fieldValues);
    QueryByCriteria queryByCriteria = new QueryByCriteria(clazz, criteria);

    if (sortAscending) {
        queryByCriteria.addOrderByAscending(sortField);
    }
    else {
        queryByCriteria.addOrderByDescending(sortField);
    }

    return (Collection<T>)getPersistenceBrokerTemplate().getCollectionByQuery(queryByCriteria);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<OleDeliverRequestHistoryRecord> getDeliverRequestHistoryRecords(String itemBarcode) {
    Criteria criteria = new Criteria();
    criteria.addEqualTo(OLEConstants.OleDeliverRequest.ITEM_ID, itemBarcode);
    QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestHistoryRecord.class, criteria);
    query.addOrderByDescending(OLEConstants.ARCHIVE_DATE);
    Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return results;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public void testSorting() throws Exception
{
    String name = "testSorting_" + System.currentTimeMillis();
    Criteria criteria = new Criteria();
    criteria.addEqualTo("articleName", name);
    QueryByCriteria query = QueryFactory.newQuery(Article.class, criteria);
    query.addOrderByDescending("articleId");
    Collection col = broker.getCollectionByQuery(query);
    assertEquals("size of collection should be zero", 0, col.size());

    //2. insert 3 matching items
    broker.beginTransaction();
    Article a1 = createArticle(null, name);
    broker.store(a1);
    Article a2 = createArticle(null, name);
    broker.store(a2);
    Article a3 = createArticle(null, name);
    broker.store(a3);
    broker.commitTransaction();
    // 3. check if all items are found
    col = broker.getCollectionByQuery(query);
    assertEquals("size of collection should be three", 3, col.size());
    Iterator iter = col.iterator();

    assertEquals("should be same value", a3.getArticleId(), ((InterfaceArticle) iter.next()).getArticleId());
    assertEquals("should be same value", a2.getArticleId(), ((InterfaceArticle) iter.next()).getArticleId());
    assertEquals("should be same value", a1.getArticleId(), ((InterfaceArticle) iter.next()).getArticleId());
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Reads in a set of FinancialSystemDocumentHeader records, limited by the indices, ordered by document number
 * @see org.kuali.kfs.sys.batch.dataaccess.FinancialSystemDocumentHeaderPopulationDao#getFinancialSystemDocumentHeadersForBatch(int, int)
 */
@Override
public Collection<FinancialSystemDocumentHeader> getFinancialSystemDocumentHeadersForBatch(int batchStartIndex, int batchEndIndex) {
    Criteria c = buildFinancialSystemDocumentHeaderCriteria();
    QueryByCriteria query = QueryFactory.newQuery(FinancialSystemDocumentHeader.class, c);
    query.setStartAtIndex(batchStartIndex);
    query.setEndAtIndex(batchEndIndex);
    query.addOrderByDescending(KFSPropertyConstants.DOCUMENT_NUMBER); // roughly try to process newer documents first

    Collection<FinancialSystemDocumentHeader> documentHeaders = getPersistenceBrokerTemplate().getCollectionByQuery(query);
    return documentHeaders;
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Document header IDs are ordered, so an ID less than the current will
 * always be previous to current.
 */
public LeaveCalendarDocumentHeader getPreviousDocumentHeader(String principalId, DateTime beginDate) {
    Criteria crit = new Criteria();
    crit.addEqualTo("principalId", principalId);
    // the pay begin date is the end date of the previous pay period
    crit.addEqualTo("endDate", beginDate.toDate());
    QueryByCriteria query = new QueryByCriteria(LeaveCalendarDocumentHeader.class, crit);
    query.addOrderByDescending("documentId");
    query.setStartAtIndex(0);
    query.setEndAtIndex(1);

    return (LeaveCalendarDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
 * Document header IDs are ordered, so an ID less than the current will
 * always be previous to current.
 */
public TimesheetDocumentHeader getPreviousDocumentHeader(String principalId, DateTime payBeginDate) {
    Criteria crit = new Criteria();
    crit.addEqualTo("principalId", principalId);
    // the pay begin date is the end date of the previous pay period
    crit.addEqualTo("endDate", payBeginDate.toDate());
    QueryByCriteria query = new QueryByCriteria(TimesheetDocumentHeader.class, crit);
    query.addOrderByDescending("documentId");
    query.setStartAtIndex(0);
    query.setEndAtIndex(1);

    return (TimesheetDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query);
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public final void sortCriterion(
	QueryByCriteria query
) throws RecognitionException, TokenStreamException {
	
	Token  id = null;
	
	try {      // for error handling
		boolean descending = false;
		id = LT(1);
		match(Identifier);
		{
		if ((LA(1)==LITERAL_asc||LA(1)==LITERAL_desc)) {
			{
			if ((LA(1)==LITERAL_asc)) {
				match(LITERAL_asc);
				descending = false;
			}
			else if ((LA(1)==LITERAL_desc)) {
				match(LITERAL_desc);
				descending = true;
			}
			else {
				throw new NoViableAltException(LT(1), getFilename());
			}
			
			}
		}
		else if ((_tokenSet_10.member(LA(1)))) {
		}
		else {
			throw new NoViableAltException(LT(1), getFilename());
		}
		
		}
		
		if (descending) {
		query.addOrderByDescending(id.getText());
		} else {
		query.addOrderByAscending(id.getText());
		}
		
	}
	catch (RecognitionException ex) {
		reportError(ex);
		recover(ex,_tokenSet_10);
	}
}
 

import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public void testPrefetched()
{
    ClassDescriptor cldProductGroup = myPB.getClassDescriptor(ProductGroup.class);
    ClassDescriptor cldArticle = myPB.getClassDescriptor(Article.class);
    Class productGroupProxy = cldProductGroup.getProxyClass();
    Class articleProxy = cldArticle.getProxyClass();

    //
    // use ProductGroup and Articles with disabled Proxy
    //
    cldProductGroup.setProxyClass(null);
    cldProductGroup.setProxyClassName(null);
    cldArticle.setProxyClass(null);
    cldArticle.setProxyClassName(null);

    resetStmtCount();
    myPB.clearCache();


    myPB.beginTransaction();

    Criteria crit = new Criteria();
    crit.addLessOrEqualThan("groupId", new Integer(5));
    QueryByCriteria q = QueryFactory.newQuery(ProductGroup.class, crit);
    q.addOrderByDescending("groupId");
    q.addPrefetchedRelationship("allArticlesInGroup");

    Collection results = myPB.getCollectionByQuery(q);
    assertEquals("Number of ProductGroups", 5, results.size());
    Collection articles = new ArrayList();
    for (Iterator it = results.iterator();it.hasNext();)
    {
        ProductGroup p = (ProductGroup) it.next();
        articles.addAll(p.getAllArticles());
    }
    assertEquals("Total number of Articles", 59, articles.size());

    //SELECT A0.KategorieName,A0.Kategorie_Nr,A0.Beschreibung FROM Kategorien A0 WHERE A0.Kategorie_Nr <=  '5' 
    //SELECT ... FROM CDS A0 WHERE A0.Kategorie_Nr IN ( '1' , '4' , '2' , '5' , '3' ) 
    //SELECT ... FROM Artikel A0 WHERE A0.Kategorie_Nr IN ( '1' , '4' , '2' , '5' , '3' ) 
    //SELECT ... FROM BOOKS A0 WHERE A0.Kategorie_Nr IN ( '1' , '4' , '2' , '5' , '3' ) 
    assertStmtCount("Read Prefetched.", 4);
    myPB.commitTransaction();

    //
    // Reset original Proxy settings
    //
    cldProductGroup.setProxyClass(productGroupProxy);
    cldProductGroup.setProxyClassName(productGroupProxy.getName());
    cldArticle.setProxyClass(articleProxy);
    cldArticle.setProxyClassName(articleProxy.getName());

}