js怎么显示mysql数据库

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

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database!');
});

connection.query('SELECT * FROM table_name', (err, results) => {
  if (err) throw err;
  console.log('Retrieved data from MySQL database:', results);
});

const table = document.getElementById('data-table');
results.forEach((row) => {
  const newRow = table.insertRow();
  newRow.insertCell().appendChild(document.createTextNode(row.column1));
  newRow.insertCell().appendChild(document.createTextNode(row.column2));
  // 继续插入其他列数据...
});