【sql】带prefix和suffix的insert

<insert id="insert" parameterType="net.huadong.entity.CustomArea">
   insert into customer_area
   <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="areaName != null">
         area_name,
      </if>
      <if test="areaType != null">
         area_type,
      </if>
      <if test="isEnable != null">
         is_enable,
      </if>
      <if test="position != null">
         position,
      </if>
      <if test="remark != null">
         remark,
      </if>
   </trim>
   <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="areaName != null">
         #{areaName},
      </if>
      <if test="areaType != null">
         #{areaType},
      </if>
      <if test="isEnable != null">
         #{isEnable},
      </if>
      <if test="position != null">
         #{position},
      </if>
      <if test="remark != null">
         #{remark},
      </if>
   </trim>
</insert>

转载于:https://www.cnblogs.com/CESC4/p/7728314.html