select * from pms_pj_info where 1=1 and PROJECT_YEAR between '${起始年度下拉}' and '${结束年度下拉}'${IF (len (CONTROL_TYPE) == 0,"","and CONTROL_TYPE like ('%" + CONTROL_TYPE + "%')") }-------------------------------------------------------------------写上红色的and不能进行空查询操作了,点击查询不到数据。