动态 SQL ——之—— prefixOverrides & prefix

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 = ?

---

---

 参考文档 地址