背景
想要整合个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官网链接
项目结构
具体代码
项目依赖
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,都写那了