如何在MySQL数据库中添加多行JTable数据

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

public class MySQLJTableInsert {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        // 创建JTable并添加数据
        JTable table = new JTable();
        DefaultTableModel model = (DefaultTableModel) table.getModel();
        model.addRow(new Object[]{"John", 25});
        model.addRow(new Object[]{"Jane", 30});
        model.addRow(new Object[]{"Tom", 35});

        // 遍历JTable的每一行，将数据插入到MySQL数据库
        try (Connection conn = DriverManager.getConnection(url, username, password)) {
            String sql = "INSERT INTO mytable (name, age) VALUES (?, ?)";
            PreparedStatement statement = conn.prepareStatement(sql);

            for (int i = 0; i < model.getRowCount(); i++) {
                String name = model.getValueAt(i, 0).toString();
                int age = Integer.parseInt(model.getValueAt(i, 1).toString());

                statement.setString(1, name);
                statement.setInt(2, age);
                statement.executeUpdate();
            }

            System.out.println("数据插入成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}