springboot 动态数据源切换

最新推荐文章于 2025-02-07 21:20:21 发布
原创 最新推荐文章于 2025-02-07 21:20:21 发布 · 341 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
收录于
Spring boot 2.x入门到深入

当前文章被收录于：

Spring boot 2.x入门到深入
33 篇文章 1 人学习
订阅专栏 查看详情
本文介绍了一个SpringBoot应用中实现多数据源切换的实例，包括配置两个数据库的基本信息，使用Druid数据源，动态数据源路由，以及在业务层切换数据源的示例代码。通过设置`DatabaseContextHolder`上下文来切换数据源，适用于读写分离或不同业务数据统计的场景。注意，事务管理前需确保切换到正确数据源。

多数据源切换Springboot实现

        之前踩了很多坑才弄明白的，可以用来做多库数据统计，读写分离之类的场景

       当然上代码

  

server:
  port: 8080
servlet:
  context-path: /
spring:
  profiles:
    active: dev
# 数据源相关配置
ds:
  # 数据库1
  basic:
    datasource:
      url: jdbc:mysql://192.168.1.88:3306/cc-game-mili?useUnicode=true&characterEncoding=utf8&useSSL=false&useAffectedRows=true&serverTimezone=GMT
      username: root
      password: root
      driver-class-name: com.mysql.jdbc.Driver
  # 数据库2
  base:
    datasource:
      url: jdbc:mysql://192.168.1.100:3306/company_frame?useUnicode=true&characterEncoding=utf8&useSSL=false&useAffectedRows=true&serverTimezone=GMT
      username: root
      password: baishou888
      driver-class-name: com.mysql.jdbc.Driver

  # 连接池配置
  datasource:
    initial_size: 20
    min_idle: 20
    max_active: 200
    max_wait: 60000
    time_between_eviction_runs_millis: 60000
    min_evictable_idle_time_millis: 300000
    test_while_idle: true
    test_on_borrow: false
    test_on_return: false
    pool_prepared_statements: true
    max_pool_prepared_statement_per_connection_size: 20


## JPA 相关配置
#spring:
#  jpa:
#    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
#    show-sql: true
# mybatis 打印sql
logging:
  level:
    com.hzw.mapper : debug
package com.zkb.config;

/**
 * 自定义数据源切换类
 */
public class DatabaseContextHolder {

    private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();

    public static void setDBKey(String dataSourceKey) {
        contextHolder.set(dataSourceKey);
    }

    public static String getDBKey() {
        return contextHolder.get();
    }

    public static void clearDBKey() {
        contextHolder.remove();
    }
}

package com.zkb.config;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import com.zkb.util.DbUtil;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

/**
 * 数据源配置
 */
@Configuration
// 扫描 Mapper 接口并容器管理
@MapperScan(basePackages = DatasourceConfig.PACKAGE, sqlSessionFactoryRef = "sqlSessionFactory")
public class DatasourceConfig {
    // mapper扫描
    static final String PACKAGE = "com.zkb.mapper";
    static final String MAPPER_LOCATION = "classpath:mapper/*.xml";

    @Value("${ds.basic.datasource.url}")
    private String urlBasic;
    @Value("${ds.basic.datasource.username}")
    private String userBasic;
    @Value("${ds.basic.datasource.password}")
    private String passwordBasic;
    @Value("${ds.basic.datasource.driver-class-name}")
    private String driverClassBasic;

    @Value("${ds.base.datasource.url}")
    private String urlBase;
    @Value("${ds.base.datasource.username}")
    private String userBase;
    @Value("${ds.base.datasource.password}")
    private String passwordBase;
    @Value("${ds.base.datasource.driver-class-name}")
    private String driverClassBase;



    @Value("${ds.datasource.max_active}")
    private Integer maxActive;
    @Value("${ds.datasource.min_idle}")
    private Integer minIdle;
    @Value("${ds.datasource.initial_size}")
    private Integer initialSize;
    @Value("${ds.datasource.max_wait}")
    private Long maxWait;
    @Value("${ds.datasource.time_between_eviction_runs_millis}")
    private Long timeBetweenEvictionRunsMillis;
    @Value("${ds.datasource.min_evictable_idle_time_millis}")
    private Long minEvictableIdleTimeMillis;
    @Value("${ds.datasource.test_while_idle}")
    private Boolean testWhileIdle;
    @Value("${ds.datasource.test_while_idle}")
    private Boolean testOnBorrow;
    @Value("${ds.datasource.test_on_borrow}")
    private Boolean testOnReturn;

    @Bean(name = "dynamicDataSource")
    @Primary
    public DynamicDataSource dynamicDataSource() {
        DynamicDataSource dynamicDataSource = DynamicDataSource.getInstance();

        // basic数据源
        DruidDataSource dataSourceBasic = initDataSource(driverClassBasic,urlBasic,userBasic,passwordBasic);
        // base数据源
        DruidDataSource dataSourceBase = initDataSource(driverClassBase,urlBase,userBase,passwordBase);

        Map<Object,Object> map = new HashMap<>();
        map.put(DbUtil.DB_BASIC, dataSourceBasic);
        map.put(DbUtil.DB_BASE, dataSourceBase);


        dynamicDataSource.setTargetDataSources(map);
        // 默认数据源
        dynamicDataSource.setDefaultTargetDataSource(dataSourceBasic);
        return dynamicDataSource;
    }

    /**
     * 初始数据源
     * @param driver    驱动
     * @param url       数据库连接
     * @param username  用户名
     * @param password  密码
     * @return
     */
    public DruidDataSource initDataSource(String driver,String url,String username,String password){
        //jdbc配置
        DruidDataSource rdataSource = new DruidDataSource();
        rdataSource.setDriverClassName(driver);
        rdataSource.setUrl(url);
        rdataSource.setUsername(username);
        rdataSource.setPassword(password);
        setPool(rdataSource);
        return rdataSource;
    }

    /**
     * 连接池配置
     * @param rdataSource
     */
    private void setPool(DruidDataSource rdataSource){
        //连接池配置
        rdataSource.setMaxActive(maxActive);
        rdataSource.setMinIdle(minIdle);
        rdataSource.setInitialSize(initialSize);
        rdataSource.setMaxWait(maxWait);
        rdataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
        rdataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
        rdataSource.setTestWhileIdle(testWhileIdle);
        rdataSource.setTestOnBorrow(testOnBorrow);
        rdataSource.setTestOnReturn(testOnReturn);
        rdataSource.setValidationQuery("SELECT 'x'");
        rdataSource.setPoolPreparedStatements(true);
        rdataSource.setMaxPoolPreparedStatementPerConnectionSize(20);
        try {
            rdataSource.setFilters("stat");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Bean(name = "transactionManager")
    @Primary
    public DataSourceTransactionManager transactionManager() {
        return new DataSourceTransactionManager(dynamicDataSource());
    }

    @Bean(name = "sqlSessionFactory")
    @Primary
    public SqlSessionFactory sqlSessionFactory(@Qualifier("dynamicDataSource") DataSource dynamicDataSource)
            throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dynamicDataSource);
        sessionFactory.setTypeAliasesPackage("com.hzw.model");
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources(DatasourceConfig.MAPPER_LOCATION));
        return sessionFactory.getObject();
    }


    @Bean
    public ServletRegistrationBean druidServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean();
        servletRegistrationBean.setServlet(new StatViewServlet());
        servletRegistrationBean.addUrlMappings("/druid/*");
        Map<String, String> initParameters = new HashMap<String, String>();
        // 用户名
        initParameters.put("loginUsername", "admin");
        // 密码
        initParameters.put("loginPassword", "admin");
        // 禁用HTML页面上的“Reset All”功能
        initParameters.put("resetEnable", "false");
        // IP白名单 (没有配置或者为空，则允许所有访问)
        initParameters.put("allow", "");
        servletRegistrationBean.setInitParameters(initParameters);
        return servletRegistrationBean;
    }

    @Bean
    public FilterRegistrationBean filterRegistrationBean() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
        filterRegistrationBean.setFilter(new WebStatFilter());
        filterRegistrationBean.addUrlPatterns("/*");
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
        return filterRegistrationBean;
    }

}
package com.zkb.config;

import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

import java.util.HashMap;
import java.util.Map;

/**
 * 动态数据源
 *
 */
public class DynamicDataSource extends AbstractRoutingDataSource {
    private static DynamicDataSource instance;
    private static byte[] lock=new byte[0];
    private static Map<Object,Object> dataSourceMap=new HashMap<Object, Object>();

    @Override
    public void setTargetDataSources(Map<Object, Object> targetDataSources) {
        super.setTargetDataSources(targetDataSources);
        dataSourceMap.putAll(targetDataSources);
        // 必须添加该句，否则新添加数据源无法识别到
        super.afterPropertiesSet();
    }

    public Map<Object, Object> getDataSourceMap() {
        return dataSourceMap;
    }

    @Override
    protected Object determineCurrentLookupKey() {
        String dbKey = DatabaseContextHolder.getDBKey();
        return dbKey;
    }

    private DynamicDataSource() {}

    public static synchronized DynamicDataSource getInstance(){
        if(instance==null){
            synchronized (lock){
                if(instance==null){
                    instance=new DynamicDataSource();
                }
            }
        }
        return instance;
    }

}

package com.zkb.controller;

import com.zkb.model.GameAccounts;
import com.zkb.model.GameOrders;
import com.zkb.service.GameAccountService;
import com.zkb.service.GameOrdersService;
import com.zkb.util.DbUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.util.CollectionUtils;
import org.springframework.util.ObjectUtils;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

/**
 * 测试控制器
 */
@Controller
public class TestController {


    @Autowired
     GameAccountService gameAccountService;
    @Autowired
    GameOrdersService gameOrdersService;



    @RequestMapping("findGameAccounts")
    @ResponseBody
    public String findGameAccounts() {

        GameAccounts gameAccounts = gameAccountService.selectBylast();

        int hs =0;
        if (!ObjectUtils.isEmpty(gameAccounts)){
            hs=gameAccounts.getId();
        }
        // 指定数据源
        List<GameAccounts> list =gameAccountService.findGameAccounts(hs);

        if (!CollectionUtils.isEmpty(list)) {
            System.out.println("执行了");
            gameAccountService.insertBatchAccount(list);
        }
        return "SUCCESS";

    }

    @RequestMapping("findGameOrders")
    @ResponseBody
    public String findGameOrders() {
        // 指定数据源
        Integer gameCount = gameOrdersService.selectCount(DbUtil.DB_BASIC); //游戏库总数
        Integer adminCount = gameOrdersService.selectCount(DbUtil.DB_BASE);  //管理后台库总数
        List<GameOrders> list= gameOrdersService.findGameOrders(adminCount,gameCount);
        if (!CollectionUtils.isEmpty(list)) {
            System.out.println("执行了");
            gameOrdersService.insertBatchOrder(list);
        }
        return "SUCCESS";
    }

}

package com.zkb.mapper;

import com.zkb.model.GameAccounts;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface GameAccountsMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(GameAccounts record);

    int insertSelective(GameAccounts record);

    GameAccounts selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(GameAccounts record);

    int updateByPrimaryKey(GameAccounts record);

    List<GameAccounts> findGameAccounts(@Param("hs") int hs);

    GameAccounts selectBylast();

    void insertBatchAccount(List<GameAccounts> list);
}
package com.zkb.mapper;

import com.zkb.model.GameOrders;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface GameOrdersMapper {
    int deleteByPrimaryKey(String orderId);

    int insert(GameOrders record);

    int insertSelective(GameOrders record);

    GameOrders selectByPrimaryKey(String orderId);

    int updateByPrimaryKeySelective(GameOrders record);

    int updateByPrimaryKey(GameOrders record);

    List<GameOrders> findGameOrders(@Param("hs")int hs,@Param("count")int count);

    GameOrders selectBylast();

    int selectCount();

    void insertBatchOrder(List<GameOrders> list);
}
package com.zkb.model;

import java.io.Serializable;
import java.util.Date;


public class GameAccounts implements Serializable {
    private Integer id;

    private String account;

    private String bindPhone;

    private String password;

    private String distributors;

    private String distCode;

    private Integer channelId;

    private String channel;

    private Date regdate;

    private String deviceid;

    private Date logintime;

    private String loginip;

    private String loginkey;

    private Integer flag;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account == null ? null : account.trim();
    }

    public String getBindPhone() {
        return bindPhone;
    }

    public void setBindPhone(String bindPhone) {
        this.bindPhone = bindPhone == null ? null : bindPhone.trim();
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password == null ? null : password.trim();
    }

    public String getDistributors() {
        return distributors;
    }

    public void setDistributors(String distributors) {
        this.distributors = distributors == null ? null : distributors.trim();
    }

    public String getDistCode() {
        return distCode;
    }

    public void setDistCode(String distCode) {
        this.distCode = distCode == null ? null : distCode.trim();
    }

    public Integer getChannelId() {
        return channelId;
    }

    public void setChannelId(Integer channelId) {
        this.channelId = channelId;
    }

    public String getChannel() {
        return channel;
    }

    public void setChannel(String channel) {
        this.channel = channel == null ? null : channel.trim();
    }

    public Date getRegdate() {
        return regdate;
    }

    public void setRegdate(Date regdate) {
        this.regdate = regdate;
    }

    public String getDeviceid() {
        return deviceid;
    }

    public void setDeviceid(String deviceid) {
        this.deviceid = deviceid == null ? null : deviceid.trim();
    }

    public Date getLogintime() {
        return logintime;
    }

    public void setLogintime(Date logintime) {
        this.logintime = logintime;
    }

    public String getLoginip() {
        return loginip;
    }

    public void setLoginip(String loginip) {
        this.loginip = loginip == null ? null : loginip.trim();
    }

    public String getLoginkey() {
        return loginkey;
    }

    public void setLoginkey(String loginkey) {
        this.loginkey = loginkey == null ? null : loginkey.trim();
    }

    public Integer getFlag() {
        return flag;
    }

    public void setFlag(Integer flag) {
        this.flag = flag;
    }
}
package com.zkb.model;

import java.util.Date;

public class GameOrders {
    private String orderId;

    private String ticketId;

    private String distributors;

    private String distCode;

    private String channelId;

    private Float amount;

    private Integer payStatus;

    private String payTime;

    private String transactionId;

    private String account;

    private Integer serverId;

    private String chrName;

    private String orderType;

    private Integer productId;

    private String productName;

    private Integer giveVcoin;

    private Integer giveVcb;

    private String channelProductId;

    private String privateData;

    private Date orderTime;

    public String getOrderId() {
        return orderId;
    }

    public void setOrderId(String orderId) {
        this.orderId = orderId == null ? null : orderId.trim();
    }

    public String getTicketId() {
        return ticketId;
    }

    public void setTicketId(String ticketId) {
        this.ticketId = ticketId == null ? null : ticketId.trim();
    }

    public String getDistributors() {
        return distributors;
    }

    public void setDistributors(String distributors) {
        this.distributors = distributors == null ? null : distributors.trim();
    }

    public String getDistCode() {
        return distCode;
    }

    public void setDistCode(String distCode) {
        this.distCode = distCode == null ? null : distCode.trim();
    }

    public String getChannelId() {
        return channelId;
    }

    public void setChannelId(String channelId) {
        this.channelId = channelId == null ? null : channelId.trim();
    }

    public Float getAmount() {
        return amount;
    }

    public void setAmount(Float amount) {
        this.amount = amount;
    }

    public Integer getPayStatus() {
        return payStatus;
    }

    public void setPayStatus(Integer payStatus) {
        this.payStatus = payStatus;
    }

    public String getPayTime() {
        return payTime;
    }

    public void setPayTime(String payTime) {
        this.payTime = payTime == null ? null : payTime.trim();
    }

    public String getTransactionId() {
        return transactionId;
    }

    public void setTransactionId(String transactionId) {
        this.transactionId = transactionId == null ? null : transactionId.trim();
    }

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account == null ? null : account.trim();
    }

    public Integer getServerId() {
        return serverId;
    }

    public void setServerId(Integer serverId) {
        this.serverId = serverId;
    }

    public String getChrName() {
        return chrName;
    }

    public void setChrName(String chrName) {
        this.chrName = chrName == null ? null : chrName.trim();
    }

    public String getOrderType() {
        return orderType;
    }

    public void setOrderType(String orderType) {
        this.orderType = orderType == null ? null : orderType.trim();
    }

    public Integer getProductId() {
        return productId;
    }

    public void setProductId(Integer productId) {
        this.productId = productId;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName == null ? null : productName.trim();
    }

    public Integer getGiveVcoin() {
        return giveVcoin;
    }

    public void setGiveVcoin(Integer giveVcoin) {
        this.giveVcoin = giveVcoin;
    }

    public Integer getGiveVcb() {
        return giveVcb;
    }

    public void setGiveVcb(Integer giveVcb) {
        this.giveVcb = giveVcb;
    }

    public String getChannelProductId() {
        return channelProductId;
    }

    public void setChannelProductId(String channelProductId) {
        this.channelProductId = channelProductId == null ? null : channelProductId.trim();
    }

    public String getPrivateData() {
        return privateData;
    }

    public void setPrivateData(String privateData) {
        this.privateData = privateData == null ? null : privateData.trim();
    }

    public Date getOrderTime() {
        return orderTime;
    }

    public void setOrderTime(Date orderTime) {
        this.orderTime = orderTime;
    }
}
package com.zkb.service;

import com.zkb.model.GameOrders;

import java.util.List;

/**
 * <h3>hzw</h3>
 * <p></p>
 *
 * @author : zkb
 * @date : 2021-01-21 19:37
 **/
public interface GameOrdersService {

    List<GameOrders> findGameOrders( int hs,int count);

    GameOrders selectBylast();

    int selectCount(String dbkey);

    void insertBatchOrder(List<GameOrders> list);
}

package com.zkb.service;

import com.zkb.model.GameAccounts;

import java.util.List;

/**
 * <h3>hzw</h3>
 * <p></p>
 *
 * @author : zkb
 * @date : 2021-01-21 18:22
 **/
public interface GameAccountService {

    List<GameAccounts> findGameAccounts(int hs);

    GameAccounts selectBylast();

    void insertBatchAccount(List<GameAccounts> list);
}

package com.zkb.service.impl;

import com.zkb.config.DatabaseContextHolder;
import com.zkb.mapper.GameAccountsMapper;
import com.zkb.model.GameAccounts;
import com.zkb.service.GameAccountService;
import com.zkb.util.DbUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <h3>hzw</h3>
 * <p></p>
 *
 * @author : zkb
 * @date : 2021-01-21 18:43
 **/
@Service
public class GameAccountServiceImpl implements GameAccountService {

    @Autowired
    GameAccountsMapper gameAccountsMapper;

    @Override
    public List<GameAccounts> findGameAccounts(int hs ) {
        // 指定数据源
        DatabaseContextHolder.setDBKey(DbUtil.DB_BASIC);
        return gameAccountsMapper.findGameAccounts(hs);
    }

    @Override
    public GameAccounts selectBylast() {
        DatabaseContextHolder.setDBKey(DbUtil.DB_BASE);
        return gameAccountsMapper.selectBylast();
    }

    @Override
    public void insertBatchAccount(List<GameAccounts> list) {
        DatabaseContextHolder.setDBKey(DbUtil.DB_BASE);
        gameAccountsMapper.insertBatchAccount(list);
    }

}

package com.zkb.service.impl;

import com.zkb.config.DatabaseContextHolder;
import com.zkb.mapper.GameOrdersMapper;
import com.zkb.model.GameOrders;
import com.zkb.service.GameOrdersService;
import com.zkb.util.DbUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * <h3>hzw</h3>
 * <p></p>
 *
 * @author : zkb
 * @date : 2021-01-21 19:38
 **/
@Service
public class GameOrdersServiceImpl implements GameOrdersService {

    @Autowired
    GameOrdersMapper gameOrdersMapper;
    @Override
    public List<GameOrders> findGameOrders(int hs,int count) {
        DatabaseContextHolder.setDBKey(DbUtil.DB_BASIC);
        return gameOrdersMapper.findGameOrders(hs,count);
    }

    @Override
    public GameOrders selectBylast() {
        DatabaseContextHolder.setDBKey(DbUtil.DB_BASIC);
        return gameOrdersMapper.selectBylast();
    }

    @Override
    public int selectCount(String dbkey) {
        DatabaseContextHolder.setDBKey(dbkey);
        return gameOrdersMapper.selectCount();
    }

    @Override
    public void insertBatchOrder(List<GameOrders> list) {
        DatabaseContextHolder.setDBKey(DbUtil.DB_BASE);
        gameOrdersMapper.insertBatchOrder(list);
    }
}

package com.zkb.util;

/**
 * 数据库数据源名称
 */
public class DbUtil {

    /**游戏数据库**/
    public static final String DB_BASIC = "ds_basic";   //游戏数据库
    /**数据库base**/
    public static final String DB_BASE = "ds_base";     //管理后台数据库

}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zkb.mapper.GameAccountsMapper">
  <resultMap id="BaseResultMap" type="com.zkb.model.GameAccounts">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="account" jdbcType="VARCHAR" property="account" />
    <result column="bind_phone" jdbcType="VARCHAR" property="bindPhone" />
    <result column="password" jdbcType="VARCHAR" property="password" />
    <result column="distributors" jdbcType="VARCHAR" property="distributors" />
    <result column="dist_code" jdbcType="VARCHAR" property="distCode" />
    <result column="channel_id" jdbcType="INTEGER" property="channelId" />
    <result column="channel" jdbcType="VARCHAR" property="channel" />
    <result column="regdate" jdbcType="TIMESTAMP" property="regdate" />
    <result column="deviceId" jdbcType="VARCHAR" property="deviceid" />
    <result column="logintime" jdbcType="TIMESTAMP" property="logintime" />
    <result column="loginIp" jdbcType="VARCHAR" property="loginip" />
    <result column="loginKey" jdbcType="VARCHAR" property="loginkey" />
    <result column="flag" jdbcType="INTEGER" property="flag" />
  </resultMap>
  <sql id="Base_Column_List">
    id, account, bind_phone, password, distributors, dist_code, channel_id, channel, 
    regdate, deviceId, logintime, loginIp, loginKey, flag
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from accounts
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from accounts
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.zkb.model.GameAccounts">
    insert into accounts (id, account, bind_phone, 
      password, distributors, dist_code, 
      channel_id, channel, regdate, 
      deviceId, logintime, loginIp, 
      loginKey, flag)
    values (#{id,jdbcType=INTEGER}, #{account,jdbcType=VARCHAR}, #{bindPhone,jdbcType=VARCHAR}, 
      #{password,jdbcType=VARCHAR}, #{distributors,jdbcType=VARCHAR}, #{distCode,jdbcType=VARCHAR}, 
      #{channelId,jdbcType=INTEGER}, #{channel,jdbcType=VARCHAR}, #{regdate,jdbcType=TIMESTAMP}, 
      #{deviceid,jdbcType=VARCHAR}, #{logintime,jdbcType=TIMESTAMP}, #{loginip,jdbcType=VARCHAR}, 
      #{loginkey,jdbcType=VARCHAR}, #{flag,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" parameterType="com.zkb.model.GameAccounts">
    insert into accounts
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="account != null">
        account,
      </if>
      <if test="bindPhone != null">
        bind_phone,
      </if>
      <if test="password != null">
        password,
      </if>
      <if test="distributors != null">
        distributors,
      </if>
      <if test="distCode != null">
        dist_code,
      </if>
      <if test="channelId != null">
        channel_id,
      </if>
      <if test="channel != null">
        channel,
      </if>
      <if test="regdate != null">
        regdate,
      </if>
      <if test="deviceid != null">
        deviceId,
      </if>
      <if test="logintime != null">
        logintime,
      </if>
      <if test="loginip != null">
        loginIp,
      </if>
      <if test="loginkey != null">
        loginKey,
      </if>
      <if test="flag != null">
        flag,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="account != null">
        #{account,jdbcType=VARCHAR},
      </if>
      <if test="bindPhone != null">
        #{bindPhone,jdbcType=VARCHAR},
      </if>
      <if test="password != null">
        #{password,jdbcType=VARCHAR},
      </if>
      <if test="distributors != null">
        #{distributors,jdbcType=VARCHAR},
      </if>
      <if test="distCode != null">
        #{distCode,jdbcType=VARCHAR},
      </if>
      <if test="channelId != null">
        #{channelId,jdbcType=INTEGER},
      </if>
      <if test="channel != null">
        #{channel,jdbcType=VARCHAR},
      </if>
      <if test="regdate != null">
        #{regdate,jdbcType=TIMESTAMP},
      </if>
      <if test="deviceid != null">
        #{deviceid,jdbcType=VARCHAR},
      </if>
      <if test="logintime != null">
        #{logintime,jdbcType=TIMESTAMP},
      </if>
      <if test="loginip != null">
        #{loginip,jdbcType=VARCHAR},
      </if>
      <if test="loginkey != null">
        #{loginkey,jdbcType=VARCHAR},
      </if>
      <if test="flag != null">
        #{flag,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.zkb.model.GameAccounts">
    update accounts
    <set>
      <if test="account != null">
        account = #{account,jdbcType=VARCHAR},
      </if>
      <if test="bindPhone != null">
        bind_phone = #{bindPhone,jdbcType=VARCHAR},
      </if>
      <if test="password != null">
        password = #{password,jdbcType=VARCHAR},
      </if>
      <if test="distributors != null">
        distributors = #{distributors,jdbcType=VARCHAR},
      </if>
      <if test="distCode != null">
        dist_code = #{distCode,jdbcType=VARCHAR},
      </if>
      <if test="channelId != null">
        channel_id = #{channelId,jdbcType=INTEGER},
      </if>
      <if test="channel != null">
        channel = #{channel,jdbcType=VARCHAR},
      </if>
      <if test="regdate != null">
        regdate = #{regdate,jdbcType=TIMESTAMP},
      </if>
      <if test="deviceid != null">
        deviceId = #{deviceid,jdbcType=VARCHAR},
      </if>
      <if test="logintime != null">
        logintime = #{logintime,jdbcType=TIMESTAMP},
      </if>
      <if test="loginip != null">
        loginIp = #{loginip,jdbcType=VARCHAR},
      </if>
      <if test="loginkey != null">
        loginKey = #{loginkey,jdbcType=VARCHAR},
      </if>
      <if test="flag != null">
        flag = #{flag,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.zkb.model.GameAccounts">
    update accounts
    set account = #{account,jdbcType=VARCHAR},
      bind_phone = #{bindPhone,jdbcType=VARCHAR},
      password = #{password,jdbcType=VARCHAR},
      distributors = #{distributors,jdbcType=VARCHAR},
      dist_code = #{distCode,jdbcType=VARCHAR},
      channel_id = #{channelId,jdbcType=INTEGER},
      channel = #{channel,jdbcType=VARCHAR},
      regdate = #{regdate,jdbcType=TIMESTAMP},
      deviceId = #{deviceid,jdbcType=VARCHAR},
      logintime = #{logintime,jdbcType=TIMESTAMP},
      loginIp = #{loginip,jdbcType=VARCHAR},
      loginKey = #{loginkey,jdbcType=VARCHAR},
      flag = #{flag,jdbcType=INTEGER}
    where id = #{id,jdbcType=INTEGER}
  </update>


  <select id="findGameAccounts" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from accounts
    where id > #{hs,jdbcType=INTEGER}
  </select>

  <select id="selectBylast"  resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
     from accounts order by id DESC limit 1
  </select>


  <!-- 批量插入生成的兑换码 -->
  <insert id ="insertBatchAccount" parameterType="java.util.List" >
    insert into accounts (id, account, bind_phone,
    password, distributors, dist_code,
    channel_id, channel, regdate,
    deviceId, logintime, loginIp,
    loginKey, flag)
    values
    <foreach collection ="list" item="item" index= "index" separator =",">
      (#{item.id,jdbcType=INTEGER}, #{item.account,jdbcType=VARCHAR}, #{item.bindPhone,jdbcType=VARCHAR},
      #{item.password,jdbcType=VARCHAR}, #{item.distributors,jdbcType=VARCHAR}, #{item.distCode,jdbcType=VARCHAR},
      #{item.channelId,jdbcType=INTEGER}, #{item.channel,jdbcType=VARCHAR}, #{item.regdate,jdbcType=TIMESTAMP},
      #{item.deviceid,jdbcType=VARCHAR}, #{item.logintime,jdbcType=TIMESTAMP}, #{item.loginip,jdbcType=VARCHAR},
      #{item.loginkey,jdbcType=VARCHAR}, #{item.flag,jdbcType=INTEGER})
    </foreach >
  </insert >



</mapper>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.zkb.mapper.GameOrdersMapper" >
  <resultMap id="BaseResultMap" type="com.zkb.model.GameOrders" >
    <id column="order_id" property="orderId" jdbcType="VARCHAR" />
    <result column="ticket_id" property="ticketId" jdbcType="VARCHAR" />
    <result column="distributors" property="distributors" jdbcType="VARCHAR" />
    <result column="dist_code" property="distCode" jdbcType="VARCHAR" />
    <result column="channel_id" property="channelId" jdbcType="VARCHAR" />
    <result column="amount" property="amount" jdbcType="REAL" />
    <result column="pay_status" property="payStatus" jdbcType="INTEGER" />
    <result column="pay_time" property="payTime" jdbcType="VARCHAR" />
    <result column="transaction_id" property="transactionId" jdbcType="VARCHAR" />
    <result column="account" property="account" jdbcType="VARCHAR" />
    <result column="server_id" property="serverId" jdbcType="INTEGER" />
    <result column="chr_name" property="chrName" jdbcType="VARCHAR" />
    <result column="order_type" property="orderType" jdbcType="VARCHAR" />
    <result column="product_id" property="productId" jdbcType="INTEGER" />
    <result column="product_name" property="productName" jdbcType="VARCHAR" />
    <result column="give_vcoin" property="giveVcoin" jdbcType="INTEGER" />
    <result column="give_vcb" property="giveVcb" jdbcType="INTEGER" />
    <result column="channel_product_id" property="channelProductId" jdbcType="VARCHAR" />
    <result column="private_data" property="privateData" jdbcType="VARCHAR" />
    <result column="order_time" property="orderTime" jdbcType="TIMESTAMP" />
  </resultMap>
  <sql id="Base_Column_List" >
    order_id, ticket_id, distributors, dist_code, channel_id, amount, pay_status, pay_time, 
    transaction_id, account, server_id, chr_name, order_type, product_id, product_name, 
    give_vcoin, give_vcb, channel_product_id, private_data, order_time
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from game_orders
    where order_id = #{orderId,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from game_orders
    where order_id = #{orderId,jdbcType=VARCHAR}
  </delete>
  <insert id="insert" parameterType="com.zkb.model.GameOrders" >
    insert into game_orders (order_id, ticket_id, distributors, 
      dist_code, channel_id, amount, 
      pay_status, pay_time, transaction_id, 
      account, server_id, chr_name, 
      order_type, product_id, product_name, 
      give_vcoin, give_vcb, channel_product_id, 
      private_data, order_time)
    values (#{orderId,jdbcType=VARCHAR}, #{ticketId,jdbcType=VARCHAR}, #{distributors,jdbcType=VARCHAR}, 
      #{distCode,jdbcType=VARCHAR}, #{channelId,jdbcType=VARCHAR}, #{amount,jdbcType=REAL}, 
      #{payStatus,jdbcType=INTEGER}, #{payTime,jdbcType=VARCHAR}, #{transactionId,jdbcType=VARCHAR}, 
      #{account,jdbcType=VARCHAR}, #{serverId,jdbcType=INTEGER}, #{chrName,jdbcType=VARCHAR}, 
      #{orderType,jdbcType=VARCHAR}, #{productId,jdbcType=INTEGER}, #{productName,jdbcType=VARCHAR}, 
      #{giveVcoin,jdbcType=INTEGER}, #{giveVcb,jdbcType=INTEGER}, #{channelProductId,jdbcType=VARCHAR}, 
      #{privateData,jdbcType=VARCHAR}, #{orderTime,jdbcType=TIMESTAMP})
  </insert>
  <insert id="insertSelective" parameterType="com.zkb.model.GameOrders" >
    insert into game_orders
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="orderId != null" >
        order_id,
      </if>
      <if test="ticketId != null" >
        ticket_id,
      </if>
      <if test="distributors != null" >
        distributors,
      </if>
      <if test="distCode != null" >
        dist_code,
      </if>
      <if test="channelId != null" >
        channel_id,
      </if>
      <if test="amount != null" >
        amount,
      </if>
      <if test="payStatus != null" >
        pay_status,
      </if>
      <if test="payTime != null" >
        pay_time,
      </if>
      <if test="transactionId != null" >
        transaction_id,
      </if>
      <if test="account != null" >
        account,
      </if>
      <if test="serverId != null" >
        server_id,
      </if>
      <if test="chrName != null" >
        chr_name,
      </if>
      <if test="orderType != null" >
        order_type,
      </if>
      <if test="productId != null" >
        product_id,
      </if>
      <if test="productName != null" >
        product_name,
      </if>
      <if test="giveVcoin != null" >
        give_vcoin,
      </if>
      <if test="giveVcb != null" >
        give_vcb,
      </if>
      <if test="channelProductId != null" >
        channel_product_id,
      </if>
      <if test="privateData != null" >
        private_data,
      </if>
      <if test="orderTime != null" >
        order_time,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="orderId != null" >
        #{orderId,jdbcType=VARCHAR},
      </if>
      <if test="ticketId != null" >
        #{ticketId,jdbcType=VARCHAR},
      </if>
      <if test="distributors != null" >
        #{distributors,jdbcType=VARCHAR},
      </if>
      <if test="distCode != null" >
        #{distCode,jdbcType=VARCHAR},
      </if>
      <if test="channelId != null" >
        #{channelId,jdbcType=VARCHAR},
      </if>
      <if test="amount != null" >
        #{amount,jdbcType=REAL},
      </if>
      <if test="payStatus != null" >
        #{payStatus,jdbcType=INTEGER},
      </if>
      <if test="payTime != null" >
        #{payTime,jdbcType=VARCHAR},
      </if>
      <if test="transactionId != null" >
        #{transactionId,jdbcType=VARCHAR},
      </if>
      <if test="account != null" >
        #{account,jdbcType=VARCHAR},
      </if>
      <if test="serverId != null" >
        #{serverId,jdbcType=INTEGER},
      </if>
      <if test="chrName != null" >
        #{chrName,jdbcType=VARCHAR},
      </if>
      <if test="orderType != null" >
        #{orderType,jdbcType=VARCHAR},
      </if>
      <if test="productId != null" >
        #{productId,jdbcType=INTEGER},
      </if>
      <if test="productName != null" >
        #{productName,jdbcType=VARCHAR},
      </if>
      <if test="giveVcoin != null" >
        #{giveVcoin,jdbcType=INTEGER},
      </if>
      <if test="giveVcb != null" >
        #{giveVcb,jdbcType=INTEGER},
      </if>
      <if test="channelProductId != null" >
        #{channelProductId,jdbcType=VARCHAR},
      </if>
      <if test="privateData != null" >
        #{privateData,jdbcType=VARCHAR},
      </if>
      <if test="orderTime != null" >
        #{orderTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.zkb.model.GameOrders" >
    update game_orders
    <set >
      <if test="ticketId != null" >
        ticket_id = #{ticketId,jdbcType=VARCHAR},
      </if>
      <if test="distributors != null" >
        distributors = #{distributors,jdbcType=VARCHAR},
      </if>
      <if test="distCode != null" >
        dist_code = #{distCode,jdbcType=VARCHAR},
      </if>
      <if test="channelId != null" >
        channel_id = #{channelId,jdbcType=VARCHAR},
      </if>
      <if test="amount != null" >
        amount = #{amount,jdbcType=REAL},
      </if>
      <if test="payStatus != null" >
        pay_status = #{payStatus,jdbcType=INTEGER},
      </if>
      <if test="payTime != null" >
        pay_time = #{payTime,jdbcType=VARCHAR},
      </if>
      <if test="transactionId != null" >
        transaction_id = #{transactionId,jdbcType=VARCHAR},
      </if>
      <if test="account != null" >
        account = #{account,jdbcType=VARCHAR},
      </if>
      <if test="serverId != null" >
        server_id = #{serverId,jdbcType=INTEGER},
      </if>
      <if test="chrName != null" >
        chr_name = #{chrName,jdbcType=VARCHAR},
      </if>
      <if test="orderType != null" >
        order_type = #{orderType,jdbcType=VARCHAR},
      </if>
      <if test="productId != null" >
        product_id = #{productId,jdbcType=INTEGER},
      </if>
      <if test="productName != null" >
        product_name = #{productName,jdbcType=VARCHAR},
      </if>
      <if test="giveVcoin != null" >
        give_vcoin = #{giveVcoin,jdbcType=INTEGER},
      </if>
      <if test="giveVcb != null" >
        give_vcb = #{giveVcb,jdbcType=INTEGER},
      </if>
      <if test="channelProductId != null" >
        channel_product_id = #{channelProductId,jdbcType=VARCHAR},
      </if>
      <if test="privateData != null" >
        private_data = #{privateData,jdbcType=VARCHAR},
      </if>
      <if test="orderTime != null" >
        order_time = #{orderTime,jdbcType=TIMESTAMP},
      </if>
    </set>
    where order_id = #{orderId,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.zkb.model.GameOrders" >
    update game_orders
    set ticket_id = #{ticketId,jdbcType=VARCHAR},
      distributors = #{distributors,jdbcType=VARCHAR},
      dist_code = #{distCode,jdbcType=VARCHAR},
      channel_id = #{channelId,jdbcType=VARCHAR},
      amount = #{amount,jdbcType=REAL},
      pay_status = #{payStatus,jdbcType=INTEGER},
      pay_time = #{payTime,jdbcType=VARCHAR},
      transaction_id = #{transactionId,jdbcType=VARCHAR},
      account = #{account,jdbcType=VARCHAR},
      server_id = #{serverId,jdbcType=INTEGER},
      chr_name = #{chrName,jdbcType=VARCHAR},
      order_type = #{orderType,jdbcType=VARCHAR},
      product_id = #{productId,jdbcType=INTEGER},
      product_name = #{productName,jdbcType=VARCHAR},
      give_vcoin = #{giveVcoin,jdbcType=INTEGER},
      give_vcb = #{giveVcb,jdbcType=INTEGER},
      channel_product_id = #{channelProductId,jdbcType=VARCHAR},
      private_data = #{privateData,jdbcType=VARCHAR},
      order_time = #{orderTime,jdbcType=TIMESTAMP}
    where order_id = #{orderId,jdbcType=VARCHAR}
  </update>


  <select id="findGameOrders"  resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from game_orders
    limit  #{hs,jdbcType=INTEGER},#{count,jdbcType=INTEGER}
  </select>

  <select id="selectBylast"  resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from game_orders order by id DESC limit 1
  </select>

  <select id="selectCount"  resultType="java.lang.Integer">
    select
    count(*)
    from game_orders
  </select>


  <insert id ="insertBatchOrder" parameterType="java.util.List" >
    insert into game_orders (order_id, ticket_id, distributors,
    dist_code, channel_id, amount,
    pay_status, pay_time, transaction_id,
    account, server_id, chr_name,
    order_type, product_id, product_name,
    give_vcoin, give_vcb, channel_product_id,
    private_data, order_time)
    values
    <foreach collection ="list" item="item" index= "index" separator =",">
      (#{item.orderId,jdbcType=VARCHAR}, #{item.ticketId,jdbcType=VARCHAR}, #{item.distributors,jdbcType=VARCHAR},
      #{item.distCode,jdbcType=VARCHAR}, #{item.channelId,jdbcType=VARCHAR}, #{item.amount,jdbcType=REAL},
      #{item.payStatus,jdbcType=INTEGER}, #{item.payTime,jdbcType=VARCHAR}, #{item.transactionId,jdbcType=VARCHAR},
      #{item.account,jdbcType=VARCHAR}, #{item.serverId,jdbcType=INTEGER}, #{item.chrName,jdbcType=VARCHAR},
      #{item.orderType,jdbcType=VARCHAR}, #{item.productId,jdbcType=INTEGER}, #{item.productName,jdbcType=VARCHAR},
      #{item.giveVcoin,jdbcType=INTEGER}, #{item.giveVcb,jdbcType=INTEGER}, #{item.channelProductId,jdbcType=VARCHAR},
      #{item.privateData,jdbcType=VARCHAR}, #{item.orderTime,jdbcType=TIMESTAMP})
    </foreach >
  </insert >






</mapper>
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com</groupId>
    <artifactId>springBootData</artifactId>
    <version>1.0-SNAPSHOT</version>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.2.RELEASE</version>
        <relativePath />
    </parent>

    <dependencies>
        <!--<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-lang3</artifactId>
            <version>3.0</version>
        </dependency>
        <dependency>
            <groupId>javax.activation</groupId>
            <artifactId>activation</artifactId>
            <version>1.1.1</version>
        </dependency>
        <dependency>
            <groupId>net.sf.json-lib</groupId>
            <artifactId>json-lib</artifactId>
            <version>2.4</version>
            <classifier>jdk15</classifier>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.8</version>
        </dependency>
    </dependencies>

</project>

到此算是实现了一整个完整的数据源切换的demo    

每次切换都需要  来制度自己所要切换到的数据源

// 指定数据源
DatabaseContextHolder.setDBKey(DbUtil.DB_BASIC);

如果有加事务的话，一定要在开启事务之前切换数据源，进入事务之后切换数据源是无效的

标签
#java #spring #数据源切换 #springboot #mysql
SpringBoot 手动实现动态切换数据源 DynamicSource （中）
最新发布
m0_74822999的博客
03-10 1110
dynamic-datasource-spring-boot-starter 是一个基于springboot的快速集成多数据源的启动器。其支持。JPA用户不建议使用，JPA自带事务，无法连续切库。
使用Spring Boot实现动态数据源切换
省赚客开发者博客
07-12 1369
在现代应用中，使用多个数据源是一个常见的需求。比如，我们可能需要在读写分离的数据库架构中，根据不同的操作选择不同的数据源。在需要切换数据源的方法上添加注解，然后在AOP切面中切换数据源。通过上述步骤，我们成功实现了Spring Boot项目中的动态数据源切换功能。这样，我们可以根据不同的业务需求，在运行时动态选择和切换数据源。大家好，我是微赚淘客系统3.0的小编，是个冬天不穿秋裤，天冷也要风度的程序猿！首先，在Spring Boot项目中引入必要的依赖。在需要使用动态数据源的服务方法上添加。
springboot之commons-dbutils的使用
大伟的博客
11-30 1119
springboot之commons-dbutils的使用
spring boot动态切换多数据源
12-08
一个spring boot动态切换多数据源的完整demo。
SpringBoot——动态数据源（多数据源自动切换）
quanzhan_King的博客
06-13 1万+
日常的业务开发项目中只会配置一套数据源，如果需要获取其他系统的数据往往是通过调用接口， 或者是通过第三方工具比如kettle将数据同步到自己的数据库中进行访问。但是也会有需要在项目中引用多数据源的场景。自研数据迁移系统，至少需要新、老两套数据源，从老库读取数据写入新库自研读写分离中间件，系统流量增加，单库响应效率降低，引入读写分离方案，写入数据是一个数据源，读取数据是另一个数据源。
springBoot如何动态切换数据源
爪哇人的博客
01-18 3685
mybatisplus提供的有插件用@DS注解就能够实现，但是这种在mysql服务宕机的情况下不能够进行自动切换，于是就想着用aop+自定义注解的方式来实现。此时你在代码层面用注解指定了一个增删改方法到从数据源，但是碰巧此时从数据源失效了，那么就会自动的切换到其它服务器。DynamicDataSourceHolder类主要是设置当前线程的数据源名称，移除数据源名称，以及获取当前数据源的名称，便于动态切换。我在这个方法上指定的是从数据库，如果此时从数据库发生宕机，那么就会自动切换到主数据库进行操作。
springboot集成dbutils、jdbc查询数据源下的数据库表格及表格字段
qq_43420577的博客
11-16 1525
springboot集成dbutils、jdbc查询数据源下的数据库表格及表格字段，包含数据库查询数据库下所有表格和表的字段信息。
SpringBoot动态切换数据源
qq_37634156的博客
08-24 4615
这里需要注意如果SpringBoot版本是2.0之后的版本，需要把【url】和【driverClassName】写成【jdbc-url】和【driver-class-name】，否则会报错【jdbcUrl is required with driverClassName.】自定义数据源枚举类，这里配置了两个数据源，则创建两个枚举。 3、注入数据源 生成bean。单一数据源与Mybatis整合时将DataSource数据源作为参数构建【SqlSessionFactory】，而多个数据源的话只需要将作为
springboot实现动态数据源切换
CAUC_lin的博客
08-11 3657
springboot+mybatis实现数据源的动态切换
spring boot使用AbstractRoutingDataSource实现动态数据源切换
热门推荐
愿风裁尽尘中沙
06-06 7万+
一、AbstractRoutingDataSource Spring boot提供了AbstractRoutingDataSource 根据用户定义的规则选择当前的数据源，这样我们可以在执行查询之前，设置使用的数据源。实现可动态路由的数据源，在每次数据库查询操作前执行。它的抽象方法 determineCurrentLookupKey() 决定使用哪个数据源。 org.springframework...
SpringBoot3动态切换数据源
m0_60681411的博客
01-05 1364
本文通过Springboot3，以切面和Filter的方式，实现了数据源的动态切换。
Spring /SpringBoot动态数据源切换以及支持动态添加数据源的方案
qq_29597223的博客
08-27 1万+
_**使用场景： 假设需要做一个工具，由于保密需要只描述场景。 A下面有 B、C、D三家或者更多分公司，人员信息统一在总公司的A数据库，分公司各自使用各自的业务数据库，用户登陆访问A数据库校验成功后将用户所属分公司的KEY保存session中（此文章以存放session为例，其他存放方式参考即可），当然本文重点在与还可以动态增加EFG。。。。分公司，无需重启应用。 _**设计思路： ...
Spring Boot多数据源配置并通过注解实现动态切换数据源
huangjhai的博客
07-31 6571
Spring Boot提供了AbstractRoutingDataSource 根据用户定义的规则选择使用的数据源，这样我们可以在每次数据库操作前设置使用的数据源，实现可动态路由的数据源，从而实现读写分离的功能。
SpringBoot中实现动态数据源切换
北执南念的博客
02-07 1192
SpringBoot中实现动态数据源切换
Spring Boot MyBatis-Plus 动态数据源切换
ch999999999999999999的博客
09-07 6522
springboot mybatis-plus 动态数据源切换一、前言二、快速开始三、注意事项四、代码demo参考 一、前言 由于项目中读写分离，或者分库分表导致数据库连接有很多。这个时候我们常常会切换多数据源进行业务的合并，但是mybatis-plus 里面内置的方法却很难试用，需要编写大量代码来实现，非常繁琐，我在网上找了很多demo部分还不能成功，走了很弯路以后，我发现 maonidou(苞...
Springboot+Druid动态切换数据源
u014295903的博客
05-21 4178
Springboot+Druid动态切换数据源一、描述二、实现2.1 maven引入jar2.2 数据源上下文DataSourceContextHolder2.3 DynamicDataSource继承AbstractRoutingDataSource抽象类2.4 Druid配置类2.2 DruidDataSourceUtil实现切换入口三、切换3.1 全局切换3.2 局部切换 一、描述 关于数据源的切换，在实际使用中经常出现，本文主要是使用Druid，最近经常使用到，根据以往项目的使用，调整后进行记录，方
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

斗码士

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值