把一张表中的数据即一个List作为查询另一张表的条件参数

XML查询语句：

<select id="getMatterFunForeach" parameterType="Map" resultType="hashmap">
  select * from(
	select m.mattertitle as mattertitle,

	<foreach collection="list" index="index" item="item" separator="," >
 		count(decode(f.funcode, '${item.funcode}', 1)) as ${item.funcode}isnot
    </foreach>
	from os_fun f
	 join os_matter_fun mf
    on f.funcode = mf.funcode
   and f.funname = mf.funname
  join os_matter m
    on m.matterid = mf.matterid
	group by m.matterid,m.mattertitle)
	<where>
		<if test="funcode!=null and funcode!=''">
			and ${funcode}ISNOT >0
		</if>
	</where>
  </select>

SpringMVC控制层：

@RequestMapping(value = "")
	public ModelAndView LoadMatteropen(
			@RequestParam(required = false,defaultValue="1") String pageNum,
			@RequestParam(required = false,defaultValue="20") String pageSize,
			@RequestParam(required = false,defaultValue="")String funcode,
			HttpServletRequest request, 
			HttpServletResponse response
			) throws Exception {
		ModelAndView result = null;
		Map<String, Object> map = new HashMap<String, Object>();
		String userid = getLoginUserId(request);
		SysUserOrg suo = sysUserOrgService.findOrgByUserId2(userid);
		WorkOrg wo = null;
		if(suo!=null){
			wo= workOrgService.getWorkOrgByOrgcode(suo.getOrgCode());
		}
		int orgtype =getLoginUserInfo(request, response).getUser().getOrgtype();//获取user对象中的orgtype
		if(orgtype==1){
			result = new ModelAndView("");
			result.addObject("funcode", funcode);
			List<OsFun> funList = osFunService.getOsFunList();
			if(funList.size()>0){
				result.addObject("funList", funList);
			}
			map.put("funcode", funcode);
			map.put("list", funList);
			Page<Map<String,Object>> mapList = osMatterService.getMatterFunForeach(map, new PageUtil(pageNum,pageSize)); 
			result.addObject("mapList", mapList);
			setPageInfo(result,mapList,"",map);
		}
		result.addObject("orgtype", orgtype);
		load(result, request, response);
		return result;
	}

freemarker页面代码：

<table class="listtable" align="center" cellpadding="0" cellspacing="1" border="0">
				<tr class="header">
					<td width="30" class="center">No</td>
					<td class="center">局委名称</td>
					<td width="60" class="center">办事项总数</td>
					<#list funList as fun>
							<td width="53" class="center">${(fun.funname)!}</td>
					</#list>
				</tr>
				<!-- loop begin -->
				<#assign i=1/>
				<#if mapList??>
				<#assign totalcount=0/>
				<#list mapList as map>
					<tr <#if map_has_next>class="trow"<#else>class="header"</#if>>
							<#if map_has_next>
							<td <#if map_has_next>class="center tno" <#else>class="right ttext" colspan="2"</#if>>${i}</td>
							<#else>
							</#if>
							<td <#if map_has_next>class="left ttext"<#else>class="right ttext" colspan="2"</#if>>${(map['ORGNAME'])!}</td> 
							<td class="center tlink">
								<#if map_has_next>
									<a href="${RootPath}x.html?orgid=${(map['ORGID'])!}">
										<#if (map['COUNT'])>0>
											${(map['COUNT'])!}个
										</#if>								
									</a>
									<#assign totalcount=totalcount+map['COUNT']/>
								<#else>
									<a href="${RootPath}x.html">
										<#if totalcount>0>
											${totalcount}个
										</#if>
									</a>
								</#if>
							</td> 
							<!-- <#list map?keys as itemKey>
								<td class="center tlink">
									<a href="${RootPath}x.html?orgid=${(map['ORGID'])!}">
										${map[itemKey]}
									</a>
								</td>
							</#list>-->
							
						 <#list funList as fun>
							<td class="center tlink">
								<a href="${RootPath}x.html?<#if map_has_next>orgid=${(map['ORGID'])!}&</#if>funcode=${fun.funcode?upper_case}">
									<#if (map['${fun.funcode?upper_case}COUNT'])>0>
										${(map['${fun.funcode?upper_case}COUNT'])!}个
									</#if>								
								</a>
							</td>
							
						</#list>
					</tr>
					<#assign i++/>
				</#list>
				</#if>
				<!-- loop end -->
			</table>