例:如下为插入用户关注记录,获取主键 fid:
<insert id="insertUserFollow" parameterType="com.ygxk.social.modules.user.entity.UserFollowEntity" useGeneratedKeys="true" keyProperty="fid" keyColumn="fid">
insert into user_follow
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="uid != null">
uid,
</if>
<if test="oid != null">
oid,
</if>
<if test="followTime != null">
followTime,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="uid != null">
#{uid,jdbcType=BIGINT},
</if>
<if test="oid != null">
#{oid,jdbcType=BIGINT},
</if>
<if test="followTime != null">
#{followTime,jdbcType=INTEGER},
</if>
</trim>
</insert>