教程3sharding jdbc讀寫(xiě)分離

3Sharding-JDBC3.1不使用3Sharding-JDBC3.1不使用基于Java編碼的規(guī)則配//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的規(guī)則配或通過(guò)Yaml方式配置，與以上配置等價(jià)：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=使用原生通過(guò)asterSlaveDataSouceFacto工廠和規(guī)則配置對(duì)象獲取asterSlaveDataSouce，MasterSlaveDataSouce實(shí)現(xiàn)自JBC的標(biāo)準(zhǔn)接口ataSouce。然后可通過(guò)DataSouce用原生JBC開(kāi)發(fā)，或者使用JA,Bats等ORJBC原生實(shí)現(xiàn)為例：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的規(guī)則配基于Spring命名空間的規(guī)則<?xmlversion="1.0"基于Spring命名空間的規(guī)則<?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中使用直接通過(guò)注入的方式即可在Spring中使用直接通過(guò)注入的方式即可使用DataSource，或者將DataSource配置在JPA、HibernateprivateDataSource3.3配置項(xiàng)說(shuō)dataSources:#name:#masterDataSourceName:#主庫(kù)數(shù)據(jù)源名稱，數(shù)據(jù)源處定義的數(shù)據(jù)源名slaveDataSourceNames#從庫(kù)數(shù)據(jù)源名稱列表，數(shù)據(jù)源處定義的數(shù)據(jù)源名loadBalanceAlgorithmClassName#從庫(kù)負(fù)載均衡算法類名稱。該類需實(shí)現(xiàn)loadBalanceAlgorithmType#從庫(kù)負(fù)載均衡算法類型，可選值：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:#