根据用户输入向数据库添加多行

const mysql = require('mysql');

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

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

// 用户输入的数据
const userData = [
  { name: 'John', age: 25 },
  { name: 'Jane', age: 30 },
  { name: 'Bob', age: 35 }
];

// 构建SQL语句
const sql = 'INSERT INTO users (name, age) VALUES ?';

// 执行插入操作
connection.query(sql, [userData.map(user => [user.name, user.age])], (error, results) => {
  if (error) throw error;
  console.log('插入成功');
});

// 关闭数据库连接
connection.end();