js复制表格一行数据库中

// 假设表格的ID为'myTable'
function copyTableRow(rowIndex) {
    const table = document.getElementById('myTable');
    const row = table.rows[rowIndex];
    const newRow = row.cloneNode(true);

    // 修改新行的ID或其他唯一标识，以避免冲突
    newRow.id = 'newRow_' + Date.now();

    // 将新行插入到表格中
    table.appendChild(newRow);

    // 获取新行的数据
    const rowData = [];
    for (let i = 0; i < newRow.cells.length; i++) {
        rowData.push(newRow.cells[i].innerText);
    }

    // 发送数据到服务器
    sendDataToServer(rowData);
}

function sendDataToServer(data) {
    const xhr = new XMLHttpRequest();
    xhr.open('POST', '/save-row', true);
    xhr.setRequestHeader('Content-Type', 'application/json');
    xhr.onreadystatechange = function () {
        if (xhr.readyState === 4 && xhr.status === 200) {
            console.log('Row saved successfully');
        }
    };
    xhr.send(JSON.stringify(data));
}

const express = require('express');
const bodyParser = require('body-parser');
const app = express();
const port = 3000;

app.use(bodyParser.json());

app.post('/save-row', (req, res) => {
    const rowData = req.body;
    // 这里可以将rowData保存到数据库
    console.log('Received row data:', rowData);

    // 假设使用MongoDB保存数据
    // const MongoClient = require('mongodb').MongoClient;
    // const url = 'mongodb://localhost:27017';
    // const dbName = 'mydatabase';
    // MongoClient.connect(url, function(err, client) {
    //     if (err) throw err;
    //     const db = client.db(dbName);
    //     db.collection('rows').insertOne(rowData, function(err, result) {
    //         if (err) throw err;
    //         console.log('Row saved to database');
    //         client.close();
    //         res.send('Row saved successfully');
    //     });
    // });

    res.send('Row saved successfully');
});

app.listen(port, () => {
    console.log(`Server running at http://localhost:${port}`);
});