多條件查詢

where 1=1 ${if(len(unitcode) == 0,"","and unitcode like '" + unitcode + "%'")}  ${if(len(abstract) == 0,"","and explanation like '" + abstract + "%'")} ${if(len(kjkm) == 0,"","and subjcode = '" + kjkm + "'")} ${if(len(xmmc) == 0,"","and valuename = '" + xmmc + "'")} ${if(len(start) == 0,"","and prepareddatev >= '" + start + "'")} ${if(len(end) == 0,"","and prepareddatev <= '" + end + "'")} ${if(len(kjkm) == 0,"","and name like  '" + kjkm + "%'")} ${if(len(date1) == 0,"","and localdebitamount >= " + date1 + "")} ${if(len(date2) == 0,"","and localdebitamount <= " + date2 + "")}
${if(len(xh1) == 0,"","and nov >=" +xh1+ "")} ${if(len(xh2) == 0,"","and nov <=" +xh2+ "")} ${if(len(depart) == 0,"","and valuename = '" + depart + "'")}