Java Query类代码示例

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@Override
public List<PositionTypeBo> getPositionTypeList(String positionType, LocalDate asOfDate) {
	List<PositionTypeBo> prgList = new ArrayList<PositionTypeBo>();
	Criteria root = new Criteria();

	if(StringUtils.isNotEmpty(positionType)
			&& !ValidationUtils.isWildCard(positionType)) {
		root.addEqualTo("positionType", positionType);  
	}

       root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PositionTypeBo.class, asOfDate, PositionTypeBo.BUSINESS_KEYS, false));
       root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PositionTypeBo.class, PositionTypeBo.BUSINESS_KEYS, false));
       
       Criteria activeFilter = new Criteria();
       activeFilter.addEqualTo("active", true);
       root.addAndCriteria(activeFilter);

       Query query = QueryFactory.newQuery(PositionTypeBo.class, root);
       
       Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
	if(!c.isEmpty())
		prgList.addAll(c);
	
	return prgList;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
public List<AssignmentBo> getActiveAssignments(LocalDate asOfDate) {
      List<AssignmentBo> assignments = new ArrayList<AssignmentBo>();
      
      Criteria root = new Criteria();
      root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());

      root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(AssignmentBo.class, asOfDate, AssignmentBo.BUSINESS_KEYS, true));
      root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(AssignmentBo.class, AssignmentBo.BUSINESS_KEYS, true));

Criteria activeFilter = new Criteria();
activeFilter.addEqualTo("active", true);
root.addAndCriteria(activeFilter);

      Query query = QueryFactory.newQuery(AssignmentBo.class, root);
      Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

      if (c != null) {
          assignments.addAll(c);
      }

      return assignments;
  }
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@Override
public LeaveCalendarDocumentHeader getMinBeginDatePendingLeaveCalendar(String principalId) {
   	Criteria root = new Criteria();
       Criteria crit = new Criteria();
       List<String> pendingStatuses = new ArrayList<String>();
       pendingStatuses.add(HrConstants.ROUTE_STATUS.ENROUTE);
       pendingStatuses.add(HrConstants.ROUTE_STATUS.INITIATED);
       pendingStatuses.add(HrConstants.ROUTE_STATUS.SAVED);        
       
       crit.addEqualTo("principalId", principalId);
       crit.addIn("documentStatus", pendingStatuses);
       ReportQueryByCriteria startDateSubQuery = QueryFactory.newReportQuery(LeaveCalendarDocumentHeader.class, crit);
       startDateSubQuery.setAttributes(new String[]{"min(beginDate)"});

       root.addEqualTo("principalId", principalId);
       root.addIn("documentStatus", pendingStatuses);
       root.addEqualTo("beginDate", startDateSubQuery);

       Query query = QueryFactory.newQuery(LeaveCalendarDocumentHeader.class, root);
       return (LeaveCalendarDocumentHeader) this.getPersistenceBrokerTemplate().getObjectByQuery(query);
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
public List<AccrualCategoryBo> getActiveAccrualCategories(String leavePlan, LocalDate asOfDate){
	List<AccrualCategoryBo> accrualCategories = new ArrayList<AccrualCategoryBo>();
	
	Criteria root = new Criteria();

	root.addEqualTo("leavePlan", leavePlan);
       root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(AccrualCategoryBo.class, asOfDate, AccrualCategoryBo.BUSINESS_KEYS, false));
       root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(AccrualCategoryBo.class, AccrualCategoryBo.BUSINESS_KEYS, false));
	
	Criteria activeFilter = new Criteria(); // Inner Join For Activity
	activeFilter.addEqualTo("active", true);
	root.addAndCriteria(activeFilter);
	
	Query query = QueryFactory.newQuery(AccrualCategoryBo.class, root);
	Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

	if (c != null) {
		accrualCategories.addAll(c);
	}
	return accrualCategories;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@Override
public PayGradeBo getPayGrade(String payGrade, String salGroup, LocalDate asOfDate) {
	Criteria root = new Criteria();

	root.addEqualTo("payGrade", payGrade);
	root.addEqualTo("salGroup", salGroup);
       root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(PayGradeBo.class, asOfDate, PayGradeBo.BUSINESS_KEYS, false));
       root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(PayGradeBo.class, PayGradeBo.BUSINESS_KEYS, false));

	Criteria activeFilter = new Criteria(); // Inner Join For Activity
	activeFilter.addEqualTo("active", true);
	root.addAndCriteria(activeFilter);

	
	Query query = QueryFactory.newQuery(PayGradeBo.class, root);
	
	PayGradeBo pg = (PayGradeBo)this.getPersistenceBrokerTemplate().getObjectByQuery(query);
	
	return pg;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@Override
public LeavePlanBo getLeavePlan(String leavePlan, LocalDate asOfDate) {
	LeavePlanBo lp = null;

	Criteria root = new Criteria();
	root.addEqualTo("leavePlan", leavePlan);
       root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(LeavePlanBo.class, asOfDate, LeavePlanBo.BUSINESS_KEYS, false));
       root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(LeavePlanBo.class, LeavePlanBo.BUSINESS_KEYS, false));
	
	Criteria activeFilter = new Criteria(); // Inner Join For Activity
	activeFilter.addEqualTo("active", true);
	root.addAndCriteria(activeFilter);
	
	
	Query query = QueryFactory.newQuery(LeavePlanBo.class, root);
	Object obj = this.getPersistenceBrokerTemplate().getObjectByQuery(query);

	if (obj != null) {
		lp = (LeavePlanBo) obj;
	}

	return lp;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
/**
 * @see org.kuali.kfs.module.ar.document.dataaccess.CustomerInvoiceDocumentDao#getAllAgingInvoiceDocumentsByProcessing(java.util.List, java.util.List, java.sql.Date, java.sql.Date)
 */
@Override
public Collection<CustomerInvoiceDocument> getAllAgingInvoiceDocumentsByProcessing(List<String> charts, List<String> organizations, Date invoiceBillingDateFrom, Date invoiceBillingDateTo) {
    Criteria criteria = this.getAllAgingInvoiceDocumentsCriteria(StringUtils.EMPTY, invoiceBillingDateFrom, invoiceBillingDateTo);

    if(ObjectUtils.isNotNull(charts) && !charts.isEmpty()){
        criteria.addIn(ArPropertyConstants.CustomerInvoiceDocumentFields.PROCESSING_CHART_OF_ACCOUNT_CODE, charts);
    }

    if(ObjectUtils.isNotNull(organizations) && !organizations.isEmpty()){
        criteria.addIn(ArPropertyConstants.CustomerInvoiceDocumentFields.PROCESSING_ORGANIZATION_CODE, organizations);
    }

    criteria.addIsNull(ArPropertyConstants.AGING_REPORT_SENT_TIME);

    Query query = QueryFactory.newQuery(CustomerInvoiceDocument.class, criteria);

    return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
/**
 * Retrieve a list of all dossier types from the database
 *
 * @return      a List of EdoDossierType objects
 */
public List<EdoDossierTypeBo> getEdoDossierTypeList() {

    List<EdoDossierTypeBo> dossierTypeList = new LinkedList<EdoDossierTypeBo>();

    Criteria cConditions = new Criteria();

    Query query = QueryFactory.newQuery(EdoDossierTypeBo.class, cConditions);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (c != null && c.size() != 0) {
        if (c.size() > 0) {
            dossierTypeList.addAll(c);
            return dossierTypeList;
        }
    }
    return null;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
/**
 * test Null Criteria
 */
public void testNullCriteria()
{
    String name = "testNullCriteria_" + System.currentTimeMillis();
    Person p = new Person();
    p.setLastname(name);
    broker.beginTransaction();
    broker.store(p);
    broker.commitTransaction();

    Criteria crit = new Criteria();
    crit.addIsNull("firstname");
    Criteria crit2 = new Criteria();
    crit2.addLike("lastname", name);
    crit.addAndCriteria(crit2);
    
    Query q = QueryFactory.newQuery(Person.class, crit);

    Collection results = broker.getCollectionByQuery(q);
    assertNotNull(results);
    assertEquals(1, results.size());
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
/**
 * bind ExistsCriteria
 * @param stmt the PreparedStatement
 * @param index the position of the parameter to bind
 * @param crit the Criteria containing the parameter
 * @param cld the ClassDescriptor
 * @return next index for PreparedStatement
 */
private int bindStatement(PreparedStatement stmt, int index, ExistsCriteria crit, ClassDescriptor cld) throws SQLException
{
    Query subQuery = (Query) crit.getValue();

    // if query has criteria, bind them
    if (subQuery.getCriteria() != null && !subQuery.getCriteria().isEmpty())
    {
        return bindStatement(stmt, subQuery.getCriteria(), cld.getRepository().getDescriptorFor(subQuery.getSearchClass()), index);

        // otherwise, just ignore it
    }
    else
    {
        return index;
    }
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@SuppressWarnings({"unchecked", "rawtypes"})
@Override
public List<JobBo> getJobs(String principalId, LocalDate payPeriodEndDate) {
    List<JobBo> jobs = new LinkedList<JobBo>();
    Criteria root = new Criteria();
    root.addEqualTo("principalId", principalId);
    root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(JobBo.class, payPeriodEndDate, JobBo.BUSINESS_KEYS, false));
    root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(JobBo.class, JobBo.BUSINESS_KEYS, false));

    Criteria activeFilter = new Criteria(); // Inner Join For Activity
    activeFilter.addEqualTo("active", true);
    root.addAndCriteria(activeFilter);


    Query query = QueryFactory.newQuery(JobBo.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (c != null) {
        jobs.addAll(c);
    }


    return jobs;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@Override
public List<HrGroupKeyBo> getHrGroupKeysWithLocations(List<String> locations, LocalDate asOfDate) {
    List<HrGroupKeyBo> aList = new ArrayList<HrGroupKeyBo>();
    Criteria root = new Criteria();

    root.addIn("locationId", locations);
    root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(HrGroupKeyBo.class, asOfDate, HrGroupKeyBo.BUSINESS_KEYS, false));
    root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(HrGroupKeyBo.class, HrGroupKeyBo.BUSINESS_KEYS, false));
    root.addEqualTo("active", true);
    Query query = QueryFactory.newQuery(HrGroupKeyBo.class, root);

    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    if(!c.isEmpty())
        aList.addAll(c);

    return aList;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
/**
 * test Subquery get all articles with price > avg(price) PROBLEM:
 * avg(price) is NOT extent aware !!
 * <p/>
 * test may fail if db does not support sub queries
 */
public void testSubQuery1()
{

    ReportQueryByCriteria subQuery;
    Criteria subCrit = new Criteria();
    Criteria crit = new Criteria();

    subCrit.addLike("articleName", "A%");
    subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
    subQuery.setAttributes(new String[]{"avg(price)"});

    crit.addGreaterOrEqualThan("price", subQuery);
    Query q = QueryFactory.newQuery(Article.class, crit);

    Collection results = broker.getCollectionByQuery(q);
    assertNotNull(results);
    assertTrue(results.size() > 0);

}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
public AssignmentBo getAssignment(String principalId, String groupKeyCode, Long jobNumber, Long workArea, Long task, LocalDate asOfDate) {
    Criteria root = new Criteria();

    root.addEqualTo("principalId", principalId);
    root.addEqualTo("groupKeyCode", groupKeyCode);
    root.addEqualTo("jobNumber", jobNumber);
    root.addEqualTo("workArea", workArea);
    root.addEqualTo("task", task);
    root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(AssignmentBo.class, asOfDate, AssignmentBo.BUSINESS_KEYS, false));
    root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(AssignmentBo.class, AssignmentBo.BUSINESS_KEYS, false));
    //root.addEqualTo("active", true);

    Criteria activeFilter = new Criteria(); // Inner Join For Activity
    activeFilter.addEqualTo("active", true);
    root.addAndCriteria(activeFilter);

    Query query = QueryFactory.newQuery(AssignmentBo.class, root);
    Object o = this.getPersistenceBrokerTemplate().getObjectByQuery(query);

    return (AssignmentBo) o;
}
 

import org.apache.ojb.broker.query.Query; //导入依赖的package包/类
@Override
public List<EdoItemBo> getPendingItemsByDossierId(String edoDossierId, String edoChecklistItemId) {
    List<EdoItemBo> itemList = new LinkedList<EdoItemBo>();
    Criteria cConditions = new Criteria();

    cConditions.addEqualTo("edoDossierId", edoDossierId);
    cConditions.addEqualTo("edoChecklistItemId", edoChecklistItemId);
    cConditions.addEqualTo("routed", true);

    Query query = QueryFactory.newQuery(EdoItemBo.class, cConditions);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (c != null && c.size() != 0) {
        itemList.addAll(c);
        return itemList;
    }

    return null;
}