Express/node-postgres传递带有多个值的对象以插入查询

const express = require('express');
const { Pool } = require('pg');

const app = express();
const pool = new Pool({
  user: 'your_username',
  host: 'your_host',
  database: 'your_database',
  password: 'your_password',
  port: 5432,
});

app.post('/insert', (req, res) => {
  const { value1, value2, value3 } = req.body; // 获取传递的对象数据

  pool.connect((err, client, done) => {
    if (err) {
      console.error('Error connecting to database', err);
      return res.status(500).json({ error: 'Error connecting to database' });
    }

    const query = 'INSERT INTO your_table(column1, column2, column3) VALUES($1, $2, $3)';
    const values = [value1, value2, value3];

    client.query(query, values, (err, result) => {
      done(); // 释放连接

      if (err) {
        console.error('Error executing query', err);
        return res.status(500).json({ error: 'Error executing query' });
      }

      return res.status(200).json({ message: 'Insert successful' });
    });
  });
});

app.listen(3000, () => {
  console.log('Server is running on port 3000');
});