在使用mybatis時(shí)，寫了一條sql語(yǔ)句，只有一個(gè)String類型的參數(shù)， 示例代碼

<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傳入一個(gè)字符串傳參數(shù)，報(bào)There is no getter for property named 'ids' in 'class java.lang.String'。

后來(lái)改成如下寫法，無(wú)論參數(shù)名是啥，都要改成"_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