Mybatis中循环执行SQL中存在就更新，不存在就插入代码！！！

最新推荐文章于 2023-06-27 15:33:40 发布

樱花味的小奶牛

最新推荐文章于 2023-06-27 15:33:40 发布

阅读量656

点赞数 1

本文链接：https://blog.csdn.net/WSSQYHW/article/details/90368634

版权

<insert id="all">
        <foreach collection="workno" item="item" index="index"  separator=";">
            IF EXISTS(SELECT * FROM busness_labortime WHERE   userid = (SELECT id FROM base_user WHERE username = #{item.workno}) AND orderno = #{orderno})
            BEGIN
            UPDATE busness_labortime SET worktime=worktime  WHERE username = #{item.workno}) AND orderno = #{orderno}
            END
            ELSE
            BEGIN
            INSERT INTO busness_labortime (userid, cdate, worktime, cuserid, orderid, orderno)
            VALUES((SELECT id FROM base_user WHERE username = #{item.workno}),getdate(),0,#{userid},(SELECT id FROM busness_product_order WHERE orderno = #{orderno}),#{orderno})
            END
        </foreach>
    </insert>

测试有效，值得使用