springboot+mybatis+sharding-jdbc整合示例代码

apply_bomb

已于 2023-10-31 10:45:21 修改

阅读量389

点赞数

于 2023-10-31 10:42:53 首次发布

本文链接：https://blog.csdn.net/apply_bomb/article/details/134134248

版权

背景

想要整合个sharding-jdbc，结果sharding-jdbc官网的入门示例居然下载不下来，无奈只能自己搭了个,下面的示例可以直接运行，并且提供了数据库脚本，对新手友好

版本说明

mysql版本：mysql8

springboot:2.7.1

sharding-jdbc:4.0.1(目前能在maven中找到的最新稳定发布版本)

mybatis-plus：(目前能在maven中找到的最新稳定发布版本)

官网链接

sharding-jdbc官网链接：

Sharding-JDBC :: ShardingSphere

mybatis-plus官网链接：

MyBatis-Plus

mybatis官网链接

mybatis – MyBatis 3 | 入门

项目结构

具体代码

项目依赖

pom.xml

<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.7.1</version>
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <groupId>com.home</groupId>
    <artifactId>sharding-sphere-demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>sharding-sphere-demo</name>
    <description>Demo project for Spring Boot</description>


    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.25</version>
        </dependency>
        <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
            <version>4.0.1</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.3.2</version>
        </dependency>
    </dependencies>


</project>

项目配置文件

application.properties

server.port=8752
spring.application.name=sharding-sphere-demo




spring.shardingsphere.datasource.names=m0,m1
spring.main.allow-bean-definition-overriding = true
#定义m0数据源
#这里的数据库名称需要和实际名称相同
# jdbcUrl、username、password这些变量名称需要根据type来变化
spring.shardingsphere.datasource.m0.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.m0.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.m0.jdbcUrl=jdbc:mysql://localhost:3306/m0?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
spring.shardingsphere.datasource.m0.username=root
spring.shardingsphere.datasource.m0.password=123456

#定义m1数据源
spring.shardingsphere.datasource.m1.type=com.zaxxer.hikari.HikariDataSource
spring.shardingsphere.datasource.m1.driver-class-name=com.mysql.jdbc.Driver
spring.shardingsphere.datasource.m1.jdbcUrl=jdbc:mysql://localhost:3306/m1?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
spring.shardingsphere.datasource.m1.username=root
spring.shardingsphere.datasource.m1.password=123456

#表t_order的选择策略
#表t_order的数据库选择策略
#表t_order的数据库根据哪个字段进行分配选择
spring.shardingsphere.sharding.tables.t_order.database-strategy.inline.sharding-column=order_id
#具体的分配计算公式
spring.shardingsphere.sharding.tables.t_order.database-strategy.inline.algorithm-expression=m$->{order_id%2}
#根据哪个字段进行分片选择表
spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.sharding-column=order_id
#具体的选择表算法
spring.shardingsphere.sharding.tables.t_order.table-strategy.inline.algorithm-expression=t_order_$->{order_id % 4}
#spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=m$->{0..1}.t_order_$->{0..5}
#这里需要列举出所有数据库表，如果没有命中分片键，sql将会在所有表中运行一遍
#由数据源名 + 表名组成，以小数点分隔。多个表以逗号分隔，支持inline表达式。
spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=m0.t_order_0,m0.t_order_2,m1.t_order_1,m1.t_order_3
# 使用雪花算法为指定字段生成id数值
spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE





# 打开sql输出日志
spring.shardingsphere.props.sql.show=true

用于链接mybatis的xml文件

OrderMapper.java

package com.example.demo;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

@Mapper
public interface OrderMapper {

    List<Map> queryByIds(@Param("order_id") Long order_id);

    List<Map> queryAll();

    List<Map> pageList(int pageNum,int pageSize);

    Integer updateById();

    Integer updateByOther();

    Integer insertOneWithId();

    Integer insertOneWithOutId();
}

测试入口

DemoController.java

package com.example.demo;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;
import java.util.Map;

@RestController
public class DemoController {


    @Autowired
    public OrderMapper orderMapper;

    /**
     * 根据id查询一条数据
     * 结论：和未分片前的原表表现相同
     * 实际执行sql
     * Actual SQL: m1 ::: select * from t_order_1 where order_id = ? ::: [1]
     * 返回结果：
     * [
     * {
     * "user_id": 1,
     * "price": 1.00,
     * "order_id": 1,
     * "status": "2"
     * }
     * ]
     */
    @GetMapping("/queryByIds")
    public Object queryByIds() {
        List<Map> maps = orderMapper.queryByIds(1L);
        return maps;
    }


    /**
     * 查询出所有数据
     * 没有分片键的查询，将对所有分片的表进行sql查询，读取到jvm，在jvm中进行汇总
     * 结论：和未分片前的原表表现相同
     * 实际执行sql
     * Actual SQL: m0 ::: select * from t_order_0
     * Actual SQL: m0 ::: select * from t_order_2
     * Actual SQL: m1 ::: select * from t_order_1
     * Actual SQL: m1 ::: select * from t_order_3
     * 返回结果：省略
     */
    @GetMapping("/queryAll")
    public Object queryAll() {
        List<Map> map = orderMapper.queryAll();
        return map;
    }


    /**
     * 分页和排序查询
     * 没有分片键的查询，将对所有分片的表进行sql查询，读取到jvm，在jvm中进行重新排序和重新分页
     * 分页参数limit中第一个offset将为0，第二个参数size将为pageNum*pageSize
     * 举例：翻到第二页，将对所有表执行sql: select * from t_order_* order by order_id asc limit 0,20，如果你由4张表就会执行4次
     * 结论：和未分片前的原表表现相同
     * 实际执行sql
     * Actual SQL: m0 ::: select * from t_order_0 order by order_id asc limit ?,? ::: [0, 20]
     * Actual SQL: m0 ::: select * from t_order_2 order by order_id asc limit ?,? ::: [0, 20]
     * Actual SQL: m1 ::: select * from t_order_1 order by order_id asc limit ?,? ::: [0, 20]
     * Actual SQL: m1 ::: select * from t_order_3 order by order_id asc limit ?,? ::: [0, 20]
     * <p>
     * 返回结果
     * [
     * {
     * "user_id": 10,
     * "price": 10.00,
     * "order_id": 10,
     * "status": "1"
     * },
     * {
     * "user_id": 11,
     * "price": 11.00,
     * "order_id": 11,
     * "status": "2"
     * },
     * {
     * "user_id": 12,
     * "price": 12.00,
     * "order_id": 12,
     * "status": "3"
     * },
     * {
     * "user_id": 13,
     * "price": 13.00,
     * "order_id": 13,
     * "status": "4"
     * },
     * {
     * "user_id": 14,
     * "price": 14.00,
     * "order_id": 14,
     * "status": "5"
     * },
     * {
     * "user_id": 15,
     * "price": 15.00,
     * "order_id": 15,
     * "status": "1"
     * },
     * {
     * "user_id": 16,
     * "price": 16.00,
     * "order_id": 16,
     * "status": "2"
     * },
     * {
     * "user_id": 17,
     * "price": 17.00,
     * "order_id": 17,
     * "status": "3"
     * },
     * {
     * "user_id": 18,
     * "price": 18.00,
     * "order_id": 18,
     * "status": "4"
     * },
     * {
     * "user_id": 19,
     * "price": 19.00,
     * "order_id": 19,
     * "status": "5"
     * }
     * ]
     */
    @GetMapping("/pageList")
    public Object pageList(@RequestParam(defaultValue = "2") Integer pageNum,
                           @RequestParam(defaultValue = "10") Integer pageSize
    ) {
        int offset = (pageNum - 1) * pageSize;
        List<Map> map = orderMapper.pageList(offset, pageSize);
        return map;
    }


    /**
     * 测试：根据分片键字段进行更新
     * Rule Type: sharding
     * Logic SQL: UPDATE t_order SET `price` = 0.01 WHERE `order_id` = 30
     * Actual SQL: m0 ::: UPDATE t_order_2 SET `price` = 0.01 WHERE `order_id` = 30
     * 返回：1
     */
    @GetMapping("/updateById")
    public Object updateById() {
        Integer num = orderMapper.updateById();
        return num;
    }


    /**
     * 测试：根据非分片字段键进行更新
     * 返回：1
     * <p>
     * Logic SQL: UPDATE t_order SET `price` = 0.02 WHERE `price` = 0.01
     * <p>
     * Actual SQL: m0 ::: UPDATE t_order_0 SET `price` = 0.02 WHERE `price` = 0.01
     * Actual SQL: m0 ::: UPDATE t_order_2 SET `price` = 0.02 WHERE `price` = 0.01
     * Actual SQL: m1 ::: UPDATE t_order_1 SET `price` = 0.02 WHERE `price` = 0.01
     * Actual SQL: m1 ::: UPDATE t_order_3 SET `price` = 0.02 WHERE `price` = 0.01
     */
    @GetMapping("/updateByOther")
    public Object updateByOther() {
        Integer num = orderMapper.updateByOther();
        return num;
    }


    /**
     * 手动指定id，插入一条数据
     * Logic SQL: INSERT INTO `m0`.`t_order`(`order_id`, `price`, `user_id`, `status`) VALUES (1000, 0.01, 30, '1');
     * Actual SQL: m0 ::: INSERT INTO `t_order_0`(`order_id`, `price`, `user_id`, `status`) VALUES (1000, 0.01, 30, '1');
     */

    @GetMapping("/insertOneWithId")
    public Object insertOne() {
        Integer num = orderMapper.insertOneWithId();
        return num;
    }


    /**
     * Logic SQL: INSERT INTO `m0`.`t_order`(`price`, `user_id`, `status`) VALUES ( 0.02, 30, '1');
     * Actual SQL: m0 ::: INSERT INTO `t_order_0`(`price`, `user_id`, `status`, order_id) VALUES (0.02, 30, '1', 925818249805824000);
     * 在不指定id的情况下插入一条数据
     */
    @GetMapping("/insertOneWithOutId")
    public Object insertOneWithOutId() {
        Integer num = orderMapper.insertOneWithOutId();
        return num;
    }


}

具体的sql

OrderMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.OrderMapper">

    <!--根据分表键order_id进行查询-->
    <select id="queryByIds" resultType="map">
        select * from t_order where order_id = #{order_id}
    </select>


    <!--没有筛选条件，直接查询全部-->
    <select id="queryAll" resultType="map">
        select * from t_order
    </select>


    <!--分页查询-->
    <select id="pageList" resultType="map">
        select * from t_order order by order_id asc limit #{pageNum},#{pageSize}
    </select>


    <update id="updateById">
        UPDATE t_order SET `price` = 0.01 WHERE `order_id` = 30
    </update>


    <update id="updateByOther">
        UPDATE t_order SET `price` = 0.02 WHERE `price` = 0.01
    </update>


    <insert id="insertOneWithId">
        INSERT INTO `m0`.`t_order`(`order_id`, `price`, `user_id`, `status`) VALUES (1000, 0.01, 30, '1');
    </insert>

    <insert id="insertOneWithOutId">
        INSERT INTO `m0`.`t_order`(`price`, `user_id`, `status`) VALUES ( 0.02, 30, '1');
    </insert>



</mapper>

DemoApplication.java

启动类

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.demo")
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }


}

数据库初始化脚本



CREATE DATABASE `m0` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin';


CREATE DATABASE `m1` CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin';

use m0;
CREATE TABLE `full_user` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;


CREATE TABLE `t_order_0` (
  `order_id` bigint NOT NULL COMMENT '订单id',
  `price` decimal(10,2) NOT NULL COMMENT '订单价格',
  `user_id` bigint NOT NULL COMMENT '下单用户id',
  `status` varchar(50) NOT NULL COMMENT '订单状态',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;


CREATE TABLE `t_order_2` (
  `order_id` bigint NOT NULL COMMENT '订单id',
  `price` decimal(10,2) NOT NULL COMMENT '订单价格',
  `user_id` bigint NOT NULL COMMENT '下单用户id',
  `status` varchar(50) NOT NULL COMMENT '订单状态',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;


CREATE TABLE `user_0` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;


CREATE TABLE `user_2` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;




CREATE TABLE `user_4` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;


CREATE TABLE m0.`full_t_order` (
  `order_id` bigint NOT NULL COMMENT '订单id',
  `price` decimal(10,2) NOT NULL COMMENT '订单价格',
  `user_id` bigint NOT NULL COMMENT '下单用户id',
  `status` varchar(50) NOT NULL COMMENT '订单状态',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;




use m1;

CREATE TABLE `t_order_1` (
  `order_id` bigint NOT NULL COMMENT '订单id',
  `price` decimal(10,2) NOT NULL COMMENT '订单价格',
  `user_id` bigint NOT NULL COMMENT '下单用户id',
  `status` varchar(50) NOT NULL COMMENT '订单状态',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;



CREATE TABLE `t_order_3` (
  `order_id` bigint NOT NULL COMMENT '订单id',
  `price` decimal(10,2) NOT NULL COMMENT '订单价格',
  `user_id` bigint NOT NULL COMMENT '下单用户id',
  `status` varchar(50) NOT NULL COMMENT '订单状态',
  PRIMARY KEY (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;



CREATE TABLE `user_1` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;




CREATE TABLE `user_3` (
  `id` int NOT NULL,
  `userid` int NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;







INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 0, 0, 0, '1' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 1, 1, 1, '2' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 2, 2, 2, '3' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 3, 3, 3, '4' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 4, 4, 4, '5' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 5, 5, 5, '1' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 6, 6, 6, '2' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 7, 7, 7, '3' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 8, 8, 8, '4' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 9, 9, 9, '5' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 10, 10, 10, '1' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 11, 11, 11, '2' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 12, 12, 12, '3' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 13, 13, 13, '4' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 14, 14, 14, '5' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 15, 15, 15, '1' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 16, 16, 16, '2' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 17, 17, 17, '3' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 18, 18, 18, '4' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 19, 19, 19, '5' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 20, 20, 20, '1' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 21, 21, 21, '2' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 22, 22, 22, '3' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 23, 23, 23, '4' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 24, 24, 24, '5' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 25, 25, 25, '1' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 26, 26, 26, '2' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 27, 27, 27, '3' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 28, 28, 28, '4' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 29, 29, 29, '5' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 30, 30, 30, '1' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 31, 31, 31, '2' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 32, 32, 32, '3' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 33, 33, 33, '4' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 34, 34, 34, '5' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 35, 35, 35, '1' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 36, 36, 36, '2' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 37, 37, 37, '3' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 38, 38, 38, '4' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 39, 39, 39, '5' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 40, 40, 40, '1' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 41, 41, 41, '2' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 42, 42, 42, '3' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 43, 43, 43, '4' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 44, 44, 44, '5' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 45, 45, 45, '1' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 46, 46, 46, '2' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 47, 47, 47, '3' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 48, 48, 48, '4' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 49, 49, 49, '5' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 50, 50, 50, '1' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 51, 51, 51, '2' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 52, 52, 52, '3' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 53, 53, 53, '4' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 54, 54, 54, '5' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 55, 55, 55, '1' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 56, 56, 56, '2' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 57, 57, 57, '3' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 58, 58, 58, '4' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 59, 59, 59, '5' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 60, 60, 60, '1' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 61, 61, 61, '2' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 62, 62, 62, '3' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 63, 63, 63, '4' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 64, 64, 64, '5' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 65, 65, 65, '1' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 66, 66, 66, '2' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 67, 67, 67, '3' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 68, 68, 68, '4' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 69, 69, 69, '5' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 70, 70, 70, '1' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 71, 71, 71, '2' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 72, 72, 72, '3' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 73, 73, 73, '4' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 74, 74, 74, '5' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 75, 75, 75, '1' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 76, 76, 76, '2' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 77, 77, 77, '3' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 78, 78, 78, '4' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 79, 79, 79, '5' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 80, 80, 80, '1' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 81, 81, 81, '2' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 82, 82, 82, '3' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 83, 83, 83, '4' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 84, 84, 84, '5' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 85, 85, 85, '1' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 86, 86, 86, '2' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 87, 87, 87, '3' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 88, 88, 88, '4' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 89, 89, 89, '5' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 90, 90, 90, '1' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 91, 91, 91, '2' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 92, 92, 92, '3' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 93, 93, 93, '4' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 94, 94, 94, '5' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 95, 95, 95, '1' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 96, 96, 96, '2' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 97, 97, 97, '3' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 98, 98, 98, '4' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 99, 99, 99, '5' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 100, 100, 100, '1' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 101, 101, 101, '2' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 102, 102, 102, '3' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 103, 103, 103, '4' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 104, 104, 104, '5' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 105, 105, 105, '1' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 106, 106, 106, '2' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 107, 107, 107, '3' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 108, 108, 108, '4' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 109, 109, 109, '5' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 110, 110, 110, '1' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 111, 111, 111, '2' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 112, 112, 112, '3' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 113, 113, 113, '4' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 114, 114, 114, '5' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 115, 115, 115, '1' );
INSERT INTO `m0`.`t_order_0` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 116, 116, 116, '2' );
INSERT INTO `m1`.`t_order_1` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 117, 117, 117, '3' );
INSERT INTO `m0`.`t_order_2` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 118, 118, 118, '4' );
INSERT INTO `m1`.`t_order_3` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 119, 119, 119, '5' );











INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (0, 0, '小明0'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (1, 1, '小黑1'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (2, 2, '小红2'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (3, 3, '小黄3'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (4, 4, '小黄4'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (5, 5, '小明5'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (6, 6, '小黑6'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (7, 7, '小红7'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (8, 8, '小黄8'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (9, 9, '小黄9'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (10, 10, '小明10'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (11, 11, '小黑11'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (12, 12, '小红12'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (13, 13, '小黄13'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (14, 14, '小黄14'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (15, 15, '小明15'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (16, 16, '小黑16'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (17, 17, '小红17'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (18, 18, '小黄18'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (19, 19, '小黄19'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (20, 20, '小明20'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (21, 21, '小黑21'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (22, 22, '小红22'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (23, 23, '小黄23'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (24, 24, '小黄24'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (25, 25, '小明25'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (26, 26, '小黑26'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (27, 27, '小红27'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (28, 28, '小黄28'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (29, 29, '小黄29'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (30, 30, '小明30'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (31, 31, '小黑31'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (32, 32, '小红32'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (33, 33, '小黄33'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (34, 34, '小黄34'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (35, 35, '小明35'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (36, 36, '小黑36'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (37, 37, '小红37'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (38, 38, '小黄38'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (39, 39, '小黄39'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (40, 40, '小明40'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (41, 41, '小黑41'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (42, 42, '小红42'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (43, 43, '小黄43'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (44, 44, '小黄44'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (45, 45, '小明45'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (46, 46, '小黑46'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (47, 47, '小红47'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (48, 48, '小黄48'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (49, 49, '小黄49'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (50, 50, '小明50'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (51, 51, '小黑51'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (52, 52, '小红52'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (53, 53, '小黄53'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (54, 54, '小黄54'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (55, 55, '小明55'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (56, 56, '小黑56'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (57, 57, '小红57'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (58, 58, '小黄58'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (59, 59, '小黄59'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (60, 60, '小明60'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (61, 61, '小黑61'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (62, 62, '小红62'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (63, 63, '小黄63'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (64, 64, '小黄64'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (65, 65, '小明65'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (66, 66, '小黑66'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (67, 67, '小红67'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (68, 68, '小黄68'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (69, 69, '小黄69'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (70, 70, '小明70'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (71, 71, '小黑71'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (72, 72, '小红72'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (73, 73, '小黄73'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (74, 74, '小黄74'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (75, 75, '小明75'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (76, 76, '小黑76'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (77, 77, '小红77'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (78, 78, '小黄78'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (79, 79, '小黄79'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (80, 80, '小明80'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (81, 81, '小黑81'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (82, 82, '小红82'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (83, 83, '小黄83'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (84, 84, '小黄84'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (85, 85, '小明85'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (86, 86, '小黑86'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (87, 87, '小红87'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (88, 88, '小黄88'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (89, 89, '小黄89'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (90, 90, '小明90'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (91, 91, '小黑91'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (92, 92, '小红92'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (93, 93, '小黄93'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (94, 94, '小黄94'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (95, 95, '小明95'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (96, 96, '小黑96'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (97, 97, '小红97'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (98, 98, '小黄98'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (99, 99, '小黄99'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (100, 100, '小明100'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (101, 101, '小黑101'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (102, 102, '小红102'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (103, 103, '小黄103'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (104, 104, '小黄104'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (105, 105, '小明105'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (106, 106, '小黑106'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (107, 107, '小红107'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (108, 108, '小黄108'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (109, 109, '小黄109'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (110, 110, '小明110'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (111, 111, '小黑111'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (112, 112, '小红112'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (113, 113, '小黄113'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (114, 114, '小黄114'); 
INSERT INTO `m0`.`user_0`(`id`, `userid`, `username`) VALUES (115, 115, '小明115'); 
INSERT INTO `m1`.`user_1`(`id`, `userid`, `username`) VALUES (116, 116, '小黑116'); 
INSERT INTO `m0`.`user_2`(`id`, `userid`, `username`) VALUES (117, 117, '小红117'); 
INSERT INTO `m1`.`user_3`(`id`, `userid`, `username`) VALUES (118, 118, '小黄118'); 
INSERT INTO `m0`.`user_4`(`id`, `userid`, `username`) VALUES (119, 119, '小黄119'); 





















INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 0, 0, 0, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 1, 1, 1, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 2, 2, 2, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 3, 3, 3, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 4, 4, 4, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 5, 5, 5, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 6, 6, 6, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 7, 7, 7, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 8, 8, 8, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 9, 9, 9, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 10, 10, 10, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 11, 11, 11, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 12, 12, 12, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 13, 13, 13, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 14, 14, 14, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 15, 15, 15, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 16, 16, 16, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 17, 17, 17, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 18, 18, 18, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 19, 19, 19, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 20, 20, 20, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 21, 21, 21, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 22, 22, 22, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 23, 23, 23, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 24, 24, 24, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 25, 25, 25, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 26, 26, 26, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 27, 27, 27, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 28, 28, 28, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 29, 29, 29, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 30, 30, 30, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 31, 31, 31, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 32, 32, 32, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 33, 33, 33, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 34, 34, 34, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 35, 35, 35, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 36, 36, 36, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 37, 37, 37, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 38, 38, 38, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 39, 39, 39, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 40, 40, 40, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 41, 41, 41, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 42, 42, 42, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 43, 43, 43, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 44, 44, 44, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 45, 45, 45, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 46, 46, 46, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 47, 47, 47, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 48, 48, 48, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 49, 49, 49, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 50, 50, 50, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 51, 51, 51, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 52, 52, 52, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 53, 53, 53, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 54, 54, 54, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 55, 55, 55, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 56, 56, 56, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 57, 57, 57, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 58, 58, 58, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 59, 59, 59, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 60, 60, 60, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 61, 61, 61, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 62, 62, 62, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 63, 63, 63, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 64, 64, 64, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 65, 65, 65, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 66, 66, 66, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 67, 67, 67, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 68, 68, 68, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 69, 69, 69, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 70, 70, 70, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 71, 71, 71, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 72, 72, 72, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 73, 73, 73, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 74, 74, 74, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 75, 75, 75, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 76, 76, 76, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 77, 77, 77, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 78, 78, 78, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 79, 79, 79, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 80, 80, 80, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 81, 81, 81, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 82, 82, 82, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 83, 83, 83, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 84, 84, 84, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 85, 85, 85, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 86, 86, 86, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 87, 87, 87, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 88, 88, 88, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 89, 89, 89, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 90, 90, 90, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 91, 91, 91, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 92, 92, 92, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 93, 93, 93, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 94, 94, 94, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 95, 95, 95, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 96, 96, 96, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 97, 97, 97, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 98, 98, 98, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 99, 99, 99, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 100, 100, 100, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 101, 101, 101, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 102, 102, 102, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 103, 103, 103, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 104, 104, 104, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 105, 105, 105, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 106, 106, 106, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 107, 107, 107, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 108, 108, 108, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 109, 109, 109, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 110, 110, 110, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 111, 111, 111, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 112, 112, 112, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 113, 113, 113, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 114, 114, 114, '5' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 115, 115, 115, '1' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 116, 116, 116, '2' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 117, 117, 117, '3' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 118, 118, 118, '4' );
INSERT INTO `m0`.`full_t_order` ( `order_id`, `price`, `user_id`, `status` ) VALUES ( 119, 119, 119, '5' );








INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (0, 0, '小明0'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (1, 1, '小黑1'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (2, 2, '小红2'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (3, 3, '小黄3'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (4, 4, '小黄4'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (5, 5, '小明5'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (6, 6, '小黑6'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (7, 7, '小红7'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (8, 8, '小黄8'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (9, 9, '小黄9'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (10, 10, '小明10'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (11, 11, '小黑11'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (12, 12, '小红12'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (13, 13, '小黄13'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (14, 14, '小黄14'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (15, 15, '小明15'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (16, 16, '小黑16'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (17, 17, '小红17'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (18, 18, '小黄18'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (19, 19, '小黄19'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (20, 20, '小明20'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (21, 21, '小黑21'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (22, 22, '小红22'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (23, 23, '小黄23'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (24, 24, '小黄24'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (25, 25, '小明25'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (26, 26, '小黑26'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (27, 27, '小红27'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (28, 28, '小黄28'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (29, 29, '小黄29'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (30, 30, '小明30'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (31, 31, '小黑31'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (32, 32, '小红32'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (33, 33, '小黄33'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (34, 34, '小黄34'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (35, 35, '小明35'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (36, 36, '小黑36'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (37, 37, '小红37'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (38, 38, '小黄38'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (39, 39, '小黄39'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (40, 40, '小明40'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (41, 41, '小黑41'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (42, 42, '小红42'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (43, 43, '小黄43'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (44, 44, '小黄44'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (45, 45, '小明45'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (46, 46, '小黑46'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (47, 47, '小红47'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (48, 48, '小黄48'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (49, 49, '小黄49'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (50, 50, '小明50'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (51, 51, '小黑51'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (52, 52, '小红52'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (53, 53, '小黄53'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (54, 54, '小黄54'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (55, 55, '小明55'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (56, 56, '小黑56'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (57, 57, '小红57'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (58, 58, '小黄58'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (59, 59, '小黄59'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (60, 60, '小明60'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (61, 61, '小黑61'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (62, 62, '小红62'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (63, 63, '小黄63'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (64, 64, '小黄64'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (65, 65, '小明65'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (66, 66, '小黑66'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (67, 67, '小红67'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (68, 68, '小黄68'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (69, 69, '小黄69'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (70, 70, '小明70'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (71, 71, '小黑71'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (72, 72, '小红72'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (73, 73, '小黄73'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (74, 74, '小黄74'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (75, 75, '小明75'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (76, 76, '小黑76'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (77, 77, '小红77'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (78, 78, '小黄78'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (79, 79, '小黄79'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (80, 80, '小明80'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (81, 81, '小黑81'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (82, 82, '小红82'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (83, 83, '小黄83'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (84, 84, '小黄84'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (85, 85, '小明85'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (86, 86, '小黑86'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (87, 87, '小红87'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (88, 88, '小黄88'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (89, 89, '小黄89'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (90, 90, '小明90'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (91, 91, '小黑91'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (92, 92, '小红92'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (93, 93, '小黄93'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (94, 94, '小黄94'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (95, 95, '小明95'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (96, 96, '小黑96'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (97, 97, '小红97'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (98, 98, '小黄98'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (99, 99, '小黄99'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (100, 100, '小明100'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (101, 101, '小黑101'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (102, 102, '小红102'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (103, 103, '小黄103'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (104, 104, '小黄104'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (105, 105, '小明105'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (106, 106, '小黑106'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (107, 107, '小红107'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (108, 108, '小黄108'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (109, 109, '小黄109'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (110, 110, '小明110'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (111, 111, '小黑111'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (112, 112, '小红112'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (113, 113, '小黄113'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (114, 114, '小黄114'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (115, 115, '小明115'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (116, 116, '小黑116'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (117, 117, '小红117'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (118, 118, '小黄118'); 
INSERT INTO `m0`.`full_user`(`id`, `userid`, `username`) VALUES (119, 119, '小黄119');

测试运行

测试运行过程和结果请见DemoController.java，都写那了

apply_bomb

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
springboot+mybatis+sharding-jdbc整合示例代码

想要整合个sharding-jdbc，结果sharding-jdbc官网的入门示例居然下载不下来，无奈只能自己搭了个,下面的示例可以直接运行，并且提供了数据库脚本，对新手友好。sharding-jdbc:4.0.1(目前能在maven中找到的最新稳定发布版本)mybatis-plus：(目前能在maven中找到的最新稳定发布版本)测试运行过程和结果请见DemoController.java，都写那了。用于链接mybatis的xml文件。mysql版本：mysql8。mybatis官网链接。
复制链接

扫一扫