有大佬可以帮忙看看吗？

Falconer_yorick 2024-06-12 17:33:58

菜鸡大学生在尝试做自己的学期课程设计，因为deadline日渐迫近但还是写不完于是用了chatGPT帮忙写了一段，但这段怎么运行都不行，菜鸡自己水平又有限，实在看不出错误。大佬们可以帮我看看吗？

main.html

<!-- 删除客户表单 -->
        <div id="deleteCustomerForm" class="form-container">
            <h2>删除客户</h2>
            <input type="text" id="deleteCustomerName" placeholder="客户姓名">
            <button onclick="deleteCustomer()">删除客户</button>
            <div id="deleteCustomerMessage"></div>
        </div>

scripts.js

async function deleteCustomer() {
    const data = { name: document.getElementById('deleteCustomerName').value };

    try {
        const response = await fetch('/deleteCustomer', {
            method: 'DELETE',
            headers: {
                'Content-Type': 'application/json'
            },
            body: JSON.stringify(data)
        });

        const result = await response.json();
        alert(result.message);
    } catch (error) {
        alert('Error: Unable to delete customer');
    }
}

server.js

// 删除客户
app.delete('/deleteCustomer', async (req, res) => {
    const { name } = req.body;
    try {
        const request = new mssql.Request();
        await request.query(`
            DELETE FROM Customers 
            WHERE name = ${name}
        `);
        res.json({ message: 'Customer deleted successfully' });
    } catch (err) {
        console.error(err);
        res.status(500).json({ message: 'Failed to delete customer' });
    }
});

报错显示：