Mybatis 选择插入，选择更新 Update insert Mapper示例

最新推荐文章于 2024-04-17 14:01:30 发布

weixin_33795743

最新推荐文章于 2024-04-17 14:01:30 发布

阅读量1.6k

点赞数

文章标签： java python 数据库

原文链接：https://my.oschina.net/zjllovecode/blog/1814344

版权

2019独角兽企业重金招聘Python工程师标准>>>

<update id="updateMethod" parameterType="com.zjl.domain">
    update table_name
    <set>
      <if test="id != null">
        id = #{id,jdbcType=BIGINT},
      </if>
      <if test="creater != null">
        creater = #{creater,jdbcType=VARCHAR},
      </if>
      <if test="modifiedDate != null">
        modified_date = #{modifiedDate,jdbcType=TIMESTAMP},
      </if>
    </set>
    where task_id = #{taskId,jdbcType=BIGINT}
  </update>

<insert id="insertSelective" parameterType="com.zjl.domain">
    insert into table_name
    <trim prefix="(" suffix=")" suffixOverrides=",">
    <if test="id != null">
    id,
    </if>
    <if test="createDate != null">
    create_date,
    </if>
    <if test="modifiedDate != null">
    modified_date,
    </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
    <if test="id != null">
    #{id,jdbcType=BIGINT},
    </if>
    <if test="createDate != null">
    #{createDate,jdbcType=TIMESTAMP},
    </if>
    <if test="modifiedDate != null">
    #{modifiedDate,jdbcType=TIMESTAMP},
    </if>
    </trim>
</insert>

转载于:https://my.oschina.net/zjllovecode/blog/1814344