Java DetachedCriteria.add方法代碼示例

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@SuppressWarnings("unchecked")
public void deleteComponentProfileByControlId(String controlId, String name) {
	DetachedCriteria detachedCriteria = DetachedCriteria.forClass(ComponentConfig.class);
	detachedCriteria.add(Restrictions.eq("controlId", controlId));
	detachedCriteria.add(Restrictions.eq("name", name));
	Session session = this.getSessionFactory().openSession();
	try {
		org.hibernate.Criteria criteria = detachedCriteria.getExecutableCriteria(session);
		List<ComponentConfig> list = criteria.list();
		if (list.size() > 0) {
			String hql = "delete " + ComponentConfigMember.class.getName()
					+ " m where m.componentConfig.id = :configId";
			session.createQuery(hql).setString("configId", list.get(0).getId()).executeUpdate();
			session.delete(list.get(0));
		}
	} finally {
		session.flush();
		session.close();
	}
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
/**
 * Returns all products not contained in a collection.
 * @return a set of products.
 */
@Transactional(readOnly = true)
public Set<Product> getNoCollectionProducts ()
{
   DetachedCriteria criteria = DetachedCriteria.forClass (Product.class);
   Iterator<Product> it =
         collectionService.getAllProductInCollection ().iterator ();

   HashSet<Long> cpid = new HashSet<> ();
   while (it.hasNext ())
   {
      cpid.add (it.next ().getId ());
   }

   if (!cpid.isEmpty())
   {
      criteria.add(Restrictions.not(Restrictions.in("id", cpid)));
   }
   criteria.add (Restrictions.eq ("processed", true));
   return new HashSet<> (productDao.listCriteria (criteria, 0, -1));
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
private static DetachedCriteria createPurgeCriteria(FlowPurgeCriteria purgeCriteria) {
    DetachedCriteria criteria = DetachedCriteria.forClass(Flow.class)
        .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
        // purge all flows with a creation time older than time limit
        .add(lt("creationTime", purgeCriteria.getTimeLimit()))
        // purge oldest flows first
        .addOrder(Order.asc("creationTime"));

    if (purgeCriteria.getApplication() != null) {
        criteria.add(eq("application", purgeCriteria.getApplication()));
    }
    
    if (purgeCriteria.getPurgeMode() == PurgeMode.CLEAN) {
        // omit flows with error status
        criteria.add(
            or(
                eq("derivedStatus", FlowStatus.CLEAN),
                isNull("derivedStatus") // old flows (both CLEAN and ERROR)
            ) 
        );
        
    }
    return criteria;
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
private void buildCriterions(Collection<com.bstek.dorado.data.provider.Criterion> criterions,DetachedCriteria dc){
	for(com.bstek.dorado.data.provider.Criterion c : criterions){
		if (c instanceof SingleValueFilterCriterion){
			SingleValueFilterCriterion fc = (SingleValueFilterCriterion) c;
			dc.add(this.buildCriterion(fc));
		}
		if (c instanceof Junction) {
			Junction jun = (Junction) c;
			org.hibernate.criterion.Junction junction = null;
			if (jun instanceof Or) {
				junction = Restrictions.disjunction();
			} else if (jun instanceof And) {
				junction = Restrictions.conjunction();
			}
			Collection<com.bstek.dorado.data.provider.Criterion> subCriterions = jun.getCriterions();
			if (subCriterions != null) {
				buildCriterions(subCriterions, junction);
			}
			dc.add(junction);
		}
	}
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@Transactional(readOnly = true)
public Product getProductByOrigin (final String origin)
{
   DetachedCriteria criteria = DetachedCriteria.forClass (Product.class);
   criteria.add (Restrictions.eq ("origin", origin));
   return productDao.uniqueResult (criteria);
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@DataProvider
public void loadAssignmentDefs(Page<AssignmentDef> page,Criteria criteria){
	IUser user=ContextHolder.getLoginUser();
	if(user==null){
		throw new RuntimeException("Please login first!");
	}
	String companyId=user.getCompanyId();
	if(StringUtils.isNotEmpty(getFixedCompanyId())){
		companyId=getFixedCompanyId();
	}
	DetachedCriteria dc=this.buildDetachedCriteria(criteria, AssignmentDef.class);
	Property p=Property.forName("companyId");
	dc.add(p.eq(companyId));
	this.pagingQuery(page, dc);
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
/**
 * Retrieve products ordered by it date of ingestion, updated.
 * The list of product is returned prior to the passed date argument.
 * Currently processed and locked products are not returned.
 *
 * @param max_date     Maximum date to retrieve products
 *                     More recent product will not be returned
 * @param max_products Maximum products to return
 * @return a scrollable list of the products
 */
@Transactional(readOnly = true)
public Iterator<Product> getProductsByCreationDate(Date max_date, int max_products)
{
   DetachedCriteria criteria = DetachedCriteria.forClass(Product.class);
   criteria.add(Restrictions.and(
         Restrictions.lt("created", max_date),
         Restrictions.and(
               Restrictions.eq("processed", true),
               Restrictions.eq("locked", false))));
   criteria.addOrder(Order.asc("created"));

   return productDao.listCriteria(criteria, 0, max_products).iterator();
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
public JobDefinition getJobDefinition(String jobDefId) {
	DetachedCriteria dc = DetachedCriteria.forClass(JobDefinition.class, "m");
	dc.add(Restrictions.eq("id", jobDefId));
	@SuppressWarnings("unchecked")
	Collection<JobDefinition> list = (Collection<JobDefinition>) this.query(dc);
	if (list.isEmpty()) {
		return null;
	} else {
		return list.iterator().next();
	}
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@DataProvider
public void loadJobCalendars(Page<JobCalendar> page,Criteria criteria){
	IUser user=ContextHolder.getLoginUser();
	if(user==null){
		throw new RuntimeException("Please login first!");
	}
	String companyId=user.getCompanyId();
	if(StringUtils.isNotEmpty(getFixedCompanyId())){
		companyId=getFixedCompanyId();
	}
	DetachedCriteria dc=this.buildDetachedCriteria(criteria, JobCalendar.class);
	Property p=Property.forName("companyId");
	dc.add(p.eq(companyId));
	this.pagingQuery(page, dc);
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@Override
public void addWhere(ItemSerializerState state)
{
	ProjectionList projections = state.getItemProjection();
	DetachedCriteria criteria = state.getItemQuery();
	criteria.add(Restrictions.eq("uuid", uuid));
	criteria.addOrder(Order.asc(PROPERTY_VERSION));
	projections.add(Projections.property(PROPERTY_VERSION), ALIAS_VERSION);
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@Override
public void addWhere(ItemSerializerState state)
{
	DetachedCriteria criteria = state.getItemQuery();
	ProjectionList projections = state.getItemProjection();
	criteria.add(Restrictions.eq("uuid", uuid));
	if( live )
	{
		criteria.add(Restrictions.eq("status", ItemStatus.LIVE.name()));
	}
	criteria.addOrder(Order.desc(PROPERTY_VERSION));
	projections.add(Projections.property(PROPERTY_VERSION), ALIAS_VERSION);
	state.setMaxResults(1);
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@SuppressWarnings("unchecked")
public Collection<ComponentConfig> loadComponentConfigsByViewName(String viewName) {
	DetachedCriteria dc = DetachedCriteria.forClass(ComponentConfig.class);
	dc.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
	dc.add(Restrictions.like("controlId", viewName + ".%"));
	dc.createAlias("componentConfigMembers", "m", CriteriaSpecification.LEFT_JOIN);
	dc.addOrder(Order.asc("m.order"));
	return (List<ComponentConfig>) this.query(dc);
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
private static void applyEcrfFieldValueMaxIdSubCriteria(org.hibernate.Criteria ecrfFieldValueCriteria, org.hibernate.Criteria ecrfFieldCriteria,
		org.hibernate.Criteria probandListEntryCriteria,Long probandListEntryId, Long ecrfFieldId) {
	DetachedCriteria subQuery = createEcrfFieldValueDetachedCriteriaMaxId(ecrfFieldValueCriteria, ecrfFieldCriteria, probandListEntryCriteria, probandListEntryId, ecrfFieldId);
	subQuery.add(Restrictions.or(Restrictions.isNull("index"),
			Restrictions.eqProperty("index", ecrfFieldValueCriteria.getAlias() + ".index")));
	ecrfFieldValueCriteria.add(Subqueries.propertyEq("id", subQuery));
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
/**
 * Проверка даты на нерабочую в определенном календаре
 *
 * @param date проверяемая дата, важен месяц и день
 * @return Выходной день в этом календаре или нет
 */
public boolean checkFreeDay(Date date) {
    final DetachedCriteria criteria = DetachedCriteria.forClass(FreeDay.class);
    criteria.add(Property.forName("calendarId").eq(getId()));
    criteria.add(Property.forName("date").eq(date));
    return !(new LinkedList<>(Spring.getInstance().getHt().findByCriteria(criteria)).isEmpty());
}
 

import org.hibernate.criterion.DetachedCriteria; //導入方法依賴的package包/類
@Override
protected Collection<Password> handleFindExpiring(Date today,
		Long departmentId, AuthenticationType authMethod, VariablePeriod reminderPeriod,
		Long reminderPeriodDays, PSFVO psf) throws Exception {
	org.hibernate.Criteria passwordCriteria = createPasswordCriteria("password0");
	SubCriteriaMap criteriaMap = new SubCriteriaMap(Password.class, passwordCriteria);
	if (departmentId != null) {
		criteriaMap.createCriteria("user").add(Restrictions.eq("department.id", departmentId.longValue()));
	}
	if (authMethod != null) {
		criteriaMap.createCriteria("user").add(Restrictions.eq("authMethod", authMethod));
	}
	DetachedCriteria subQuery = DetachedCriteria.forClass(PasswordImpl.class, "password1"); // IMPL!!!!
	subQuery.add(Restrictions.eqProperty("password1.user", "password0.user"));
	subQuery.setProjection(Projections.max("id"));
	passwordCriteria.add(Subqueries.propertyEq("id", subQuery));
	passwordCriteria.add(Restrictions.eq("expires", true)); // performance only...
	if (psf != null) {
		PSFVO sorterFilter = new PSFVO();
		sorterFilter.setFilters(psf.getFilters());
		sorterFilter.setSortField(psf.getSortField());
		sorterFilter.setSortOrder(psf.getSortOrder());
		CriteriaUtil.applyPSFVO(criteriaMap, sorterFilter);
	}
	ArrayList<Password> resultSet = CriteriaUtil.listExpirations(passwordCriteria, today, null, null, null, reminderPeriod, reminderPeriodDays);
	return (Collection<Password>) CriteriaUtil.applyPVO(resultSet, psf, false); // no dupes by default
}