useGeneratedKeys="true" keyProperty="id">

sql全部内容:

<insert id="insertSelective" parameterType="com.gblfy.mall.pojo.Shipping" useGeneratedKeys="true" keyProperty="id">
insert into mall_shipping
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
id,
</if>
<if test="userId != null">
user_id,
</if>
<if test="receiverName != null">
receiver_name,
</if>
<if test="receiverPhone != null">
receiver_phone,
</if>
<if test="receiverMobile != null">
receiver_mobile,
</if>
<if test="receiverProvince != null">
receiver_province,
</if>
<if test="receiverCity != null">
receiver_city,
</if>
<if test="receiverDistrict != null">
receiver_district,
</if>
<if test="receiverAddress != null">
receiver_address,
</if>
<if test="receiverZip != null">
receiver_zip,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id != null">
#{id,jdbcType=INTEGER},
</if>
<if test="userId != null">
#{userId,jdbcType=INTEGER},
</if>
<if test="receiverName != null">
#{receiverName,jdbcType=VARCHAR},
</if>
<if test="receiverPhone != null">
#{receiverPhone,jdbcType=VARCHAR},
</if>
<if test="receiverMobile != null">
#{receiverMobile,jdbcType=VARCHAR},
</if>
<if test="receiverProvince != null">
#{receiverProvince,jdbcType=VARCHAR},
</if>
<if test="receiverCity != null">
#{receiverCity,jdbcType=VARCHAR},
</if>
<if test="receiverDistrict != null">
#{receiverDistrict,jdbcType=VARCHAR},
</if>
<if test="receiverAddress != null">
#{receiverAddress,jdbcType=VARCHAR},
</if>
<if test="receiverZip != null">
#{receiverZip,jdbcType=VARCHAR},
</if>
</trim>
</insert>