shardingjdbc读写分离，分表不分库。

shardingjdbc读写分离，分表不分库。

设置1个主表。一个从表。

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="${jdbc.driver}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
</bean>

<bean id="read_dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="${jdbc.read.driver}"/>
    <property name="url" value="${jdbc.read.url}"/>
    <property name="username" value="${jdbc.read.username}"/>
    <property name="password" value="${jdbc.read.password}"/>

</bean>

<!-- 定义读写分离数据源, 读写分离数据源实现了DataSource接口, 可直接当做数据源处理 -->
<masterslave:data-source id="dataSource_0" master-data-source-name="dataSource" slave-data-source-names="read_dataSource" strategy-type="ROUND_ROBIN"/>




<!--分表策略，sharding-column这里根据order_id(这列属性不能是String,只能是整型)分表，OrderSingleKeyTableShardingAlgorithm是分表算法-->
<sharding:standard-strategy id="tableShardingStrategy" sharding-column="order_id"
precise-algorithm-class="com.os.buqu.algorithm.OrderSingleKeyTableShardingAlgorithm"/>

<sharding:data-source id="shardingDataSource">
    <!--因为我只有一张表。所以就只需要配置一个dataSource-->
    <sharding:sharding-rule data-source-names="dataSource_0" default-data-source-name="dataSource_0">
        <sharding:table-rules>
            <!--logic-tables逻辑表名-->
            <!--actual-data-nodes真实表名-->
            <sharding:table-rule logic-table="demo_order" actual-data-nodes="dataSource_0.demo_order_0,dataSource_0.demo_order_1"
                                 table-strategy-ref="tableShardingStrategy"/>
        </sharding:table-rules>
        <sharding:binding-table-rules>
            <!--logic-tables逻辑表名-->
            <sharding:binding-table-rule logic-tables="demo_order"/>
        </sharding:binding-table-rules>
    </sharding:sharding-rule>
</sharding:data-source>