#### 1.首先pom.xml配置文件 ~~~ <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.0.0.RELEASE</version> </parent> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <!-- 測試 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <!-- web組件 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.1</version> </dependency> <!-- mysql依賴 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!-- springboot 集成lombok --> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> </dependencies> ~~~ #### 2.創建兩個數據庫test01和test02,一個數據庫呢對應一個數據源這時候就不能使用默認的數據源了。 test1 user1 test2 user2 #### 3.說下多數據源：例如公司分為兩個數據庫，一個數據庫專門存放共同的配置文件，一個數據庫垂直業務數據庫，垂直是根據業務劃分的，在一個項目中有多個數據源指不同庫jdbc連接，多數據源劃分可以分包劃分（業務）、注解方式劃分。 #### 4.現在application.properties配置文件中寫這兩個數據源，注意前面配置的名字要小心： ~~~ spring.datasource.test1.jdbc-url=jdbc:mysql://localhost:3306/test01 spring.datasource.test1.username=root spring.datasource.test1.password=123456 spring.datasource.test1.driver-class-name=com.mysql.jdbc.Driver spring.datasource.test2.jdbc-url=jdbc:mysql://localhost:3306/test02 spring.datasource.test2.username=root spring.datasource.test2.password=123456 spring.datasource.test2.driver-class-name=com.mysql.jdbc.Driver ~~~ #### 5.創建兩個包test01和test02,然后每個包里面包含mapper、service,以test01包下的文件為例，test02包下的一樣只需要把1改為2. ~~~ UserMapperTest01.java: @Mapper public interface UserMapperTest01 { @Select("select * from user where name=#{name}") User findByName(@Param("name")String name); @Insert("insert into user(name,age) values(#{name},#{age})") int insert(@Param("name")String name,@Param("age")Integer age); } ~~~ UserServiceTest01.java: ~~~ @Service public class UserServiceTest01 { @Autowired private UserMapperTest01 userMapperTest01; public int insertUser(String name,Integer age) { int insertUserResult=userMapperTest01.insert(name, age); int i=1/age; System.out.println(insertUserResult); //怎么驗證事務開啟成功 return insertUserResult; } } ~~~ #### 6.創建兩個datasource的配置文件，DataSource1Config.java和DataSource2Config.java,以1為例，2一樣只需要把 1改為2. ~~~ @Configuration @MapperScan(basePackages="com.itmayiedu.test01",sqlSessionFactoryRef="test1SqlSessionFactory") public class DataSource1Config { @Bean(name="test1DataSource") @ConfigurationProperties(prefix="spring.datasource.test1") @Primary public DataSource testDataSource() { return DataSourceBuilder.create().build(); } @Bean(name="test1SqlSessionFactory") @Primary public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource")DataSource dataSource) throws Exception { SqlSessionFactoryBean bean=new SqlSessionFactoryBean(); bean.setDataSource(dataSource); return bean.getObject(); } @Bean(name="test1TransactionManager") @Primary public DataSourceTransactionManager testTransactionManager(@Qualifier("test1DataSource")DataSource dataSource) { return new DataSourceTransactionManager(dataSource); } @Bean(name="test1SqlSessionTemplate") @Primary public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test1SqlSessionFactory")SqlSessionFactory sqlSessionFactory) { return new SqlSessionTemplate(sqlSessionFactory); } } ~~~ #### 7.Controller層： ~~~ /** 多數據源測試 */ @RestController public class MybatisMultiDataSourceController { @Autowired private UserServiceTest01 userServiceTest01; @Autowired private UserServiceTest02 userServiceTest02; @RequestMapping("/insertUserTest01") public Integer insertUserTest1(String name,Integer age) { return userServiceTest01.insertUser(name, age); } @RequestMapping("/insertUserTest02") public Integer insertUserTest2(String name,Integer age) { return userServiceTest02.insertUser(name, age); } } ~~~ #### 8.啟動類： ~~~ @SpringBootApplication //@MapperScan(basePackages= {"com.itmayiedu.test01.mapper"}) public class MyBatisApp01 { public static void main(String[] args) { SpringApplication.run(MyBatisApp01.class,args); } ~~~