摘要:
select count(*) from o_org where( case when ?='条件' and org_no='43101' then 1 when ?!='条件' then 1 else 0 end )=1两个条件相同 ,? 是参数的值 ,通过对?值的判断 动态添加条件org_no='43101'select * from o_org where( case when 1='1' and org_no='43101' then 1 when 1!='1' then 1 阅读全文