如何使用node.js将图片上传到mysql

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

const app = express();

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

// 创建文件上传配置
const upload = multer({
  dest: 'uploads/' // 上传文件存储的临时目录
});

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

  // 读取图片文件的二进制数据
  const image = fs.readFileSync(path);

  // 将图片的二进制数据存储到数据库中
  connection.query('INSERT INTO images (name, type, data) VALUES (?, ?, ?)', [originalname, mimetype, image], (error, results) => {
    if (error) {
      console.error(error);
      res.status(500).json({ message: '上传图片失败' });
    } else {
      res.json({ message: '上传图片成功' });
    }
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('服务器已启动');
});