org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘item’ not found. Available parameters are [xxx, list, xxx]
Mapper中方法如下
@Insert(" INSERT INTO xxxxxx (\n" +" table_id,\n" +" code,\n" +" field_key,\n" +" create_time,\n" +" update_time\n" +" )\n" +" VALUES\n" +" <foreach collection=\"list\" item=\"item\" separator=\",\">\n" +" (\n" +" #{item.tableId},\n" +" #{item.code},\n" +" #{item.fieldKey},\n" +" #{item.createTime},\n" +" #{item.updateTime}\n" +" )\n" +" </foreach>")int batchInsert(List<xxxx> xxx);
看着是没错的, 一直报上面的错。
解法:
@Insert中的 sql加上 包裹即可