特殊字符 替代符号
& &
< <
> >
" "
' '
小于等于 a<=b a <= b a <![CDATA[<= ]]>b
大于等于 a>=b a >= b a <![CDATA[>= ]]>b
不等于 a!=b a <![CDATA[ <> ]]>b a <![CDATA[!= ]]>b
例子:<if test="provinceId != null">
AND <![CDATA[ province_id = #{provinceId} ]]>
</if>
<if test="id != null">
AND <![CDATA[ id <> #{id} ]]>
</if>
实例
<where> delete_falt = 1 //这是查询删除标识为1的信息
<if test="newsSystemParam.beginTime != null">
AND create_time >= #{newsSystemParam.beginTime}
</if>
<if test="newsSystemParam.endTime != null">
AND create_time <= #{newsSystemParam.endTime}
</if>
<if test="newsSystemParam.titleAndContent != null and newsSystemParam.titleAndContent != ''">
AND (title LIKE concat('%',#{newsSystemParam.titleAndContent},'%'))
OR (content LIKE concat('%',#{newsSystemParam.titleAndContent},'%'))
</if>
</where>