mybatis使用注解，当有参数列表报nested exception is org.apache.ibatis.binding.BindingException: Parameter

rain_vigour

于 2022-06-21 10:40:50 发布

阅读量389

点赞数

分类专栏： Java 文章标签： mybatis java

本文链接：https://blog.youkuaiyun.com/sinat_40292249/article/details/125386535

版权

Java 专栏收录该内容

1 篇文章

订阅专栏

1. 报错

@Select("select count(*) from manage_file where del_flag = 0 and file_id in " +
            "<foreach item='fileId' index='index' collection='fileIds' open='(' separator=',' close=')'>" +
            "#{fileId}" +
            "</foreach>" 
    )
    int CountUpdateManageFile(@Param("fileIds") Long[] fileIds);

nested exception is org.apache.ibatis.binding.BindingException: Parameter 'fileId' not found. Available parameters are [fileIds, param1]

2. 使用注解@Param需要加<script></script>

 @Select("<script>select count(*) from manage_file where del_flag = 0 and file_id in " +
            "<foreach item='fileId' index='index' collection='fileIds' open='(' separator=',' close=')'>" +
            "#{fileId}" +
            "</foreach>" +
            "</script>"
    )
    int CountUpdateManageFile(@Param("fileIds") Long[] fileIds);