当前位置: 首页>>代码示例>>Java>>正文


Java Criteria.addExists方法代码示例

本文整理汇总了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;
    }
}
 
开发者ID:kuali,项目名称:kfs,代码行数:31,代码来源:BudgetConstructionOrganizationReportsDaoOjb.java

示例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);
	}
}
 
开发者ID:KualiCo,项目名称:ojb,代码行数:51,代码来源:OQLParser.java

示例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;
}
 
开发者ID:kuali,项目名称:kfs,代码行数:45,代码来源:BudgetConstructionLockDaoOjb.java


注:本文中的org.apache.ojb.broker.query.Criteria.addExists方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。