1、dao层实例
List<AppVersionEntity> queryDownloadVersionList(@Param("appIdList") List<String> appIdList,@Param("bcId") String bcId);
2、xml
<select id="queryDownloadVersionList" resultMap="appVersionInfo">
SELECT DISTINCT
v.*
FROM
app_version v
INNER JOIN public_task_push_resource r ON ( v.app_id = r.resource_id AND v.version = r.resource_version )
INNER JOIN public_task_push_corporation c ON r.task_id = c.task_id
WHERE
c.createdby_corp_id = #{bcId}
AND c.corporation_id = #{bcId}
AND v.app_id IN
<foreach collection="appIdList" open="(" separator="," close=")" item="item" index="index">
#{item.appId}
</foreach>
</select>