Java微服务分布式分库分表ShardingSphere - ShardingSphere-JDBC

@Configuration
public class ShardingSphereConfig {

    @Bean
    public DataSource dataSource() {
        // 配置真实数据源
        Map<String, DataSource> dataSourceMap = new HashMap<>();
        // 配置第一个数据源
        BasicDataSource dataSource1 = new BasicDataSource();
        dataSource1.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource1.setUrl("jdbc:mysql://localhost:3306/ds0");
        dataSource1.setUsername("root");
        dataSource1.setPassword("");
        dataSourceMap.put("ds0", dataSource1);

        // 配置第二个数据源
        BasicDataSource dataSource2 = new BasicDataSource();
        dataSource2.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource2.setUrl("jdbc:mysql://localhost:3306/ds1");
        dataSource2.setUsername("root");
        dataSource2.setPassword("");
        dataSourceMap.put("ds1", dataSource2);

        // 配置Order表规则，即分库策略
        ShardingStrategy shardingStrategy = new InlineShardingStrategy("user_id", "ds${user_id % 2}");
        TableRuleConfig orderTableRuleConfig = new TableRuleConfigBuilder("t_order")
                .setDatabaseShardingStrategyConfig(new InlineShardingStrategyConfiguration("user_id", "ds${user_id % 2}")).build();

        // 配置分片规则
        ShardingRuleConfiguration shardingRuleConfig = new ShardingRuleConfiguration();
        shardingRuleConfig.getTableRuleConfigs().add(orderTableRuleConfig);
        shardingRuleConfig.getBindingTableGroups().add("binding_table_group");
        shardingRuleConfig.getBroadcastTables().add("broadcast_table");

        // 配置OrderItem表规则，即分表策略
        TableRuleConfiguration orderItemTableRuleConfig = new TableRuleConfigBuilder("t_order_item")
                .setTableShardingStrategyConfig(new StandardShardingStrategyConfiguration("order_id", shardingStrategy)).build();
        shardingRuleConfig.getTableRuleConfigs().add(orderItemTableRuleConfig);

        // 获取ShardingSphereDataSource
        return ShardingSphereDataSourceFactory.createDataSource(dataSourceMap, Collections.singleton(shardingRuleConfig), new Properties());
    }
}