使用Node.JS将JSON对象数据插入到MySQL

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost', // MySQL服务器地址
  user: 'root', // MySQL用户名
  password: 'password', // MySQL密码
  database: 'database_name' // 数据库名称
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ' + err.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);
});

const jsonData = {
  name: 'John',
  age: 25,
  email: 'john@example.com'
};

const sql = 'INSERT INTO table_name SET ?';

connection.query(sql, jsonData, (err, result) => {
  if (err) {
    console.error('Error inserting data into MySQL table: ' + err.stack);
    return;
  }
  console.log('Data inserted into MySQL table successfully.');
});

connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL database connection: ' + err.stack);
    return;
  }
  console.log('MySQL database connection closed.');
});