通过jquery javascript函数使用SESSION变量更新MySQL

$.ajax({
  url: '/update-session',
  type: 'POST',
  data: {
    session_key: 'your_session_key',
    session_value: 'your_session_value'
  },
  success: function(response) {
    console.log('Session updated successfully:', response);
  },
  error: function(error) {
    console.error('Error updating session:', error);
  }
});

const express = require('express');
const mysql = require('mysql');

const app = express();
app.use(express.json());

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_mysql_username',
  password: 'your_mysql_password',
  database: 'your_mysql_database'
});

connection.connect();

app.post('/update-session', (req, res) => {
  const { session_key, session_value } = req.body;

  connection.query('UPDATE your_table SET session_value = ? WHERE session_key = ?', [session_value, session_key], (error, results) => {
    if (error) {
      console.error('Error updating session:', error);
      res.status(500).send('Error updating session');
    } else {
      console.log('Session updated successfully:', results);
      res.send('Session updated successfully');
    }
  });
});

app.listen(3000, () => {
  console.log('Server started on port 3000');
});