(case
when substr(starttime::varchar,0,5)='2020' then '2020年'
when substr(starttime::varchar,0,5)='2019' then '2019年'
when substr(starttime::varchar,0,5)='2018' then '2018年'
when substr(starttime::varchar,0,5)='2017' then '2017年'
when substr(starttime::varchar,0,5)='2016' then '2016年'
when substr(starttime::varchar,0,5)='2015' then '2015年'
when substr(starttime::varchar,0,5)='2014' then '2014年'
when substr(starttime::varchar,0,5)='2013' then '2013年'
when substr(starttime::varchar,0,5)='2012' then '2012年'
when substr(starttime::varchar,0,5)='2011' then '2011年'
when substr(starttime::varchar,0,5)='2010' then '2010年'
when starttime is null then '其他年份' end
) AS year
2.mybatis中判断某个传参是否为空
<if test="geojsonString !=null and geojsonString !=''">
WHERE
st_intersects(geom,st_geomfromgeojson(#{geojsonString}))</if>
1.case when( case when substr(starttime::varchar,0,5)='2020' then '2020年' when substr(starttime::varchar,0,5)='2019' then '2019年' when substr(starttime::varchar,0,5)='2018' then '2018年' when substr(starttime::var