如何将Nodejs的输入存储到数据库中

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

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

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

// 创建HTTP服务器
const server = http.createServer((req, res) => {
  const { pathname, query } = url.parse(req.url);
  const { input } = querystring.parse(query);

  if (pathname === '/save') {
    // 将输入存储到数据库中
    const sql = `INSERT INTO inputs (input) VALUES ('${input}')`;
    connection.query(sql, (error, results) => {
      if (error) throw error;
      console.log('Input saved to database');
      res.end('Input saved to database');
    });
  } else {
    res.end('Invalid endpoint');
  }
});

// 监听端口
server.listen(3000, () => {
  console.log('Server is running on port 3000');
});