mysql 批量添加和批量修改

最新推荐文章于 2024-06-04 09:48:22 发布

zengwenhe1987

最新推荐文章于 2024-06-04 09:48:22 发布

阅读量749

点赞数

分类专栏： mySql

本文链接：https://blog.csdn.net/qq_36357608/article/details/103013943

版权

mySql 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

以该表为例

批量添加语句：

INSERT INTO power_role(

role_id,

role_name,

effective,

create_date,

creater,

update_date,

updater,

remark

)

VALUES

(

#{item.roleId,jdbcType=INTEGER},

#{item.roleName,jdbcType=VARCHAR},

#{item.effective,jdbcType=INTEGER},

#{item.createDate,jdbcType=CHAR},

#{item.creater,jdbcType=VARCHAR},

#{item.updateDate,jdbcType=CHAR},

#{item.updater,jdbcType=VARCHAR},

#{item.remark,jdbcType=VARCHAR}

)

</foreach >

</insert>

批量修改：

<!--批量更新-->
<update id="SimpleUpdate" parameterType="java.util.List">
  <foreach collection="list" item="items" separator=";">
      update t_diag
      <set>
        <if test="items.diagCode != null" >
          diag_code = #{items.diagCode,jdbcType=VARCHAR},
        </if>
        <if test="items.diagName != null" >
          diag_name = #{items.diagName,jdbcType=VARCHAR},
        </if>
        <if test="items.diagType != null" >
          diag_type = #{items.diagType,jdbcType=VARCHAR},
        </if>
        <if test="items.disThing != null" >
          dis_thing = #{items.disThing,jdbcType=VARCHAR},
        </if>
        <if test="items.pathologyCut != null" >
          pathology_cut = #{items.pathologyCut,jdbcType=VARCHAR},
        </if>
        <if test="items.xRay != null" >
          X_ray = #{items.xRay,jdbcType=VARCHAR},
        </if>
        <if test="items.operCode != null" >
          oper_code = #{items.operCode,jdbcType=VARCHAR},
        </if>
        <if test="items.operName != null" >
          oper_name = #{items.operName,jdbcType=VARCHAR},
        </if>
        <if test="items.operDate != null" >
          oper_date = #{items.operDate,jdbcType=TIMESTAMP},
        </if>
        <if test="items.singl != null" >
          singl = #{items.singl,jdbcType=VARCHAR},
        </if>
        <if test="items.createDate != null" >
          create_date = #{items.createDate,jdbcType=TIMESTAMP},
        </if>
        <if test="items.patAdmCondition != null" >
          pat_adm_condition = #{items.patAdmCondition,jdbcType=VARCHAR},
        </if>
        <if test="items.pid != null" >
          pid = #{items.pid,jdbcType=VARCHAR},
        </if>
        <if test="items.vid != null" >
          vid = #{items.vid,jdbcType=VARCHAR},
        </if>
        INHospStat = #{items.inhospstat,jdbcType=VARCHAR}
      </set>
      where patient_id = #{items.patientId} and diag_no = #{items.diagNo}
  </foreach>
</update>