mybatis:方法需要传入多个参数时,报错:Caused by: org.apache.ibatis.binding.BindingException: Parameter 'p_v_id' not

来源:互联网 发布:iphone主题软件下载 编辑:程序博客网 时间:2024/06/05 21:26

mybatis:方法需要传入多个参数时,报错:Caused by: org.apache.ibatis.binding.BindingException: Parameter 'p_v_id' not


错误sql如下:

@Delete("delete from iconfig where p_v_id=#{p_v_id} and env_id=#{env_id} and conf_id=#{conf_id};")public void deleteIConfig(<String p_v_id,@Param("env_id")String env_id,@Param("conf_id")String conf_id);

绿色标识的参数p_v_id没有带@Param注解,导致执行sql时无法辨识p_v_id字段。


修复方式:

@Delete("delete from iconfig where p_v_id=#{p_v_id} and env_id=#{env_id} and conf_id=#{conf_id};")public void deleteIConfig(@Param("p_v_id")String p_v_id,@Param("env_id")String env_id,@Param("conf_id")String conf_id);


0 0
原创粉丝点击