springboot集成druid连接池不支持批量更新

原因：Druid的防火墙配置(WallConfig)中变量multiStatementAllow默认为false；

解决方案：设置Druid的防火墙配置(WallConfig)中变量multiStatementAllow=true，新建DruidDataSource配置类

配置类代码：

1@Configuration
2public class DataSourceConfig {
3
4    @Autowired
5    WallFilter wallFilter;
6
7    @Bean    //声明其为Bean实例
8    @Primary  //在同样的DataSource中，首先使用被标注的DataSource
9    @ConfigurationProperties(prefix = "spring.datasource")
10    public DataSource dataSource(){
11        DruidDataSource datasource = new DruidDataSource();
12
13        // filter
14        List<Filter> filters = new ArrayList<>();
15        filters.add(wallFilter);
16        datasource.setProxyFilters(filters);
17
18        return datasource;
19    }
20
21    @Bean(name = "wallFilter")
22    @DependsOn("wallConfig")
23    public WallFilter wallFilter(WallConfig wallConfig){
24        WallFilter wallFilter = new WallFilter();
25        wallFilter.setConfig(wallConfig);
26        return wallFilter;
27    }
28
29    @Bean(name = "wallConfig")
30    public WallConfig wallConfig(){
31        WallConfig wallConfig = new WallConfig();
32        wallConfig.setMultiStatementAllow(true);//允许一次执行多条语句
33        wallConfig.setNoneBaseStatementAllow(true);//允许一次执行多条语句
34        return wallConfig;
35    }
36
37}

然后修改sql连接url路径：声明allowMultiQueries=true；参考路径方式：

url: jdbc:mysql://localhost:3306/ies? allowMultiQueries=true&autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=Hongkong

就此，问题解决。