如图:合理运用动态sql,也可随意控制插入字段信息,代码中只对appVersion和userMobile赋值,
<insert id="insertDataPointInfo" keyColumn="id" keyProperty="id" useGeneratedKeys="true">
INSERT INTO data_point_info
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
id,
</if>
<if test="itemId != null">
item_id,
</if>
<if test="distinctId != null">
distinct_id,
</if>
<if test="userId != null">
user_id,
</if>
<if test="username != null">
user_name,
</if>
<if test="userMobile != null">
user_mobile,
</if>
<if test="os != null">
os,
</if>
<if test="osVersion != null">
os_version,
</if>
<if test="appVersion != null">
app_version,
</if>
<if test="ip!= null">
ip,
</if>
<if test="opTime!= null">
op_time,
</if>
</trim>
VALUES
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">
#{id,jdbcType=INTEGER},
</if>
<if test="itemId != null">
#{itemId,jdbcType=INTEGER},
</if>
<if test="distinctId != null">
#{distinctId,jdbcType=VARCHAR},
</if>
<if test="userId != null">
#{userId,jdbcType=VARCHAR},
</if>
<if test="username != null">
#{username,jdbcType=VARCHAR},
</if>
<if test="userMobile != null">
#{userMobile,jdbcType=VARCHAR},
</if>
<if test="os != null">
#{os,jdbcType=VARCHAR},
</if>
<if test="osVersion != null">
#{osVersion,jdbcType=VARCHAR},
</if>
<if test="appVersion != null">
#{appVersion,jdbcType=VARCHAR},
</if>
<if test="ip != null">
#{ip,jdbcType=VARCHAR},
</if>
<if test="opTime != null">
#{opTime},
</if>
</trim>
</insert>
联系客服