shardingjdbc javaapi配置

Sharding-JDBC 是一款基于 JDBC 的轻量级 Java 框架，用于分库分表和读写分离场景中。下面是基于 Java API 的 Sharding-JDBC 配置示例：

1. 导入 Sharding-JDBC 相关依赖：

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

2. 创建 ShardingDataSource：

DataSourceRule dataSourceRule = new DataSourceRule(createDataSourceMap());
TableRule orderTableRule = TableRule.builder("t_order").actualTables(Arrays.asList("t_order_0", "t_order_1")).dataSourceRule(dataSourceRule).build();
TableRule orderItemTableRule = TableRule.builder("t_order_item").actualTables(Arrays.asList("t_order_item_0", "t_order_item_1")).dataSourceRule(dataSourceRule).build();
ShardingRule shardingRule = ShardingRule.builder().dataSourceRule(dataSourceRule).tableRules(Arrays.asList(orderTableRule, orderItemTableRule)).build();
DataSource dataSource = ShardingDataSourceFactory.createDataSource(shardingRule);

其中，`createDataSourceMap()` 方法用于创建数据源 Map：

private static Map<String, DataSource> createDataSourceMap() {
    Map<String, DataSource> dataSourceMap = new HashMap<>();
    dataSourceMap.put("ds_0", createDataSource("ds_0"));
    dataSourceMap.put("ds_1", createDataSource("ds_1"));
    return dataSourceMap;
}

private static DataSource createDataSource(final String dataSourceName) {
    // TODO: 创建数据源
}

3. 配置 Sharding-JDBC 分片策略：

ShardingRule shardingRule = ShardingRule.builder()
        .dataSourceRule(dataSourceRule)
        .tableRules(Arrays.asList(orderTableRule, orderItemTableRule))
        .databaseShardingStrategy(new DatabaseShardingStrategy("user_id", new ModuloDatabaseShardingAlgorithm()))
        .tableShardingStrategy(new TableShardingStrategy("order_id", new ModuloTableShardingAlgorithm()))
        .build();

其中，`ModuloDatabaseShardingAlgorithm` 和 `ModuloTableShardingAlgorithm` 分别为自定义的分库和分表算法。

4. 使用 ShardingDataSource 进行数据库操作：

try (Connection conn = dataSource.getConnection();
     PreparedStatement pstmt = conn.prepareStatement("INSERT INTO t_order (user_id, order_id) VALUES (?, ?)")) {
    pstmt.setInt(1, 1);
    pstmt.setInt(2, 1001);
    pstmt.executeUpdate();
}

以上就是基于 Java API 的 Sharding-JDBC 配置示例。