mybatisplus通用批量修改

最新推荐文章于 2024-08-31 18:44:22 发布

布蕾烧仙草

最新推荐文章于 2024-08-31 18:44:22 发布

阅读量2.4k

点赞数

分类专栏： mybatisplus

本文链接：https://blog.csdn.net/sinat_40761705/article/details/127843417

版权

MyBatis 批量修改 SQL动态构建 MyUpdateListSelectiveMethod 分批更新

关键词由CSDN通过智能技术生成

mybatisplus 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

准备工作见上一篇批量插入

根据id批量修改

import com.baomidou.mybatisplus.core.injector.AbstractMethod;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.SqlSource;

/**
 * @author  xiu
 * @date  2022/1/27 11:13
 * @description 根据id批量修改
 */
public class MyUpdateListSelectiveMethod extends AbstractMethod {

    public MyUpdateListSelectiveMethod(String methodName) {
        super(methodName);
    }

    @Override
    public MappedStatement injectMappedStatement(Class<?> mapperClass, Class<?> modelClass, TableInfo tableInfo) {
        StringBuilder sql = new StringBuilder();
        sql.append("<script>\n");
        sql.append("<foreach collection=\"records\" item=\"record\" index=\"index\" open=\"\" close=\"\" separator=\";\">");
        sql.append(" UPDATE ");
        sql.append(tableInfo.getTableName());
        sql.append(this.sqlSet(true, false, tableInfo, true, "record", "record."));
        sql.append(" WHERE ");
        sql.append(String.format(" %s=#{%s} ", tableInfo.getKeyColumn(), "record." + tableInfo.getKeyProperty()));
        sql.append("</foreach>");
        sql.append("\n</script>");
        SqlSource sqlSource = this.languageDriver.createSqlSource(this.configuration, sql.toString(), modelClass);
        return this.addUpdateMappedStatement(mapperClass, modelClass, sqlSource);
    }
}