xml里面批量遍历和单个遍历

//批量
<insert id="inserBeatch">
    insert into table_name(table_name,tabel_code)
        values
        <foreach collection="param" index="i" item="item" separator=",">
            (#{item.tableName},
            #{item.tabelCode})
        </foreach>
</insert>

mapper层中的传参
List<xxxx> findInfo(@Param("param")List<String> applyId);
//单个
<select id="findInfo" resultType="xxxxx">
    select * 
        from table_name where table_id in
            <foreach collection="param" separator="," open="(" close=")" item="item" index="i">
                #{item}
            </foreach>
</select>