mybatis批量操作

最新推荐文章于 2023-03-20 16:28:50 发布

zhangsan9527

最新推荐文章于 2023-03-20 16:28:50 发布

阅读量200

点赞数

本文链接：https://blog.csdn.net/zhangsan9527/article/details/106302598

版权

mybatis 批量操作
add

//mapper 接口
Integer add(@Param("ids") List<User> ids);
//sql
<insert id="add" >
        insert into
        user_info(
        id,
        name)
        values
        <foreach collection="ids" item="item" separator=",">
            (#{item.id},
            #{item.name})
        </foreach>
    </insert>

update

@Data
@ApiModel
public class BatchDTO implements Serializable {

    private static final long serialVersionUID = -2200320124239531727L;
    @ApiModelProperty("是否删除 0 删除 1正常")
    private Integer isDelete;

    @ApiModelProperty("1 启用 0禁用")
    private Integer states;
    @ApiModelProperty("id数组")
    private List<Integer> ids;
    
    }
    
int batchUpdate(BatchDTO batchDTO);
 <update id="batchUpdate">
        update user_info
        <set>
            <if test="isDelete !=null">
                is_delete=#{isDelete},
            </if>
            <if test="states !=null">
                states=#{states}
            </if>
        </set>
        where id in
        <foreach collection="ids" item="item" open="(" close=")" separator=",">
            #{item}
        </foreach>
    </update>