调用app.use/app.post (插入到db中)以获取表单值

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

const app = express();
app.use(bodyParser.urlencoded({ extended: false }));

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接数据库
connection.connect();

// 处理表单提交的数据
app.post('/submit', (req, res) => {
  const { name, email, message } = req.body;

  // 插入数据到数据库
  const sql = `INSERT INTO users (name, email, message) VALUES (?, ?, ?)`;
  connection.query(sql, [name, email, message], (error, results) => {
    if (error) throw error;
    console.log('Data inserted successfully');
    res.send('Data inserted successfully');
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});