application.yml配置数据源
下文中的master
与local
可以更改为任意名字,后面会在数据源类中使用到。
JDBC连接可能出现时区问题,加入serverTimezone=CTT或UTC
spring:
datasource:
master:
# 使用druid数据源
type: com.alibaba.druid.pool.DruidDataSource
jdbc-url: jdbc:mysql://ip地址:端口号/dbName?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: user
password: password
driver-class-name: com.mysql.cj.jdbc.Driver
local:
# 使用druid数据源
type: com.alibaba.druid.pool.DruidDataSource
jdbc-url: jdbc:mysql://ip地址:端口号/dbName?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: user
password: password
driver-class-name: com.mysql.cj.jdbc.Driver
创建数据源配置类yml中有几个数据源就创建几个类
DataSource1Config
package com.niuniu.demo.config;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework