mybatis中传入ids String类型参数异常

最新推荐文章于 2023-08-14 10:58:28 发布

{丸の子}

最新推荐文章于 2023-08-14 10:58:28 发布

阅读量1.1k

点赞数

分类专栏： java 文章标签： java 数据库

本文链接：https://blog.csdn.net/waterseason/article/details/84820030

版权

java 专栏收录该内容

341 篇文章 1 订阅

订阅专栏

在使用mybatis时，写了一条sql语句，只有一个String类型的参数，示例代码


<select id="getApplyNum" parameterType="java.lang.String" resultType="java.util.Map">  
         SELECT  
            t.activity_id AS "activityId",  
            COUNT(1) AS "count"  
        FROM  
            t_user t  
        WHERE  
            t.activity_id IN (${ids})  
        GROUP BY  
            t.activity_id  
    </select>

Mybatis查询sql传入一个字符串传参数，报There is no getter for property named 'ids' in 'class java.lang.String'。

后来改成如下写法，无论参数名是啥，都要改成"_parameter"。问题解决。


<select id="getApplyNum" parameterType="java.lang.String" resultType="java.util.Map">  
        SELECT  
           t.activity_id AS "activityId",  
           COUNT(1) AS "count"  
       FROM  
           t_user t  
       WHERE  
           t.activity_id IN (${_parameter})  
       GROUP BY  
           t.activity_id  
   </select>