本文整理汇总了Java中org.apache.ojb.broker.query.QueryByCriteria.addOrderBy方法的典型用法代码示例。如果您正苦于以下问题:Java QueryByCriteria.addOrderBy方法的具体用法?Java QueryByCriteria.addOrderBy怎么用?Java QueryByCriteria.addOrderBy使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.QueryByCriteria
的用法示例。
在下文中一共展示了QueryByCriteria.addOrderBy方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getDisbursementNumberRanges
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.ole.pdp.dataaccess.PaymentDetailDao#getDisbursementNumberRanges(java.lang.String)
*/
public List<DisbursementNumberRange> getDisbursementNumberRanges(String campus) {
LOG.debug("getDisbursementNumberRanges() started");
java.util.Date now = new java.util.Date();
Timestamp nowTs = new Timestamp(now.getTime());
Criteria criteria = new Criteria();
criteria.addLessOrEqualThan(PdpPropertyConstants.DISBURSEMENT_NUMBER_RANGE_START_DATE, nowTs);
criteria.addEqualTo(PdpPropertyConstants.PHYS_CAMPUS_PROC_CODE, campus);
criteria.addEqualTo(OLEPropertyConstants.ACTIVE, true);
QueryByCriteria qbc = new QueryByCriteria(DisbursementNumberRange.class, criteria);
qbc.addOrderBy(OLEPropertyConstants.BANK_CODE, true);
return (List<DisbursementNumberRange>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
示例2: getDeliverNotices
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的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: getLoanDocumentsForNoticeGeneration
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public List<OleLoanDocument> getLoanDocumentsForNoticeGeneration(String noticeType, Collection<Object> deliverNotices) {
List<OleLoanDocument> oleDeliverLoanDocuments = new ArrayList<>();
List<String> loanIds = getLoanIds(deliverNotices);
if (loanIds.size() > 0) {
Criteria criteria = new Criteria();
criteria.addColumnIn("LOAN_TRAN_ID", loanIds);
if (noticeType.equals(OLEConstants.NOTICE_OVERDUE) || noticeType.equals(OLEConstants.NOTICE_LOST)) {
criteria.addLessOrEqualThan("loanDueDate", new Timestamp(System.currentTimeMillis()));
} else if (noticeType.equals(OLEConstants.NOTICE_COURTESY)) {
criteria.addGreaterOrEqualThan("loanDueDate", new Timestamp(System.currentTimeMillis()));
}
QueryByCriteria query = QueryFactory.newQuery(OleLoanDocument.class, criteria);
query.addOrderBy("patronId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
for (Object oleLoanDocument : results) {
oleDeliverLoanDocuments.add((OleLoanDocument) oleLoanDocument);
}
}
return oleDeliverLoanDocuments;
}
示例4: buildPrefetchQuery
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Build the query to perform a batched read get orderBy settings from CollectionDescriptor
*
* @param ids Collection containing all identities of objects of the ONE side
*/
protected Query buildPrefetchQuery(Collection ids)
{
CollectionDescriptor cds = getCollectionDescriptor();
QueryByCriteria query = buildPrefetchQuery(ids, cds.getForeignKeyFieldDescriptors(getItemClassDescriptor()));
// check if collection must be ordered
if (!cds.getOrderBy().isEmpty())
{
Iterator iter = cds.getOrderBy().iterator();
while (iter.hasNext())
{
query.addOrderBy((FieldHelper) iter.next());
}
}
return query;
}
示例5: getDisbursementNumberRanges
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.pdp.dataaccess.PaymentDetailDao#getDisbursementNumberRanges(java.lang.String)
*/
@Override
public List<DisbursementNumberRange> getDisbursementNumberRanges(String campus) {
LOG.debug("getDisbursementNumberRanges() started");
java.util.Date now = new java.util.Date();
Timestamp nowTs = new Timestamp(now.getTime());
Criteria criteria = new Criteria();
criteria.addLessOrEqualThan(PdpPropertyConstants.DISBURSEMENT_NUMBER_RANGE_START_DATE, nowTs);
criteria.addEqualTo(PdpPropertyConstants.PHYS_CAMPUS_PROC_CODE, campus);
criteria.addEqualTo(KFSPropertyConstants.ACTIVE, true);
QueryByCriteria qbc = new QueryByCriteria(DisbursementNumberRange.class, criteria);
qbc.addOrderBy(KFSPropertyConstants.BANK_CODE, true);
return (List<DisbursementNumberRange>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
示例6: getAll
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Get list of all ElectronicInvoiceItemMappings
*/
public List getAll() {
LOG.debug("getAll() started");
QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class);
qbc.addOrderBy("id", true);
List l = (List) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
return l;
}
示例7: customizeQuery
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* In addition to what the referenced method does, this also fixes a mysql order by issue (see class comments)
*
* @see org.apache.ojb.broker.accesslayer.QueryCustomizerDefaultImpl#customizeQuery(java.lang.Object,
* org.apache.ojb.broker.PersistenceBroker, org.apache.ojb.broker.metadata.CollectionDescriptor,
* org.apache.ojb.broker.query.QueryByCriteria)
*/
@Override
public Query customizeQuery(Object anObject, PersistenceBroker broker, CollectionDescriptor cod, QueryByCriteria query) {
boolean platformMySQL = broker.serviceSqlGenerator().getPlatform() instanceof PlatformMySQLImpl;
Map<String, String> attributes = getAttributes();
for (String attributeName : attributes.keySet()) {
if (!attributeName.startsWith(ORDER_BY_FIELD)) {
continue;
}
String fieldName = attributeName.substring(ORDER_BY_FIELD.length());
ClassDescriptor itemClassDescriptor = broker.getClassDescriptor(cod.getItemClass());
FieldDescriptor orderByFieldDescriptior = itemClassDescriptor.getFieldDescriptorByName(fieldName);
// the column to sort on derived from the property name
String orderByColumnName = orderByFieldDescriptior.getColumnName();
// ascending or descending
String fieldValue = attributes.get(attributeName);
boolean ascending = (StringUtils.equals(fieldValue, ASCENDING));
// throw an error if not ascending or descending
if (!ascending && StringUtils.equals(fieldValue, DESCENDING)) {
throw new RuntimeException("neither ASC nor DESC was specified in ojb file for " + fieldName);
}
if (platformMySQL) {
// by negating the column name in MySQL we can get nulls last (ascending or descending)
String mysqlPrefix = (ascending) ? MYSQL_NEGATION : "";
query.addOrderBy(mysqlPrefix + orderByColumnName, false);
} else {
query.addOrderBy(orderByColumnName, ascending);
}
}
return query;
}
示例8: testingGetAllEntries
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* This method should only be used in unit tests. It loads all the gl_sf_balances_t rows in memory into a collection. This won't
* sace for production.
*
* @return a Collection of all sufficient funds records in the database
*/
public Collection testingGetAllEntries() {
LOG.debug("testingGetAllEntries() started");
Criteria criteria = new Criteria();
QueryByCriteria qbc = QueryFactory.newQuery(SufficientFundBalances.class, criteria);
qbc.addOrderBy(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, true);
qbc.addOrderBy(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE, true);
qbc.addOrderBy(OLEPropertyConstants.ACCOUNT_NUMBER, true);
qbc.addOrderBy(OLEPropertyConstants.FINANCIAL_OBJECT_CODE, true);
return getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
}
示例9: getOverdueLoanDocument
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getOverdueLoanDocument() {
Criteria criteria = new Criteria();
criteria.addLessThan("loanDueDate", new Timestamp(System.currentTimeMillis()));
QueryByCriteria query = QueryFactory.newQuery(OleLoanDocument.class, criteria);
criteria.addColumnIsNull("REPMNT_FEE_PTRN_BILL_ID");
query.addOrderBy("patronId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return results;
}
示例10: getCourtesyLoanDocument
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的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: getHoldRequests
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getHoldRequests(List<String> requestTypeIds) {
Criteria criteria = new Criteria();
criteria.addIn("requestTypeId", requestTypeIds);
criteria.addEqualTo("borrowerQueuePosition", "1");
criteria.addColumnIsNull("ONHLD_NTC_SNT_DT");
String pickupLocation = getPickUpLocation();
if (pickupLocation != null && !pickupLocation.trim().isEmpty()) {
criteria.addEqualTo("PCKUP_LOC_ID", pickupLocation);
}
QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestBo.class, criteria);
query.addOrderBy("borrowerId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return results;
}
示例12: getHoldRequestsByPickupLocation
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getHoldRequestsByPickupLocation(List<String> requestTypeIds, String pickupLocationId) {
Criteria criteria = new Criteria();
criteria.addIn("requestTypeId", requestTypeIds);
criteria.addEqualTo("borrowerQueuePosition", "1");
criteria.addColumnIsNull("ONHLD_NTC_SNT_DT");
if (pickupLocationId != null && !pickupLocationId.trim().isEmpty()) {
criteria.addEqualTo("PCKUP_LOC_ID", pickupLocationId);
}
QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestBo.class, criteria);
query.addOrderBy("borrowerId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return results;
}
示例13: getExpiredRequests
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
public Collection<Object> getExpiredRequests() {
Criteria criteria = new Criteria();
criteria.addLessOrEqualThan("requestExpiryDate", new Timestamp(System.currentTimeMillis()));
QueryByCriteria query = QueryFactory.newQuery(OleDeliverRequestBo.class, criteria);
query.addOrderBy("borrowerId");
Collection results = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return results;
}
示例14: getFKQuery
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Answer the foreign key query to retrieve the collection
* defined by CollectionDescriptor
*/
private Query getFKQuery(Object obj, ClassDescriptor cld, CollectionDescriptor cds)
{
Query fkQuery;
QueryByCriteria fkQueryCrit;
if (cds.isMtoNRelation())
{
fkQueryCrit = getFKQueryMtoN(obj, cld, cds);
}
else
{
fkQueryCrit = getFKQuery1toN(obj, cld, cds);
}
// check if collection must be ordered
if (!cds.getOrderBy().isEmpty())
{
Iterator iter = cds.getOrderBy().iterator();
while (iter.hasNext())
{
fkQueryCrit.addOrderBy((FieldHelper)iter.next());
}
}
// BRJ: customize the query
if (cds.getQueryCustomizer() != null)
{
fkQuery = cds.getQueryCustomizer().customizeQuery(obj, pb, cds, fkQueryCrit);
}
else
{
fkQuery = fkQueryCrit;
}
return fkQuery;
}
示例15: getAll
import org.apache.ojb.broker.query.QueryByCriteria; //导入方法依赖的package包/类
/**
* Get list of all ElectronicInvoiceItemMappings
*/
@Override
public List getAll() {
LOG.debug("getAll() started");
QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class);
qbc.addOrderBy("id", true);
List l = (List) getPersistenceBrokerTemplate().getCollectionByQuery(qbc);
return l;
}