多数据源下 使用mybatisplus的ActiveRecord模式操作crud

MybatisPlus支持在多数据源下使用ActiveRecord模式。

1. 首先需要在配置文件中配置多个数据源：

@Bean(name = "ds1")
@ConfigurationProperties(prefix = "mybatis-plus.ds1")
public DruidDataSource dataSourceOne(){
    return DruidDataSourceBuilder.create().build();
}

@Bean(name = "ds2")
@ConfigurationProperties(prefix = "mybatis-plus.ds2")
public DruidDataSource dataSourceTwo(){
    return DruidDataSourceBuilder.create().build();
}

@Bean
@Primary
public DynamicDataSource dataSource(DataSource ds1, DataSource ds2){
    Map<Object, Object> targetDataSources = new HashMap<>();
    targetDataSources.put("ds1", ds1);
    targetDataSources.put("ds2", ds2);
    DynamicDataSource dataSource = new DynamicDataSource();
    dataSource.setTargetDataSources(targetDataSources);
    return dataSource;
}

2. 然后在实体类中使用@TableName注解指定对应的数据表和数据库：

@TableName(value = "user", resultMap = "userMap", keepGlobalPrefix = true)
public class User extends Model<User> {

    private String id;
    private String name;
    private String age;

    @Override
    protected Serializable pkVal() {
        return this.id;
    }
    
    // getter/setter省略...
}

3. 最后在业务中操作数据即可：

@Autowired
private DataSource dataSource;

public void test(){
    User u1 = new User();
    u1.setAge("11");
    u1.setName("test1");
    u1.setDataSource(dataSource);
    u1.insert();
    
    User u2 = u1.selectById("1");
    u2.setAge("22");
    u2.setDataSource(dataSource);
    u2.updateById();
    
    u1.deleteById("1");
}