select DQ,sum(ZFCL_HJ) ,sum(ZFCL_LZCL) ,sum(ZFCL_GACL),month from ljlhsj_1 where DQ != '合计'
${if(len(年)==0,"","and year = '"+年+"'")}
${if(月=='第一季度',"and (month = '01' or month = '02' or month = '03')","")}
${if(月=='第二季度',"and (month = '04' or month = '05' or month = '06')","")}
${if(月=='第三季度',"and (month = '07' or month = '08' or month = '09')","")}
${if(月=='第四季度',"and (month = '10' or month = '11' or month = '12')","")}
${if(len(月)==0 or 月=='第四季度' or 月=='第一季度' or 月=='第二季度' or 月=='第三季度',"","and month = '"+月+"'")}
group by DQ,month order by code
中
${if(len(月)==0 or 月=='第四季度' or 月=='第一季度' or 月=='第二季度' or 月=='第三季度',"","and month = '"+月+"'")}
这个多个条件的语句应该怎么写,我这种写法 or 是不识别的,可能查询的时候当成了数据库中的 or
数据库中只有月份,没有季度,且传过来的参数,可能是月份 01,02,03...,也可能是季度 第一季度...
不想全部写成
${if(月=='第四季度',"and (month = '10' or month = '11' or month = '12')","")}
这种的,有什么好方法吗??