Parameter 'member_id' not found.错误

Question

 Parameter 'member_id' not found. Available parameters are [0, 1, param1, param2]

 <delete id="deleteNull" parameterType="string">
        DELETE from access_layer
        WHERE access_layer.member_id = #{member_id} and node_id = #{node_id}
        IS NULL;
    </delete>

 for (Access_Layer acl : layer) {
                                if (acl.getMember_id() != null && !acl.getMember_id().equals("")
                                        && acl.getMember_id().equals(member.getMember_id()) && acl.getNode_id() == null
                                        || acl.getNode_id().equals("")) {
                                    System.out.println(acl.getMember_id() + "," + acl.getNode_id());
                                    accessService.deleteNull(acl.getMember_id(), acl.getNode_id());
                                }
                            }

控制台输出：c,null
应该是对的。但是会报这种错。

Answer 1

parameterType="string" 这个只能传递一个参数，但是你的sql中使用的是2个参数