【Mybatis】自动填充其它属性

小鸟不会费

于 2025-01-03 20:12:19 发布

阅读量126

点赞数 2

文章标签： mybatis

本文链接：https://blog.csdn.net/f_h_h/article/details/144917239

版权

    <insert id="addAndGet" keyColumn="incr_id" keyProperty="record.incrId" useGeneratedKeys="true">
        <selectKey keyProperty="record.incrId" resultType="long" order="BEFORE">
            select if(max(incr_id) is null, #{delta}, max(incr_id) + #{delta}) as newId from procurement_auto_increment where name = #{record.name} and state = #{record.state}
        </selectKey>

        INSERT INTO procurement_auto_increment (name, state , incr_id)
        values (#{record.name}, #{record.state}, #{delta})
        ON DUPLICATE key update incr_id = if(state = #{record.state}, ifnull(incr_id, 0) + #{delta}, #{delta} ), state = #{record.state}
    </insert>