一、mybatis的trim的主要参数
1、prefix=添加前缀 ;
2、suffix=添加后缀;
3、prefixOverrides=去掉前缀 ;
4、suffixOverrides=去掉后缀
二、trim的使用
1、insert的使用
<insert id="insert" parameterType="UserBo" useGeneratedKeys="true"> INSERT INTO sys_user <trim prefix="(" suffix=")" suffixOverrides="," > create_time, update_time, is_deleted, <if test="name != null and name != ''"> `name`, </if> <if test="type != null"> type, </if> <if test="remark != null and remark != ''"> remark, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides="," > NOW(), NOW(), 0, <if test="name != null and name != ''"> #{name}, </if> <if test="type != null"> #{type}, </if> <if test="remark != null and remark != ''"> #{remark}, </if> </trim> </insert>
2、update的使用
<update id="updateUserInfo" parameterType="cn.scdn.pojo.User"> update sys_user <trim prefix="set" suffix="where id =#{id }" suffixOverrides=","> <if test="userName != null and userName != ''"> user_name =#{userName}, </if> <if test="password != null and password !=''"> password = #{password}, </if> <if test="remark != null and remark != ''"> remark =#{remark}, </if> </trim> </update>