sharding （三） inline表达式分片策略

只需更改 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>