本文整理汇总了Java中org.apache.ojb.broker.query.QueryByCriteria.addOrderByDescending方法的典型用法代码示例。如果您正苦于以下问题:Java QueryByCriteria.addOrderByDescending方法的具体用法?Java QueryByCriteria.addOrderByDescending怎么用?Java QueryByCriteria.addOrderByDescending使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.QueryByCriteria
的用法示例。
在下文中一共展示了QueryByCriteria.addOrderByDescending方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: retrieveMostEffectiveMileageRates
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;
}
示例2: selectNextAvailableCheckLineNumber
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;
}
}
示例3: retrieveMostEffectiveMileageRates
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;
}
示例4: selectNextAvailableCheckLineNumber
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;
}
}
示例5: getVoteRecordMostCurrentRound
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;
}
示例6: findAllOrderBy
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);
}
示例7: findAllActiveOrderBy
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);
}
示例8: findMatchingOrderBy
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);
}
示例9: getDeliverRequestHistoryRecords
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;
}
示例10: testSorting
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());
}
示例11: getFinancialSystemDocumentHeadersForBatch
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;
}
示例12: getPreviousDocumentHeader
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);
}
示例13: getPreviousDocumentHeader
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);
}
示例14: sortCriterion
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);
}
}
示例15: testPrefetched
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());
}