mybatis

最新推荐文章于 2024-08-21 23:39:15 发布

猪思马记

最新推荐文章于 2024-08-21 23:39:15 发布

阅读量112

点赞数

分类专栏： java mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/mazuyu408/article/details/107296966

版权

java 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

mybatis

2 篇文章 0 订阅

订阅专栏

1、mybatis批量插入数据信息

<insert id="insertMoreEmpOrg"  parameterType="java.util.List">
    INSERT INTO
    hr_emp_org(EMPID,ORGID,ISMAN, UPDATETIME)
    VALUES
    <foreach collection="empOrgList" item="item" separator=",">
        (#{item.empid},#{item.orgid},#{item.isman},#{item.updatetime})
    </foreach>
</insert>

2、mybatis批量修改数据信息

<update id="updateMoreEmpJob" parameterType="java.util.List">
    update hr_emp_job
    <trim prefix="set" suffixOverrides=",">
        <trim prefix="INDATE =case EMPID" suffix="end,">
            <foreach collection="empJobList" item="item" index="index">
                <if test="item.indate != null">
                    when #{item.empid} then #{item.indate}
                </if>
            </foreach>
        </trim>
。。。。。
        <trim prefix="ORGID =case EMPID" suffix="end,">
            <foreach collection="empJobList" item="item" index="index">
                <if test="item.orgid != null">
                    when #{item.empid} then #{item.orgid}
                </if>
            </foreach>
        </trim>
        
    </trim>
    where
    EMPID in
    <foreach collection="empJobList" item="item" open="(" separator="," close=")">
        #{item.empid}
    </foreach>
</update>

3、mybatis批量修改数据信息（联合主键）

<update id="updateMoreEmpOrg" parameterType="java.util.List">
    update hr_emp_org
    <trim prefix="set" suffixOverrides=",">
        <trim prefix="ISMAN = CASE" suffix="end,">
            <foreach collection="empOrgList" item="item" index="index">
                <if test="item.isman != null">
                    when EMPID = #{item.empid} and ORGID = #{item.orgid} then #{item.isman}
                </if>
            </foreach>
        </trim>
        <trim prefix="UPDATETIME = CASE" suffix="end,">
            <foreach collection="empOrgList" item="item" index="index">
                <if test="item.updatetime != null">
                    when EMPID = #{item.empid} and ORGID = #{item.orgid}then #{item.updatetime}
                </if>
            </foreach>
        </trim>
    </trim>
    where
    EMPID in
    <foreach collection="empOrgList" item="item" open="(" separator="," close=")">
        #{item.empid}
    </foreach>