使用expressjs获取数据Rowdatapacket

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

const app = express();

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

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

// 定义路由
app.get('/data', (req, res) => {
  // 执行数据库查询
  connection.query('SELECT * FROM mytable', (error, results) => {
    if (error) throw error;

    // 处理查询结果
    const data = results.map(row => {
      // 将Rowdatapacket对象转换为普通对象
      return { ...row };
    });

    res.json(data);
  });
});

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