Spring Boot 集成shadding jdbc 做读写分

1. pom.xml

<dependencies>

        <!--单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>

        <!--导入mybatisPlus ，Springboot整合mybatisplus依赖的包-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatisplus-spring-boot-starter</artifactId>
            <version>1.0.5</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus</artifactId>
            <version>2.3</version>
        </dependency>


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!--druid 连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>



        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>


        <!--shadding jdbc依赖包-->
        <dependency>
            <groupId>io.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>3.1.0.M1</version>
        </dependency>

    </dependencies>

2. 配置文件

server:
  port: 8001

mybatis-plus:
  #mybatisPlus mapper xml文件地址
  mapper-locations:  classpath*:mapper/*.xml
  # mybaits-plus type-aliases 文件地址
  type-aliases-package: com.tina.shadding.jdbc.entity
  # 驼峰下划线转换
  global-config:
    db-column-underline: true

#配置sharding jdbc 读写分离
sharding:
  jdbc:
    datasource:
      names: demo-write,demo-read
      demo-write:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://152.136.27.48:8888/d_tina?useUnicode=true&characterEncoding=utf-8&useSSL=false
        username: root
        password: abc123456
      demo-read:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://152.136.27.48:8889/d_tina?useUnicode=true&characterEncoding=utf-8&useSSL=false
        username: root
        password: abc123456
    config:
      sharding:
        props:
          sql.show: true
      masterslave:
        load-balance-algorithm-type: round_robin
        name: dataSource
        master-data-source-name: demo-write
        slave-data-source-names: demo-read