and
(1=1 ${if(len(sqstr) == 0,"","and 开始日期>='"+sqstr+"'")}
and
1=1 ${if(len(sqend) == 0,"","and 开始日期<='"+sqend+"'")}
)
and
(
1=1 ${if(len(spstr) == 0,"","and 结束日期>='"+spstr+"'")}
and
1=1 ${if(len(spend) == 0,"","and 结束日期<='"+spend+"'")}
)
改写成我这种,就能实现你想要的了,我懂你的