SELECT * FROM 销量 ${if(len(area) == 0,"","where 地区 = '" + area + "'")}
公司别,职位,目前状况 为3个条件,有值则执行带有查询条件的查询;无值则查询数据
写三行就好了
SELECT * FROM 销量
where 1=1
${if(len(area1) == 0,"","and 地区1 = '" + area1 + "'")}
${if(len(area2) == 0,"","and 地区2 = '" + area2 + "'")}
${if(len(area3) == 0,"","and 地区3 = '" + area3 + "'")}
SELECT * FROM 销量 WHERE 1=1 ${if(len(area) == 0,""," AND 地区 = '" + area + "'")} ${if(len(area1) == 0,""," AND 地区 = '" + area1 + "'")} ${if(len(area2) == 0,""," AND 地区 = '" + area2 + "'")}