本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addExists方法的典型用法代码示例。如果您正苦于以下问题:Java Criteria.addExists方法的具体用法?Java Criteria.addExists怎么用?Java Criteria.addExists使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria
的用法示例。
在下文中一共展示了Criteria.addExists方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: isLeafOrg
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionOrganizationReportsDao#isLeafOrg(java.lang.String, java.lang.String)
*/
public boolean isLeafOrg(String chartOfAccountsCode, String organizationCode) {
Criteria childExistsCriteria = new Criteria();
childExistsCriteria.addEqualTo("reportsToChartOfAccountsCode", chartOfAccountsCode);
childExistsCriteria.addEqualTo("reportsToOrganizationCode", organizationCode);
childExistsCriteria.addEqualTo("organization.active", Boolean.TRUE);
QueryByCriteria childExistsQuery = QueryFactory.newQuery(BudgetConstructionOrganizationReports.class, childExistsCriteria);
Criteria criteria = new Criteria();
criteria.addEqualTo("chartOfAccountsCode", chartOfAccountsCode);
criteria.addEqualTo("organizationCode", organizationCode);
criteria.addExists(childExistsQuery);
String[] queryAttr = { KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE };
ReportQueryByCriteria query = new ReportQueryByCriteria(BudgetConstructionOrganizationReports.class, queryAttr, criteria, true);
Iterator rowsReturned = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(query);
if (rowsReturned.hasNext()) {
TransactionalServiceUtils.exhaustIterator(rowsReturned);
return false;
}
else {
return true;
}
}
示例2: existsExpr
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public final void existsExpr(
Criteria criteria
) throws RecognitionException, TokenStreamException {
try { // for error handling
Query subQuery = null;
boolean negative = false;
{
if ((LA(1)==LITERAL_not)) {
match(LITERAL_not);
negative = true;
}
else if ((LA(1)==LITERAL_exists)) {
}
else {
throw new NoViableAltException(LT(1), getFilename());
}
}
{
if ((LA(1)==LITERAL_exists) && (LA(2)==TOK_LPAREN)) {
match(LITERAL_exists);
match(TOK_LPAREN);
subQuery=selectQuery();
match(TOK_RPAREN);
}
else if ((LA(1)==LITERAL_exists) && (LA(2)==TOK_STAR||LA(2)==Identifier)) {
subQuery=existsQuery();
}
else {
throw new NoViableAltException(LT(1), getFilename());
}
}
if (negative) {
criteria.addNotExists(subQuery);
} else {
criteria.addExists(subQuery);
}
}
catch (RecognitionException ex) {
reportError(ex);
recover(ex,_tokenSet_7);
}
}
示例3: getOrphanedPositionLocks
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.bc.document.dataaccess.BudgetConstructionLockDao#getOrphanedPositionLocks(java.lang.String)
*/
public List<BudgetConstructionPosition> getOrphanedPositionLocks(String lockUnivId) {
Criteria criteria = new Criteria();
if (StringUtils.isNotBlank(lockUnivId)) {
criteria.addEqualTo(BCPropertyConstants.POSITION_LOCK_USER_IDENTIFIER, lockUnivId);
}
else {
criteria.addNotNull(BCPropertyConstants.POSITION_LOCK_USER_IDENTIFIER);
}
ReportQueryByCriteria query = QueryFactory.newReportQuery(BudgetConstructionPosition.class, criteria);
query.addOrderByAscending(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR);
query.addOrderByAscending(BCPropertyConstants.POSITION_NUMBER);
List<BudgetConstructionPosition> allPositionLocks = (List<BudgetConstructionPosition>) getPersistenceBrokerTemplate().getCollectionByQuery(query);
List<BudgetConstructionPosition> orphanedPositionLocks = new ArrayList<BudgetConstructionPosition>();
for (BudgetConstructionPosition position : allPositionLocks) {
Criteria criteria2 = new Criteria();
criteria2.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, position.getUniversityFiscalYear());
criteria2.addEqualTo(BCPropertyConstants.POSITION_NUMBER, position.getPositionNumber());
Criteria subCrit = new Criteria();
subCrit.addEqualToField(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, Criteria.PARENT_QUERY_PREFIX + KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR);
subCrit.addEqualToField(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, Criteria.PARENT_QUERY_PREFIX + KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
subCrit.addEqualToField(KFSPropertyConstants.ACCOUNT_NUMBER, Criteria.PARENT_QUERY_PREFIX + KFSPropertyConstants.ACCOUNT_NUMBER);
subCrit.addEqualToField(KFSPropertyConstants.SUB_ACCOUNT_NUMBER, Criteria.PARENT_QUERY_PREFIX + KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
subCrit.addEqualTo(BCPropertyConstants.APPOINTMENT_FUNDING_LOCK_USER_ID, position.getPositionLockUserIdentifier());
ReportQueryByCriteria subQuery = QueryFactory.newReportQuery(BudgetConstructionFundingLock.class, subCrit);
subQuery.setAttributes(new String[] { "1" });
criteria2.addExists(subQuery);
List<PendingBudgetConstructionAppointmentFunding> appointmentFundingLocks = (List<PendingBudgetConstructionAppointmentFunding>) getPersistenceBrokerTemplate().getCollectionByQuery(QueryFactory.newQuery(PendingBudgetConstructionAppointmentFunding.class, criteria2));
if (appointmentFundingLocks == null || appointmentFundingLocks.isEmpty()) {
orphanedPositionLocks.add(position);
}
}
return orphanedPositionLocks;
}