(在Ibatis里,#val#,除了替换值,它都会加上一个单引号',所以sql中不需要加引号的话直接用$val$):
t.OPERATOR_ID = #operatorId#
t.OPERATOR_NAME like '%$operatorName$%'
t.OPERATOR_NAME like '%'||#operatorName#||'%'
t.DRAFTE_START_DATE>=trunc(#startDate#, 'dd')
t.OPERATOR_ID = #operatorId#
t.OPERATOR_NAME like '%$operatorName$%'
t.OPERATOR_NAME like '%'||#operatorName#||'%'
t.DRAFTE_START_DATE>=trunc(#startDate#, 'dd')