${if(len(startDate)==0 && len(endDate)==0,''," AND SJSJRQ BETWEEN '"+startDate+"' and '"+endDate+"'")}
startDate,endDate 为参数
根据传递过来参数的长度,判断是否需要相应sql查询语句
${if(len(starttime)==0 && len(endtime)==0,''," and t.xt_djsj between '"+starttime+" 00:00:00' and '"+endtime+" 23:23:59'")}
starttime,endtime为参数,00:00:00,23:23:59为后面 可以拼接的字符串
根据传递过来参数的长度,判断是否需要相应sql查询语句