License

Build Status

主要贡献者

简介

整体架构图

相关文档

Quick Start

引入maven依赖

<!-- 引入sharding-jdbc核心模块--><dependency>    <groupId>com.dangdang</groupId>    <artifactId>sharding-jdbc-core</artifactId>    <version>${latest.release.version}</version></dependency>

规则配置

ShardingRuleshardingRule =newShardingRule(dataSourceRule,Arrays.asList(tableRule),newDatabaseShardingStrategy("sharding_column_1",newXXXShardingAlgorithm()),newTableShardingStrategy("sharding_column_2",newXXXShardingAlgorithm()));

使用原生JDBC接口

DataSourcedataSource =newShardingDataSource(shardingRule);Stringsql ="SELECT i.* FROM t_order o JOIN t_order_item i ON o.order_id=i.order_id WHERE o.user_id=? AND o.order_id=?";try (Connectionconn =dataSource.getConnection();PreparedStatementpreparedStatement =conn.prepareStatement(sql)) {preparedStatement.setInt(1,10);preparedStatement.setInt(2,1001);try (ResultSetrs =preparedStatement.executeQuery()) {while(rs.next()) {System.out.println(rs.getInt(1));System.out.println(rs.getInt(2));System.out.println(rs.getInt(3));        }    }}

使用Spring命名空间配置

<?xml version="1.0" encoding="UTF-8"?><beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:rdb="http://www.dangdang.com/schema/ddframe/rdb"xsi:schemaLocation="http://www.springframework.org/schema/beans                        http://www.springframework.org/schema/beans/spring-beans.xsd                        http://www.springframework.org/schema/context                        http://www.springframework.org/schema/context/spring-context.xsd                        http://www.dangdang.com/schema/ddframe/rdb                        http://www.dangdang.com/schema/ddframe/rdb/rdb.xsd">    <context:property-placeholderlocation="classpath:conf/rdb/conf.properties"ignore-unresolvable="true"/>        <beanid="dbtbl_0"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">        <propertyname="driverClassName"value="com.mysql.jdbc.Driver"/>        <propertyname="url"value="jdbc:mysql://localhost:3306/dbtbl_0"/>        <propertyname="username"value="root"/>        <propertyname="password"value=""/>    </bean>    <beanid="dbtbl_1"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">        <propertyname="driverClassName"value="com.mysql.jdbc.Driver"/>        <propertyname="url"value="jdbc:mysql://localhost:3306/dbtbl_1"/>        <propertyname="username"value="root"/>        <propertyname="password"value=""/>    </bean>    <rdb:strategyid="orderTableStrategy"sharding-columns="order_id"algorithm-expression="t_order_${order_id.longValue() % 4}"/>    <rdb:strategyid="orderItemTableStrategy"sharding-columns="order_id"algorithm-expression="t_order_item_${order_id.longValue() % 4}"/>    <rdb:data-sourceid="shardingDataSource">        <rdb:sharding-ruledata-sources="dbtbl_0,dbtbl_1">            <rdb:table-rules>                <rdb:table-rulelogic-table="t_order"actual-tables="t_order_${0..3}"table-strategy="orderTableStrategy"/>                <rdb:table-rulelogic-table="t_order_item"actual-tables="t_order_item_${0..3}"table-strategy="orderItemTableStrategy"/>            </rdb:table-rules>            <rdb:default-database-strategysharding-columns="user_id"algorithm-expression="dbtbl_${user_id.longValue() % 2 + 1}"/>        </rdb:sharding-rule>    </rdb:data-source></beans>