mybatis的trim标签insert标签update标签

<insert id="insert" parameterType="com.tortuousroad.groupon.cart.entity.Cart">
 insert into cart
 <trim prefix="(" suffix=")" suffixOverrides=",">
     <if test="id != null">
         id,
     </if>
     <if test="userId != null">
         user_id,
     </if>
     <if test="count != null">
         count,
     </if>
     <if test="createTime != null">
         create_time,
     </if>
     <if test="updateTime != null">
         update_time,
     </if>
 </trim>
 <trim prefix="values (" suffix=")" suffixOverrides=",">
     <if test="id != null">
         #{id,jdbcType=BIGINT},
     </if>
     <if test="userId != null">
         #{userId,jdbcType=BIGINT},
     </if>
     <if test="count != null">
         #{count,jdbcType=INTEGER},
     </if>
     <if test="createTime != null">
         #{createTime,jdbcType=TIMESTAMP},
     </if>
     <if test="updateTime != null">
         #{updateTime,jdbcType=TIMESTAMP},
     </if>
 </trim>
</insert>

<update id="update" parameterType="com.bank.vo.Pledge">
  update bank_pledge
  <trim prefix="set" suffixOverrides=",">
    <if test="certificate!=null">
      certificate=#{certificate,jdbcType=VARCHAR},
    </if>
  </trim>
  where id=#{id}
</update>