美文网首页
mybatis中传入ids String类型参数异常

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

作者: 丸_子 | 来源:发表于2016-10-04 19:06 被阅读309次

在使用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>

欢迎加入QQ群:104286694

相关文章

网友评论

      本文标题:mybatis中传入ids String类型参数异常

      本文链接:https://www.haomeiwen.com/subject/ircsyttx.html