<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.9</version>
</dependency>
核心依赖是
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
spring
datasource:
dynamic:
primary: master
strict: true #严格匹配数据源
datasource:
master:
url: jdbc:gbase://127.0.0.1:22084/test
username: eeee
password: 123456
driver-class-name: com.gbase.jdbc.Driver
slave:
url: jdbc:mysql://127.0.0.1:3306/my_xxl_job?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
以上配置完成之后,默认查询的数据库是master 因为配置里面有一个primary: master
如果想要查询MySQL数据库,那么在你写的接口,mapper层,加一个
1 加依赖 2 配置yml 3 mapper层选择某一个数据源,如果不写,就是设置的默认的那个