node.js SQL Insert Into with array

const mysql = require('mysql');

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

// 连接到数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database');
});

// 要插入的数据数组
const dataArray = [
  { name: 'John', age: 25 },
  { name: 'Jane', age: 30 },
  { name: 'Bob', age: 35 }
];

// 构建插入语句
const insertQuery = 'INSERT INTO users (name, age) VALUES ?';

// 将数据数组转换为二维数组
const values = dataArray.map(obj => [obj.name, obj.age]);

// 执行插入语句
connection.query(insertQuery, [values], (err, result) => {
  if (err) throw err;
  console.log('Inserted rows:', result.affectedRows);
});

// 关闭数据库连接
connection.end((err) => {
  if (err) throw err;
  console.log('Disconnected from the database');
});