Mybatis中的trim

prefix=""是在前面添加东西
suffix=""实在后面添加东西
prefixOverrides="" 是去除前面的东西
suffixOverrides=""是去除后面的东西
trim 也可以代替where set 标签 prefix="where"在前面添加where查询时可以用到suffix="where"，prefix="set"在后面添加where在前面添加set修改时可以用到

如：

<update id="updateStudent3">
  update student
    <trim prefix="set"  prefixOverrides="," suffixOverrides="," suffix="where">
      <if test="stuname!=null ">stuname = #{stuname},</if>
      <if test="stusex != null"> ,stusex = #{stusex}</if>
    </trim>
   stuid = #{stuid}
</update>

<select id="findAllStudent1" resultMap="BaseResultMap" parameterType="com.phf.entity.Student">
  select * from student
  <trim prefix="where" prefixOverrides="and|or">
        <if test="stuid!=null">stuid = #{stuid}</if>
        <if test="stuname!=null and stuname !=''">and stuname = #{stuname}</if>
  </trim>
</select>