gt: greater than 大于
gte: greater than or equal 大于等于
lt: less than 小于
lte: less than or equal 小于等于
示例
tn>2 and tn <=9
<if test="request.tn gt 2 and request.tn lte 9">
AND aging.${request.durationField}=#{request.tn}
</if>
gt: greater than 大于
gte: greater than or equal 大于等于
lt: less than 小于
lte: less than or equal 小于等于
示例
tn>2 and tn <=9
<if test="request.tn gt 2 and request.tn lte 9">
AND aging.${request.durationField}=#{request.tn}
</if>