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
<if test="id != null" > and id=#{id}</if>
<if test="name != null" > and name=#{name}</if>
<if test="password != null" >and password=#{password}</if>
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....