只需更改 sharding 的配置策略 (inline 表达式配置文件如下),其他代码不变
<sharding:inline-strategy id="idlineShardingStrategy" sharding-column="id"
algorithm-expression="t_manager_${id % 2}"/>
<sharding:data-source id="shardingDataSource">
<!--因为我只有一张表。所以就只需要配置一个dataSource-->
<sharding:sharding-rule data-source-names="dataSource" default-data-source-name="dataSource">
<sharding:table-rules>
<!--logic-tables逻辑表名: 逻辑表名 其实就是 sql 中 写的表名称-->
<sharding:table-rule logic-table="t_manager"
actual-data-nodes="dataSource.t_manager_0,dataSource.t_manager_1"
table-strategy-ref="idlineShardingStrategy" generate-key-column="id"
column-key-generator-class="com.study.algorithm.IdKeyGenerator"/>
</sharding:table-rules>
<sharding:binding-table-rules>
<sharding:binding-table-rule logic-tables="t_manager"/>
</sharding:binding-table-rules>
</sharding:sharding-rule>
<sharding:props>
<prop key="sql.show">true</prop>
</sharding:props>
</sharding:data-source>