springboot集成@DS注解实现数据源切换的方法示例

         < dependency >

            < groupId >com.baomidou</ groupId >

            < artifactId >dynamic-datasource-spring-boot-starter</ artifactId >

            < version >3.0.0</ version >

        </ dependency >

spring:

   datasource:

    #配置hikari连接池

    hikari:

      minimum-idle: 4

      maximum-pool-size: 16

      connection-timeout: 10000

      idle-timeout: 30000

      connection-init-sql: set names utf8mb4

    #动态数据源配置

    dynamic:

      #主数据源，默认启用

      primary: business

      datasource:

        #数据源1

        business:

          driver-class-name: com.mysql.cj.jdbc.Driver

          url: jdbc:mysql://localhost:3306/db_business?useUnicode=true&characterEncoding=utf-8

          username: ****

          password: ****

        #数据源2

        user:

          driver-class-name: com.mysql.cj.jdbc.Driver

          url: jdbc:mysql://localhost:3306/db_user?useUnicode=true&characterEncoding=utf-8

          username: ****

          password: ****

        #数据源3

        order:

          driver-class-name: com.mysql.cj.jdbc.Driver

          url: jdbc:mysql://localhost:3306/db_order?useUnicode=true&characterEncoding=utf-8

          username: ****

          password: ****

@Service

@DS ( "slave" )

public class UserServiceImpl implements UserService {

   @Autowired

   private JdbcTemplate jdbcTemplate;

   public List<Map<String, Object>> selectAll() {

     return   jdbcTemplate.queryForList( "select * from user" );

   }

   @Override

   @DS ( "slave_1" )

   public List<Map<String, Object>> selectByCondition() {

     return   jdbcTemplate.queryForList( "select * from user where age >10" );

   }