and date between ${"'"+start_date+"' and '"+end_date+"'"}
怎么将上述代码改成如果两个参数start_date和end_date为空的情况下,这串代码的结果是" ",不影响前面的sql
${if(len(start_date)==0,""," and date >='"+start_date+"')")}
${if(len(end_date)==0,""," and date <='"+end_date+"')")}
${if(len(start_date) == 0 && len(end_date)== 0,"","and date between '" + start_date+ "' and '" +end_date +"'")}