sql中使用in时报错: nested exception is org.apache.ibatis.type.TypeException

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException:Could not set parameters for mapping: ParameterMapping{property='ids', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #4 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #4 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (4 > number of parameters, which is 3).

详情见：https://blog.csdn.net/fz13768884254/article/details/82876539

将获取到的字符串数组，例如"10021","10022","10028"，使用concat拼接括号后放置在in后面，account_id 类型为bigint，

就会报错，相应解决方案如下：

<select id="getNum" resultType="java.lang.Integer">
    select
    count(*)
    from data_sta
    where (create_time BETWEEN #{startTime} AND #{endTime}) and account_id in
    concat("(",#{ids},")")
    <!-- 解决方案一：直接使用 (#{ids}) or (${ids}) 来代替concat("(",#{ids},")")-->
         
    <!--解决方案二，将拼接的数组字符串转换为集合 
         <foreach collection="ids"  item="item" index="index" separator="," open="(" close=")">
            #{item}
    </foreach>-->
</select>