${len(yf==0,"YEAR='"+y+"'"," MONTH='"+yf+"')}
这样查的不对、因为好像里面变成了字符串了。有什么别的办法么、、
后面这个就是加了一个yf=7应该查7月的吧结果没。
select * from dm_nontax_received where 1=1
${if(len(yf)=0," and YEAR='"+year_code+"'"," and MONTH='"+month_code+"'")}
改成类似这样吧：
where 1=1
${len(yf==0," and YEAR='"+year_code+"'"," and MONTH='"+month_code+"'")}
~~~~
${len(yf==0,"YEAR="+y," MONTH="+yf)}
${len(yf==0,"and YEAR='"+y+"'","and MONTH='"+yf+"')}
1min目标场景问卷
立即参与
