如何用java在Mysql数据库中插入数组值

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DatabaseConnection {
    private static final String URL = "jdbc:mysql://localhost:3306/database_name";
    private static final String USERNAME = "username";
    private static final String PASSWORD = "password";

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(URL, USERNAME, PASSWORD);
    }
}

int[] array = {1, 2, 3, 4, 5};

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class InsertArrayValues {
    public static void main(String[] args) {
        int[] array = {1, 2, 3, 4, 5};

        try (Connection connection = DatabaseConnection.getConnection()) {
            String sql = "INSERT INTO table_name (column_name) VALUES (?)";
            PreparedStatement statement = connection.prepareStatement(sql);

            for (int value : array) {
                statement.setInt(1, value);
                statement.executeUpdate();
            }

            System.out.println("Array values inserted successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}