mybatis批量操作

最新推荐文章于 2023-02-08 22:33:51 发布

CxToBj

最新推荐文章于 2023-02-08 22:33:51 发布

阅读量91

点赞数

分类专栏： SpringBoot

本文链接：https://blog.csdn.net/lang09/article/details/103141460

版权

SpringBoot 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

//myBatis批量更新(此接口传入的参数是List<Map m > 类型)
<update id="upherbsCount" parameterType="java.util.List">
          <foreach collection="list" separator=";" item="cus">
                update herbscount set  herbs_count = herbs_count+1,update_time = #{cus.updateTime,jdbcType=TIMESTAMP}
                where hospital_id = #{cus.unit_id} and patient_id = #{cus.patientId} and herbs_company_id = #{cus.herbsCompanyId} and year(create_time) = #{cus.byYear}  and is_delete=0
          </foreach>
    </update>
    //myBatis批量插入
   （此接口插入的是参数是list<Map m> 类型）
    <insert id="addHerbsCount" parameterType="java.util.List">
        insert into herbscount (id, hospital_id, patient_id,
        herbs_company_id, herbs_count, update_time,
        create_time, is_delete
        )
        values
        <foreach collection="list" index="index" item="countherbs" open="(" separator="),(" close=")">
            #{countherbs.id,jdbcType=VARCHAR}, #{countherbs.unit_id,jdbcType=VARCHAR}, #{countherbs.patientId,jdbcType=VARCHAR},
            #{countherbs.herbsCompanyId,jdbcType=VARCHAR}, #{countherbs.herbsCount,jdbcType=INTEGER},
            #{countherbs.updateTime,jdbcType=TIMESTAMP}, #{countherbs.createTime,jdbcType=TIMESTAMP},  #{countherbs.isDelete,jdbcType=INTEGER}
        </foreach>
    </insert>