<trim>: prefix+prefixOverrides+suffix+suffixOverrides

[html]  view plain  copy

1. <trim prefix="where" prefixOverrides="where" suffixOverrides="and">  
2.           <if test="select_items != null">  
3.               ID = #{select_items,jdbcType=VARCHAR}  
4.               or HOME_URL = #{select_items,jdbcType=VARCHAR}  
5.               or CHIEF = #{select_items,jdbcType=VARCHAR}  
6.               or CONTACT_PERSON = #{select_items,jdbcType=VARCHAR}  
7.               and  
8.           </if>  
9.           <if test="groupName != null">  
10.               GROUP_NAME = #{groupName,jdbcType=VARCHAR}  
11.           </if>  
12. </trim>  

prefix : 给<trim>包裹的sql语句加上前缀.

suffix : 给<trim>包裹的sql语句加上后缀.

prefixOverrides: 如果<trim>包裹的sql语句是空语句（经常出现在 if 判断为否的情况下）,取消指定的前缀，如where.

suffixOverrides: 如果<trim>包裹的sql语句是空语句（经常出现在 if 判断为否的情况下）,取消指定的后缀，如and | or. 逗号等

\.

来源： https://blog.csdn.net/u011568312/article/details/52329497