Struts2 条件查询中的联合查询

       Criteria criteria = getSession().createCriteria(TspcApply.class);
		
       if(startdate!=null&&!"".equals(startdate))
		{
			criteria.add(Restrictions.ge("startdate",startdate));
		}
       if(enddate!=null&&!"".equals(enddate))
		{
			criteria.add(Restrictions.le("enddate",enddate));
		}
       //联合查询
       criteria.createCriteria("tagtAgent","agent");
       if(agentname!=null&&!"".equals(agentname))    	   
		{
		   criteria.add(Restrictions.like("agent.agentname",agentname,MatchMode.ANYWHERE));
		}
       if(feefrom>0)
		{
  	     criteria.add(Restrictions.eq("feefrom",feefrom));
		}
       if(typeid>0)
		{
    	 //联合查询
    	   criteria.createCriteria("agent.tagtType","type");
    	   criteria.add(Restrictions.eq("type.typeid",typeid));
		}
       if(fundid>0)
		{
    	 //联合查询
    	   criteria.createCriteria("tspcFund","fund");
    	   criteria.add(Restrictions.eq("fund.fundid",fundid));
		}

       criteria.addOrder(Order.desc("enddate"));

       int recordsize = ((Integer) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();  
       
       criteria.setProjection(null);
       criteria.setResultTransformer(CriteriaSpecification.ROOT_ENTITY);
       netbarlist=criteria.list();