mybatis @Select 中 in 一个数组怎么写

 报错

原先是 userId in #{userIds} 这样写的,会报错，

解决方案

in后面改成<foreach> 进行拆解就可以了,eg

@Select({
            "<script>",
                "select * from article as a where a.state='1' and a.userId in ",
                "<foreach collection='userIds' item='item' open='(' separator=',' close=')'>",
                    "#{item}",
                "</foreach> " +
                "order by updateTime desc ",
            "</script>"
    })
    List<Article> getPByUserIds(@Param("userIds") List<Integer> userIds);