ruoyi-cloud配置shardingjdbc

<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>shardingsphere-jdbc-core</artifactId>
    <version>5.0.0</version>
</dependency>

dataSources:
  # 主数据源
  db_master:
    url: jdbc:mysql://localhost:3306/db_master?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

  # 分片数据源1
  db_shard_1:
    url: jdbc:mysql://localhost:3306/db_shard_1?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

  # 分片数据源2
  db_shard_2:
    url: jdbc:mysql://localhost:3306/db_shard_2?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

rules:
  # 分库分表规则
  - !SHARDING
    tables:
      # 分表规则
      user:
        actualDataNodes: db${0..1}.user_${0..1}
        tableStrategy:
          standard:
            shardingColumn: user_id
            shardingAlgorithmName: userShardingAlgorithm

public class UserShardingAlgorithm implements ShardingAlgorithm<String> {

    @Override
    public Collection<String> doSharding(Collection<String> availableTargetNames, ShardingValue<String> shardingValue) {
        Collection<String> shardingResult = new LinkedHashSet<>();
        for (String value : shardingValue.getValues()) {
            for (String tableName : availableTargetNames) {
                if (tableName.endsWith("_" + Math.abs(value.hashCode()) % 2)) {
                    shardingResult.add(tableName);
                }
            }
        }
        return shardingResult;
    }
}

@Configuration
public class ShardingSphereConfig {

    @Bean
    public DataSource dataSource() throws SQLException {
        return ShardingDataSourceFactory.createDataSource(
                new ClassPathResource("sharding.yml").getInputStream());
    }
}