spring boot 整合多数据源JDBC、多数据源mybatis、多数据源springdata jpa

本文主要是介绍spring boot 整合多数据源JDBC、多数据源mybatis、多数据源springdata jpa，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

代码地址：(spring-boot github地址)

1、springboot整合JDBC

2、springboot整合mybatis

3、springboot整合springdata jpa

1、springboot整合jdbc

在application.properties中配置数据库链接信息

#数据源1
spring.datasource.one.type = com.alibaba.druid.pool.DruidDataSource
spring.datasource.one.username = root
spring.datasource.one.password = root
spring.datasource.one.url = jdbc:mysql://localhost/chapter01?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC#数据源2
spring.datasource.two.type = com.alibaba.druid.pool.DruidDataSource
spring.datasource.two.username = root
spring.datasource.two.password = root
spring.datasource.two.url = jdbc:mysql://localhost/chapter02?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC

配置Datasource

@Configuration
public class DataSourceConfig {@Bean("dataSourceOne")@ConfigurationProperties("spring.datasource.one")public DataSource dataSourceOne() {return DruidDataSourceBuilder.create().build();}@Bean("dataSourceTwo")@ConfigurationProperties("spring.datasource.two")public DataSource dataSourceTwo() {return DruidDataSourceBuilder.create().build();}
}

配置JdbcTemplate

@Configuration
public class JdbcConfiguration {@Bean("jdbcTemplateOne")public JdbcTemplate jdbcTemplateOne(@Qualifier("dataSourceOne") DataSource dataSource) {return new JdbcTemplate(dataSource);}@Bean("jdbcTemplateTwo")public JdbcTemplate jdbcTemplateTwo(@Qualifier("dataSourceTwo") DataSource dataSource) {return new JdbcTemplate(dataSource);}
}

创建实体

public class User {private String id;private String name;private String age;public String getId() {return id;}public void setId(String id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getAge() {return age;}public void setAge(String age) {this.age = age;}
}

创建dao层

@Repository
public class UserDao {@Resource(name = "jdbcTemplateOne")private JdbcTemplate jdbcTemplateOne;@Resource(name = "jdbcTemplateTwo")private JdbcTemplate jdbcTemplateTwo;public void save(User user) {jdbcTemplateOne.update("insert into user (name,age) values (?,?)",user.getName(),user.getAge());jdbcTemplateTwo.update("insert into user (name,age) values (?,?)",user.getName(),user.getAge());}public void getList() {List<User> user1 = jdbcTemplateOne.query("select * from user",new BeanPropertyRowMapper<>(User.class));List<User> user2 = jdbcTemplateTwo.query("select * from user",new BeanPropertyRowMapper<>(User.class));System.out.println("user1:" + user1);System.out.println("user2:" + user2);}
}

创建 controller

@RestController
public class UserController {@Autowiredprivate UserDao userDao;@GetMapping("/save")public void save() {User user = new User();user.setName("张三");user.setAge("20");userDao.save(user);user = new User();user.setName("李四");user.setAge("20");userDao.save(user);}@GetMapping("/get")public void get() {userDao.getList();}
}

以上就是jdbc多数据源配置。mybatis、springdata jpa多数据源配置与其类似。

我的github地址上都有单独的工程讲解，可以去参考：https://github.com/FadeHub/spring-boot-learn