利用js实现网页与mysql数据库

// 引入mysql模块
const mysql = require('mysql');

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

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

// 执行数据库操作
const sql = 'SELECT * FROM users';
connection.query(sql, (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

// 关闭数据库连接
connection.end((err) => {
  if (err) {
    console.error('Error closing database: ' + err.stack);
    return;
  }
  console.log('Database connection closed.');
});