mybatis在接收list集合时,出现了接收的参数找不到的错误:


此时Mapper.xml文件中sql代码:

<select id="findTagsByTagIds" parameterType="list" resultType="com.blog.dao.pojo.Tag">
        select id,tag_name as tagName from ms_tag
        where id in
        <foreach collection="tagIds" item="tagId" separator="," open="(" close=")">
             #{tagId}
        </foreach>
    </select>

解决方法是将接收的tagIds的参数改为list:

<foreach collection="list" item="tagId" separator="," open="(" close=")">
             #{tagId}
        </foreach>

程序就可正常运行了。

更多推荐

出现Parameter ‘tagIds‘ not found. Available parameters are [arg0, collection, list