mybatis判断不同数据源走不同sql

把下面配置放到启动类中
@Bean
public DatabaseIdProvider getDatabaseIdProvider() {
DatabaseIdProvider databaseIdProvider = new VendorDatabaseIdProvider();
Properties properties = new Properties();
properties.setProperty(“Oracle”, “oracle”);
properties.setProperty(“MySQL”, “mysql”);
properties.setProperty(“SqlServer”,“sqlserver”);
databaseIdProvider.setProperties(properties);
return databaseIdProvider;
}

之后在xml中可以使用databaseId = “mysql” 属性