比如year表示字段 , ${year}是年份参数
select * from 表 where year >= ${year} and year <= ${year} ;
select * from 表 where year >= ${year} -3 and year <= ${year}(今年)
where year >= ${year} - 3 and year <= ${year}