通过Arraylist在数据库中插入数据列表

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;

public class InsertData {
    public static void main(String[] args) {
        ArrayList<String> dataList = new ArrayList<>();
        dataList.add("Data 1");
        dataList.add("Data 2");
        dataList.add("Data 3");

        Connection connection = null;
        PreparedStatement statement = null;

        try {
            // 建立数据库连接
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database", "username", "password");

            // 准备SQL语句
            String sql = "INSERT INTO table_name (column_name) VALUES (?)";

            // 创建PreparedStatement对象
            statement = connection.prepareStatement(sql);

            // 使用批处理插入数据
            for (String data : dataList) {
                statement.setString(1, data);
                statement.addBatch();
            }

            // 执行批处理
            statement.executeBatch();

            System.out.println("数据插入成功！");

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭资源
            try {
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}