mybatis if or条件查询
mybatis中多条件删除例子如下: delete from tb_duty where ( dscd=#{item.dscd}, and unit_id=#{item.unitid}, and year=#{item.year}, and month=#{item.month}, and flag=#{item.flag} )
当然可以
select id, name, password
from user
where 1=1
and id=#{id}
and name=#{name}
and password=#{password}