在foreach循环中单击按钮，从目录中删除特定文件，并从数据库数组中删除其名称

<button id="deleteButton">删除文件</button>

document.getElementById("deleteButton").addEventListener("click", deleteFile);

const fs = require("fs");
const database = require("database"); // 假设已经导入了数据库操作的模块

function deleteFile() {
  const directory = "/path/to/directory"; // 目录路径
  const filesToDelete = ["file1.txt", "file2.txt", "file3.txt"]; // 要删除的文件名数组

  filesToDelete.forEach((file) => {
    const filePath = directory + "/" + file;

    // 删除目录中的文件
    fs.unlink(filePath, (err) => {
      if (err) {
        console.error(err);
      } else {
        console.log("文件已成功删除：" + filePath);
      }
    });

    // 从数据库数组中删除文件名
    database.deleteFileName(file);
  });
}

const mysql = require("mysql");

function deleteFileName(fileName) {
  const connection = mysql.createConnection({
    host: "localhost",
    user: "username",
    password: "password",
    database: "database_name"
  });

  connection.connect();

  const query = "DELETE FROM files WHERE name = ?";
  connection.query(query, [fileName], (error, results, fields) => {
    if (error) {
      console.error(error);
    } else {
      console.log("文件名已从数据库中成功删除：" + fileName);
    }
  });

  connection.end();
}