prefixOverrides 属性会忽略通过管道分隔的文本序列(注意此例中的空格也是必要的)。它的作用是移除所有指定在 prefixOverrides 属性中的内容,并且插入 prefix 属性中指定的内容。(注意 prefixOverrides 单词不能写错,包括大小写,否则会报错)。 prefix Overrides——>前缀 覆盖
<select id="selectNotificDynamic1" resultType="com.domain.entity.Notific">
SELECT * FROM Notific
<trim prefix="where" prefixOverrides="and |or">
<if test="method != null">
and Method = #{method,jdbcType=VARCHAR}
</if>
<if test="statusOfread != null">
and StatusOfread = #{statusOfread,jdbcType=VARCHAR}
</if>
</trim>
</select>
参数
String statusOfread = "0"; | String statusOfread = ""; | String statusOfread = "0"; |
String method = "PUSH"; | String method = "PUSH"; | String method = ""; |
sql语句为
SELECT * FROM Notific where Method = ? and StatusOfread = ? |
参数
String statusOfread = null; |
String method = "PUSH"; |
sql语句
SELECT * FROM Notific where Method = ? |
参数
String statusOfread = "0"; |
String method = null; |
sql语句
SELECT * FROM Notific where StatusOfread = ? |
参考文档 地址