教程3sharding jdbc读写分离

3Sharding-JDBC3.1不使用3Sharding-JDBC3.1不使用基于Java编码的规则配//Map<String,DataSource>dataSourceMap=new//BasicDataSourcemasterDataSource=newBasicDataSource();dataSourceMap.put("ds_master",//BasicDataSourceslaveDataSource1=newBasicDataSource();dataSourceMap.put("ds_slave0",//BasicDataSourceslaveDataSource2=new//MasterSlaveRuleConfigurationmasterSlaveRuleConfig=Arrays.asList("ds_slave0",//DataSourcedataSourcemasterSlaveRuleConfig,newHashMap<String,基于Yaml的规则配或通过Yaml方式配置，与以上配置等价：ds_master:!!mons.dbcp.BasicDataSourcedriverClassName:com.mysql.jdbc.Driverurl:jdbc:mysql://localhost:3306/ds_masterusername:rootds_slave0:!!mons.dbcp.BasicDataSourcedriverClassName:com.mysql.jdbc.Driverurl:jdbc:mysql://localhost:3306/ds_slave0username:rootds_slave1:!!mons.dbcp.BasicDataSourcedriverClassName:com.mysql.jdbc.Driverurl:jdbc:mysql://localhost:3306/ds_slave1username:rootname:ds_msmasterDataSourceName:slaveDataSourceNames:[ds_slave0,sql.show:truekey1:value1DataSourcesql.show:truekey1:value1DataSourcedataSource=使用原生通过asterSlaveDataSouceFacto工厂和规则配置对象获取asterSlaveDataSouce，MasterSlaveDataSouce实现自JBC的标准接口ataSouce。然后可通过DataSouce用原生JBC开发，或者使用JA,Bats等ORJBC原生实现为例：DataSourcedataSource=Stringsql="SELECTi.*FROMt_orderoJOINt_order_itemiONo.order_id=i.order_idWHEREo.user_id=?ANDo.order_id=?";try(Connectionconn=PreparedStatementpreparedStatement={preparedStatement.setInt(1,preparedStatement.setInt(2,try(ResultSetrs={while(rs.next()){}}}3.2使用<!--forspringboot<!--forspringboot--<!--forspringnamespace--基于boot的规则配基于Spring命名空间的规则<?xmlversion="1.0"基于Spring命名空间的规则<?xmlversion="1.0"encoding="UTF-<beansxmlns="/schema/beans"<beanid="ds_master"class="mons.dbcp.BasicDataSource"name="driverClassName"value="com.mysql.jdbc.Driver"name="url"name="username"value="root"name="password"value=""<beanid="ds_slave0"name="driverClassName"value="com.mysql.jdbc.Driver"name="url"name="username"value="root"name="password"value=""<beanid="ds_slave1"class="mons.dbcp.BasicDataSource"<propertyname="driverClassName"value="com.mysql.jdbc.Driver"<propertyname="url"在Spring中使用直接通过注入的方式即可在Spring中使用直接通过注入的方式即可使用DataSource，或者将DataSource配置在JPA、HibernateprivateDataSource3.3配置项说dataSources:#name:#masterDataSourceName:#主库数据源名称，数据源处定义的数据源名slaveDataSourceNames#从库数据源名称列表，数据源处定义的数据源名loadBalanceAlgorithmClassName#从库负载均衡算法类名称。该类需实现loadBalanceAlgorithmType#从库负载均衡算法类型，可选值：ROUND_ROBIN，<propertyname="username"value="root"<propertyname="password"value=""<master-slave:data-sourceid="masterSlaveDataSource"master-data-source-name="ds_master"slave-data-source-names="ds_slave0,ds_slave1"><prop<prop<propprops:#