在进程结束时使用executeUpdate命令执行提交删除多条记录

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

public class DeleteRecords {
    public static void main(String[] args) {
        // 建立数据库连接
        Connection connection = null;
        Statement statement = null;
        try {
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
            statement = connection.createStatement();

            // 定义要执行的删除操作
            String sql = "DELETE FROM mytable WHERE id IN (1, 2, 3)";

            // 执行SQL语句并返回受影响的行数
            int rowsAffected = statement.executeUpdate(sql);

            // 输出受影响的行数
            System.out.println("删除了 " + rowsAffected + " 条记录");

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            try {
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}