如何使用node.js&Mysql将数据从在线表单添加到数据库？

npm install mysql

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

const server = http.createServer((req, res) => {
    // 在这里处理表单提交请求
});

server.listen(3000, 'localhost', () => {
    console.log('Server running at http://localhost:3000/');
});

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

// 在服务器启动代码中添加以下代码
server.use(bodyParser.urlencoded({ extended: false }));

// 处理表单提交请求的地方
server.on('request', (req, res) => {
    if (req.method === 'POST') {
        const formData = req.body;
        // 在这里处理表单数据
    }
});

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

// 处理表单提交请求的地方
server.on('request', (req, res) => {
    if (req.method === 'POST') {
        const formData = req.body;
        connection.connect((err) => {
            if (err) {
                console.error('Error connecting to database: ' + err.stack);
                return;
            }
            
            connection.query('INSERT INTO your_table SET ?', formData, (error, results, fields) => {
                if (error) {
                    console.error('Error inserting data into database: ' + error.stack);
                    return;
                }

                console.log('Data inserted successfully!');
                res.end('Data inserted successfully!');
            });
            
            connection.end();
        });
    }
});