Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]

解决org.apache.ibatis.binding.BindingException: Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2] 问题

错误的情况:

Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]

我的mapper是这样:Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]

Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]

xml文件是这样的:

Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]

然后就报了上面的错!!!

解决方法:按错误提示信息修改xml文件即可,如下

Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]

成功!

Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]Parameter '0' not found. Available parameters are [arg2, arg1, arg0, param3, param1, param2]