如何在ExpressJS中实现数据库的插入和更新

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database: ', err);
    return;
  }
  console.log('Connected to database');
});

const data = { name: 'John', age: 25 };

connection.query('INSERT INTO table_name SET ?', data, (err, result) => {
  if (err) {
    console.error('Error inserting data: ', err);
    return;
  }
  console.log('Data inserted successfully');
});

const data = { name: 'John Doe', age: 26 };

connection.query('UPDATE table_name SET ? WHERE id = ?', [data, 1], (err, result) => {
  if (err) {
    console.error('Error updating data: ', err);
    return;
  }
  console.log('Data updated successfully');
});