Mybatis注解式写批量查询语句

代码样例：

@Select({
        "<script>" +
                "select * from user where id in " +
                "<foreach item = 'item' index = 'index' collection = 'ids' open='(' separator=',' close=')'>" +
                "#{item}" +
                "</foreach>"+
        "</script>"})
List<User> getByIds(@Param("ids") List<Integer> ids);

没啥好讲的，刷点分