mysql java多线程并发插入数据

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;

public class ConcurrentInsertExample {
    private static final String INSERT_SQL = "INSERT INTO your_table (column1, column2) VALUES (?, ?)";

    public static void main(String[] args) {
        ExecutorService executorService = Executors.newFixedThreadPool(10);

        for (int i = 0; i < 100; i++) {
            final int index = i;
            executorService.submit(() -> {
                try (Connection connection = getConnection();
                     PreparedStatement preparedStatement = connection.prepareStatement(INSERT_SQL)) {
                    preparedStatement.setString(1, "value1_" + index);
                    preparedStatement.setString(2, "value2_" + index);
                    preparedStatement.executeUpdate();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            });
        }

        executorService.shutdown();
    }

    private static Connection getConnection() throws SQLException {
        // 这里使用你的数据库连接池获取连接
        return null;
    }
}