prefix:前缀(在前面加上的东西)
prefixOverrides:去掉第一个什么(如果第一个是什么,则去掉)
suffix:后缀(在后面加上什么)
suffixOverrides:去掉后缀(如果最后一个是什么,则去掉)
select * from user
<trim prefix="WHERE" prefixoverride="AND |OR">
<if test="name != null and name.length()>0"> AND name=#{name}</if>
<if test="gender != null and gender.length()>0"> AND gender=#{gender}</if>
</trim>
update user
<trim prefix="set" suffixoverride="," suffix=" where id = #{id} ">
<if test="name != null and name.length()>0"> name=#{name} , </if>
<if test="gender != null and gender.length()>0"> AND gender=#{gender} , </if>
</trim>