添加新行时自动插入日期戳

// HTML部分
<table id="myTable">
  <tr>
    <th>姓名</th>
    <th>日期戳</th>
  </tr>
  <tr>
    <td>张三</td>
    <td>2022-01-01</td>
  </tr>
</table>

// JavaScript部分
document.getElementById("myTable").addEventListener("click", function(event) {
  if (event.target.tagName === "BUTTON") {
    var table = document.getElementById("myTable");
    var row = table.insertRow(-1);
    var cell1 = row.insertCell(0);
    var cell2 = row.insertCell(1);
    cell1.innerHTML = "新姓名";
    cell2.innerHTML = getCurrentDate();
  }
});

function getCurrentDate() {
  var date = new Date();
  var year = date.getFullYear();
  var month = ("0" + (date.getMonth() + 1)).slice(-2);
  var day = ("0" + date.getDate()).slice(-2);
  return year + "-" + month + "-" + day;
}

// 安装依赖：npm install express mysql

// app.js
const express = require("express");
const mysql = require("mysql");

const app = express();
const connection = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
  database: "mydatabase"
});

app.post("/addRow", (req, res) => {
  const currentDate = getCurrentDate();
  const sql = `INSERT INTO mytable (name, timestamp) VALUES ('新姓名', '${currentDate}')`;
  connection.query(sql, (error, results) => {
    if (error) throw error;
    res.send("New row added with timestamp: " + currentDate);
  });
});

function getCurrentDate() {
  const date = new Date();
  const year = date.getFullYear();
  const month = ("0" + (date.getMonth() + 1)).slice(-2);
  const day = ("0" + date.getDate()).slice(-2);
  return year + "-" + month + "-" + day;
}

app.listen(3000, () => {
  console.log("Server is running on port 3000");
});