81,091
社区成员
发帖
与我相关
我的任务
分享
<delete id="delete" parameterType="java.lang.Long">
delete from table
where id = #{id }
<if test="name != null and name != ''">
and name = #{name }
</if>
<if test="value!= null and value!= ''">
and value= #{value}
</if>
<if test="value == null">
and value is null
</if>
</delete>