在NodeJS和mysql上调用jQuery AJAX调用(POST请求)以获得依赖下拉列表

const express = require('express');
const mysql = require('mysql');
const bodyParser = require('body-parser');

const app = express();

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database');
});

app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());

app.post('/getDropdownData', (req, res) => {
  const query = 'SELECT * FROM dropdown_data'; // 替换为你的数据库表名

  connection.query(query, (err, results) => {
    if (err) throw err;
    res.json(results);
  });
});

const port = 3000; // 替换为你想要的端口号

app.listen(port, () => {
  console.log(`Server running on port ${port}`);
});

$.ajax({
  url: '/getDropdownData',
  type: 'POST',
  dataType: 'json',
  success: function(data) {
    // 处理返回的数据
    console.log(data);
  },
  error: function(error) {
    console.log(error);
  }
});