yml文件:master配置主库,slave配置从库
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
dynamic:
primary: master
datasource:
master:
username: root
password: root
url: jdbc:mysql://localhost:3306/mhxysy
slave:
username: root
password: root
url: jdbc:mysql://localhost:3306/cms
使用,在数据访问层方法上添加@DS注解,指定要是用的数据库,完成
@Repository
public interface AdminMapper {
@DS("master")
@Select("select * from admin")
List selectAllFromMaster();
@DS("slave")
@Select("select * from admin")
List selectAllFromSlave();
}



