写一段使用SpringBoot ＋ Mybatis实现user表分表插入用户数据代码

首先，需要在Mybatis中配置分表策略和数据源路由。这里使用ShardingSphere进行分表和数据源路由的配置。

1. 添加ShardingSphere的相关依赖

<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-core</artifactId>
    <version>${shardingsphere.version}</version>
</dependency>

2. 配置ShardingSphere的数据源和分表策略

spring:
  shardingsphere:
    datasource:
      names: ds0, ds1
      ds0:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/user0?useSSL=false&serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
        username: root
        password: root
      ds1:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/user1?useSSL=false&serverTimezone=UTC&useUnicode=true&characterEncoding=utf8
        username: root
        password: root
    sharding:
      tables:
        user:
          actualDataNodes: ds${0..1}.user_${0..1}
          tableStrategy:
            standard:
              shardingColumn: id
              shardingAlgorithmName: userTableShardingAlgorithm
          keyGenerateStrategy:
            column: id
            keyGeneratorName: snowflake
      defaultDatabaseStrategy:
        inline:
          shardingColumn: id
          algorithmExpression: ds${id % 2}
      shardingAlgorithms:
        userTableShardingAlgorithm:
          type: INLINE
          props:
            algorithm-expression: user_${id % 2}
      keyGenerators:
        snowflake:
          type: SNOWFLAKE
          props:
            worker-id: 123

3. 创建User实体类和Mapper接口

@Data
public class User {
    private Long id;
    private String name;
    private Integer age;
}

@Mapper
public interface UserMapper {
    @Insert("INSERT INTO user_${id % 2}(name, age) VALUES(#{name}, #{age})")
    int insert(User user);
}

4. 创建Service层，调用Mapper插入数据

@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;

    public void save(User user) {
        userMapper.insert(user);
    }
}

以上就是使用SpringBoot和Mybatis实现user表分表插入用户数据的代码。