windows安装mysql8.0，并插入百万条数据

package cn.lzufe;


import java.sql.*;
import java.util.Arrays;
import java.util.List;

public class Test03 {

    private static String url="jdbc:mysql://127.0.0.1:3306/daka?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=UTC";
    private static String user = "root";
    private static String password="123";

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        Class.forName("com.mysql.cj.jdbc.Driver");

        Connection connection = DriverManager.getConnection(url, user, password);
        String sql =" select * from teacher where depart like ? and location_time like ?";

        List<String> list = Arrays.asList("食堂","保安","长青学院","外聘教师","商户","临时人员","维修","医务","图书馆(物业","工地","施工");

        for (String str:list) {
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,"%"+str+"%");
            preparedStatement.setString(2,"2022-05-20%");



            ResultSet resultSet = preparedStatement.executeQuery();
            int count =0;

            while (resultSet.next()){
                count++;
//                System.out.println(resultSet.getString("name")+":"+
//                        resultSet.getString("depart")+":"+
//                        resultSet.getString("location_time")+
//                        resultSet.getString("location"));
            }

            System.out.println(str+":"+count);
        }
    }
}