mybatis 标签使用

<trim prefix="(" suffix=")" suffixOverrides=","></trim>

释: 
	prefix: 在trim标签内的sql加上前缀
    suffix: 在trim标签内的sql加上后缀
	prefixOverrides: 在trim标签内的sql去掉多余的前缀
	suffixOverrides: 在trim标签内的sql去掉多余的后缀

eg:

<!--新增-->
insert into user
<trim prefix="(" suffix=")" suffixOverrides=",">
	<if test="userName!= null and userName != '' ">user_name,</if>
	<if test="headPic != null  and headPic != '' ">head_pic,</if>
</trim>	
<trim prefix="values (" suffix=")" suffixOverrides=",">
	<if test="userName != null and userName != '' ">#{userName },</if>
	<if test="headPic != null  and headPic != '' ">#{headPic},</if>
</trim>	

<!--修改-->
update project_case
<trim prefix="SET" suffixOverrides=",">
	<if test="userName != null and userName != '' ">user_name = #{userName},</if>
</trim>