就是java中判断数据为null然后告诉数据库删除数据,不知道语句哪里写错了,麻烦帮我看看。
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());
}
<delete id="deleteNull" parameterType="string">
DELETE from access_layer WHERE member_id = #{member_id} and node_id IS NULL;
</delete>