1.if
用于字段条件判断
属性:
test
2. trim
完成set或者是where标记的功能
属性:
前缀:prefix
去掉第一个标记:prefixoverride
后缀:suffix
去掉最后一个标记:suffixoverride
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"> gender=#{gender} , </if>
</trim>