mysql 生成测试数据

<dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.22</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>compile</scope>
        </dependency>
    </dependencies>

package com.zyw.util;

import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.sql.*;

/**
 * Created by IntelliJ IDEA.
 * User: 
 * Date: 2021/10/11
 * Time: 14:25
 * To change this template use File | Settings | File Templates.
 */
public class BatchInsert {
    @Test
    public void test() throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/db2?serverTimezone=UTC", "root", "111111");
        PreparedStatement preparedStatement = connection.prepareStatement("insert into student values(null,?,?,?)");
        for(int i=0;i<=10000;i++) {
            preparedStatement.setString(1,randomName());
            preparedStatement.setString(2,randomSex());
            preparedStatement.setInt(3,(int)(Math.random()*30));
            preparedStatement.addBatch();
            if(i%1000==0) {
                preparedStatement.executeBatch();
                preparedStatement.clearBatch();
            }
        }
        preparedStatement.close();
        connection.close();
    }

    public String  randomSex(){
        return (int)(Math.random()*2)==0?"男":"女";
    }

    public String  randomName(){
        char[] x={'张','赵','李','王','钱','孙','周'};
        char[] name={'啊','的','给','是','你','在','有','为','对','等','分','非','高','吖','先','被','那','会','或'};
        int a=(int)(Math.random()*6);
        int b=(int)(Math.random()*18);
        int b1=(int)(Math.random()*18);
        StringBuffer stringBuffer=new StringBuffer();
        stringBuffer.append(x[a]);
        stringBuffer.append(name[b]);
        stringBuffer.append(name[b1]);
        return stringBuffer.toString();
    }


}