Spring Boot教程十：資料庫讀寫分離__資料庫

文章實現一主兩從的續寫分離：工程目錄

首先pom檔案

<!--排除預設日誌架構--><dependency>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-starter-web</artifactId>   <exclusions>      <exclusion>         <groupId>org.springframework.boot</groupId>         <artifactId>spring-boot-starter-logging</artifactId>      </exclusion>   </exclusions></dependency><dependency>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-starter-test</artifactId>   <scope>test</scope></dependency><!--log4j--><dependency>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-starter-log4j</artifactId>   <version>1.3.8.RELEASE</version></dependency><!--druid--><dependency>   <groupId>com.alibaba</groupId>   <artifactId>druid</artifactId>   <version>1.0.18</version></dependency><!-- 資料庫驅動 --><dependency>   <groupId>mysql</groupId>   <artifactId>mysql-connector-java</artifactId>   <version>5.1.25</version></dependency><!--mybaits --><dependency>   <groupId>org.mybatis.spring.boot</groupId>   <artifactId>mybatis-spring-boot-starter</artifactId>   <version>${mybatis.spring.boot.version}</version></dependency><dependency>   <groupId>commons-collections</groupId>   <artifactId>commons-collections</artifactId></dependency><!--swagger--><dependency>   <groupId>io.springfox</groupId>   <artifactId>springfox-swagger2</artifactId>   <version>2.6.1</version></dependency><dependency>   <groupId>io.springfox</groupId>   <artifactId>springfox-swagger-ui</artifactId>   <version>2.6.1</version></dependency><!-- 添加redis支援 --><dependency>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-starter-redis</artifactId>   <version>1.2.8.RELEASE</version></dependency><!-- gson --><dependency>   <groupId>com.google.code.gson</groupId>   <artifactId>gson</artifactId></dependency><!-- 熱部署外掛程式修改了代碼會自動重啟 --><dependency>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-devtools</artifactId></dependency><dependency>   <groupId>org.springframework.boot</groupId>   <artifactId>spring-boot-starter-jdbc</artifactId>   <optional>true</optional></dependency><!--Aspect--><dependency>   <groupId>org.springframework</groupId>   <artifactId>spring-aop</artifactId>   <version>4.3.12.RELEASE</version></dependency><dependency>   <groupId>org.springframework</groupId>   <artifactId>spring-aspects</artifactId>   <version>4.3.12.RELEASE</version></dependency><dependency>   <groupId>org.aspectj</groupId>   <artifactId>aspectjrt</artifactId>   <version>1.6.11</version></dependency><dependency>   <groupId>org.aspectj</groupId>   <artifactId>aspectjweaver</artifactId>   <version>1.6.11</version></dependency><dependency>   <groupId>cglib</groupId>   <artifactId>cglib</artifactId>   <version>2.1_3</version></dependency><dependency>   <groupId>javax.servlet</groupId>   <artifactId>servlet-api</artifactId>   <version>2.5</version></dependency>

application.properties設定檔

#根據環境讀取設定檔#application-test.properties：測試環境#application-dev.properties：開發環境#application-prod.properties：生產環境spring.profiles.active=dev#資料來源類型spring.datasource.type=com.alibaba.druid.pool.DruidDataSource#從庫資料來源個數spring.datasource.readSize=2# Mybatis配置spring.mybatis.configLocation=mybatis/mybatis.xml# mapper路徑spring.mybatis.mapperLocations=mapper/*.xml

application-dev.properties設定檔