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);