关于MyBatis Column count doesn't match value count at row
把
<mapper namespace="com.xr.mapper.UserMapper">
<insert id="addUsers" >
insert into t_user values
<foreach collection="list" item="item" separator=",">
(#{item.userName},#{item.passWord})
</foreach>
</insert>
</mapper>
改为:
<mapper namespace="com.xr.mapper.UserMapper">
<insert id="addUsers" >
insert into t_user(USER_NAME, `PASSWORD`) values
<foreach collection="list" item="item" separator=",">
(#{item.userName},#{item.passWord})
</foreach>
</insert>
</mapper>
原因:
由于列值没有对应,所以找不到需要对应的列,在MyBatis中必须值列对应
仅供参考,