mybatis的trim的使用

一、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>