在Nodejs中使用Jquery Ajax请求从数据库中删除

npm install jquery

const mysql = require('mysql');
const $ = require('jquery');

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

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database: ' + err.stack);
    return;
  }
  console.log('Connected to database successfully!');
});

app.post('/deleteUser', (req, res) => {
  const userId = req.body.userId;

  // 使用jQuery Ajax发送POST请求
  $.ajax({
    url: '/deleteUser',
    type: 'POST',
    data: { userId: userId },
    success: function(result) {
      // 执行数据库删除操作
      connection.query('DELETE FROM users WHERE id = ?', [userId], (err, results) => {
        if (err) {
          console.error('Error deleting user from database: ' + err.stack);
          res.status(500).send('Error deleting user from database');
          return;
        }
        console.log('User deleted successfully!');
        res.status(200).send('User deleted successfully');
      });
    },
    error: function(error) {
      console.error('Error sending Ajax request: ' + error.stack);
      res.status(500).send('Error sending Ajax request');
    }
  });
});