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(); }