Question

mybatis执行批量更新的时候，总会报错。

错误内容：Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Invalid value "3" for parameter "parameterIndex" [90008-175]
### The error may involve com.its.itone.riipservice.service.impl.mapper.RuleCommandMapper.batchUpdate-Inline

映射配置:
<update id="batchUpdate" parameterType="java.util.List">

<foreach collection="list" item="item" open="" close="" separator=";" >
UPDATE hec_rule_command SET c_exe_order = #{item.exeOrder} WHERE c_id = #{item.id}
</foreach>

</update>
service 调用： count = commandMapper.batchUpdate(commandList);

Answer 1

你这条sql就有问题，批量后面的id怎么会是= ，批量的id是个数组，批量的关键字是in