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

2016-10-04  本文已影响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

上一篇 下一篇

猜你喜欢

热点阅读