1、增加日期过滤条件
select
*
from
table1
where field1 > to_date('${rq}','yyyy-MM-dd')
2、在SQL中使用单选框参数
${if($checkBox0," and T.status in(0, 1)","")}
3、SQL中过滤非中文
REGEXP_LIKE (T1.bm, '[\\u4e00-\\u9fa5]')
4、帆软行号
转自:https://blog.csdn.net/qq_34105362/article/details/80436410