mybatis批量插入报错Parameter ‘id‘ not found. Available parameters are [entities, param1]

最新推荐文章于 2024-08-06 10:09:13 发布

cry1049208942

最新推荐文章于 2024-08-06 10:09:13 发布

阅读量2.5k

点赞数 4

分类专栏： Java

本文链接：https://blog.csdn.net/cry1049208942/article/details/115690603

版权

Java 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

{
"code": "500",
"message": "nested exception is org.apache.ibatis.executor.ExecutorException: Error getting generated key or setting result to parameter object. Cause: org.apache.ibatis.binding.BindingException: Parameter 'id' not found. Available parameters are [entities, param1]"
}

将
int insertBatch(@Param("entities") List<GtjCircuitAuditRuleItem> entities);

改为
int insertBatch(List<GtjCircuitAuditRuleItem> entities);

将
<foreach collection="entities" item="entity" separator=",">
(#{entity.ruleId}, #{entity.name}, #{entity.code}, #{entity.value}, #{entity.description},
#{entity.sortKey})
</foreach>
改为
<foreach collection="list" item="entity" separator=",">
(#{entity.ruleId}, #{entity.name}, #{entity.code}, #{entity.value}, #{entity.description},
#{entity.sortKey})
</foreach>