最近在学习mybatis<trim suffixOverrides="," >
<if test="name != null and name != '' ">
name=#{name},
</if>
<if test="sex != null ">
sex=#{sex},
</if>
<if test="age != null ">
age=#{age},
</if>
<if test="remark != null and remark != '' ">
remark=#{remark},
</if>
</trim> where id=#{id}
<if test="name != null and name != '' ">
name=#{name},
</if>
<if test="sex != null ">
sex=#{sex},
</if>
<if test="age != null ">
age=#{age},
</if>
<if test="remark != null and remark != '' ">
remark=#{remark},
</if>
</trim> where id=#{id}
这样就可以去掉多余的那个‘,’
http://mybatis.github.io/mybatis-3/zh/dynamic-sql.html官方文档