1、日期比较大小及日期格式化:
DATE_FORMAT(a.PAY_TIME_,'%Y-%m-%d') <= DATE_FORMAT(#{endMonthPay},'%Y-%m-%d')
>
2、转义
CASE sex
WHEN '1' THEN '男'
WHEN '2' THEN '女'
ELSE '其他' END
3、foreach in
map.put("demoListKey",demoList);
AND 字段 in
<foreach collection="demoListKey" item="demoList" index="index" separator="," open="(" close=")">
#{demoList}
</foreach>