如何使用Node.js在数据库中保存镜像路径？

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

const app = express();
const upload = multer({ dest: 'uploads/' });

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

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

// 处理上传请求
app.post('/upload', upload.single('image'), (req, res) => {
  const imagePath = req.file.path;

  // 将路径保存到数据库
  const query = `INSERT INTO images (path) VALUES ('${imagePath}')`;
  connection.query(query, (error, results) => {
    if (error) throw error;
    res.send('Image uploaded successfully!');
  });
});

// 处理获取镜像请求
app.get('/image/:id', (req, res) => {
  const imageId = req.params.id;

  // 从数据库中检索路径
  const query = `SELECT path FROM images WHERE id = ${imageId}`;
  connection.query(query, (error, results) => {
    if (error) throw error;
    const imagePath = results[0].path;
    res.sendFile(imagePath);
  });
});

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