1、在jdbc连接的url中加入
&allowMultiQueries=true
2、在druid 配置中设置如下
@Bean
@ConfigurationProperties("spring.datasource.druid")
public DataSource druid() {
DruidDataSource dataSource=new DruidDataSource();
List<Filter> list=new ArrayList<>();
WallFilter wallFilter=new WallFilter();
WallConfig config = new WallConfig();
//允许一次执行多条语句
config.setMultiStatementAllow(true);
//允许非基本语句的其他语句
//config.setNoneBaseStatementAllow(true);
wallFilter.setConfig(config);
list.add(wallFilter);
dataSource.setProxyFilters(list);
return dataSource;
}