使用mybatis批量操作数据时,输出如下异常:
nested exception is org.apache.ibatis.binding.BindingException: Parameter 'list' not found. Available parameters are [collection, list]
原因是mybatis没有找到对应的集合名称,下为原配置:
int insertTestObjects( List<TestObject> objectList);
<insert id="insertTestObjects" parameterType="com.xxx.TestObject">
insert into testObject (o_id,o_type, create_time)
values
<foreach collection="objectList" item="item" separator=",">
(#{item.oId,jdbcType=BIGINT}, #{item.oType,jdbcType=INTEGER},
#{item.createTime,jdbcType=TIMESTAMP})
</foreach>
</insert>
可以
1.修改mapper的方法参数
int insertTestObjects(@Param("objectList") List<TestObject> objectList);
或者
2.
<insert id="insertTestObjects" parameterType="com.xxx.TestObject">
insert into testObject (o_id,o_type, create_time)
values
<foreach collection="list" item="item" separator=",">
(#{item.oId,jdbcType=BIGINT}, #{item.oType,jdbcType=INTEGER},
#{item.createTime,jdbcType=TIMESTAMP})
</foreach>
</insert>