回答:注意事项,使用between...and...,如果查询的是跨度到月份的,制包含就开始月份,不包含终止月份,加上终止月份
select
a.*
from
(
(SELECTyxtscs_number_x yxtscs_number,'线网' AS line,selectDate FROM tb_plan_dept)union
(SELECTyxtscs_number_1 yxtscs_number,'1号线' AS line,selectDate FROM tb_plan_dept)union
(SELECTyxtscs_number_2 yxtscs_number,'2号线' AS line,selectDate FROM tb_plan_dept)union
(SELECTyxtscs_number_3 yxtscs_number,'3号线' AS line,selectDate FROM tb_plan_dept)union
(SELECTyxtscs_number_5 yxtscs_number,'4号线' AS line,selectDate FROM tb_plan_dept)
)a
where
((date_format(a.selectDate,'%Y-%m-%d') ${if(len(startDate) == 0,""," BETWEEN '" + startDate+ "' AND '" + endDate+ "'")})
or (date_format(a.selectDate, "%Y-%m" ) ${if(len(endDate) == 0,""," = '"+endDate+"'")}))
${if(len(line) == 0,""," and a.line = '" + line + "'")}