trim 属性:
prefix:前缀覆盖并增加其内容
suffix:后缀覆盖并增加其内容
prefixOverrides:前缀判断的条件
suffixOverrides:后缀判断的条件
trim元素的主要功能是可以在自己包含的内容钱加上某些前缀,也可以在其后加上某写后缀,与之对应的属性是prefix和suffix;可以把包含内容的首部某些内容覆盖,即忽略,也可以把尾部的某些内容覆盖,对应的属性是prefixOverrides和suffixOverrides。
注意语句之中不要出现中文的空格或换行符号。
例1:
<select id="queryListByTrim" parameterType="com.message.bean.Message" resultMap="MessageResult">
select * from message
<trim prefix="WHERE" prefixOverrides="AND|OR">
<if test="description != null"> AND DESCRIPTION=#{description} </if>
<if test="command != null"> AND COMMAND=#{command} </if>
</trim>
</select>
生成语句:
select * from message WHERE COMMAND=?
例2:
<update id="updateByTrim" parameterType="com.message.bean.Message">
update message
<trim prefix="set" suffixOverrides="," suffix="where id = #{id} ">
<if test="description != null and description.length()>0">DESCRIPTION=#{description},</if>
<if test="command != null and command.length()>0">COMMAND = #{command,jdbcType=VARCHAR},</if>
</trim>
</update>
生成语句:
update message set COMMAND = ? where id = ?
例3:
<insert id="insertByTrim" parameterType="com.message.bean.Message">
INSERT INTO message
<trim prefix="(" suffix=")" suffixOverrides=",">
ID,
<if test="command != null">COMMAND,</if>
<if test="description != null">DESCRIPTION,</if>
<if test="content != null">CONTENT,</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
null,
<if test="command != null">#{command,jdbcType=VARCHAR},</if>
<if test="description != null">#{description,jdbcType=VARCHAR},</if>
<if test="content != null">#{content,jdbcType=VARCHAR},</if>
</trim>
</insert>
生成语句:
INSERT INTO message ( ID, COMMAND, DESCRIPTION, CONTENT ) values ( null, ?, ?, ? )