mybatis批量update時報錯multi-statement not allow的問題

更新時間：2023年10月12日 09:04:01 作者：不會程序的JAVA程序媛

這篇文章主要介紹了mybatis批量update時報錯multi-statement not allow的問題及解決方案,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教

原因

mysql默認不支持批量更新

Druid的multiStatementAllow默認是false

解決方案

方法一

修改application配置

spring.datasource.url 后面加上 &allowMultiQueries=true
如果配置了druid 注釋掉 filters: wall，加上
filter:
wall:
config:
multi-statement-allow: true
none-base-statement-allow: true

參考如下

spring:
  #mysql
  datasource:
    url: jdbc:xxx&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true&allowMultiQueries=true
    username: xxx
    password: xxx
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    #druid
    druid:
#      filters: wall
      filter:
        wall:
          config:
            multi-statement-allow: true
            none-base-statement-allow: true

方法二

添加一個DruidConfig類

package com.song.config;
import com.alibaba.druid.filter.Filter;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.wall.WallConfig;
import com.alibaba.druid.wall.WallFilter;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
import java.util.ArrayList;
import java.util.List;
/**
 * @author anatre
 * @date 2020.06.04
 */
@Configuration
public class DruidConfig {
    @Bean
    @ConfigurationProperties (prefix="spring.datasource")
    public DataSource druidPrimary(){
        DruidDataSource druidDataSource = new  DruidDataSource();
        List<Filter> filterList = new ArrayList<> ();
        filterList.add(wallFilter());
        druidDataSource.setProxyFilters(filterList);
        return new DruidDataSource();
    }
    @Bean
    public WallFilter wallFilter(){
        WallFilter wallFilter = new WallFilter();
        wallFilter.setConfig(wallConfig());
        return wallFilter;
    }
    @Bean
    public WallConfig wallConfig() {
        WallConfig config = new WallConfig();
        //允許一次執(zhí)行多條語句
        config.setMultiStatementAllow(true);
        config.setNoneBaseStatementAllow(true);
        return config;
    }
}